如何指示SQLAlchemy在创建时创建SQLite FTS3表
我希望SQLAlchemy在.create_all()
期间创建一个FTS3表。 我需要添加哪些特殊选项,以便知道CREATE VIRTUAL TABLE ... USING FTS3(tokenizer=...)
?
据我所知要实现这个功能,你必须改善sqlite方言来改变create_table行为。
但是,你可以使用这个快速,但丑陋的解决方案与“monkeypatching”
# ugly monkeypatch
from sqlalchemy.dialects.sqlite.base import SQLiteDDLCompiler
old_create_table = SQLiteDDLCompiler.visit_create_table
def new_create_table(*args, **kwargs):
sql = old_create_table(*args, **kwargs)
# TODO
# 1) check table with FTS3
# 2) change sql to CREATE VIRTUAL TABLE ... USING FTS3(tokenizer=...)
print 'SQL: %s' % sql
return sql
SQLiteDDLCompiler.visit_create_table = new_create_table
# end of ugly monkey patch
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import schema, MetaData, Column, Integer
metadata = MetaData()
Base = declarative_base(metadata=metadata)
class MyModel(Base):
__tablename__ = 'table'
id = Column(Integer, primary_key=True)
if __name__ == '__main__':
from sqlalchemy import create_engine
engine = create_engine('sqlite:///', echo=True)
metadata.bind = engine
metadata.create_all()
链接地址: http://www.djcxy.com/p/3189.html
上一篇: How do I instruct SQLAlchemy to create SQLite FTS3 tables on create
下一篇: how to embed a linux bash terminal inside ruby on rails web page?