Sami Koskimäki koskimas

linkedin.com/in/koskimakisami

koskimas / kysely-intro-2.sql

Last active November 15, 2021 06:32

	insert into "person" (id, first_name, last_name)
	values ($1, $2, $3)
	on conflict ("id") do nothing

koskimas / kysely-intro-2.ts

Created November 14, 2021 15:14

koskimas / kysely-intro-1.sql

Last active November 14, 2021 14:41

	with "species_ages" as (
	select "species",
	min("pet"."age") as "min_age",
	max("pet"."age") as "max_age"
	from "pet"
	group by "species"
	)
	select "max_age"
	from "species_ages", (
	select "species", count("toy"."id") as "num_toys"

koskimas / o2-query-modifiers-join.ts

Created November 18, 2019 08:22

	await Person.query()
	.joinRelated('children(isFemale, hasPets, isJennifer)')
	.modifiers({
	hasPets(query: QueryBuilder<Person>): void {
	query.whereExists(Person.relatedQuery('pets'))
	},

	isJennifer(query: QueryBuilder<Person>): void {
	query.modify('findByName', 'Jennifer')
	}

koskimas / o2-query-modifiers-graph.ts

Last active November 18, 2019 08:21

	await Person.query()
	.withGraphFetched('children(isFemale, hasPets, isJennifer)')
	.modifiers({
	// New query-local modifier
	hasPets(query: QueryBuilder<Person>): void {
	query.whereExists(Person.relatedQuery('pets'))
	},

	// Bind argument to existing modifier.
	isJennifer(query: QueryBuilder<Person>): void {

koskimas / o2-query-modifiers-basic.ts

Last active November 18, 2019 08:20

	// Modifiers can be used with any query.
	await Person.query().modify('findByName', fullName)

	// Modifiers can be used with eager loading.
	await Person.query().withGraphFetched('children(isFemale)')

koskimas / o2-modifiers-model.ts

Last active November 18, 2019 08:40

	class Person extends Model {
	static modifiers = {
	isFemale(query: QueryBuilder<Person>): void {
	query.where('gender', 'female')
	},

	findByName(query: QueryBuilder<Person>, name: string): void {
	const { ref, fn } = Person
	const { lower } = fn

koskimas / o2-static-before-delete-hook.ts

Created November 17, 2019 09:09

-class Person extends Model {
-  static async beforeDelete({
-    asFindQuery,
-    cancelQuery
-  }: StaticHookArguments<Person>): Promise<any> {
-    const idsOfPersonsAboutToBeDeleted = await asFindQuery().select('id')
-    if (!(await shouldDelete(idsOfPersonsAboutToBeDeleted))) {
-      cancelQuery()
-    }

koskimas / o2-find.js

Created November 16, 2019 18:16

	// Note that the following query isn't executed! There's no `await`.
	const jennifers = Actor.query().where('firstName', 'Jennifer')

	// This is the only query that gets executed. `jennifers` query is built into
	// the SQL as a subquery.
	const movies = await Actor.relatedQuery('movies')
	.for(jennifers)
	.where('genre', 'action')

koskimas / o2-unrelate.js

Last active November 16, 2019 18:20

	// Note that the following query isn't executed! There's no `await`.
	const finnishActorsThatHaveChildren = Actor.query()
	.where('nationality', 'finnish')
	.whereExists(Actor.relatedQuery('children'))

	// This is the only query that gets executed. `finnishActorsThatHaveChildren`
	// query is built into the SQL as a subquery.
	await Actor.relatedQuery('movies')
	.for(finnishActorsThatHaveChildren)
	.unrelate()