MoSQL

MoSQL is a lightweight module that allows Python developers to use Python-specific syntax to work with SQL-driven databases.

This means the code written to interact with the database looks like Python, but is converted to standard, working SQL statements via MoSQL.

Features:

• Supported statements:
• SELECT
• UPDATE
• INSERT
• DELETE
• JOIN
• DROP

What is new in this release:

• The Database supports to keep connection open.
• The Database is thread-safe now.
• The insert() supports multi-value.
• The build_where() translates x IN () into FALSE.
• The build_where() allows to use pair as key to include operator.
• The mosql.util.Statement.format ignores false - in bool context - clause argument.
• The mosql.util.Statement.format raises TypeError if there is any unused clause argument.
• Added mosql.util.Query.enable_echo() to echo the SQL it builds.

What is new in version 0.9.1:

• Now qualifier() supports to encode unicode into utf-8 str automatically.

What is new in version 0.8:

• Fixed the complain of inserting with empty dict.
• Added mosql.sqlite for better SQLite support.
• Added mosql.query.replace().
• Renamed mosql.statement to mosql.stmt.
• Added mosql.func for basic SQL functions supprt.
• Support using pair (2-tuple) to build AS statement.
• Support subquery perfectly.

What is new in version 0.7:

• Added the Travis CI badge.
• Added The Utilities for Python DB API 2.0 - mosql.db.
• Arranged the examples.

What is new in version 0.6.1:

• Nothing but the change of the docs.

What is new in version 0.5.3:

• Fixed the compatibility of mosql.util with types which inherit the the basic types.

What is new in version 0.5.1:

• The mosql.result.Model.save() uses mosql.result.Model.arrange_by to save the changes on column squashed.
• The mosql.result.Model.clear() is also improved.
• Improved the program of loading result set.
• The mosql.result.Model.select() or mosql.result.Model.where() returns None if no row is returned.

What is new in version 0.2.1:

• Fixed a bug after appending row.

What is new in version 0.1.6:

• Supports to delimit the identifier (for avoiding injection from identifier).
• Supports arbitrary SQL statements by mosql.util.raw.
• Supports to customize parameter name of prepared statement by mosql.util.param.
• mosql.ext is deprecated now. Use mosql.common instead.