SQLObject 3.12.0

Mohammadreza Saveji mohammadrezasaveji at gmail.com
Sun Dec 22 08:10:40 EST 2024


thank a lot Oleg.
have a nice day.

On Fri, Dec 20, 2024 at 4:56 PM Oleg Broytman via Python-list <
python-list at python.org> wrote:

> Hello!
>
> I'm pleased to announce version 3.12.0, the release of branch
> 3.12 of SQLObject.
>
>
> What's new in SQLObject
> =======================
>
> Drivers
> -------
>
> * Add support for CyMySQL; there're some problems with unicode yet.
>
> * Separate ``psycopg`` and ``psycopg2``;
>   ``psycopg`` is actually ``psycopg3`` now; not all tests pass.
>
> * Minor fix in getting error code from PyGreSQL.
>
> * Dropped ``oursql``. It wasn't updated in years.
>
> * Dropped ``PySQLite2``. Only builtin ``sqlite3`` is supported.
>
> Tests
> -----
>
> * Run tests with Python 3.13.
>
> * Run tests with ``psycopg-c``; not all tests pass.
>
> * Fix ``test_exceptions.py`` under MariaDB, PostgreSQL and SQLite.
>
> * ``py-postgres``: Set ``sslmode`` to ``allow``;
>   upstream changed default to ``prefer``.
>
> CI
> --
>
> * Run tests with ``PyGreSQL`` on w32, do not ignore errors.
>
> * Skip tests with ``pg8000`` on w32.
>
> * GHActions: Switch to ``setup-miniconda``.
>
> * GHActions: Python 3.13.
>
> For a more complete list, please see the news:
> http://sqlobject.org/News.html
>
>
> What is SQLObject
> =================
>
> SQLObject is a free and open-source (LGPL) Python object-relational
> mapper.  Your database tables are described as classes, and rows are
> instances of those classes.  SQLObject is meant to be easy to use and
> quick to get started with.
>
> SQLObject supports a number of backends: MySQL/MariaDB (with a number of
> DB API drivers: ``MySQLdb``, ``mysqlclient``, ``mysql-connector``,
> ``PyMySQL``, ``mariadb``), PostgreSQL (``psycopg2``, ``PyGreSQL``,
> partially ``pg8000`` and ``py-postgresql``), SQLite (builtin ``sqlite3``);
> connections to other backends
> - Firebird, Sybase, MSSQL and MaxDB (also known as SAPDB) - are less
> debugged).
>
> Python 2.7 or 3.4+ is required.
>
>
> Where is SQLObject
> ==================
>
> Site:
> http://sqlobject.org
>
> Download:
> https://pypi.org/project/SQLObject/3.12.0
>
> News and changes:
> http://sqlobject.org/News.html
>
> StackOverflow:
> https://stackoverflow.com/questions/tagged/sqlobject
>
> Mailing lists:
> https://sourceforge.net/p/sqlobject/mailman/
>
> Development:
> http://sqlobject.org/devel/
>
> Developer Guide:
> http://sqlobject.org/DeveloperGuide.html
>
>
> Example
> =======
>
> Install::
>
>   $ pip install sqlobject
>
> Create a simple class that wraps a table::
>
>   >>> from sqlobject import *
>   >>>
>   >>> sqlhub.processConnection = connectionForURI('sqlite:/:memory:')
>   >>>
>   >>> class Person(SQLObject):
>   ...     fname = StringCol()
>   ...     mi = StringCol(length=1, default=None)
>   ...     lname = StringCol()
>   ...
>   >>> Person.createTable()
>
> Use the object::
>
>   >>> p = Person(fname="John", lname="Doe")
>   >>> p
>   <Person 1 fname='John' mi=None lname='Doe'>
>   >>> p.fname
>   'John'
>   >>> p.mi = 'Q'
>   >>> p2 = Person.get(1)
>   >>> p2
>   <Person 1 fname='John' mi='Q' lname='Doe'>
>   >>> p is p2
>   True
>
> Queries::
>
>   >>> p3 = Person.selectBy(lname="Doe")[0]
>   >>> p3
>   <Person 1 fname='John' mi='Q' lname='Doe'>
>   >>> pc = Person.select(Person.q.lname=="Doe").count()
>   >>> pc
>   1
>
> Oleg.
> --
>     Oleg Broytman            https://phdru.name/            phd at phdru.name
>            Programmers don't die, they just GOSUB without RETURN.
> --
> https://mail.python.org/mailman/listinfo/python-list
>


More information about the Python-list mailing list