python 通用数据库类型,跨数据库SQLAlchemy应用程序的通用TEXT / CLOB数据类型

I am working on Python web application that uses MySQL as a database backend on the development environment and Oracle 11g on the production environment. Is there a specific way to unify the SQLAlchemy text fields, so that they work both on MySQL and Oracle database? For the Oracle backend in the models I use sqlalchemy.CLOB and for MySQL sqlalchemy.TEXT.

解决方案

According to @agronholm on #sqlalchemy one is supposed to use generic SQLAlchemy type Text (which TEXT is specialization of):

A variably sized string type.

In SQL, usually corresponds to CLOB or TEXT. Can also take Python

unicode objects and encode to the database’s encoding in bind params

(and the reverse for result sets.) In general, TEXT objects do not

have a length; while some databases will accept a length argument

here, it will be rejected by others.