func CreateUser(db *sqlx.DB, au ApiUserCreate) error { var err error // Nevermind -- we have to use QueryRow to grab the user_id out of the statement, so we can make sure to // properly build the corresponding row in the auth schema query_str, err := db.Preparex(`INSERT INTO tinyplannr_api.user (email, first_name, last_name, zip_code, update_dt) VALUES ($1, $2, $3, $4, $5) RETURNING user_id;`) err = query_str.QueryRowx(au.Email, au.FirstName, au.LastName, au.ZipCode, au.UpdateDt).Scan(&au.UserId) if err != nil { return err } // Creates the corresponding row/entry in the auth table. err = CreateUserAuth(db, au) if err != nil { return err } return err }