1 reply

Query Attached Databases in SQLite

Hey so I am using drizzle with my local sqlite db, I have several databases which I at runtime attach to the main sqlite database. I need to query across each of these is there a reasonably nice way to do this through the orm? Maybe some sort of aliasing?

currently I am forced to do some sort of sql generation in the orm

const insertSql = db
  .insert(groupMessages)
  .values(optimisticMessage as GroupMessage)
  .returning()
  .toSQL()

const insertSql = db
  .insert(groupMessages)
  .values(optimisticMessage as GroupMessage)
  .returning()
  .toSQL()

which I then loop over a replace with the correct database aliases

const newMessage = db.get(sql.raw(replaceParams(            insertSql.sql.replace('"groupMessages"',`"${databaseAlias}"."groupMessages"`),
insertSql.params,
    ),
  ),
)

const newMessage = db.get(sql.raw(replaceParams(            insertSql.sql.replace('"groupMessages"',`"${databaseAlias}"."groupMessages"`),
insertSql.params,
    ),
  ),
)

But this is pretty ugly and not sql injection safe.

Any ideas on how to go about this? I guess a similiar issue would be multiple table schemas in other databases like postgres. Is there a standard approach on how to handle these situations at the minute?

Drizzle Team•3y ago•

1 reply

peterferguson

Query Attached Databases in SQLite

const insertSql = db
  .insert(groupMessages)
  .values(optimisticMessage as GroupMessage)
  .returning()
  .toSQL()

const insertSql = db
  .insert(groupMessages)
  .values(optimisticMessage as GroupMessage)
  .returning()
  .toSQL()

which I then loop over a replace with the correct database aliases

const newMessage = db.get(sql.raw(replaceParams(            insertSql.sql.replace('"groupMessages"',`"${databaseAlias}"."groupMessages"`),
insertSql.params,
    ),
  ),
)

const newMessage = db.get(sql.raw(replaceParams(            insertSql.sql.replace('"groupMessages"',`"${databaseAlias}"."groupMessages"`),
insertSql.params,
    ),
  ),
)

Query Attached Databases in SQLite

Similar Threads

Query Attached Databases in SQLite

Similar Threads

Similar Threads

Similar Threads