user/restart-db fails when using hugsql clojure syntax

[eskemojoe007]

hugsql allows for the usage of clojure syntax within the queries, but when working with queries in the repl an error is raised when running restart-db when the code exists. The error does not happen if the repl is restarted.

Step to Recreate

1. lein new luminus myapp +postgres
2. Create DB and update connection string in dev-config.edn
3. Modify myapp/resources/sql/queries.sql to make get-user to read:

-- :name get-user :? :1
-- :doc retrieves a user record given the id
SELECT * FROM users
/*~ (if (:id params) */
WHERE id = :id
/*~*/
where email = :email
/*~ ) ~*/

4. Start repl lein repl
5. Start app - (start)
6. Migrate - (migrate)
7. create at least 1 record

(myapp.db.core/create-user!
 {:id 1
  :first_name "steve"
  :last_name "jobs"
  :email "steve.jobs@apple.com"
  :pass "admin"})

8. Test that both connection string types work:

• (myapp.db.core/get-user {:id "1"})
• (myapp.db.core/get-user {:email "steve.jobs@apple.com"})

9. (restart-db)

You get the following error:

class clojure.lang.Symbol cannot be cast to class clojure.lang.Namespace (clojure.lang.Symbol and clojure.lang.Namespace are in unnamed module of loader 'app')

Removing the lines of code from get-user and making it a simple query allows restart-db to function properly. This has been verified on both linux mint and windows 10.