Topics

Kysely•9mo ago

Binary fields in mySQL

I have a schema with ids stored as BINARY (sucks I know). Is it possible to write a plugin to convert them to string when receiving?

Solution:

You can use the typeCast config of mysql2 ```ts typeCast: function (field, next) { if (field.type === 'TINY' && field.length === 1) {...

Jump to solution

4 Replies

koskimas•9mo ago

Are you using the built-in MysqlDialect?

thelinuxlich•9mo ago

yes solved it with

typeCast(field,next) {
    if (field.type === 'BINARY') {
        return field.string();
    }
    return next();
}

typeCast(field,next) {
    if (field.type === 'BINARY') {
        return field.string();
    }
    return next();
}

passing to createPool options

Solution

koskimas•9mo ago

You can use the typeCast config of mysql2

  typeCast: function (field, next) {
    if (field.type === 'TINY' && field.length === 1) {
      return (field.string() === '1'); // 1 = true, 0 = false
    } else {
      return next();
    }
  }

  typeCast: function (field, next) {
    if (field.type === 'TINY' && field.length === 1) {
      return (field.string() === '1'); // 1 = true, 0 = false
    } else {
      return next();
    }
  }

thelinuxlich•9mo ago

thanks!

1.4KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

jsonb_build_object and raw sql possibilitiesis possible to do this query without use sql.raw? ``` sql<string>`jsonb_build_object(${sql.join([ ts_rank in selectstill not possible? ```typescript .select([ 'finance_reimbursement_requests.reimbursemen How to convert this raw query to kysely?```sql UPDATE finance_reimbursement_approval_matrix SET has_approved = true WHERE approval_matrix_id Converting a more complex query to KyselyI wrote this query for my database, and I've been trying to convert it to use Kysely but can't seem Select count?Can't find any docs regarding this can someone send me the docs for this? Thank you in advance.Error "isSelectQueryBuilder" while using doUpdateSet on conflictHello, I get an error when dealing with an update object factory for `doUpdateSet` expression during New type error in 0.26.3I recently upgraded from 0.26.1 to 0.26.3 and I'm getting a type error trying to call a reusable exp what is this error, i started getting it randomly``` error: syntax error at or near ")" at /Users/username/Workspace/company/project/node_modules Kysely doesn't work in jest/test environmentFor some reason Kysely does not work when I'm running test via Jest. I have a simple Express applica Is there a plan to add "NULLS NOT DISTINCT" (postgresql v15) option to unique constraints/indexes?In postgresql version 15.0 "NULLS NOT DISTINCT" statement was introduced. How to include this statem