Any way to specify the collation of columns?

[kunzhipeng]

I noticed the collation of columns is always the same as the database. Any way to specify it?

e.g. The collation of the database is 'latin1', but i need to insert 'utf-8' chars. So i need to specify the collation of string columns as 'utf8'.

[tylerlong]

quick_orm is built-upon SQLAlchemy, so you might want to refer to SQLAlchemy's documentation.

check this page: http://docs.sqlalchemy.org/en/rel_0_7/core/types.html

[kunzhipeng]

Thanks.

__table_args__ can be used for specifying charset of MySQL table.
Does quick_orm support __table_args__?

class Node(Base):
     __table_args__ = {'mysql_engine':'InnoDB','mysql_charset':'utf8'}

[tylerlong]

I think so. quick_orm does not compromise the power of SQLAlchemy. Please tell me if you meet issues.

[kunzhipeng]

Yes. It works. I tested it just now. Thanks.

For what reason, it doesn't support __tablename__?

[tylerlong]

In the code of quick_orm, table names are generated by method camelcase_to_underscore, you can see it here: https://github.com/tylerlong/quick_orm/blob/master/quick_orm/core.py.

So it does not support user defined table name yet. But we can change that.