patwoz
patwoz
PostsComments
DTDrizzle Team
Created by patwoz on 8/27/2024 in #help
How do I load sqlite extensions for drizzle-kit?
I'm getting SqliteError: unknown function: ulid_with_prefix() when running drizzle-kit migrate due of the ulid extension I'm using. How do I load the extension within drizzle kit?
12 replies
DTDrizzle Team
Created by patwoz on 4/30/2024 in #help
sql where column md5
Hey, how can I achieve the following statement in drizzle? 
-- mysql

SELECT * FROM podcasts_title
WHERE MD5(guid)='baf59ee6be7bf0cc8140038d7cd641b4'
--    ^^^^^^^^^
-- mysql

SELECT * FROM podcasts_title
WHERE MD5(guid)='baf59ee6be7bf0cc8140038d7cd641b4'
--    ^^^^^^^^^
await db
    .select()
    .from(podcastsTitle)
    .where(
      eq(podcastsTitle.guid, songId)
      // ^^^^^^^^^^^^^^^^^^
    )
await db
    .select()
    .from(podcastsTitle)
    .where(
      eq(podcastsTitle.guid, songId)
      // ^^^^^^^^^^^^^^^^^^
    )
2 replies