sqlite

package

v0.0.0-...-e0e25f9 Latest Latest Go to latest Published: Apr 12, 2024 License: MIT Imports: 11 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

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
}