sqlitedb

package
v0.0.0-...-05b860d Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Apr 28, 2024 License: MIT Imports: 8 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func CheckDatabaseName

func CheckDatabaseName(databaseName string) bool

func CheckTableName

func CheckTableName(tableName string) bool

func EscapeApostrophes

func EscapeApostrophes(dataString string) string

func EscapeDoubleQuotes

func EscapeDoubleQuotes(dataString string) string

Types

type SQLiteDBStruct

type SQLiteDBStruct struct {
	//----------
	FilePath    string
	Database    string
	DatabaseExt string
	//----------
	AutoCreate bool
	//----------
	DB *sql.DB
}

func Connect

func Connect(conn SQLiteDBStruct) (SQLiteDBStruct, error)

func (*SQLiteDBStruct) Close

func (conn *SQLiteDBStruct) Close() error

func (*SQLiteDBStruct) Connect

func (conn *SQLiteDBStruct) Connect() error

func (*SQLiteDBStruct) Exec

func (conn *SQLiteDBStruct) Exec(query string, args ...any) (sql.Result, error)

func (*SQLiteDBStruct) GetRowsInfo

func (conn *SQLiteDBStruct) GetRowsInfo(rows *sql.Rows) (
	[]struct {
		Sequence int
		Name     string
		Type     string
	},
	map[string]string,
	error)

func (*SQLiteDBStruct) GetSQLTableInfo

func (conn *SQLiteDBStruct) GetSQLTableInfo(tableName string) (
	[]struct {
		Sequence int
		Name     string
		Type     string
	},
	map[string]string,
	error)

func (*SQLiteDBStruct) GetTableInfo

func (conn *SQLiteDBStruct) GetTableInfo(tableName string) (
	[]struct {
		Sequence int
		Name     string
		Type     string
	},
	map[string]string,
	error)

func (*SQLiteDBStruct) Query

func (conn *SQLiteDBStruct) Query(query string, args ...any) (*sql.Rows, error)

func (*SQLiteDBStruct) QueryRecords

func (conn *SQLiteDBStruct) QueryRecords(query string, args ...any) ([]map[string]any, error)

func (*SQLiteDBStruct) QueryRow

func (conn *SQLiteDBStruct) QueryRow(query string, args ...any) *sql.Row

func (*SQLiteDBStruct) ScanRows

func (conn *SQLiteDBStruct) ScanRows(sqlRows *sql.Rows) ([]map[string]any, error)

func (*SQLiteDBStruct) ShowTables

func (conn *SQLiteDBStruct) ShowTables() ([]string, error)

func (*SQLiteDBStruct) ShowTablesMap

func (conn *SQLiteDBStruct) ShowTablesMap() (map[string]map[string]string, error)

func (*SQLiteDBStruct) TableExists

func (conn *SQLiteDBStruct) TableExists(tableName string) (bool, error)

Jump to

Keyboard shortcuts

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