#function(select/insert/etc...)# is not a function

[prpanto]

After a lot of search (10hours) I really tiered with types on typescript on my app with nuxt and drizzle(mysql). Please I need help...
My project is clone from repo next but with mysql https://github.com/atinux/nuxt-todos-edge
I have some error of select/insert/delete/update/ect...

1. useDatabase(...).#function# is not a function
2. Property 'id' does not exist on type 'User'. (Im not sure if it is related with drizzle)

Setup:

// /server/utils/db.ts
import { drizzle, MySql2Database } from 'drizzle-orm/mysql2'
import * as mysql from 'mysql2/promise'

const runtimeConfig = useRuntimeConfig()
let database: MySql2Database

export * as tables from '~/server/database/schema'

export const useDatabase = async () => {
  if (!database) {
    const client = await mysql.createConnection(runtimeConfig.databaseUri)
    
    database = drizzle(client)
  }
  
  return database
}

// /server/database/schema.ts
import { mysqlTable, varchar, int, timestamp, serial } from 'drizzle-orm/mysql-core'

export const todos = mysqlTable('todos', {
  id: serial('id').primaryKey(),
  userId: int('user_id').notNull(), // GitHub Id
  title: varchar('varchar', { length: 255 }).notNull(),
  completed: int('completed').notNull().default(0),
  createdAt: timestamp('created_at').defaultNow(),
})

How I use:

// /server/api/todos/index.get.ts
import { eq } from 'drizzle-orm'

export default eventHandler(async (event) => {
  const session = await requireUserSession(event)

  const todos = await useDatabase().select().from(tables.todos).where(eq(tables.todos.userId, session.user.id)).all()

  return todos
})

[nathanchapman]

@prpanto

For issue 1: you need to await the useDatabase function first since it's also async.

// /server/api/todos/index.get.ts
import { eq } from 'drizzle-orm'

export default eventHandler(async (event) => {
  const session = await requireUserSession(event)
  const db = await useDatabase()

  const todos = await db.select().from(tables.todos).where(eq(tables.todos.userId, session.user.id)).all()

  return todos
}

For issue 2: There's no users table in your schema, so I'm really not sure what's going on here. I'd need to see more of your code, including what requireUserSession is doing