Database Migration using library

Question

I was trying to migrate database schema to POSTGRESQL using the code below BUT it does not work, it returned an error

"source driver: unknown driver file (forgotten import?)"

And it worked well using CLI

Up.sql and down.sql files are in dbMigration folder

package main

import (
    "log"
    "github.com/golang-migrate/migrate"
)

func main() {
    mg, err := migrate.New(
        "file://dbMigration",
        "postgres://username:localhost:5432/databasename?sslmode=disable",
    )
    if err != nil {
        log.Fatal(err)
    }
    if err = mg.Up; err != nil {
        log.Fatal(err)
    }
}

The Fool · Accepted Answer · 2022-01-23 12:41:39Z

3

If you use database packages in go, you usually need to import the driver separately.

That's also what the error is trying to tell you.

source driver: unknown driver file (forgotten import?)

In golang-migrate, you can import the driver from their repository.

import (
    "github.com/golang-migrate/migrate/v4"
    _ "github.com/golang-migrate/migrate/v4/database/postgres"
    _ "github.com/golang-migrate/migrate/v4/source/github"
)

This is also documented in their readme.

edited Jan 23, 2022 at 12:41

answered Jan 23, 2022 at 12:12

The Fool

21.2k7 gold badges76 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Database Migration using library

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related