So there is a major disadvantage for using the following format for
keeping track of foreign keys in things like "comments" plugin and
"tagging" plugin
db.define_table('comments_link',
Field('table_name'),
Field('record_id'),
Field('comment_id', db.comment),
)
SO you end up with the following csv
"blog_post", "123", 15
The problem is when exporting the database to csv, the foreign
references don't keep their integrity, since they are just string
fields after all.
I am saying this to notify anybody who might be doing this in their systems.
I will be rewriting blogitizors plugins to use a real foreign key
reference for these, sadly but it is necessary. It will however speed
the database up by doing this.
And another update, blogitizor will be released open source within a week.
-Thadeus
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
