darwinx

darwinx

Biblioteca de evolución del esquema de Postgres para Go With PGX
Basado en https://github.com/guiabolso/darwin

Ejemplo

 package main

import (
	"context"
	"github.com/jackc/pgx/v5"
	"github.com/pkg/errors"
	"net/url"
)

var (
	migrations = []darwinx. Migration {
		{
			Version :     1 ,
			Description : "Creating table posts" ,
			Script : `CREATE TABLE posts (
						id INT 		auto_increment, 
						title 		VARCHAR(255),
						PRIMARY KEY (id)
					 );` ,
		},
		{
			Version :     2 ,
			Description : "Adding column body" ,
			Script :      "ALTER TABLE posts ADD body TEXT AFTER title;" ,
		},
	}
)

func main () {
	conn , _ := pgx . Connect ( context . Background (), ( & url. URL {
        Scheme :   "postgres" ,
        User :     url . UserPassword ( "postgres" , "admin" ),
        Host :     "localhost:5432/tcp" ,
        Path :     "db" ,
        RawQuery : "sslmode=disable&timezone=UTC" ,
    }). String ())

	d , _ := darwinx . New ( conn , darwinx . WithMigration ( migrations ))

	err := d . Migrate ()
	if err != nil {
		log . Println ( err )
	}
}