SQLObject A free and open source object-relational mapper for Python
Download

SQLObject Ranking & Summary

SQLObject Tags

interface database python mapper database interface database mapper mapper

SQLObject Description

A free and open source object-relational mapper for Python SQLObject comes with support for MySQL, PostgreSQL, MaxDB/SapDB, MS SQL, SQLite, Firebird, and Sybase.SQLObject is a popular Object Relational Manager for providing an object interface to your database, with tables as classes, rows as instances, and columns as attributes.SQLObject includes a Python-object-based query language that makes SQL more abstract, and provides substantial database independence for applications. What's New in This Release: Features & Interface: · .selectBy(), .deleteBy() and .by*() methods pass all values through .from_python(), not only unicode. · The user can choose a DB API driver for SQLite by using a "backend" parameter in DB URI or SQLiteConnection that can be a comma-separated list of backend names. Possible backends are: "pysqlite2" (alias "sqlite2"), "sqlite3", "sqlite" (alias "sqlite1"). Default is to test pysqlite2, sqlite3 and sqlite in that order. · The user can choose a DB API driver for PostgreSQL by using a "backend" parameter in DB URI or PostgresConnection that can be a comma-separated list of backend names. Possible backends are: "psycopg2", "psycopg1", "psycopg" (tries psycopg2 and psycopg1), "pygresql". Default is "psycopg". WARNING: API change! PostgresConnection's parameter "usePygresql" is now replaced with "backend=pygresql". · The user can choose a DB API driver for MSSQL by using a "backend" parameter in DB URI or MSSQLConnection that can be a comma-separated list of backend names. Possible backends are: "adodb" (alias "adodbapi") and "pymssql". Default is to test adodbapi and pymssql in that order. · alternateMethodName is defined for all unique fields, not only alternateID; this makes SQLObject create .by*() methods for all unique fields. · SET client_encoding for PostgreSQL to the value of "charset" parameter in DB URI or PostgresConnection. · TimestampCol() can be instantiated without any defaults, in this case default will be None (good default for TIMESTAMP columns in MySQL). Small Features: · Imported DB API drivers are stored as connection instance variables, not in global variables; this allows to use different DB API drivers at the same time; for example, PySQLite2 and sqlite3. · Removed all deprecated attribute and functions. · Removed the last remained string exceptions.

SQLObject Related Software