dbo Publisher's description
DBO is a database object relational mapper (ORM) written entirely in Python.
DBO is a database object relational mapper (ORM) written entirely in Python. It's similar to PyDO, SQLObject, and SQLDict, among others.
DBO allows you to reflect your database tables into python objects. DBO composes all SQL queries, allowing the developer to focus on other things. It was originally written as a component system for a web framework, but it has since become its own framework that is useful in contexts beyond web development.
It has a number of features:
* Python 2.2 newclass style support.
* Major SQL verbs: select, insert, update, delete, create, drop
* Complex SQL queries supported: Programmatically build your SQL queries using python based class definitions.
* Database independence: Port your DBO objects to a new database engine with minimal to no changes.
* Sequence and auto-increment support: A database column that serves as a table's unique ID can be either a sequence or an auto-increment, regardless of the underlying database engine.
* Transaction support (when supported by the database engine): Update, Insert and Delete as many objects as you want within a transaction, and you can roll back all the changes.
* Schema creation: you don't even need to write the schema for your tables, DBO will do that for you given the structure of the Table classes you define. This simplifies schema adjustments by allowing the developer to make the change once.
* Support for single or multiple primary keys: A unique feature not found in other python based ORMs.
* Flexible type system: Using the primitive column types, you can build more complex column types that are used to convert the data as it flows in and out of the database.
* Support for relational information: DBO understands when a specific column is a foreign key, and, in response to a reference(), DBO will wrap the foreign table reference in its designated Table object, automatically.
* Support for relational information BEFORE you insert using a link: If you need to relate objects before you insert them, just link() the columns. DBO will ensure the generated database IDs will propagate to foreign references as soon as you insert your changes.
* On the fly Views: DBO can join two or more Tables into a single object, using appropriate foreign keys to automatically build a join statement for speedups during selects.
* Serialization support across the board: Every DBO class defined can save and restore its state to disk. This not only includes Tables and Views, but ResultSets, links, and query strings!
* WebKit plugin, intergrate DBO objects with your servlets.
System Requirements:No special requirements.
Program Release Status: Minor Update
Program Install Support: Install and Uninstall