norm-repro.nim

import
  std / [options, logging, with]

import
  norm / [model, sqlite]

addHandler newConsoleLogger(fmtStr = "")

type
  User* = ref object of Model
    email*: string

  Customer* = ref object of Model
    name*: Option[string]
    user*: User

func newUser*(email = ""): User =
  User(email: email)

func newCustomer*(name = none string; user = newUser()): Customer =
  Customer(name: name, user: user)

let dbConn* = open(":memory:", "", "", "")

dbConn.createTables(newCustomer())

var
  userFoo = newUser("foo@foo.foo")
  userBar = newUser("bar@bar.bar")
  alice = newCustomer(some "Alice", userFoo)
  bob = newCustomer(some "Bob", userFoo)
  sam = newCustomer(some "Sam", userBar)
  aliceAndBob = [alice, bob]

with dbConn:
  insert aliceAndBob
  insert userBar
  insert sam

var customerBar = newCustomer()
dbConn.select(customerBar, "User.email = ?", "bar@bar.bar")