github.com/rickb777/sqlapi

sqlapi

sqlgen generates SQL statements and database helper functions from your Go structs. It can be used in place of a simple ORM or hand-written SQL. sqlapi (this package) supports the generated code.

See the demo directory for examples. Look in the generated files *_sql.go and the hand-crafted files (hook.go, issue.go, user.go).

Currently, support is included for MySQL, PostgreSQL and SQLite. Other dialects can be added relatively easy - send a Pull Request!

Features

package constraint

• Representations for inter-table constraints.

package require

• Predicates allowing easier detection of unexpected results from SELECTS, e.g. when the result set size is not exactly one.

package dialect

• SQL dialects for SQLite, MySQL, PostgreSQL and its pgx variant. This provides some conditional SQL generation and also

package where

• Fluent construction of WHERE and HAVING clauses: this is now [github.com/rickb777/where](https://github .com/rickb777/where). This also provides control over identifier quoting, e.g. ANSI SQL, back-ticks, etc.

Install

Install with this command:

go get github.com/rickb777/sqlapi

Please continue reading about sqlgen2.