database

package

v0.1.0 Latest Latest Go to latest Published: Apr 6, 2025 License: MIT Imports: 5 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/arthurdotwork/mig

Links

Open Source Insights

Documentation ¶

Index ¶

Constants
func Connect(cfg *config.Config) (*sql.DB, error)
func InitializeTables(db *sql.DB) error
func RecordHistory(db *sql.DB, version string, sqlContent string, tx *sql.Tx) error
func RecordMigration(db *sql.DB, version string, tx *sql.Tx) error
type MigrationVersion
- func GetAppliedMigrations(db *sql.DB) ([]MigrationVersion, error)

Constants ¶

View Source

const (
	CreateVersionTableSQL = `` /* 173-byte string literal not displayed */

	CreateHistoryTableSQL = `` /* 191-byte string literal not displayed */

)

Constants for the SQL statements to create the migration tables

Variables ¶

This section is empty.

Functions ¶

func Connect ¶

func Connect(cfg *config.Config) (*sql.DB, error)

Connect establishes a connection to the PostgreSQL database

func InitializeTables ¶

func InitializeTables(db *sql.DB) error

InitializeTables creates the necessary migration tables if they don't exist

func RecordHistory ¶

func RecordHistory(db *sql.DB, version string, sqlContent string, tx *sql.Tx) error

RecordHistory records an entry in the migration history with the SQL content

func RecordMigration ¶

func RecordMigration(db *sql.DB, version string, tx *sql.Tx) error

RecordMigration records a successfully applied migration

Types ¶

type MigrationVersion ¶

type MigrationVersion struct {
	ID        int
	Version   string
	AppliedAt time.Time
}

MigrationVersion represents a record in the mig_versions table

func GetAppliedMigrations ¶

func GetAppliedMigrations(db *sql.DB) ([]MigrationVersion, error)

GetAppliedMigrations retrieves all applied migrations

Source Files ¶

View all Source files

database.go

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL