SQLObject 3.12.0.post2

[Oleg Broytman via Python-list]

Hello!

I'm pleased to announce version 3.12.0.post2, the second post-release
of release 3.12.0 of branch 3.12 of SQLObject.


What's new in SQLObject
===

Installation/dependencies
-

* Use ``FormEncode`` 2.1.1 for 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.post2

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
  
  >>> p.fname
  'John'
  >>> p.mi = 'Q'
  >>> p2 = Person.get(1)
  >>> p2
  
  >>> p is p2
  True

Queries::

  >>> p3 = Person.selectBy(lname="Doe")[0]
  >>> p3
  
  >>> pc = Person.select(Person.q.lname=="Doe").count()
  >>> pc
  1

Oleg.
-- 
Oleg Broytmanhttps://phdru.name/p...@phdru.name
   Programmers don't die, they just GOSUB without RETURN.
-- 
https://mail.python.org/mailman/listinfo/python-list

online course - INTRODUCTION TO PYTHON PROGRAMMING FOR BIOLOGISTS - 24-27 February

[info--- via Python-list]

Dear all,
there are the last seats available for our online course - INTRODUCTION TO 
PYTHON PROGRAMMING FOR BIOLOGISTS
Dates: 24–27 February
Course Website: [ https://www.physalia-courses.org/courses-workshops/python24/ 
]( https://www.physalia-courses.org/courses-workshops/python24/ )
This four-day course is tailored for biologists and life scientists at all 
levels with little or no prior programming experience. Participants will gain a 
strong foundation in Python programming and its applications in biological data 
analysis, with a focus on hands-on exercises and real-world projects.
 
By the end of the course, you will be able to:
Write and run Python code for biological data analysis and visualization.

Use bioinformatics libraries like BioPython.

Perform statistical analysis with Python.

Create organized and reusable code.

Develop a simple project tailored to your research field.
Program Highlights:
 
Day 1: Python basics, data types, and DNA sequence manipulation.
Day 2: Dictionaries, loops, and field data analysis.
Day 3: I/O handling, BioPython, and ChIP-seq data processing.
Day 4: Statistics, visualization, and advanced projects in viral genomics.
 
Best regards,
Carlo
 
 



Carlo Pecoraro, Ph.D


Physalia-courses DIRECTOR

i...@physalia-courses.org

mobile: +49 17645230846




-- 
https://mail.python.org/mailman/listinfo/python-list