sqlite

package

v0.0.0-...-d782b9e Latest Latest Go to latest Published: Aug 4, 2024 License: MIT Imports: 11 Imported by: 0

Details

This section is empty.

This section is empty.

func CreateSchema(ctx context.Context, schema *pkg.Schema, db *sqlx.DB) error

CreateSchema creates the schema in the database. It generates all the SQL queries to CREATE the tables and indexes and runs it inside a transaction.

func GenerateSQLiteCreateTable(schema *pkg.Schema) (map[string][]string, error)

func GenerateSQLiteDeleteObject(schema *pkg.Schema) (map[string]string, error)

func GenerateSQLiteGetObjectMainTable(schema *pkg.Schema) (string, error)

GenerateSQLiteGetObjectMainTable generates SQLite query for getting the object with id from table.

func GenerateSQLiteGetObjectSecondaryTable(schema *pkg.Schema, name string) (string, error)

func GenerateSQLiteListObjectsMainTable(schema *pkg.Schema, limit, offset int) (string, error)

func GenerateSQLiteListObjectsSecondaryTable(schema *pkg.Schema, name string, ids []int64) (
	string,
	error,
)

func GenerateSQLiteUpdateObject(schema *pkg.Schema) (map[string]string, error)

func GetObject(
	ctx context.Context,
	db *sqlx.DB,
	schema *pkg.Schema,
	id int64,
) (map[string]interface{}, error)

func InsertData(ctx context.Context, db *sqlx.DB, schema *pkg.Schema, data map[string]interface{}) (int64, error)

type PaginationRequest struct {
	Offset int
	Limit  int
}

type PaginationResponse struct {
	Total  int
	Data   []map[string]interface{}
	Offset int
}

func ListObjects(
	ctx context.Context,
	db *sqlx.DB,
	schema *pkg.Schema,
	paginationRequest *PaginationRequest,
) (*PaginationResponse, error)

type QueryData struct {
	Fields    []pkg.Field
	TableName string
	IdField   string
	Limit     int
	Offset    int
}

type TableData struct {
	TableName string
	Fields    []pkg.Field
}