database

package

v0.0.1 Latest Latest Go to latest Published: Jun 29, 2025 License: Apache-2.0 Imports: 4 Imported by: 0

Details

Package database provides SQLite database connection and query functionality

View Source

const (
	// InMemoryDB represents the SQLite in-memory database identifier
	InMemoryDB = ":memory:"
)

This section is empty.

This section is empty.

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

DB wraps a SQLite database connection with common operations

func New(dbPath string, readOnly bool) (*DB, error)

New creates a new database connection

func (db *DB) Close() error

Close closes the database connection

func (db *DB) Execute(statement string, args ...interface{}) (int64, error)

Execute runs an INSERT, UPDATE, or DELETE statement

func (db *DB) GetTableSchema(tableName string) ([]map[string]interface{}, error)

GetTableSchema returns the schema information for a specific table

func (db *DB) GetTables() ([]string, error)

GetTables returns a list of all tables in the database

func (db *DB) Path() string

Path returns the database file path

func (db *DB) Query(query string, args ...interface{}) ([]map[string]interface{}, error)

Query executes a SELECT query and returns the results