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.
Comments not found