gmane.comp.python.sqlobject

Re: 1.4.0 beta1 -- please test with MS SQL

Oleg Broytman — 2013-05-04T16:21:10

   These are major changes and I'd like to ask users of MS SQL to test
this beta release.

Oleg.

Re: SQLObject 1.4.0 beta1

Oleg Broytman — 2013-05-04T16:11:40

   I'm stopping supporting branch 1.2. Please send patches for branch
1.3, 1.4 or the trunk.

Oleg.

SQLObject 1.4.0 beta1

Oleg Broytman — 2013-05-04T16:01:47

Hello!

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


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

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

* Support for PostgreSQL 8.1 is dropped. The minimal supported version of
  PostgreSQL is 8.2 now.

* Optimization in PostgresConnection: use INSERT...RETURNING id
  to get the autoincremented id in one query instead of two
  (INSERT + SELECT id).

* Changed the way to get if the table has identity in MS SQL.

* NCHAR/NVARCHAR and N''-quoted strings for MS SQL.

Major contributor for this release is Andrew Ziem,

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,

Re: MySQL: Commands out of sync; you can't run this command now

Oleg Broytman — 2013-04-24T08:09:05

Hi!

On Wed, Apr 24, 2013 at 08:51:57AM +0100, "Maciej (Matchek) Blizi??ski" <maciej< at >opencsw.org> wrote:

   I'm glad it's fixed. Good luck!

Oleg.

Re: MySQL: Commands out of sync; you can't run this command now

Maciej (Matchek) Bliziński — 2013-04-24T07:51:57

2013/4/16 Oleg Broytman <phd< at >phdru.name>

That was my suspicion too, but it's an wsgi application which doesn't
use threads. I experimented by reducing the number of wsgi application
copies / threads in Apache config to 1. It didn't help, so it's
probably not that.

I've got an update: I noticed that MySQLdb[1] has a new version (1.2.4)
so I upgraded it and the problem seems to have gone away. Maybe it was
some interplay between SqlObject and the MySQL driver for Python, or
just simply the db driver had a problem.

Maciej

[1] https://pypi.python.org/pypi/MySQL-python

------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr

Re: MySQL: Commands out of sync; you can't run this command now

Oleg Broytman — 2013-04-16T10:12:39

Hi!

On Tue, Apr 16, 2013 at 10:52:29AM +0100, "Maciej (Matchek) Blizi??ski" <maciej< at >opencsw.org> wrote:

   conn.ping() is intended to reopen the connection after a timeout;
AFAIR the default timeout is 3600 seconds, not a few minutes. There
shouldn't be any problem with ping after a minute or two.

   "Commands out of sync"means the application calls functions in the
wrong order:
https://dev.mysql.com/doc/refman/5.1/en/commands-out-of-sync.html
   Is the app multithreaded? Could it be the app tries to reuse the same
transaction in different threads?


   None of that, I'm sure. Unfortunately I cannot help further -- I
seldom use MySQL, I use Postgres for bigger projects and SQLite for
smaller ones, so I have to rely on on other people's feedback.

Oleg.

MySQL: Commands out of sync;you can't run this command now

Maciej (Matchek) Bliziński — 2013-04-16T09:52:29

Hello list,

I'm running into a problem when running a small web app in webpy with
sqlobject. The app is a REST interface which handles URLs such as:

GET /pkgdb/rest/srv4/7793c4a5ecd6494b25d475632618e44c/pkg-stats/ HTTP/1.1

and

PUT /releases/catalogs/unstable/i386/SunOS5.9/7793c4a5ecd6494b25d475632618e44c/
HTTP/1.1

When called with PUT, it does a few checks and inserts a row into a
table. When the application runs, it initially works for a minute or
two, but eventually gets into state in which it always fails with this
exception:

Traceback (most recent call last):
  File "/opt/csw/lib/python/site-packages/web/application.py", line
239, in process
    return self.handle()
  File "/opt/csw/lib/python/site-packages/web/application.py", line
230, in handle
    return self._delegate(fn, self.fvars, args)
  File "/opt/csw/lib/python/site-packages/web/application.py", line
420, in _delegate
    return handle_class(cls)
  File "/opt/csw/lib/python/site-packages/web/application.py", line
396, in handle_class

Re: specifying schema for mssql

Andrew Z — 2013-02-06T16:22:02

Thank you for the tip.  Postgres makes it easier because it has a
session-level command for specifying the schema search path, but
Microsoft SQL Server requires the schema to be pretended to every
table reference for every query. For now I will stick with the default
schema.


Best regards,
Andrew

------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb

Re: specifying schema for mssql

Oleg Broytman — 2013-02-04T21:40:23

   Using non-default schema is only implemented for Postgres. You can
see how it's implemented in sqlobject/postgres/pgconnection.py and
implement something similar for mssql.

Oleg.

specifying schema for mssql

Andrew Z — 2013-02-04T21:20:59

With SQLObject 1.3.2 and mssql backend, how do you specify the schema
equivalent to the command 'use foo'?  I want to use a schema that is
neither 'dbo' not the default for the user.  I don't see how to do it
using the URI after glancing over the documentation and code.


Andrew

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_jan

Re: running tests

Oleg Broytman — 2013-02-03T10:07:06

Hello!

On Sat, Feb 02, 2013 at 07:44:23PM -0700, Andrew Z <ahz001< at >gmail.com> wrote:

   Use py.test:

$ py.test sqlobject/tests/test_unicode.py  -D sqlite:///tmp/foo.db

   py.test is a library from py.lib; pytest is from logilab -- a
completely different library.

   During the years I've working on SQLObject I developed a number of
shell scripts to run tests and collect reports. If you are intersted I
can send them to you.

Oleg.

running tests

Andrew Z — 2013-02-03T02:44:23

I read http://www.sqlobject.org/DeveloperGuide.html#testing and am
still unclear on exactly how to run a test.  Sorry, this may be a
basic question, but I hope the Developer Guide could be more explicit.

After installing py.test, I basically did this:

$ svn co http://svn.colorstudy.com/SQLObject/trunk SQLObject
$ cd SQLObject
$ python sqlobject/tests/test_unicode.py  -D sqlite:///tmp/foo.db

However:
Traceback (most recent call last):
  File "sqlobject/tests/test_unicode.py", line 1, in <module>
    from sqlobject import *
ImportError: No module named sqlobject

I also tried something like and got basically the same error

$ pytest sqlobject/tests/test_unicode.py  -D sqlite:///tmp/foo.db




Andrew

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_jan

Re: INSERT INTO and cursor

Oleg Broytman — 2013-01-22T20:32:56

Hi!

On Tue, Jan 22, 2013 at 03:21:06PM -0500, Markos Kapes <mkapes< at >gmail.com> wrote:

   If there is no error, in what way it fails? It didn't insert the row?
Could it be an automatic rollback at the end of a transaction?

Oleg.

INSERT INTO and cursor

Markos Kapes — 2013-01-22T20:21:06

Any good reason why this code should fail to insert while the underlying query in mysql shell works?
cursor=cbx.conn.cursor()
cursor.execute(u"INSERT INTO notes (message, author) VALUES ('test', 'test');")
Furthermore, this fails silently, so no error to give me a clue.
Selects still work as expected, but somehow, all the old legacy code I've got that uses statements of the above type have stopped working.
As always, thanks much for the advice,
--Markos Kapes


------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d

SourceForge's Allura

Oleg Broytman — 2013-01-18T20:46:15

Hello!

   SourceForge insisted on upgrading registered projects to their new
backend called Allura, so I allowed them to upgrade the project.
See http://sourceforge.net/projects/sqlobject/
   The most notable changes are:
administrative interface: https://sourceforge.net/p/sqlobject/admin/
tickets: http://sourceforge.net/p/sqlobject/_list/tickets
and wiki: http://sourceforge.net/p/sqlobject/wiki/Home/
   Not sure how to use the new wiki to the benefits of the community.

Oleg.

Re: (no subject)

Stéphane Brault — 2013-01-11T22:42:48

Shed off some pounds doesnt have to be hard http://2ndshopthai.com/cottageadvertisingdavidroberts/

------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812

Re: passwords hashed using pgcrypto (in the database)

Oleg Broytman — 2012-12-30T21:48:32

Hello and happy New Year!

On Sun, Dec 30, 2012 at 09:46:00PM +0100, Tomas Vondra <tv< at >fuzzy.cz> wrote:

   I think it's possible with many lines of code. SQLObject doesn't send
raw values on INSERT/UPDATE -- it calls sqlrepr(value) which in turn
calls value.__sqlrepr__(dbname) if the value has __sqlrepr__ method. So
you have to return a wrapper with __sqlrepr__ method, and it can be
returned from a validator.
   See the following program as a small example:

from formencode import validators

class CryptValue(object):
    def __init__(self, value):
        self.value = value

    def __sqlrepr__(self, db):
        assert db == 'postgres'
        return "crypt('%s')" % self.value

class CryptValidator(validators.Validator):
    def from_python(self, value, state):
        return CryptValue(value)

class SOCryptCol(SOCol):
    def createValidators(self, dataType=None):
        return [CryptValidator()]

    def _sqlType(self):
        return 'TEXT NOT NULL'

class CryptCol(Col):
    baseClass = SOCryptCol

cla

passwords hashed using pgcrypto (in the database)

Tomas Vondra — 2012-12-30T20:46:00

Hi,

I'm learning SQLObject - checking if we could use it on our projects, 
and I got stuck at hashing passwords inside the database.

Imagine a simple table with info about users:

CREATE TABLE users (
     id       INT PRIMARY KEY,
     login    TEXT NOT NULL UNIQUE,
     pwdhash  TEXT NOT NULL
)

where "pwdhash" is a hashed password. We're using PostgreSQL and we 
usually handle this inside the database using a pgcrypto module, that 
provides various hash/crypto functions. An insert into the table then 
looks like this

     INSERT INTO users VALUES (1, 'login', crypt('mypassword', 
gen_salt('bf')))

which generates a salt, computes the hash and stores that into a single 
text column (salt+hash). The authentication then looks like this:

     SELECT id, login FROM users WHERE login = 'login' AND pwdhash = 
crypt('mypassword', pwdhash)

which reuses the salt stored in the column.

I'm investigating if we could do this with SQLObject, but it seems to 
me the answer is 'no'. I see it's possible to define mag

Re: freezes with multi-threading ?

Sophana K — 2012-12-05T22:34:25

I just found out that my the script that launches my web server doesn't
launch correctly the python virtualenv that I had setup. I was using a very
old version of sqlobjects(0.10.3) and of mysqldb.

I just fixed this, and will now wait for the next freeze to happen (if it
ever happens again)...

Thanks for your great support.



On Tue, Dec 4, 2012 at 6:47 PM, Oleg Broytman <phd< at >phdru.name> wrote:

------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss< at >lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Re: freezes with multi-threading ?

Oleg Broytman — 2012-12-04T17:47:17

Hi! Pity to listen you have problems.

On Tue, Dec 04, 2012 at 01:02:52PM +0100, Sophana K <sophana78< at >gmail.com> wrote:

   It'd be helpful to find a version of SO that doesn't freeze.
Unfortunately it requires to rollback your code and to run a lot of
experiments.


   There shouldn't be any path -- you use sqlhub as the connection:

class MyClass(SQLObject):
    _connection = sqlhub # Actually, this is the default

sqlhub.threadConnection = connectionFromURI('...')

   Sqlhub's __get__ and __set__ methods return the real connection.


   You can see the code at dbconnection.py stared at the line 332: class
DBAPI, method getConnection. You can explicitly disable the pool by
setting dbConnection._pool = None.


   Should be. The pool is protected by _poolLock. Does something in the
code trigger your suspicions?

Oleg.

Re: freezes with multi-threading ?

Oleg Broytman — 2012-12-04T18:40:57

Hi! Pity to listen you have problems.

On Tue, Dec 04, 2012 at 01:02:52PM +0100, Sophana K <sophana78< at >gmail.com> wrote:

   It'd be helpful to find a version of SO that doesn't freeze.
Unfortunately it requires to rollback your code and to run a lot of
experiments.


   There shouldn't be any path -- you use sqlhub as the connection:

class MyClass(SQLObject):
    _connection = sqlhub # Actually, this is the default

sqlhub.threadConnection = connectionFromURI('...')

   Sqlhub's __get__ and __set__ methods return the real connection.


   You can see the code at dbconnection.py stared at the line 332: class
DBAPI, method getConnection. You can explicitly disable the pool by
setting dbConnection._pool = None.


   Should be. The pool is protected by _poolLock. Does something in the
code trigger your suspicions?
On Tue, Dec 04, 2012 at 01:02:52PM +0100, Sophana K <sophana78< at >gmail.com> wrote:

Oleg.