K
Kysely•5mo ago
hash0

smallint support (Postgres)

Type dataType does not contain smallint? 
addColumn<CN extends string>(columnName: CN, dataType: DataTypeExpression, build?: ColumnBuilderCallback): CreateTableBuilder<TB, C | CN>;
addColumn<CN extends string>(columnName: CN, dataType: DataTypeExpression, build?: ColumnBuilderCallback): CreateTableBuilder<TB, C | CN>;
export type DataTypeExpression = ColumnDataType | Expression<any>;
export type DataTypeExpression = ColumnDataType | Expression<any>;
export type ColumnDataType = 'varchar' | `varchar(${number})` | 'char' | `char(${number})` | 'text' | 'integer' | 'int2' | 'int4' | 'int8' | 'bigint' | 'boolean' | 'real' | 'double precision' | 'float4' | 'float8' | 'decimal' | `decimal(${number}, ${number})` | 'numeric' | `numeric(${number}, ${number})` | 'binary' | `binary(${number})` | 'bytea' | 'date' | 'datetime' | `datetime(${number})` | 'time' | `time(${number})` | 'timetz' | `timetz(${number})` | 'timestamp' | `timestamp(${number})` | 'timestamptz' | `timestamptz(${number})` | 'serial' | 'bigserial' | 'uuid' | 'json' | 'jsonb' | 'blob';
export type ColumnDataType = 'varchar' | `varchar(${number})` | 'char' | `char(${number})` | 'text' | 'integer' | 'int2' | 'int4' | 'int8' | 'bigint' | 'boolean' | 'real' | 'double precision' | 'float4' | 'float8' | 'decimal' | `decimal(${number}, ${number})` | 'numeric' | `numeric(${number}, ${number})` | 'binary' | `binary(${number})` | 'bytea' | 'date' | 'datetime' | `datetime(${number})` | 'time' | `time(${number})` | 'timetz' | `timetz(${number})` | 'timestamp' | `timestamp(${number})` | 'timestamptz' | `timestamptz(${number})` | 'serial' | 'bigserial' | 'uuid' | 'json' | 'jsonb' | 'blob';
Solution:
Yep, seems to be missing. You can use 
addColumn("foo", sql`smallint`)
addColumn("foo", sql`smallint`)
...
Jump to solution
5 Replies
hash0
hash0•5mo ago
No description
Solution
koskimas
koskimas•5mo ago
Yep, seems to be missing. You can use 
addColumn("foo", sql`smallint`)
addColumn("foo", sql`smallint`)
hash0
hash0•5mo ago
ok. Thx!
hash0
hash0•5mo ago
Created a small PR with a type update. https://github.com/kysely-org/kysely/pull/860
GitHub
Add missing smallint support for addColumn() by hash0000 · Pull Req...
Add missing smallint type support for addColumn()
koskimas
koskimas•5mo ago
Thanks! Merged
Want results from more Discord servers?
Add your server
More Posts
Examples inner join using OR?Hello, we are having trouble trying to have a inner join using OR, as in `ON a.id = b.id OR a.sub_idfull join "using" list of columnsHey, How can I create a full join which uses "using" I want to use "using" in the join but I only sIs kysely sanitizing sql injection when using raw sql ?Suppose I have a piece of code that does sql`${myString}` where myString contains sql injection, wilSupport for D1 batchingHi. I'm wondering about support for batching statements with Cloudflare's D1 batching, similar to liOmit/filter out columns from queryHey, is there an easy or convenient way with Kysely to filter out data from a query? Lets say I havHow to create a typed array of columns for select?Hello, I am trying to create some helpers that contain the list of columns used by multiple queries,Return `null` by default if no record foundHey, I am looking to have my queries return `null` instead of `undefined` if no records match my quecmpr as eb call SqlBool return typeHello, missed a couple of updates and now I'm back updating to latest. Found out `eb.cmpr` has been Argument of type 'RawBuilder<unknown>' is not assignable to...I have a query that looks like this: countQuery.where( 'activityId', 'in', Generic function to stream a tableI am trying to write a generic function that will take a kysely connection, a table name, a column n