import db.sqlite

struct Foo {
	id       int @[primary; sql: serial]
	name     string
	children []Child @[fkey: 'parent_id']
}

struct Child {
	id        int @[primary; sql: serial]
	parent_id int
	name      string
	bar       ?Bar @[fkey: 'child_id']
}

struct Bar {
	id       int @[primary; sql: serial]
	child_id int
	name     string
}

fn main() {
	db := sqlite.connect(':memory:')!

	sql db {
		create table Foo
		create table Child
		create table Bar
	}!

	child_one := Child{
		name: 'abc'
	}

	child_two := Child{
		name: 'def'
	}

	bar_one := Bar{
		id:   0
		name: 'name'
	}

	foo := Foo{
		name:     'abc'
		children: [
			child_one,
			child_two,
		]
	}
	_ := sql db {
		insert foo into Foo
	}!

	sql db {
		update Child set bar = bar_one where id == 0
	}!
}