repo

package

v0.1.12 Latest Latest Go to latest Published: Jun 9, 2026 License: MIT Imports: 16 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/biisal/rowsql

Links

Open Source Insights

Documentation ¶

Overview ¶

Package repo contains the repository for the database

Index ¶

Variables
func ErrorInvalidTable(tableName string) error
func IsTableNotExistError(err error) bool
type CreateTableProps
type ListDataProps
type Querier
type Queries
- func New(db *sqlx.DB, driver configs.Driver, queryBuilder queries.Builder, ...) *Queries
type RowCache
- func NewRowCache(max int) *RowCache
type UpdateOrDeleteRowProps

Constants ¶

This section is empty.

Variables ¶

View Source

var ErrorNotFound = errors.New("not found")

Functions ¶

func ErrorInvalidTable ¶

func ErrorInvalidTable(tableName string) error

func IsTableNotExistError ¶

func IsTableNotExistError(err error) bool

Types ¶

type CreateTableProps ¶

type CreateTableProps struct {
	TableName string            `json:"tableName"`
	Inputs    []models.ColValue `json:"inputs"`
}

type ListDataProps ¶

type ListDataProps struct {
	TableName string `json:"tableName"`
	Limit     int    `json:"limit"`
	Offset    int    `json:"offset"`
	Column    string `json:"column"`
	Order     string `json:"order"`
}

type Querier ¶

type Querier interface {
	ListTables(ctx context.Context) ([]models.ListTablesRow, error)
	ListColsMetaData(ctx context.Context, tableName string) ([]models.ColValue, error)
	ListRows(ctx context.Context, props ListDataProps) ([]models.RowSet, error)
	InsertRow(ctx context.Context, tableName string, colValues []models.ColValue) error
	UpdateRow(ctx context.Context, props UpdateOrDeleteRowProps) error
	DeleteRow(ctx context.Context, props UpdateOrDeleteRowProps) error
	GetRow(ctx context.Context, tableName, hash string, offset, limit int) ([]models.ColValue, error)
	GetDriver() configs.Driver
	RunSQLQuery(ctx context.Context, query string) (*models.RunSQLQueryOutput, error)
}

type Queries ¶

type Queries struct {
	// contains filtered or unexported fields
}

func New ¶

func New(db *sqlx.DB, driver configs.Driver, queryBuilder queries.Builder, maxItemsPerPage int) *Queries

func (*Queries) CheckTableExitsInDB ¶

func (q *Queries) CheckTableExitsInDB(ctx context.Context, tableName string) error

func (*Queries) CreateHistoryTable ¶

func (q *Queries) CreateHistoryTable(ctx context.Context) error

func (*Queries) CreateTable ¶

func (q *Queries) CreateTable(ctx context.Context, props CreateTableProps) error

func (*Queries) DeleteHistory ¶

func (q *Queries) DeleteHistory(ctx context.Context, id int) error

func (*Queries) DeleteRow ¶

func (q *Queries) DeleteRow(ctx context.Context, props UpdateOrDeleteRowProps) error

func (*Queries) DeleteTable ¶

func (q *Queries) DeleteTable(ctx context.Context, tableName string) error

func (*Queries) GetDriver ¶

func (q *Queries) GetDriver() configs.Driver

func (*Queries) GetQuotedTableName ¶

func (q *Queries) GetQuotedTableName(tableName string) string

func (*Queries) GetRow ¶

func (q *Queries) GetRow(ctx context.Context, tableName, hash string, offest, limit int) ([]models.ColValue, error)

func (*Queries) GetRowCount ¶

func (q *Queries) GetRowCount(ctx context.Context, tableName string) (int, error)

func (*Queries) Init ¶

func (q *Queries) Init(ctx context.Context) (err error)

func (*Queries) InsertHistory ¶

func (q *Queries) InsertHistory(ctx context.Context, message string)

func (*Queries) InsertRow ¶

func (q *Queries) InsertRow(ctx context.Context, tableName string, form []models.ColValue) error

func (*Queries) ListColsMetaData ¶ added in v0.1.7

func (q *Queries) ListColsMetaData(ctx context.Context, tableName string) ([]models.ColValue, error)

func (*Queries) ListHistory ¶

func (q *Queries) ListHistory(ctx context.Context, limit, offset int) ([]models.History, error)

func (*Queries) ListRows ¶

func (q *Queries) ListRows(ctx context.Context, props ListDataProps) ([]models.RowSet, error)

func (*Queries) ListTables ¶

func (q *Queries) ListTables(ctx context.Context) ([]models.ListTablesRow, error)

func (*Queries) RunSQLQuery ¶ added in v0.1.7

func (q *Queries) RunSQLQuery(ctx context.Context, query string) (*models.RunSQLQueryOutput, error)

func (*Queries) UpdateRow ¶

func (q *Queries) UpdateRow(ctx context.Context, props UpdateOrDeleteRowProps) error

func (*Queries) WithTx ¶

func (q *Queries) WithTx(tx *sqlx.Tx) *Queries

type RowCache ¶

type RowCache struct {
	Max  int
	Keys []string
	Rows map[string]any
	// contains filtered or unexported fields
}

func NewRowCache ¶

func NewRowCache(max int) *RowCache

func (*RowCache) Delete ¶

func (c *RowCache) Delete(key string)

func (*RowCache) Get ¶

func (c *RowCache) Get(key string) any

func (*RowCache) Set ¶

func (c *RowCache) Set(key string, row any)

type UpdateOrDeleteRowProps ¶

type UpdateOrDeleteRowProps struct {
	TableName string
	Values    []models.ColValue
	Hash      string
	Limit     int
	Offset    int
}

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL