Versions in this module Expand all Collapse all v1 v1.2.0 Apr 4, 2024 Changes in this version + func ExecuteReadQuery(ctx context.Context, query string, conn *sql.Conn, lim int64) ([]map[string]any, error) + func ExecuteWriteQuery(ctx context.Context, query string, conn *sql.Conn) (sql.Result, error) + func GenerateDBFieldMap(doc any) map[string]reflect.Value + func GenerateDeleteQuery(table, id string) string + func GenerateInsertQuery(tableName string, record map[string]any) string + func GenerateReadQuery(tableName string, filter map[string]any) string + func GenerateTableName(table interface{}) string + func GenerateUpdateQuery(table string, id string, record map[string]any) string + func GenerateWhereClauseFromFilter(filter any) string + func GenerateWhereClauseFromID(id any) string + func GetSQLiteConnection(dbPath string) (*sql.Conn, error) + func HandleSliceAny(v []any) string + func IsZeroValue(value any) bool + func MapToRecord(record map[string]any) (*pb.RecordResponse, error) + func MapsToRecords(records []map[string]any) (*pb.RecordsResponse, error) + func ScanSingleRow(rows *sql.Rows, fieldMap map[string]reflect.Value) error + func SyncTable(ctx context.Context, conn *sql.Conn, table interface{}) error + type Statement struct + func (stmt Statement) AddWhereClause(cond string) string + func (stmt Statement) AllCols() Statement + func (stmt Statement) CheckWhereClauseNotEmpty() error + func (stmt Statement) Columns(cols ...string) Statement + func (stmt Statement) ExecuteInsertQuery(ctx context.Context, conn *sql.Conn, tx *sql.Tx, query string) (any, error) + func (stmt Statement) ExecuteReadQuery(ctx context.Context, conn *sql.Conn, tx *sql.Tx, query string, doc any) error + func (stmt Statement) ExecuteWriteQuery(ctx context.Context, conn *sql.Conn, tx *sql.Tx, query string) (sql.Result, error) + func (stmt Statement) GenerateDeleteQuery() string + func (stmt Statement) GenerateInsertQuery(doc any) string + func (stmt Statement) GenerateReadQuery(doc any) string + func (stmt Statement) GenerateUpdateQuery(doc any) string + func (stmt Statement) GenerateWhereClause(filter ...any) Statement + func (stmt Statement) ID(id any) Statement + func (stmt Statement) In(col string, values ...any) Statement + func (stmt Statement) MustCols(cols ...string) Statement + func (stmt Statement) ShowSQL(showSQL bool) Statement + func (stmt Statement) Table(name string) Statement + func (stmt Statement) Where(cond string, args ...any) Statement