Change drizzle connection string at runtime

I have an existing

drizzle

drizzle

instance that's exported from a module that many other modules import. I'd like to modify that instance at runtime to change the connection string. I thought maybe I could set the

$client

$client

like so:

db.$client = new Pool({
    connectionString: createConnectionString({
        user: inject('DATABASE_USER'),
        password: inject('DATABASE_PASSWORD'),
        host: inject('DATABASE_HOST'),
        port: inject('DATABASE_PORT'),
        database: databaseName,
    })
})

await db.$client.connect()

db.$client = new Pool({
    connectionString: createConnectionString({
        user: inject('DATABASE_USER'),
        password: inject('DATABASE_PASSWORD'),
        host: inject('DATABASE_HOST'),
        port: inject('DATABASE_PORT'),
        database: databaseName,
    })
})

await db.$client.connect()

But it just hangs.. I know this seems odd but I need to be able to swap out the db connection for each integration test.. I don't know how to accomplish that without actually modifying the singleton db connection

Drizzle Team•16mo ago

Tandy

Change drizzle connection string at runtime

I have an existing

drizzle

drizzle

instance that's exported from a module that many other modules import. I'd like to modify that instance at runtime to change the connection string. I thought maybe I could set the

$client

$client

like so:

db.$client = new Pool({
    connectionString: createConnectionString({
        user: inject('DATABASE_USER'),
        password: inject('DATABASE_PASSWORD'),
        host: inject('DATABASE_HOST'),
        port: inject('DATABASE_PORT'),
        database: databaseName,
    })
})

await db.$client.connect()

db.$client = new Pool({
    connectionString: createConnectionString({
        user: inject('DATABASE_USER'),
        password: inject('DATABASE_PASSWORD'),
        host: inject('DATABASE_HOST'),
        port: inject('DATABASE_PORT'),
        database: databaseName,
    })
})

await db.$client.connect()

Change drizzle connection string at runtime

Similar Threads

Change drizzle connection string at runtime

Similar Threads

Similar Threads

Similar Threads