Association supported

[draveness]

Supporting all association in SQLite needs too much work, especially when related to the association. The many-to-many relation is hard to implement in the project because it's so complicated and we need to deal with different edge cases.

In order to reduce the complexcity of this lib. We decided to remove the foreign key from the whole project and use binary to store these kinds of relation.

[draveness]

#9 #19

[draveness]

Two kinds of implementation:

Use comment.1

Each model should have an association property which at the second position in database:

privatedId, association, ...

The type of association is TEXT, and it contains all the association information of current value. ex:

"comment.1 person.2 shopping_item.1"

Each association value is separated by a space, type and privatedId are separated by a dot ..

Use single privatedId with some associations value

commentsAssociation = "1 2 3"
peopleAssociation = "1 2 4"

[draveness]

After discussion, we decide to use association table instead of all foreign key. Separate models and associations. If there is association like this.

define :article do
  has_many :comments
end

define :comment do
  belongs_to :article
end

Models defined above will generate an association table called article_comment_association automatically.

column: privateId, articleId, commentId