Documentation ¶
Overview ¶
Package mysql is responsible for mysql database connections and initialization.
Index ¶
Constants ¶
This section is empty.
Variables ¶
View Source
var MysqlQueries = []string{
`CREATE TABLE IF NOT EXISTS Thread(
Id VARCHAR(36) PRIMARY KEY,
CreatedAt TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6) not null,
Path varchar(255) not null UNIQUE
)`,
`CREATE TABLE IF NOT EXISTS Comment(
Id VARCHAR(36) PRIMARY KEY,
ThreadId VARCHAR(36) not null,
Body text not null,
Author varchar(255) not null,
Confirmed bool not null default false,
CreatedAt TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6) not null,
ReplyTo VARCHAR(36) default null,
DeletedAt TIMESTAMP(6) NULL,
FOREIGN KEY(ThreadId) references Thread(Id)
)`,
}
MysqlQueries represents a list of queries for initial table creation in mysql
Functions ¶
func CreateDatabase ¶
func CreateDatabase(databaseConfig model.Database) (abstraction.Database, error)
CreateDatabase creates a database instance from the given config
func CreateTestDatabase ¶
func CreateTestDatabase() abstraction.Database
CreateTestDatabase creates a test database
func ValidateConfig ¶
ValidateConfig validates the config for mysql
Types ¶
This section is empty.
Click to show internal directories.
Click to hide internal directories.