database

type AuthProfile struct {
	UserId   int64  `db:"id"`
	Username string `db:"username"`
}

type DBConfig struct {
	SQLFilePaths
	// Queries must be a pointer kind ( a pointer to a struct )
	Queries
	Type     DBType
	Host     string
	Port     int
	User     string
	Password string
	Database string
	SSLMode  string
	Params   string
	// contains filtered or unexported fields
}

type DBType string

type Queries interface{}

type SQLFilePaths struct {
	// QueryFilePath .sql file containing all the queries to be executed. Useful
	// for separating SQL from code logic
	QueryFilePath *string
	// SchemaFilePath .sql file containing the SQL commands. This can have SQL commands
	// to create / alter tables. Use CREATE TABLE IF NOT EXISTS for all create
	// table queries. For any subsequent modifications,
	// add alter queries inside the schema file and those changes
	// will be synced during the server boot.
	SchemaFilePath *string
}

type ThunderByteSetting struct {
	ID    int    `db:"id"`
	Key   string `db:"key"`
	Value string `db:"value"`
}

type ThunderByteSettings []ThunderByteSetting

type ThunderbyteQueries struct {
	GetAllSettings             *sqlx.Stmt `query:"get-all-settings"`
	GetSettingByKey            *sqlx.Stmt `query:"get-setting-by-key"`
	VerifyCredentials          *sqlx.Stmt `query:"verify-creds"`
	FetchAuthProfileByUsername *sqlx.Stmt `query:"fetch-auth-profile-by-username"`
	FetchAuthProfileById       *sqlx.Stmt `query:"fetch-auth-profile-by-id"`
	CreateAuthProfile          *sqlx.Stmt `query:"create-auth-profile"`
	CreatePassword             *sqlx.Stmt `query:"create-password"`
}

type VerifiedUser struct {
	UserId   int64  `db:"userid"`
	Username string `db:"username"`
}