sqldb

Documentation

Index

• func CheckDatabaseName(databaseName string) bool
• func CheckTableName(tableName string) bool
• func EscapeApostrophes(dataString string) string
• func EscapeDoubleQuotes(dataString string) string
• func EscapeMySQLString(dataString string) string
• func EscapePostgreSQLString(dataString string) string
• func NullStringToString(value sql.NullString) string
• type SQLdb
  • func Connect(conn SQLdb, checkENV ...bool) (SQLdb, error)
  • func (conn *SQLdb) Close() error
  • func (conn *SQLdb) Connect(checkENV ...bool) error
  • func (conn *SQLdb) Exec(query string, args ...any) (sql.Result, error)
  • func (conn *SQLdb) GetSQLTableInfo(tableName string) ([]struct{ ... }, map[string]string, error)
  • func (conn *SQLdb) GetTableInfo(tableName string) ([]struct{ ... }, map[string]string, error)
  • func (conn *SQLdb) Query(query string, args ...any) (*sql.Rows, error)
  • func (conn *SQLdb) QueryRecords(query string, args ...any) ([]map[string]any, error)
  • func (conn *SQLdb) QueryRow(query string, args ...any) *sql.Row
  • func (conn *SQLdb) ShowDatabases() ([]string, error)
  • func (conn *SQLdb) ShowTables() ([]string, error)
  • func (conn *SQLdb) ShowTablesMap() (map[string]map[string]string, error)
  • func (conn *SQLdb) TableExists(tableName string) (bool, error)

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

func EscapeMySQLString

func EscapeMySQLString(dataString string) string

func EscapePostgreSQLString

func EscapePostgreSQLString(dataString string) string

func NullStringToString

func NullStringToString(value sql.NullString) string

Types

type SQLdb

type SQLdb struct {
	//--------------------
	DBType string
	//--------------------
	Host string
	//--------------------
	User     string
	Password string
	//--------------------
	AllowNativePasswords bool
	//--------------------
	FilePath    string
	DataPath    string
	Database    string
	DatabaseExt string
	//--------------------
	AutoCreate bool
	//--------------------
	DB *sql.DB
	// contains filtered or unexported fields
}

func Connect

func Connect(conn SQLdb, checkENV ...bool) (SQLdb, error)

func (*SQLdb) Close

func (conn *SQLdb) Close() error

func (*SQLdb) Connect

func (conn *SQLdb) Connect(checkENV ...bool) error

func (*SQLdb) Exec

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

func (*SQLdb) GetSQLTableInfo

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

func (*SQLdb) GetTableInfo

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

func (*SQLdb) Query

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

func (*SQLdb) QueryRecords

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

func (*SQLdb) QueryRow

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

func (*SQLdb) ShowDatabases

func (conn *SQLdb) ShowDatabases() ([]string, error)

func (*SQLdb) ShowTables

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

func (*SQLdb) ShowTablesMap

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

func (*SQLdb) TableExists

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