Topics

Kysely•16mo ago

stock trade

query https://user-images.githubusercontent.com/103982094/228803165-415ff305-d8d7-49e2-ba93-1359bf69c74f.png please share your solutions or discuss the solutions in the comments. Kysely feedback and suggestions for enhancement are also welcome.

9 Replies

Igal•16mo ago

v0.24.2 solution https://wirekang.github.io/kysely-playground/?p=f&i=-NSLNa1J1ghEtp8rCN6y using a helper function to DRY it up. using a single .where invocation, but could chain multiple invocations for the and - wanted a single eb for all.

koskimas•16mo ago

Nice! Why is that withTables needed? Didn't the DB used to get merged with the global DB type automatically in the playground?

Igal•16mo ago

Whenever you start importing stuff, it breaks 😢

thelinuxlich•16mo ago

why you need sql.lit when using bxp? The bxp example when you hover the function shows .bxp("age","+", 1)

Igal•16mo ago

I normally wouldn't, wanted to be 100% matched to the source.

wirekang•16mo ago

Now you can import stuffs if you wrap interface DB with declare global https://wirekang.github.io/kysely-playground/?p=f&i=-NSJaFkfVUzf8Pi8gHmV

thelinuxlich•16mo ago

Noice

Igal•16mo ago

Thank you! Updated the solution's playground link.

wirekang•16mo ago

https://kyse.link/?p=s&i=HoRucnpO790dG0o1TvN1

1.5KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

Trouble running migrationsI am trying to use Kysely on a svelte-kit project, I set up the migration script like the example sh Suggestions on implementing SQLite as DocumentDB or GraphDNWould love recommendations on using Kysely to implement something similar to the following. https://open source examplesDo you know of a mid-large size open source codebase that has integrated kysely? Size isn’t most im Types for use with leftJoinHiya! I'm attempting to do a leftJoin and return the result: ``` const result = await db .sel mysql InsertResult always emptymy app is heavy id/transaction user and i need the id of created register to insert another register RawBuilder is not "Compilable"How one should execute RawBuilders coming from (for example) ```sql`customsql` ``` since they're no Query with ANDs and ORs - struggling with syntaxI want to be able to create a query that looks like this - i.e. has a first WHERE section that mus Subquery type error when using genericsI have the following simple query being generated by my function `f`: ```typescript const f = () => Extacting where clause generation into dedicated functionI'm building up a query dynamically and need to use some of the logic embedded in where clauses from createQueryIdIs this function supposed to be exported and used in users code? I'm handling query execution with a