HugSQL

A Clojure library for embracing SQL.

Documentation

Full documentation is at hugsql.org

API Documentation

API Docs

Recent Changes

0.4.9

• preserve file/line metadata from parsed SQL and attach to vars (issue #77) (Thanks Phil Hagelberg! @technomancy)
• fix unbound fn error w/ Clojure expression definitions (issue #59)
• pass the generated function names to the adapter (pull request #83) (Thanks Conor McDermottroe! @conormcd)
• bump version dependencies

0.4.8

• add validation exception for no value for :name (issue #39)
• add clojure.jdbc support for .getGeneratedKeys
• stricter parsing for whitespace; (issue #41)
• fix truncated SQL when blank comment encountered (issue #44)
• add test profiles for clojure versions
• fix multiarity macros definitions (Thanks to Joel Kaasinen) (pull request #66)
• doc fixes
• bump version dependencies

0.4.7

• fix deprecations for latest clojure.java.jdbc changes (issue #38)

0.4.6

• extend identifier param types to support SQL aliases (issue #33)
• fix clj expr eating trailing newline in parser (issue #37)
• fix command & result being ignored in private fns (issue #32)

0.4.5

• support pg double-colon type cast when suffix of HugSQL param (issue #30)
• doc: update escaping colon section to mention double-colon usage

0.4.4

• fix parser error regarding whitespace (issue #27)
• fix handling of vector value parameters (issue #28)
• docs: add faq on preventing sql injection

0.4.3

• report better error message for missing HugSQL header (issue #24)
• fix parser handling of Windows newlines (issue #26)
• missing parameter validation now checks deep-get param names
• add type hints for reflection warnings

0.4.2

• fix parameter mismatch validation for false/nil (issue #23)
• fix sqlvec-fn* not propagating all options
• add doc clarification on tuple list multi-record insert vs large batch insert (issue #22)
• small doc fixes

0.4.1

• map-of-db-fns, map-of-sqlvec-fns & -from-string variants for easier custom use of hugsql-created functions (issue #19) (See Other Useful Functions)
• link to postgresql async adapter fixed (pull #20)
• minor test & doc updates

0.4.0

• Escape colon in SQL (issue #13)
• def-db-fns-from-string & def-sql-fns-from-string (issue #16)
• Added several functions that operate on individual SQL statements, which are useful at the REPL or for one-off composing. (See Other Useful Functions)
• Specify a function as private and other metadata (issue #17)
• Better support for Returning Execute and Insert w/ Return Keys (See Insert Usage) (issues #8 and #15)
• Clojure Expressions
• Snippets
• Parameter Name Deep-Get for drilling down into parameter data
• Better docs & tests

See CHANGELOG for more

License

Copyright © 2018 Layerware, Inc.

Distributed under the Apache License, Version 2.0