sqlite3

Documentation

Overview

Integrates with migration tools recognizing the standard "migrate up" and "migrate down" annotations, simplifying asset database schema management and rollbacks in SQLite3.

Index

• func Migrations() embed.FS

Examples

• Migrations

Functions

func Migrations

func Migrations() embed.FS

Example

dsn := "test.db"
if v, ok := os.LookupEnv("SQLITE3_DB"); ok {
	dsn = v
}

db, err := gorm.Open(sqlite.Open(dsn), &gorm.Config{})
if err != nil {
	panic("failed to connect database")
}

sqlDb, _ := db.DB()

migrationsSource := migrate.EmbedFileSystemMigrationSource{
	FileSystem: Migrations(),
	Root:       "/",
}

_, err = migrate.Exec(sqlDb, "sqlite3", migrationsSource, migrate.Up)
if err != nil {
	panic(err)
}

tables := []string{"entities", "entity_tags", "edges", "edge_tags"}
for _, table := range tables {
	fmt.Println(db.Migrator().HasTable(table))
}

err = os.Remove(dsn)
if err != nil {
	panic(err)
}

Output:

true
true
true
true