Foreign Key #78
Description
Thanks for this repo!
Does SimpleSQLite supports foreign key (with ORM) by referencing another table?
For example:
class EmailAddress(Model):
id = Integer(primary_key=True)
address = Text(not_null=True, unique=True)
class Email(Model):
id = Integer(primary_key=True)
content= Text()
from_addr = Email() # This?
to_addr = Email() # And this?Moreover, if so, can we create the corresponding foreignkey entry if it doesn't already exists?
Email.insert(
Email(
content="Hello!",
from_addr=EmailAddress(...),
to_addr=EmailAddress(...),
)
)