Gorm connection from Existing SQLite connection

[lesichkovm]

Describe the feature

To be able to use an already opened SQLite DB by Gorm

Motivation

The Gorm for MySQL and Postgres support existing database connections to be reused.

However none of the other databases support the same.

It should be unified accross the board.

Even probably add a special method that accepts a database/sql instance

gorm.FromDB(db *sql.DB)

Related Issues

[lesichkovm]

@jinzhu any updates on this issue?

[manuelarte]

@lesichkovm did you manage to do it?

I managed to have something working like this:

"gorm.io/driver/sqlite"
"gorm.io/gorm"

gormDB, err := gorm.Open(sqlite.New(sqlite.Config{Conn: db}), &gorm.Config{})

[lesichkovm]

@manuelarte thank you for chipping in. Looks like a nice way of accomplishing it.

@jinzhu can this be made part of the standard functions, to not require workarounds.