database

func FetchColumnNames ¶

func FetchColumnNames(db *sqlx.DB, tableName string) ([]string, error)

func InsertStruct ¶

func InsertStruct(db *sqlx.DB, tableName string, data any) error

InsertStruct inserts a struct's fields into the specified table.

func InsertTrxStruct ¶ added in v1.8.69

func InsertTrxStruct(db *sqlx.Tx, tableName string, data any) error

func ParseRows ¶

func ParseRows(rows *sql.Rows, dest interface{}) error

func PostgresConn ¶

func PostgresConn() (*sqlx.DB, error)

func UpdateStruct ¶

func UpdateStruct(db *sqlx.DB, tableName string, data any, conditionField string, conditionValue interface{}) error

UpdateStruct updates fields in the specified table for a given struct based on a condition.

func UpdateTrxStruct ¶ added in v1.8.69

func UpdateTrxStruct(db *sqlx.Tx, tableName string, data any, conditionField string, conditionValue interface{}) error