Versions in this module Expand all Collapse all v1 v1.0.2 Jul 16, 2022 Changes in this version type DBAccess + func (d *DBAccess) GetDataMapPage(sqlQuery string, pageNo int, pageSize int, dbFilePath string) ([]map[string]interface{}, error) v1.0.1 Jan 23, 2022 Changes in this version + const Err_DatabaseFileNotExists + const Err_DatabaseIsLocked + const Err_FileIsNotDatabase + const Err_NoRowsFound + func Decrypt(data []byte, passphrase string) ([]byte, error) + func DecryptFile(p string, pwdPhrase string) error + func Encrypt(plainData []byte, passphrase string) ([]byte, error) + func EncryptFile(p string, pwdPhrase string) error + type CollectionInfo struct + PageNo int + PageSize int + PositionFrom int + PositionTo int + RecordCount int + TotalPages int + type DBAccess struct + MaxIdleConns uint + MaxOpenConns uint + PRAGMA []string + Remote IRemoteSQLite + ShrinkDatabaseFiles bool + ShrinkWatchList []string + func NewDBAccess(d DBAccess) *DBAccess + func (d *DBAccess) AddDBFileToShrinkWatchList(dbFilePath string) + func (d *DBAccess) AppendDataTable(dtSrce *collc.Table, dtDest *collc.Table) (*collc.Table, error) + func (d *DBAccess) CloneDataTable(dtSrce *collc.Table) (*collc.Table, error) + func (d *DBAccess) DatabaseExists(path string) bool + func (d *DBAccess) Decrypt(data []byte, pwdPhrase string) ([]byte, error) + func (d *DBAccess) DecryptDatabase(dbFilePath string, pwdPhrase string) error + func (d *DBAccess) Encrypt(data []byte, pwdPhrase string) ([]byte, error) + func (d *DBAccess) EncryptDatabase(dbFilePath string, pwdPhrase string) error + func (d *DBAccess) ExecuteNonQuery(sqlStatement string, dbFilePath string) (int64, error) + func (d *DBAccess) ExecuteNonQueryNoTx(sqlStatement string, dbFilePath string) (int64, error) + func (d *DBAccess) ExecuteNonQueryPointToDB(sqlStatement string, db *sql.DB) (int64, error) + func (d *DBAccess) ExecuteScalare(sqlStatement string, dbFilePath string) (interface{}, error) + func (d *DBAccess) ExecuteScalarePointToDB(sqlStatement string, db *sql.DB) (interface{}, error) + func (d *DBAccess) GetColumnNames(dbFilePath string, tblName string) ([]string, error) + func (d *DBAccess) GetDB(dbFilePath string) (*sql.DB, error) + func (d *DBAccess) GetDataMap(sqlQuery string, dbFilePath string) ([]map[string]interface{}, error) + func (d *DBAccess) GetDataMapPointToDB(sqlQuery string, db *sql.DB) ([]map[string]interface{}, error) + func (d *DBAccess) GetDataTable(sqlQuery string, dbFilePath string) (*collc.Table, error) + func (d *DBAccess) GetDataTableJSON(tbl *collc.Table) string + func (d *DBAccess) GetDataTableRange(dtSrc *collc.Table, from int, to int) (*collc.Table, error) + func (d *DBAccess) GetDataTableWithTag(sqlQuery string, dbFilePath string, tag string) (*collc.Table, error) + func (d *DBAccess) GetPageInfoFromQuery(r *http.Request) (int, int) + func (d *DBAccess) GetPageOffset(recordCount int, pageSize int, pageNo int) (int, int, int) + func (d *DBAccess) GetPagingInfo(pageSize int, pageNo int, tableName string, countColName string, filter string, ...) (int, int, CollectionInfo) + func (d *DBAccess) GetShrinkWatchList() []string + func (d *DBAccess) GetTableCount(tableName string, dbFilePath string) (int64, error) + func (d *DBAccess) InsertDataTable(t *collc.Table, dbFilePath string) (int64, error) + func (d *DBAccess) ShrinkDB(dbFilePath string) error + func (dc *DBAccess) BulkInsert(dtSrc *collc.Table, dbFilePath string, notify func(status string)) error + func (dc *DBAccess) CloneDatabase(srcFilePath string, destFilePath string, notify func(status string)) error + func (dc *DBAccess) GetDataTableLongQuery(sqlQuery string, dbFilePath string, pageSize int, ...) (*collc.Table, error) + type LonqQueryArgs struct + PageSize int + ResultTable *collections.Table + RowsFetched int64 + Status string + TotalPages int + TotalToFetch int64 Incompatible versions in this module v2.0.1+incompatible Aug 22, 2023 v2.0.0+incompatible Jul 23, 2022