gosqlite3

package module

v1.3.0 Latest Latest Go to latest Published: Feb 20, 2025 License: GPL-3.0 Imports: 4 Imported by: 0

Details

gosqlite3 provides basic CRUD functionalities and a predefined users tables that contains below columns

Column name	Type
Id	INTEGER PRIMARY KEY AUTOINCREMENT
username	TEXT NOT NULL UNIQUE
password	TEXT

Create "db/config" folder under parent program folder .
Create "config.yml" file inside config dir .
Add below config in the "config.yml" file . Please note that the file can be updated based on users requirement .

dbConfig:
  path: "./db" # Path where the db will be created and stored
  name: "mydb.db" # Name of the db

This section is empty.

This section is empty.

func ConnectToSQLiteDB(dbName, dbPath string) (*sql.DB, error)

func ReadDbConfig() (*sql.DB, error)

type Config struct {
	DatabaseConfig Database `yaml:"dbConfig"`
}

Struct to hold the full YAML config

type Database struct {
	DbPath string `yaml:"path"`
	DbName string `yaml:"name"`
}

Global vars will be used for storing config details

Path	Synopsis
crud
examples