database

Documentation

Index

• func DBFields(object interface{}) (string, error)
• func DBKeyValuePairs(object interface{}) (string, error)
• func DBPlaceholder(object interface{}) (string, error)
• func DBPlaceholderForIDs(ids []int) string
• func DBValues(object interface{}) ([]interface{}, error)
• func Delete(db *sql.DB, table string, objectID int) error
• func ExecuteQuery(db *sql.DB, query string, args []interface{}) (sql.Result, error)
• func ExecuteRowQuery(db *sql.DB, query string, args []interface{}) (*sql.Rows, error)
• func Insert(db *sql.DB, table string, object interface{}) (*sql.Rows, error)
• func InterfaceInt(ints []int) []interface{}
• func RemoveResource(db *sql.DB, object string, objectID int, resource string, resourceID int) error
• func Resource(db *sql.DB, object string, objectID int, resource string) (*sql.Rows, error)
• func Search(db *sql.DB, table string, name string) (*sql.Rows, error)
• func Select(db *sql.DB, table string, objectIDs []int) (*sql.Rows, error)
• func SetResource(db *sql.DB, object string, objectID int, resource string, resourceID int) error
• func Update(db *sql.DB, table string, objectID int, object interface{}) (*sql.Rows, error)

Functions

func DBFields

func DBFields(object interface{}) (string, error)

taken from: https://github.com/jmoiron/sqlx/issues/255 DBFields reflects on a struct and returns the values of fields with `db` tags and returns the keys.

func DBKeyValuePairs

func DBKeyValuePairs(object interface{}) (string, error)

DBValues reflects on a struct and returns the values of fields which have a `db` tag.

func DBPlaceholder

func DBPlaceholder(object interface{}) (string, error)

DBPlaceholder reflects on a struct and returns a placeholder string for every field which have a `db` tag.

func DBPlaceholderForIDs

func DBPlaceholderForIDs(ids []int) string

func DBValues

func DBValues(object interface{}) ([]interface{}, error)

DBValues reflects on a struct and returns the values of fields which have a `db` tag.

func Delete

func Delete(db *sql.DB, table string, objectID int) error

func ExecuteQuery

func ExecuteQuery(db *sql.DB, query string, args []interface{}) (sql.Result, error)

func ExecuteRowQuery

func ExecuteRowQuery(db *sql.DB, query string, args []interface{}) (*sql.Rows, error)

func Insert

func Insert(db *sql.DB, table string, object interface{}) (*sql.Rows, error)

func InterfaceInt

func InterfaceInt(ints []int) []interface{}

func RemoveResource

func RemoveResource(db *sql.DB, object string, objectID int, resource string, resourceID int) error

func Resource

func Resource(db *sql.DB, object string, objectID int, resource string) (*sql.Rows, error)

func Search

func Search(db *sql.DB, table string, name string) (*sql.Rows, error)

func Select

func Select(db *sql.DB, table string, objectIDs []int) (*sql.Rows, error)

func SetResource

func SetResource(db *sql.DB, object string, objectID int, resource string, resourceID int) error

func Update

func Update(db *sql.DB, table string, objectID int, object interface{}) (*sql.Rows, error)