db

Documentation

Index

• func Close()
• func Connect(host string, port int, user, password, dbname string, sslmode bool) (*sql.DB, error)
• func DeleteStruct(table string, conditions builder.Builder) error
• func Exec(statement builder.Builder) error
• func InsertStruct(table string, model interface{}) (string, error)
• func LoadStruct(table string, model interface{}, conditions builder.Builder) error
• func Query(statement builder.Builder) (*sql.Rows, error)
• func QueryStruct(statement builder.Builder, model interface{}) error
• func StructDeleteQuery(table string, conditions builder.Builder) (string, []interface{}, error)
• func StructInsertQuery(table string, obj interface{}) (string, []interface{})
• func StructMultipleInsertQuery(table string, obj interface{}) (string, []interface{})
• func StructScan(rows *sql.Rows, obj interface{}) error
• func StructSelectQuery(table string, obj interface{}, conditions builder.Builder) (string, []interface{}, error)
• func StructUpdateQuery(table string, obj interface{}, updatableFields string, ...) (string, []interface{}, error)
• func UpdateStruct(table string, model interface{}, conditions builder.Builder, fields ...string) error

Functions

func Close

func Close()

Close database connection

func Connect

func Connect(host string, port int, user, password, dbname string, sslmode bool) (*sql.DB, error)

Connect connects to the database

func DeleteStruct

func DeleteStruct(table string, conditions builder.Builder) error

DeleteStruct delete struct instance in the database table

func Exec

func Exec(statement builder.Builder) error

Exec prepare the statement and insert into the database

func InsertStruct

func InsertStruct(table string, model interface{}) (string, error)

InsertStruct insert struct values in the database table

func LoadStruct

func LoadStruct(table string, model interface{}, conditions builder.Builder) error

LoadStruct select struct values from the database table. model must be a pointer to a struct or an array.

func Query

func Query(statement builder.Builder) (*sql.Rows, error)

Query prepare the statement, executes and returns the Rows

func QueryStruct

func QueryStruct(statement builder.Builder, model interface{}) error

QueryStruct prepare and execute the statement and then populates the model model must be a pointer to a struct or an array.

func StructDeleteQuery

func StructDeleteQuery(table string, conditions builder.Builder) (string, []interface{}, error)

StructDeleteQuery generates the delete query based on the struct fields

func StructInsertQuery

func StructInsertQuery(table string, obj interface{}) (string, []interface{})

StructInsertQuery generates the insert query based on the struct fields

func StructMultipleInsertQuery

func StructMultipleInsertQuery(table string, obj interface{}) (string, []interface{})

StructMultipleInsertQuery generates the insert query based on the array of structs

func StructScan

func StructScan(rows *sql.Rows, obj interface{}) error

StructScan write rows data to struct array or struct

func StructSelectQuery

func StructSelectQuery(table string, obj interface{}, conditions builder.Builder) (string, []interface{}, error)

StructSelectQuery generates the select query based on the struct fields Object can be a poninter to an array or struct

func StructUpdateQuery

func StructUpdateQuery(table string, obj interface{}, updatableFields string, conditions builder.Builder) (string, []interface{}, error)

StructUpdateQuery generates the update query based on the struct fields

func UpdateStruct

func UpdateStruct(table string, model interface{}, conditions builder.Builder, fields ...string) error

UpdateStruct update struct values in the database table