How to insert into all values (and columns) from another table / view?
I realize I could write the raw sql, however I was curious how I would go about creating the following insert statement using kysely.
insert into <table>
select * from <view_or_table>
...
Triggers vs stored procedures
Hey everyone, I don't think this is related to Kysely directly, so excuse me but this is the only SQL type of server I am in. I am wondering what is the best way to automatically update a table attribute based on when another attribute changes (in the same table or another table). For example, if I want to have the attributes
updatedAt and lastLogin updated on their own from the Model below ```ts
model User {
id Int @id @default(autoincrement())
createdAt DateTime @default(now()) @db.Date
updatedAt DateTime @db.Timestamp() ...`Selectable`, `Insertable` and `Updateable` wrappers
Hey everyone, I am using this package: https://github.com/valtyr/prisma-kysely and I noticed that the output file does not include
...
export type Person = Selectable<PersonTable>
export type NewPerson = Insertable<PersonTable>
export type EditedPerson = Updateable<PersonTable>
export type Person = Selectable<PersonTable>
export type NewPerson = Insertable<PersonTable>
export type EditedPerson = Updateable<PersonTable>
How to sort by random?
Imagine this query:
```ts
export default function findUsers() {
return db...
Solution:
Should do it...
orderBy(sql`random()`)
orderBy(sql`random()`)
Using jsonArrayFrom with mariadb.
Hello,
Madiadb does not have cast to JSON, and cannot reference nested subqueries.
I'm a typescript newbie. 🙂
How can I rewrite this function to achieve a similar result with Mariadb?...
insert data into a table that has id of type bigserial
I created a table that has id(bigserial), cognitoId(varchar), subaccountInfo(json), I'm trying like this:
```
const obj = [{
nome: "nil", ...
Unable to connect to DB
Thank God there is a Discord server xD
I been trying to make this work for like 2 hours and I can't get it to work ```ts
import { Pool } from 'pg';
import {...
Solution:
There are a few approaches:
https://kysely.dev/docs/recipes/schemas
1. WithSchemaPlugin to apply schema globally to all queries.
2. withSchema method to apply to specific queries on the fly....
Limit with a literal value
Hi folks, thanks for all your work on Kysely, it's great!
I'm wondering how I can add a limit clause with a literal value, rather than a parameter.
I have a strange use case, I'm querying a https://materialize.com/ database, which presents as postgres, but has different features. It also has some limitations, one of which is limit must be a literal value, not an expression or parameter. ...
Prisma-kysely generator converts boolean to a number
Hi, so using
prisma-kysely, the generated type for a prisma Bool appears to be a number for some reason. Is this correct?Solution:
Oh my mistake. mysql does in fact not have a bool type lol
Is there a way to not have as many Selectable<> generics?
Hi. I'm using
prisma-kysely to generate my Kysely types, and it generates them with the Generated generic. I therefore need to use the Selectable generic to change it to the return type of what is selected when I want to use the type. Is there a way to avoid using it so often?insertId return by transaction
the insertId returned by a transaction is of the last executed query, right?
How can I use Kysely migration inside NextJS 13 project?
I created a folder called kysely in root directory of next js then created a migrator.ts which contains migration code (Migrator) and created a folder inside kysely folder called migrations then I placed all migrations in it. I tried to run the migrator.ts file with ts-node but it's throwing some module import issues (cannot use import module outside a module) how can I run migration in nextjs
Solution:
Fixed the issue by replacing ts-node with tsx
and also changed migrationFolder path to absolute path
```typescript
const migrator = new Migrator({...
i am trying to select my id from type uuid
when i select all id from administrator table, it returns me status 200 and returns all id
```
const responseDb = await db
.withSchema("schemaName")...
I am getting an error when entering an id with a uuid value
const uuid = uuidv4()
await db
.withSchema("schema_name")
.insertInto("table_name")...
Solution:
Hey 👋
You should try casting it to
uuid using sql template tag:
```ts...How can i enable postgres Extensions (eg: uuid) with in Kysely Migration File
const query = sql
create extension "uuid-ossp";;
how to execute this raw query inside migration file up method...Solution:
Hey 👋
You can execute raw queries by passing your Kysely instance to
.execute like this:
```ts...Unable to insert geometry Postgres
Hey everyone 👋🏻
Greetings!
I am trying to insert
point data into my Postgresql table but getting error: parse error - invalid geometry error. Here is the code ...Achieve Prisma-like nested selects
Hi. Is it possible to achieve Prisma-like nested selects with Kysely? I have the following code and it has the type below in Prisma, but I'm not sure how to achieve the same in Kysely without just doing an additional
select * from CommitteeCountry where id in (select id from Committee) or something along those lines and then mapping the results in JS
```ts
const data = await prisma.Committee.findMany({
include: {
countries: true,...Solution:
Why is numUpdatedRows a BigInt?
Hi. I'd just like to ask as to why the number of updated rows in Kysely is a BigInt, as for all other ORMs that I've seen, it's just a normal number. Was there any reason for this decision?
Solution:
In reality it can't. That SSD would use up all the atoms in the universe 😄
It's more for consistency. The inserted row's ID in the
InsertObject needs to be a bigint. Therefore all the others are too....How to translate the WITH keyword in postgres when SELECT does not have FROM?
I'm trying to translate the following postgres function into pure Kysley:
```sql
CREATE OR REPLACE FUNCTION rand.similarity_search(model TEXT, needle TEXT)
RETURNS TABLE (...