def setup_database():
# Create data tables
postgres_db.create_tables([User, Post, PostUser, Tag, PostTag, Settings],
safe=True)
# Adding gin index to Post.content and Tag.name for faster search
language = 'english'
Post.add_index(
SQL("CREATE INDEX post_full_text_search ON post USING GIN(to_tsvector('"
+ language + '\',content))'))
Tag.add_index(
SQL("CREATE INDEX tag_full_text_search ON tag USING GIN(to_tsvector('"
+ language + '\', name))'))
