Foreign Key

[soraxas]

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(...),
  )
)

[thombashi]

@soraxas Unfortunately, SimpleSQLite does not support foreign keys for ORM for now. I will consider future enhancements.

[soraxas]

I see! Anything that I can help with it?