Oleg Broytman | 13 Apr 14:28 2014
X-Face

SQLObject 1.5.2

Hello!

I'm pleased to announce version 1.5.2, the second bugfix release of branch
1.5 of SQLObject.

What's new in SQLObject
=======================

* Adapt duplicate error message strings for SQLite 3.8.

Contributor for this release is Neil Muller.

For a more complete list, please see the news:
http://sqlobject.org/News.html

What is SQLObject
=================

SQLObject is an 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, PostgreSQL, SQLite,
Firebird, Sybase, MSSQL and MaxDB (also known as SAPDB).

Where is SQLObject
==================

Site:
http://sqlobject.org
(Continue reading)

Oleg Broytman | 13 Apr 14:29 2014
X-Face

SQLObject 1.6.0b1

Hello!

I'm pleased to announce version 1.6.0b1, the first beta of the upcoming
release of branch 1.6 of SQLObject.

What's new in SQLObject
=======================

Features & Interface
--------------------

* Python 2.4 is no longer supported. The minimal supported version is
  Python 2.5.

* DateTimeCol and TimeCol preserve microseconds. The feature requires
  Python 2.6+ because in Python 2.5 datetime.strptime doesn't support
  '%f' format.

  WARNING: backward compatibility problem! Date/Time columns created
  with microseconds cannot be read back with older versions of
  SQLObject.

* Upgrade ez_setup to 1.4.2.

* Adapt duplicate error message strings for SQLite 3.8.

Contributors for this release are Geoffrey Wossum and Neil Muller.

For a more complete list, please see the news:
http://sqlobject.org/News.html
(Continue reading)

Andrew Philpot | 24 Feb 20:33 2014
Picon

sqlobject back end to Oracle

What is the status of this backend?  I'm being encouraged to deploy an 
sqlobject+MySQL app to an Oracle shop.  Assuming there is nothing 
available, are there other strategies folks have used to bridge this gap?

Andrew

------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
Oleg Broytman | 13 Feb 16:49 2014
X-Face

SQLObject needs your help!

Hello, everyone! In his yesterday's post
http://www.ianbicking.org/blog/2014/02/saying-goodbye-to-python.html
Ian Bicking mentioned me as the person who saved him from the burden of
maintaining SQLObject. Thank you, Ian! It was an interesting experience
(and an urgent business need at that time).
   Unfortunately now is the worst time to praise me for working on
SQLObject. As everyone can see I wasn't very active the last year(s) and
this year the work stopped completely. I must apologize and explain
myself.
   I failed to build an active community. I am sorry. My communication
skills are perhaps not so good. And I certainly lack community-building
skills.
   Currently I am involved in three big projects, only one of them uses
SQLObject. I am tired and seldom have power to do anything besides my
work. Even worse, said project doesn't generate enough revenue and my
bosses decided to cut it in a month or two. After that I will have even
less incentive to work on SQLObject. I am very very sorry.
   It would be best for SQLObject and the community if someone takes
over the project and revives it. If you'd like, please step up.
   Or, if nobody wants to take the lead, I can continue working as the
integrator. Please send your patches (SourceForge tracker, mail list,
private mail directly to me), I'll test them, apply them and will
release new versions. I can help converting the repository to Mercurial
or git (I prefer git) if there are developers who are interested in
working with a distributed VCS.
   But without your work, dear developers, SQLObject is doomed.

Oleg.
--

-- 
     Oleg Broytman            http://phdru.name/            phd <at> phdru.name
(Continue reading)

Oleg Broytman | 25 Dec 16:53 2013
X-Face

SQLObject 1.6.0a1

Hello!

I'm pleased to announce version 1.6.0a1, the first alpha of the upcoming
release of branch 1.6 of SQLObject.

What's new in SQLObject
=======================

Features & Interface
--------------------

* Python 2.4 is no longer supported. The minimal supported version is
  Python 2.5.

* DateTimeCol and TimeCol preserve microseconds. The feature requires
  Python 2.6+ because in Python 2.5 datetime.strptime doesn't support
  '%f' format.

  WARNING: backward compatibility problem! Date/Time columns created
  with microseconds cannot be read back with older versions of
  SQLObject.

* Upgrade ez_setup to 1.4.2.

Contributor for this release is Geoffrey Wossum.

For a more complete list, please see the news:
http://sqlobject.org/News.html

What is SQLObject
(Continue reading)

Oleg Broytman | 15 Dec 16:42 2013
X-Face

SQLObject 1.5.1

Hello!

I'm pleased to announce version 1.5.1, the first bugfix release of branch
1.5 of SQLObject.

What's new in SQLObject
=======================

* SQLiteConnection.close() now closes and reopens a connection
  to in-memory database.

Contributor for this release is Maciej (Matchek) Blizinski.

For a more complete list, please see the news:
http://sqlobject.org/News.html

What is SQLObject
=================

SQLObject is an 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, PostgreSQL, SQLite,
Firebird, Sybase, MSSQL and MaxDB (also known as SAPDB).

Where is SQLObject
==================

Site:
(Continue reading)

Daniel Fetchinson | 10 Nov 22:21 2013

RelatedJoin allows adding item several times

Perhaps it is by design but I was kind of surprised to see that if I have

class x(SQLObject):
    ys = RelatedJoin( 'y' )

class y(SQLObject):
    ....

then I'm allowed to add several times the same 'y' object to 'x' via

myx = x.get( 1 )
myy = y.get( 1 )
x.addY( myy )
x.addY( myy )
x.addY( myy )

Is there a keyword argument to RelatedJoin or to addY that forbids this?
Or I have to code this myself, i.e. check if an object is already
added, and if yes, refuse to do it?

Cheers,
Daniel

--

-- 
Psss, psss, put it down! - http://www.cafepress.com/putitdown

------------------------------------------------------------------------------
November Webinars for C, C++, Fortran Developers
Accelerate application performance with scalable programming models. Explore
techniques for threading, error checking, porting, and tuning. Get the most 
(Continue reading)

sophana78 . | 31 Oct 10:40 2013
Picon

<class 'sqlobject.dberrors.ProgrammingError'>: Commands out of sync; you can't run this command now

Hi

Every few weeks, my web server, which uses sqlobjects, gets stuck with this error:
<class 'sqlobject.dberrors.ProgrammingError'>: Commands out of sync; you can't run this command now

It sometime recovers after a few hundred transactions, sometime, it doesn't and remains stuck in this state.

It seems that all connections in the pool are "bad".

Do you know a way of reseting these connections? conn.commit()? conn.ping()? kill the connection (how)?

After looking at the code, I'm thinking about the following patch:
in dbconnection.py, in _runWithConnection, I would like to catch this error. If it happens, I would reset the connection, then retry.

Or should I do this in mysqlconnection.py, in _executeRetry?

Is there a way to know what was the previous transaction that causes this problem on the connection?

Thanks for your help.


------------------------------------------------------------------------------
Android is increasing in popularity, but the open development platform that
developers love is also attractive to malware creators. Download this white
paper to learn more about secure code signing practices that can help keep
Android apps secure.
http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
Maciej (Matchek) Bliziński | 16 Oct 10:41 2013

Temporary databases / Closing the :memory: database connection

Hi guys,

I'd like to use an in-memory sqlite database for testing, and I have a problem where I don't seem to be able to let go of a database which was once created. Here's a test that shows what I mean:

class Foo(sqlobject.SQLObject):
  bar = sqlobject.UnicodeCol(length=250, unique=True)

db_uri = 'sqlite:/:memory:'
conn = sqlobject.connectionForURI(db_uri)
sqlobject.sqlhub.processConnection = conn
Foo.createTable()
# All is good so far. Now let's drop the database.
conn.close()
del conn
# "The database is automatically deleted and memory is reclaimed when the last connection to the database closes."
# Let's create a fresh in-memory database.
conn = sqlobject.connectionForURI(db_uri)
sqlobject.sqlhub.processConnection = conn
Foo.createTable()
# Here, an exception is thrown:
sqlobject.dberrors.OperationalError: table foo already exists

I must have somehow gotten a connection to the same in-memory database that was created on the first call to connectionForURI(). After looking at dbconnection.py, I came up with an invasive method:

sqlobject.dbconnection.TheURIOpener.cachedURIs = {}
conn = sqlobject.connectionForURI(db_uri)
sqlobject.sqlhub.processConnection = conn
Foo.createTable()

It does what I need, but it doesn't seem like it's what SQLObject developers intended. Do you have any recommendations?

Maciej
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
Oleg Broytman | 5 Oct 14:56 2013
X-Face

SQLObject 1.5.0

Hello!

I'm pleased to announce version 1.5.0, the first stable release of branch
1.5 of SQLObject.

What's new in SQLObject
=======================

Features & Interface
--------------------

* Helpers for class Outer were changed to lookup columns in table's
  declarations.

* Support for Python 2.4 is declared obsolete and will be removed
  in the next release.

Minor features
--------------

* When a PostgresConnection raises an exception the instance has
  code/error attributes copied from psycopg2's pgcode/pgerror attributes.

* Encode unicode enum values to str.

* Removed setDeprecationLevel from the list of public functions.

* A number of fixes for tests.

Bugfixes
--------

* A bug was fixed in DBConnection.close(); close() doesn't raise
  an UnboundLocalError if connection pool is empty.

* Fixed parameters for pymssql.

Documentation
-------------

* GNU LGPL text was added as docs/LICENSE file.

* Old FSF address was changed to the new one.

Contributors for this release are Patrick Gendron, Rhubarb Sin,
Neil Muller, Robert Ayrapetyan, Gert Burger and Francisco Chiotta.

For a more complete list, please see the news:
http://sqlobject.org/News.html

What is SQLObject
=================

SQLObject is an 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, PostgreSQL, SQLite,
Firebird, Sybase, MSSQL and MaxDB (also known as SAPDB).

Where is SQLObject
==================

Site:
http://sqlobject.org

Development:
http://sqlobject.org/devel/

Mailing list:
https://lists.sourceforge.net/mailman/listinfo/sqlobject-discuss

Archives:
http://news.gmane.org/gmane.comp.python.sqlobject

Download:
https://pypi.python.org/pypi/SQLObject/1.5.0

News and changes:
http://sqlobject.org/News.html

Oleg.
--

-- 
     Oleg Broytman            http://phdru.name/            phd <at> phdru.name
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
Oleg Broytman | 17 Sep 21:45 2013
X-Face

Vacation

Ten days vacation. Perhaps I'll be online from time to time...

Oleg.
--

-- 
     Oleg Broytman            http://phdru.name/            phd <at> phdru.name
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk

Gmane