#!/bin/bash getRecipesByUsername() { local username="$1" query <&2 tid="$(query <(cat >&2) | getColumns 1 START TRANSACTION; INSERT INTO tags (name) VALUES ('$(escape "$tag")'); SELECT LAST_INSERT_ID(); COMMIT; EOF )" fi echo "INSERT INTO recipeTags (recipeFk, tagFk) VALUES ($rid, $tid)" | execute done }