crud

Documentation

Index

• func Create(table string, columns []string, values []interface{}) (map[string]interface{}, error)
• func Delete(table string, id int64) error
• func List(table string, filters map[string]interface{}) ([]map[string]interface{}, error)
• func Raw(query string, args ...interface{}) ([]map[string]interface{}, int64, error)
• func Read(table string, id int64) (map[string]interface{}, error)
• func Update(table string, id int64, updates map[string]interface{}) (map[string]interface{}, error)

Functions

func Create

func Create(table string, columns []string, values []interface{}) (map[string]interface{}, error)

Create inserts a new record into the table and returns the created record

func Delete

func Delete(table string, id int64) error

Delete removes a record based on a table and ID

func List

func List(table string, filters map[string]interface{}) ([]map[string]interface{}, error)

List retrieves records based on a table and a map of key and values

func Raw

func Raw(query string, args ...interface{}) ([]map[string]interface{}, int64, error)

Raw executes any SQL command (SELECT, INSERT, UPDATE, DELETE, etc.)

func Read

func Read(table string, id int64) (map[string]interface{}, error)

Read retrieves a record from the table based on the ID

func Update

func Update(table string, id int64, updates map[string]interface{}) (map[string]interface{}, error)

Update updates a record based on a table and ID, and returns the updated record dynamically