K
Kysely•12mo ago
bun

is this uuid() correct in mysql?

export async function up(db: Kysely<any>): Promise<void> { await db.schema .createTable("Payment") .addColumn("id", "char", (col) => col.defaultTo(raw("UUID()")).primaryKey())
1 Reply
Igal
Igal•12mo ago
Hey đź‘‹ Try this out: 
await db.schema
  .createTable("Payment")
  .addColumn("id", "varchar(36)", (cb) =>
    cb.primaryKey().defaultTo(sql`(uuid())`),
  )
  .execute()
await db.schema
  .createTable("Payment")
  .addColumn("id", "varchar(36)", (cb) =>
    cb.primaryKey().defaultTo(sql`(uuid())`),
  )
  .execute()
https://kyse.link/?p=s&i=G2STlnUKzAqM9heKsHES
Want results from more Discord servers?
Add your server
More Posts
aliases vs strict mode in tsconfigI have a problem with tsconfig. When I have strict mode kysely does not find aliases. What is the "mCTE with exists() and case()Hey guys, just wrote this one and I thought I'd share. ```sql WITH "ongoing" AS ( SELECT Kysely originI have to ask. Where does the “kysely” name come from…?🤷‍♂️ It means “sour” in my mother tongue �coalesce in where statementI've found examples and documentation for coalesce in select however I still struggle how to use it Which approach is better for coalesce and similar functions?The fn and raw looks to me familiar as in sequelize there is fn and literal. What is the right approSingle source of truth (defaultAlias-schema-tableName)Hi, is there any way how to set default alias to schema.table mapping to have single source of truth