rotten news relay - comp.lang.python

Subject: Re: SQLObject 3.12.0
From: Mohammadreza Saveji
Newsgroups: comp.lang.python
Date: Sun, 22 Dec 2024 13:10 UTC
References: 1 2

Path: eternal-september.org!news.eternal-september.org!feeder3.eternal-september.org!news.swapon.de!fu-berlin.de!uni-berlin.de!not-for-mail
From: mohammadrezasaveji@gmail.com (Mohammadreza Saveji)
Newsgroups: comp.lang.python
Subject: Re: SQLObject 3.12.0
Date: Sun, 22 Dec 2024 16:40:40 +0330
Lines: 152
Message-ID: <mailman.15.1734937051.2912.python-list@python.org>
References: <Z2Vp2Fd2qK3E8rHR@phdru.name>
<CA+KYhwxZs-QrMaC9yv9-TL_+5=G0x-ivqiRcctDrT81=q1mjxw@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Trace: news.uni-berlin.de FP1LY356S76M+sCP6dIFewHxeyI4ngGQzzfXwuhtagHg==
Cancel-Lock: sha1:+m8sVO0dieX1BTrIVFZoeUZhLUY= sha256:JXLA6dG9QqGeOw/6MQ1JfDCP48itMwGJKIybSSELwJw=
Return-Path: <mohammadrezasaveji@gmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
Authentication-Results: mail.python.org; dkim=pass
reason="2048-bit key; unprotected key"
header.d=gmail.com header.i=@gmail.com header.b=f5Lhgsm+;
dkim-adsp=pass; dkim-atps=neutral
X-Spam-Status: OK 0.004
X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'pfxlen:0': 0.03; 'pip':
0.04; 'yet.': 0.04; 'skip:= 10': 0.05; '>>>': 0.07;
'tests': 0.07; 'url:mailman': 0.09; '2.7': 0.09; 'email
addr:python.org>': 0.09; 'instances': 0.09; 'meant': 0.09; 'open-
source': 0.09; 'skip:` 10': 0.09; 'skip:` 20': 0.09; 'import':
0.15; 'announce': 0.15; 'url:listinfo': 0.15; '=======': 0.16;
'builtin': 0.16; 'changes:': 0.16; 'classes,': 0.16; 'mssql':
0.16; 'now;': 0.16; 'pass.': 0.16; 'received:mail-
wm1-x330.google.com': 0.16; 'supported.': 0.16; 'unicode': 0.16;
'url-ip:104.18.32/24': 0.16; 'url-ip:172.64.155/24': 0.16;
'url:project': 0.16; 'url:pypi': 0.16; 'wrote:': 0.16; 'python':
0.16; 'developer': 0.16; 'api': 0.17; 'to:addr:python-list': 0.20;
'url-ip:188.166.95.178/32': 0.20; 'url-ip:188.166.95/24': 0.20;
'fri,': 0.22; "what's": 0.22; 'version': 0.23; 'install': 0.23;
'skip:p 30': 0.23; 'run': 0.23; 'code': 0.23; 'list,': 0.24; 'url-
ip:188.166/16': 0.24; "wasn't": 0.26; '>>>': 0.28; 'email
addr:python.org>': 0.28; 'error': 0.29; 'mailing': 0.31; 'dec':
0.31; 'default': 0.31; 'message-id:@mail.gmail.com': 0.31;
'dropped': 0.32; 'programmers': 0.32; 'python-list': 0.32; "i'm":
0.33; 'header:In-Reply-To:1': 0.34; 'received:google.com': 0.34;
'release': 0.34; 'from:addr:gmail.com': 0.34; 'fix': 0.36;
'those': 0.36; '...': 0.37; 'class': 0.37; 'example': 0.37; 'url-
ip:151.101.0.223/32': 0.38; 'url-ip:151.101.128.223/32': 0.38;
'url-ip:151.101.192.223/32': 0.38; 'url-ip:151.101.64.223/32':
0.38; 'use': 0.39; 'branch': 0.39; 'hello!': 0.39; '(with': 0.39;
'years.': 0.40; 'skip:o 10': 0.61; 'skip:\xc2 10': 0.62; 'true':
0.63; 'complete': 0.64; 'less': 0.64; 'your': 0.64; 'url:name':
0.64; 'news': 0.65; '20,': 0.67; 'pleased': 0.67; 'url:net': 0.67;
'day.': 0.68; '-----': 0.69; 'site:': 0.69; 'url:news': 0.69;
'ignore': 0.71; 'free': 0.71; 'easy': 0.74; 'quick': 0.77;
'database': 0.80; 'known': 0.84; 'drivers': 0.84; 'email name:&lt
;python-list': 0.84; 'minor': 0.84; 'news:': 0.84; 'postgresql':
0.84; 'skip:p 50': 0.84; 'sqlite': 0.84; 'tables': 0.84;
'url:sourceforge': 0.84; 'url:p': 0.88; 'return.': 0.91
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=20230601; t=1734937049; x=1735541849; darn=python.org;
h=to:subject:message-id:date:from:in-reply-to:references:mime-version
:from:to:cc:subject:date:message-id:reply-to;
bh=5wn0ESbDBwBHH3zjmy2tl+fCtyvl7UyNqwWxlqFgGag=;
b=f5Lhgsm+NFEqFQo+Dt3t4EvfmBsR+52ZAr+Lf1MSgMeBojwJ+Z2Kfssz63xh2D0mzE
utCZVF7+SXQXyLsNeUn8Nd9DO5qZfk2F2UCK+6Z0s5ice1dzhTjqeF9IJNZRtchkPN5l
sRT8qiTABpC/vZiDCuR1CqlPsWdJEDSCzymD2PYfCXsm63MM1ZESvX7HATzJoqGchAK/
pPb9kswtdP+Yvuha0WmEmwmIn/45ZOH4dLJqoJgN7SdJz5v1ieCwt59JB5MNl92qfVcE
1o9/S7OOKPDRyBnfWFyFDkP4nsLPoEiIpNnVJvAMfvkdmujOSF5GVbPjHo+vjl+CBdY7
mrBA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=1e100.net; s=20230601; t=1734937049; x=1735541849;
h=to:subject:message-id:date:from:in-reply-to:references:mime-version
:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;
bh=5wn0ESbDBwBHH3zjmy2tl+fCtyvl7UyNqwWxlqFgGag=;
b=crl2JEWhoSaYlGlI3EpSRuji1JOrGsWJ+PvMGcMR59qKrRGGL/n8csQBGZgi4rKr3K
xt1YiSX8/bcA/amdWSaAb4OTUVuohIAIQy6bYSUPuiEr20K5ytwmwrvOpXy0OexN98GD
S3qsNNijGpOt+E3GEzOeuZQJn2+hqaaALCzz4am2QUL/mhMBZdiGbcqzQ6UcvZrUDkXQ
dP9SohgYpDRYZRvj3tM8OsZ1RJWtVxkuV+J5UfkXPjxMRPSMqdngrz0uRkUeR7PxSLkN
Ev0LygSmJBBLIBLuOAU05qFszfupolz+Cgqqw1BBmEGvUEvPKtnxNWdTGijuJLPonp7i
LuFQ==
X-Forwarded-Encrypted: i=1;
AJvYcCXnQuRbLqwF9H+Dtfz8deCcf5TQhaV1UDmNNkYiSiZtGIRkXMp2H+XK8RChh6wIvE716DS1Lz7bNTJzbw==@python.org
X-Gm-Message-State: AOJu0YylnwmV0EPKcX0iX1HF0BeYZewj73OI+k+A05bnM8ZhNwnP/DIl
6lLE3qsWgaV+t+S5020s4PxuwqOgK7KwZ2TdP252j36wy3rF8o/ZAYnPNrFyHa7FDChLWtbVzAF
1aZAur/Ryr3b0zBgdP5ln/zL5bq/rUhM1HnU=
X-Gm-Gg: ASbGnctAoxcn6DE28lYzKCkPPqFNaSMIK7/MW/wL64irWrV/vnOMORV28Jnax0+JZb/
6K91ttHFwLR9obY7xP8BsZZ31pf/E9yqju3hFSw==
X-Google-Smtp-Source: AGHT+IHz5EyLG9TS3OpYaR293jqJezizghc92yC1OHHON7knroGAan4jIAZwdyKLDNC64X6mLI9fw/kmYRAH1bLHaIw=
X-Received: by 2002:a05:600c:548e:b0:434:f753:600f with SMTP id
5b1f17b1804b1-436686473c2mr96603815e9.19.1734937048797; Sun, 22 Dec 2024
22:57:28 -0800 (PST)
In-Reply-To: <Z2Vp2Fd2qK3E8rHR@phdru.name>
X-Content-Filtered-By: Mailman/MimeDel 2.1.39
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.39
Precedence: list
List-Id: General discussion list for the Python programming language
<python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>,
<mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <https://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>,
<mailto:python-list-request@python.org?subject=subscribe>
X-Mailman-Original-Message-ID: <CA+KYhwxZs-QrMaC9yv9-TL_+5=G0x-ivqiRcctDrT81=q1mjxw@mail.gmail.com>
X-Mailman-Original-References: <Z2Vp2Fd2qK3E8rHR@phdru.name>

View all headers

thank a lot Oleg.
have a nice day.

On Fri, Dec 20, 2024 at 4:56 PM Oleg Broytman via Python-list <
python-list@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" rel="nofollow" target="_blank">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@phdru.name
> Programmers don't die, they just GOSUB without RETURN.
> --
> https://mail.python.org/mailman/listinfo/python-list
>

Subject	Author
Re: SQLObject 3.12.0	Mohammadreza Saveji

BOFH excuse #345: Having to manually track the satellite.

comp / comp.lang.python / Re: SQLObject 3.12.0