sqlobject-cvs Mailing List for SQLObject (Page 112)
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
Menu
▾
▴
sqlobject-cvs — CVS notification
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
(9) |
Apr
(74) |
May
(29) |
Jun
(16) |
Jul
(28) |
Aug
(10) |
Sep
(57) |
Oct
(9) |
Nov
(29) |
Dec
(12) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(7) |
Feb
(14) |
Mar
(6) |
Apr
(3) |
May
(12) |
Jun
(34) |
Jul
(9) |
Aug
(29) |
Sep
(22) |
Oct
(2) |
Nov
(15) |
Dec
(52) |
| 2005 |
Jan
(47) |
Feb
(78) |
Mar
(14) |
Apr
(35) |
May
(33) |
Jun
(16) |
Jul
(26) |
Aug
(63) |
Sep
(40) |
Oct
(96) |
Nov
(96) |
Dec
(123) |
| 2006 |
Jan
(159) |
Feb
(144) |
Mar
(64) |
Apr
(31) |
May
(88) |
Jun
(48) |
Jul
(16) |
Aug
(64) |
Sep
(87) |
Oct
(92) |
Nov
(56) |
Dec
(76) |
| 2007 |
Jan
(94) |
Feb
(103) |
Mar
(126) |
Apr
(123) |
May
(85) |
Jun
(11) |
Jul
(130) |
Aug
(47) |
Sep
(65) |
Oct
(70) |
Nov
(12) |
Dec
(11) |
| 2008 |
Jan
(30) |
Feb
(55) |
Mar
(88) |
Apr
(20) |
May
(50) |
Jun
|
Jul
(38) |
Aug
(1) |
Sep
(9) |
Oct
(5) |
Nov
(6) |
Dec
(39) |
| 2009 |
Jan
(8) |
Feb
(16) |
Mar
(3) |
Apr
(33) |
May
(44) |
Jun
(1) |
Jul
(10) |
Aug
(33) |
Sep
(74) |
Oct
(22) |
Nov
|
Dec
(15) |
| 2010 |
Jan
(28) |
Feb
(22) |
Mar
(46) |
Apr
(29) |
May
(1) |
Jun
(1) |
Jul
(27) |
Aug
(8) |
Sep
(5) |
Oct
(33) |
Nov
(24) |
Dec
(41) |
| 2011 |
Jan
(4) |
Feb
(12) |
Mar
(35) |
Apr
(29) |
May
(19) |
Jun
(16) |
Jul
(32) |
Aug
(25) |
Sep
(5) |
Oct
(11) |
Nov
(21) |
Dec
(12) |
| 2012 |
Jan
(3) |
Feb
(4) |
Mar
(20) |
Apr
(4) |
May
(25) |
Jun
(13) |
Jul
|
Aug
|
Sep
(2) |
Oct
(25) |
Nov
(9) |
Dec
(1) |
| 2013 |
Jan
(6) |
Feb
(8) |
Mar
|
Apr
(10) |
May
(31) |
Jun
(7) |
Jul
(18) |
Aug
(33) |
Sep
(4) |
Oct
(16) |
Nov
|
Dec
(27) |
| 2014 |
Jan
(2) |
Feb
|
Mar
|
Apr
(11) |
May
(39) |
Jun
(8) |
Jul
(11) |
Aug
(4) |
Sep
|
Oct
(27) |
Nov
|
Dec
(71) |
| 2015 |
Jan
(17) |
Feb
(47) |
Mar
(33) |
Apr
|
May
|
Jun
(9) |
Jul
(7) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(8) |
| 2016 |
Jan
(4) |
Feb
(4) |
Mar
|
Apr
|
May
(12) |
Jun
(7) |
Jul
(9) |
Aug
(31) |
Sep
(8) |
Oct
(3) |
Nov
(15) |
Dec
(1) |
| 2017 |
Jan
(13) |
Feb
(7) |
Mar
(14) |
Apr
(8) |
May
(10) |
Jun
(4) |
Jul
(2) |
Aug
(1) |
Sep
|
Oct
(8) |
Nov
(4) |
Dec
(5) |
| 2018 |
Jan
(2) |
Feb
(8) |
Mar
|
Apr
(4) |
May
|
Jun
(6) |
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
(1) |
Dec
|
| 2019 |
Jan
(1) |
Feb
(16) |
Mar
(1) |
Apr
(3) |
May
(5) |
Jun
(1) |
Jul
|
Aug
|
Sep
(2) |
Oct
|
Nov
(1) |
Dec
(3) |
| 2020 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
(1) |
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
(2) |
Nov
|
Dec
(2) |
| 2021 |
Jan
|
Feb
(2) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
(1) |
Dec
|
| 2022 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(6) |
Oct
(1) |
Nov
(1) |
Dec
(4) |
| 2023 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(3) |
Sep
(2) |
Oct
(2) |
Nov
(4) |
Dec
|
| 2024 |
Jan
|
Feb
(2) |
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
(9) |
| 2025 |
Jan
|
Feb
(4) |
Mar
(2) |
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
(2) |
Dec
(2) |
|
From: <sub...@co...> - 2006-12-08 17:34:42
|
Author: ianb
Date: 2006-12-08 10:34:34 -0700 (Fri, 08 Dec 2006)
New Revision: 2127
Modified:
SQLObject/trunk/sqlobject/events.py
Log:
Fix RowUpdateSignal docstring
Modified: SQLObject/trunk/sqlobject/events.py
===================================================================
--- SQLObject/trunk/sqlobject/events.py 2006-12-07 15:35:35 UTC (rev 2126)
+++ SQLObject/trunk/sqlobject/events.py 2006-12-08 17:34:34 UTC (rev 2127)
@@ -110,10 +110,11 @@
class RowUpdateSignal(Signal):
"""
- Called when an instance is updated through a call to ``.set()``.
- The arguments are ``(instance, kwargs)``. ``kwargs`` can be
- modified. This is run *before* the instance is updated; if you
- want to look at the current values, simply look at ``instance``.
+ Called when an instance is updated through a call to ``.set()``
+ (or a column attribute assignment). The arguments are
+ ``(instance, kwargs)``. ``kwargs`` can be modified. This is run
+ *before* the instance is updated; if you want to look at the
+ current values, simply look at ``instance``.
"""
class AddColumnSignal(Signal):
|
|
From: <sub...@co...> - 2006-12-07 15:35:48
|
Author: phd Date: 2006-12-07 08:35:35 -0700 (Thu, 07 Dec 2006) New Revision: 2126 Modified: home/phd/SQLObject/paramstyles/setup.cfg home/phd/SQLObject/paramstyles/setup.py Log: Merged patches from the revisions 2116:2125 from the trunk Modified: home/phd/SQLObject/paramstyles/setup.cfg =================================================================== --- home/phd/SQLObject/paramstyles/setup.cfg 2006-12-07 15:23:52 UTC (rev 2125) +++ home/phd/SQLObject/paramstyles/setup.cfg 2006-12-07 15:35:35 UTC (rev 2126) @@ -15,8 +15,8 @@ doc_base = docs/ dest = docs/html modules = sqlobject +exclude_modules = sqlobject.tests title = SQLObject -blog_url = http://sqlobject.org/news/ mailing_list_url = http://sqlobject.org/community.html settings = normal_link_color=#039 visited_color=#093 Modified: home/phd/SQLObject/paramstyles/setup.py =================================================================== --- home/phd/SQLObject/paramstyles/setup.py 2006-12-07 15:23:52 UTC (rev 2125) +++ home/phd/SQLObject/paramstyles/setup.py 2006-12-07 15:35:35 UTC (rev 2126) @@ -55,7 +55,7 @@ ], author="Ian Bicking", author_email="ia...@co...", - url="http://sqlobject.org", + url="http://sqlobject.org/devel/", download_url="http://cheeseshop.python.org/pypi/SQLObject/", license="LGPL", packages=["sqlobject"] + ['sqlobject.%s' % package for package in subpackages], |
|
From: <sub...@co...> - 2006-12-07 15:24:02
|
Author: phd Date: 2006-12-07 08:23:52 -0700 (Thu, 07 Dec 2006) New Revision: 2125 Modified: SQLObject/docs/community.txt SQLObject/docs/rebuild Log: Added a link to the development docs. Modified: SQLObject/docs/community.txt =================================================================== --- SQLObject/docs/community.txt 2006-12-07 15:23:38 UTC (rev 2124) +++ SQLObject/docs/community.txt 2006-12-07 15:23:52 UTC (rev 2125) @@ -16,9 +16,12 @@ <http://sourceforge.net/tracker/?group_id=74338&atid=540674>`_. Development takes place in the `subversion repository -<repository.html>`_. If you are interested in contributing you should -read the `Developer Guide <docs/DeveloperGuide.html>`_. +<repository.html>`_. There are `development docs`_. If you are +interested in contributing you should read the `Developer Guide +<docs/DeveloperGuide.html>`_. +.. _`development docs`: /devel/ + The `Author List <docs/Authors.html>`_ tries to list all the major contributors. Modified: SQLObject/docs/rebuild =================================================================== --- SQLObject/docs/rebuild 2006-12-07 15:23:38 UTC (rev 2124) +++ SQLObject/docs/rebuild 2006-12-07 15:23:52 UTC (rev 2125) @@ -7,7 +7,7 @@ NORMAL="Authors DeveloperGuide FAQ Inheritance News SQLBuilder SQLObject TODO web/index web/links web/repository web/community - index sqlobject-admin" + index community sqlobject-admin" for NAME in $NORMAL ; do if [ -e "$NAME.html" -a ! "$NAME.html" -ot "$NAME.txt" ] ; then |
|
From: <sub...@co...> - 2006-12-07 15:23:44
|
Author: phd Date: 2006-12-07 08:23:38 -0700 (Thu, 07 Dec 2006) New Revision: 2124 Modified: SQLObject/branches/0.7-bugfix/docs/community.txt SQLObject/branches/0.7-bugfix/docs/rebuild Log: Added a link to the development docs. Modified: SQLObject/branches/0.7-bugfix/docs/community.txt =================================================================== --- SQLObject/branches/0.7-bugfix/docs/community.txt 2006-12-07 15:09:20 UTC (rev 2123) +++ SQLObject/branches/0.7-bugfix/docs/community.txt 2006-12-07 15:23:38 UTC (rev 2124) @@ -16,9 +16,12 @@ <http://sourceforge.net/tracker/?group_id=74338&atid=540674>`_. Development takes place in the `subversion repository -<repository.html>`_. If you are interested in contributing you should -read the `Developer Guide <docs/DeveloperGuide.html>`_. +<repository.html>`_. There are `development docs`_. If you are +interested in contributing you should read the `Developer Guide +<docs/DeveloperGuide.html>`_. +.. _`development docs`: devel/ + The `Author List <docs/Authors.html>`_ tries to list all the major contributors. Modified: SQLObject/branches/0.7-bugfix/docs/rebuild =================================================================== --- SQLObject/branches/0.7-bugfix/docs/rebuild 2006-12-07 15:09:20 UTC (rev 2123) +++ SQLObject/branches/0.7-bugfix/docs/rebuild 2006-12-07 15:23:38 UTC (rev 2124) @@ -7,7 +7,7 @@ NORMAL="Authors DeveloperGuide FAQ Inheritance News SQLBuilder SQLObject TODO web/index web/links web/repository web/community - index sqlobject-admin" + index community sqlobject-admin" for NAME in $NORMAL ; do if [ -e "$NAME.html" -a ! "$NAME.html" -ot "$NAME.txt" ] ; then |
|
From: <sub...@co...> - 2006-12-07 15:09:28
|
Author: phd
Date: 2006-12-07 08:09:20 -0700 (Thu, 07 Dec 2006)
New Revision: 2123
Modified:
SQLObject/branches/0.7-bugfix/setup.py
Log:
Fixed version in Cheeseshop URL.
Modified: SQLObject/branches/0.7-bugfix/setup.py
===================================================================
--- SQLObject/branches/0.7-bugfix/setup.py 2006-12-07 15:06:23 UTC (rev 2122)
+++ SQLObject/branches/0.7-bugfix/setup.py 2006-12-07 15:09:20 UTC (rev 2123)
@@ -52,7 +52,7 @@
author="Ian Bicking",
author_email="ia...@co...",
url="http://sqlobject.org",
- download_url="http://cheeseshop.python.org/pypi/SQLObject/0.7.1",
+ download_url="http://cheeseshop.python.org/pypi/SQLObject/0.7.2",
license="LGPL",
packages=["sqlobject"] + ['sqlobject.%s' % package for package in subpackages],
scripts=["scripts/sqlobject-admin"],
|
|
From: <sub...@co...> - 2006-12-07 15:06:26
|
Author: phd Date: 2006-12-07 08:06:23 -0700 (Thu, 07 Dec 2006) New Revision: 2122 Modified: SQLObject/docs/News.txt Log: Synchronized News with the 0.7-bugfix branch. Modified: SQLObject/docs/News.txt =================================================================== --- SQLObject/docs/News.txt 2006-12-07 15:06:00 UTC (rev 2121) +++ SQLObject/docs/News.txt 2006-12-07 15:06:23 UTC (rev 2122) @@ -132,6 +132,12 @@ * A bug fix that allows to use SQLObject with DateTime from Zope. +Documentation Added +------------------- + +* Added "How can I define my own intermediate table in my Many-to-Many + relationship?" to FAQ. + SQLObject 0.7.1 =============== |
|
From: <sub...@co...> - 2006-12-07 15:06:13
|
Author: phd Date: 2006-12-07 08:06:00 -0700 (Thu, 07 Dec 2006) New Revision: 2121 Modified: SQLObject/branches/0.7-bugfix/docs/News.txt Log: Synchronized News with the trunk. Modified: SQLObject/branches/0.7-bugfix/docs/News.txt =================================================================== --- SQLObject/branches/0.7-bugfix/docs/News.txt 2006-12-06 18:58:17 UTC (rev 2120) +++ SQLObject/branches/0.7-bugfix/docs/News.txt 2006-12-07 15:06:00 UTC (rev 2121) @@ -48,7 +48,8 @@ Documentation Added ------------------- -Added "How can I define my own intermediate table in my Many-to-Many relationship?" to FAQ. +* Added "How can I define my own intermediate table in my Many-to-Many + relationship?" to FAQ. SQLObject 0.7.1 =============== @@ -135,10 +136,10 @@ column. * New `documented reflection interface - <http://sqlobject.org/docs/interface.py.html>`_, using the new - ``.sqlmeta`` class/instance. Most special attributes that started - with ``_`` were moved into ``sqlmeta`` (with leading underscore - removed). + <http://svn.colorstudy.com/SQLObject/docs/interface.py>`_, using the + new ``.sqlmeta`` class/instance. Most special attributes that + started with ``_`` were moved into ``sqlmeta`` (with leading + underscore removed). * New aggregate functions for select results, like ``cls.select().max(columnName)``: ``.max()``, ``.min()``, |
|
From: <sub...@co...> - 2006-12-06 17:52:18
|
Author: ianb Date: 2006-12-06 10:52:04 -0700 (Wed, 06 Dec 2006) New Revision: 2119 Modified: SQLObject/trunk/setup.cfg Log: Don't publish the docstrings from the test modules Modified: SQLObject/trunk/setup.cfg =================================================================== --- SQLObject/trunk/setup.cfg 2006-12-06 16:41:59 UTC (rev 2118) +++ SQLObject/trunk/setup.cfg 2006-12-06 17:52:04 UTC (rev 2119) @@ -15,6 +15,7 @@ doc_base = docs/ dest = docs/html modules = sqlobject +exclude_modules = sqlobject.tests title = SQLObject mailing_list_url = http://sqlobject.org/community.html settings = normal_link_color=#039 |
|
From: <sub...@co...> - 2006-12-06 16:42:15
|
Author: ianb Date: 2006-12-06 09:41:59 -0700 (Wed, 06 Dec 2006) New Revision: 2118 Modified: SQLObject/trunk/setup.cfg SQLObject/trunk/setup.py Log: Changed locations for devel docs; removed blog link Modified: SQLObject/trunk/setup.cfg =================================================================== --- SQLObject/trunk/setup.cfg 2006-12-04 16:53:28 UTC (rev 2117) +++ SQLObject/trunk/setup.cfg 2006-12-06 16:41:59 UTC (rev 2118) @@ -16,7 +16,6 @@ dest = docs/html modules = sqlobject title = SQLObject -blog_url = http://sqlobject.org/news/ mailing_list_url = http://sqlobject.org/community.html settings = normal_link_color=#039 visited_color=#093 Modified: SQLObject/trunk/setup.py =================================================================== --- SQLObject/trunk/setup.py 2006-12-04 16:53:28 UTC (rev 2117) +++ SQLObject/trunk/setup.py 2006-12-06 16:41:59 UTC (rev 2118) @@ -55,7 +55,7 @@ ], author="Ian Bicking", author_email="ia...@co...", - url="http://sqlobject.org", + url="http://sqlobject.org/devel/", download_url="http://cheeseshop.python.org/pypi/SQLObject/", license="LGPL", packages=["sqlobject"] + ['sqlobject.%s' % package for package in subpackages], |
|
From: SourceForge.net <no...@so...> - 2006-12-06 11:57:41
|
Bugs item #1610027, was opened at 2006-12-06 12:57 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1610027&group_id=74338 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: General Group: SQLObject release (specify) Status: Open Resolution: None Priority: 5 Private: No Submitted By: Michael Lang (nuddelaug) Assigned to: Nobody/Anonymous (nobody) Summary: Memory Leak SQLObject-0.7.2 Initial Comment: Hi, i've used SQLObject on ubuntu with sqlite and found a strange behavior consuming the machine memory where it shouldnt do. i wrote a script which creates 2 Tables mostly stringcol, i then iter over a list of names inserting them into just one table buy creating a new Object from the Class for my table, after inserting the values i even del the Object but the memoryuseage increases still <code snip> while [ 1 ]: line = sys.stdin.readline() if not line: break tbl = Table2(col1="a", col2="b", col3="c", ... ) del tbl <code snip> im a getting something wrong ? the data gets inserted, sqlite> SELECT count(*) FROM table2; 117760 but after these Records the machine craps up in swaping due ~350M memory usage on 512M Machine running other things to. thanks for any help kind regards Michael lang ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1610027&group_id=74338 |
|
From: East r. <smv...@op...> - 2006-12-05 09:11:31
|
34291 |
|
From: <sub...@co...> - 2006-12-04 16:53:42
|
Author: ianb Date: 2006-12-04 09:53:28 -0700 (Mon, 04 Dec 2006) New Revision: 2117 Added: SQLObject/tags/0.7.2/0.7-bugfix/ Modified: SQLObject/tags/0.7.2/0.7-bugfix/setup.cfg Log: Tagging release Copied: SQLObject/tags/0.7.2/0.7-bugfix (from rev 2116, SQLObject/branches/0.7-bugfix) Modified: SQLObject/tags/0.7.2/0.7-bugfix/setup.cfg =================================================================== --- SQLObject/branches/0.7-bugfix/setup.cfg 2006-12-04 15:37:51 UTC (rev 2116) +++ SQLObject/tags/0.7.2/0.7-bugfix/setup.cfg 2006-12-04 16:53:28 UTC (rev 2117) @@ -1,7 +1,3 @@ -[egg_info] -tag_build = a -tag_svn_revision = true - [pudge] title = SQLObject dest = docs/html |
|
From: <sub...@co...> - 2006-12-04 15:37:54
|
Author: phd
Date: 2006-12-04 08:37:51 -0700 (Mon, 04 Dec 2006)
New Revision: 2116
Modified:
home/phd/SQLObject/paramstyles/sqlobject/postgres/pgconnection.py
Log:
Merged patches from the revisions 2112:2115 from the trunk: a patch by Robert Forkel <xro...@go...>: psycopg1 requires port to be a string; psycopg2 requires port to be an int.
Modified: home/phd/SQLObject/paramstyles/sqlobject/postgres/pgconnection.py
===================================================================
--- home/phd/SQLObject/paramstyles/sqlobject/postgres/pgconnection.py 2006-12-04 15:36:19 UTC (rev 2115)
+++ home/phd/SQLObject/paramstyles/sqlobject/postgres/pgconnection.py 2006-12-04 15:37:51 UTC (rev 2116)
@@ -45,7 +45,10 @@
if usePygresql:
dsn_dict["host"] = "%s:%d" % (host, port)
else:
- dsn_dict["port"] = port
+ if psycopg.__version__.split('.')[0] == '1':
+ dsn_dict["port"] = str(port)
+ else:
+ dsn_dict["port"] = port
if db:
dsn_dict["database"] = db
if user:
|
|
From: <sub...@co...> - 2006-12-04 15:36:32
|
Author: phd Date: 2006-12-04 08:36:19 -0700 (Mon, 04 Dec 2006) New Revision: 2115 Modified: SQLObject/docs/News.txt Log: A patch by Robert Forkel <xro...@go...>: psycopg1 requires port to be a string; psycopg2 requires port to be an int. Modified: SQLObject/docs/News.txt =================================================================== --- SQLObject/docs/News.txt 2006-12-04 15:35:37 UTC (rev 2114) +++ SQLObject/docs/News.txt 2006-12-04 15:36:19 UTC (rev 2115) @@ -102,6 +102,8 @@ * Allow multiple MSSQL connections. +* Psycopg1 requires port to be a string; psycopg2 requires port to be an int. + SQLObject 0.7.2 =============== |
|
From: <sub...@co...> - 2006-12-04 15:35:49
|
Author: phd
Date: 2006-12-04 08:35:37 -0700 (Mon, 04 Dec 2006)
New Revision: 2114
Modified:
SQLObject/trunk/sqlobject/postgres/pgconnection.py
Log:
A patch by Robert Forkel <xro...@go...>:
psycopg1 requires port to be a string; psycopg2 requires port to be an int.
Modified: SQLObject/trunk/sqlobject/postgres/pgconnection.py
===================================================================
--- SQLObject/trunk/sqlobject/postgres/pgconnection.py 2006-12-04 15:35:19 UTC (rev 2113)
+++ SQLObject/trunk/sqlobject/postgres/pgconnection.py 2006-12-04 15:35:37 UTC (rev 2114)
@@ -45,7 +45,10 @@
if usePygresql:
dsn_dict["host"] = "%s:%d" % (host, port)
else:
- dsn_dict["port"] = port
+ if psycopg.__version__.split('.')[0] == '1':
+ dsn_dict["port"] = str(port)
+ else:
+ dsn_dict["port"] = port
if db:
dsn_dict["database"] = db
if user:
|
|
From: <sub...@co...> - 2006-12-04 15:35:34
|
Author: phd
Date: 2006-12-04 08:35:19 -0700 (Mon, 04 Dec 2006)
New Revision: 2113
Modified:
SQLObject/branches/0.7-bugfix/docs/News.txt
SQLObject/branches/0.7-bugfix/sqlobject/postgres/pgconnection.py
Log:
A patch by Robert Forkel <xro...@go...>:
psycopg1 requires port to be a string; psycopg2 requires port to be an int.
Modified: SQLObject/branches/0.7-bugfix/docs/News.txt
===================================================================
--- SQLObject/branches/0.7-bugfix/docs/News.txt 2006-12-04 15:18:42 UTC (rev 2112)
+++ SQLObject/branches/0.7-bugfix/docs/News.txt 2006-12-04 15:35:19 UTC (rev 2113)
@@ -15,6 +15,8 @@
* Allow multiple MSSQL connections.
+* Psycopg1 requires port to be a string; psycopg2 requires port to be an int.
+
SQLObject 0.7.2
===============
Modified: SQLObject/branches/0.7-bugfix/sqlobject/postgres/pgconnection.py
===================================================================
--- SQLObject/branches/0.7-bugfix/sqlobject/postgres/pgconnection.py 2006-12-04 15:18:42 UTC (rev 2112)
+++ SQLObject/branches/0.7-bugfix/sqlobject/postgres/pgconnection.py 2006-12-04 15:35:19 UTC (rev 2113)
@@ -45,7 +45,10 @@
if usePygresql:
dsn_dict["host"] = "%s:%d" % (host, port)
else:
- dsn_dict["port"] = port
+ if psycopg.__version__.split('.')[0] == '1':
+ dsn_dict["port"] = str(port)
+ else:
+ dsn_dict["port"] = port
if db:
dsn_dict["database"] = db
if user:
|
|
From: <sub...@co...> - 2006-12-04 15:18:46
|
Author: phd
Date: 2006-12-04 08:18:42 -0700 (Mon, 04 Dec 2006)
New Revision: 2112
Modified:
home/phd/SQLObject/paramstyles/sqlobject/mssql/mssqlconnection.py
Log:
Merged patches from the revisions 2103:2111 from the trunk
Modified: home/phd/SQLObject/paramstyles/sqlobject/mssql/mssqlconnection.py
===================================================================
--- home/phd/SQLObject/paramstyles/sqlobject/mssql/mssqlconnection.py 2006-12-04 15:16:36 UTC (rev 2111)
+++ home/phd/SQLObject/paramstyles/sqlobject/mssql/mssqlconnection.py 2006-12-04 15:18:42 UTC (rev 2112)
@@ -16,37 +16,42 @@
if not sqlmodule:
try:
import adodbapi as sqlmodule
- self.dbconnection = sqlmodule.connect
- # ADO uses unicode only (AFAIK)
- self.usingUnicodeStrings = True
+ except ImportError:
+ import pymssql as sqlmodule
- # Need to use SQLNCLI provider for SQL Server Express Edition
- if kw.get("ncli"):
- conn_str = "Provider=SQLNCLI;"
- else:
- conn_str = "Provider=SQLOLEDB;"
+ if sqlmodule.__name__ == 'adodbapi':
+ import adodbapi as sqlmodule
+ self.dbconnection = sqlmodule.connect
+ # ADO uses unicode only (AFAIK)
+ self.usingUnicodeStrings = True
- conn_str += "Data Source=%s;Initial Catalog=%s;"
+ # Need to use SQLNCLI provider for SQL Server Express Edition
+ if kw.get("ncli"):
+ conn_str = "Provider=SQLNCLI;"
+ else:
+ conn_str = "Provider=SQLOLEDB;"
- # MSDE does not allow SQL server login
- if kw.get("sspi"):
- conn_str += "Integrated Security=SSPI;Persist Security Info=False"
- self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db)]
- else:
- conn_str += "User Id=%s;Password=%s"
- self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db, keys.user, keys.password)]
+ conn_str += "Data Source=%s;Initial Catalog=%s;"
- col.popKey(kw, "sspi")
- col.popKey(kw, "ncli")
+ # MSDE does not allow SQL server login
+ if kw.get("sspi"):
+ conn_str += "Integrated Security=SSPI;Persist Security Info=False"
+ self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db)]
+ else:
+ conn_str += "User Id=%s;Password=%s"
+ self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db, keys.user, keys.password)]
- except ImportError: # raise the exceptions other than ImportError for adodbapi absence
- import pymssql as sqlmodule
- self.dbconnection = sqlmodule.connect
- sqlmodule.Binary = lambda st: str(st)
- # don't know whether pymssql uses unicode
- self.usingUnicodeStrings = False
- self.make_conn_str = lambda keys: \
- ["", keys.user, keys.password, keys.host, keys.db]
+ col.popKey(kw, "sspi")
+ col.popKey(kw, "ncli")
+
+ else: # pymssql
+ self.dbconnection = sqlmodule.connect
+ sqlmodule.Binary = lambda st: str(st)
+ # don't know whether pymssql uses unicode
+ self.usingUnicodeStrings = False
+ self.make_conn_str = lambda keys: \
+ ["", keys.user, keys.password, keys.host, keys.db]
+
self.autoCommit=int(autoCommit)
self.host = host
self.db = db
|
|
From: <sub...@co...> - 2006-12-04 15:16:39
|
Author: phd Date: 2006-12-04 08:16:36 -0700 (Mon, 04 Dec 2006) New Revision: 2111 Modified: SQLObject/docs/News.txt Log: Updated News.txt. Modified: SQLObject/docs/News.txt =================================================================== --- SQLObject/docs/News.txt 2006-12-04 15:15:23 UTC (rev 2110) +++ SQLObject/docs/News.txt 2006-12-04 15:16:36 UTC (rev 2111) @@ -94,6 +94,14 @@ * The reference loop between SQLObject and SQLObjectState eliminated using weak references. +SQLObject 0.7.3 +=============== + +Bug Fixes +--------- + +* Allow multiple MSSQL connections. + SQLObject 0.7.2 =============== |
|
From: SourceForge.net <no...@so...> - 2006-12-04 15:16:19
|
Patches item #1603319, was opened at 2006-11-26 22:21 Message generated for change (Comment added) made by phd You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1603319&group_id=74338 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None >Status: Closed >Resolution: Accepted Priority: 5 Private: No Submitted By: Paul Johnston (paj28) >Assigned to: Oleg Broytmann (phd) Summary: Allow multiple MSSQL connections Initial Comment: Hi, This patch fixes a bug in mssqlconnection. Previously, it was only possible to create one connection; subsequent connections would be missing the dbconnection attribute. The fix I've used seems sensible and it works for me. Is there any further testing I need to do? Hope this helps, Paul ---------------------------------------------------------------------- >Comment By: Oleg Broytmann (phd) Date: 2006-12-04 18:16 Message: Logged In: YES user_id=4799 Originator: NO Applied and committed in the revisions 2108, 2109. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1603319&group_id=74338 |
|
From: <sub...@co...> - 2006-12-04 15:15:29
|
Author: phd Date: 2006-12-04 08:15:23 -0700 (Mon, 04 Dec 2006) New Revision: 2110 Modified: SQLObject/branches/0.7-bugfix/docs/News.txt Log: Updated News.txt. Modified: SQLObject/branches/0.7-bugfix/docs/News.txt =================================================================== --- SQLObject/branches/0.7-bugfix/docs/News.txt 2006-12-04 15:13:09 UTC (rev 2109) +++ SQLObject/branches/0.7-bugfix/docs/News.txt 2006-12-04 15:15:23 UTC (rev 2110) @@ -7,6 +7,14 @@ .. _start: +SQLObject 0.7.3 +=============== + +Bug Fixes +--------- + +* Allow multiple MSSQL connections. + SQLObject 0.7.2 =============== @@ -40,7 +48,6 @@ Added "How can I define my own intermediate table in my Many-to-Many relationship?" to FAQ. - SQLObject 0.7.1 =============== |
|
From: <sub...@co...> - 2006-12-04 15:13:14
|
Author: phd
Date: 2006-12-04 08:13:09 -0700 (Mon, 04 Dec 2006)
New Revision: 2109
Modified:
SQLObject/trunk/sqlobject/mssql/mssqlconnection.py
Log:
A patch 1603319 by Paul Johnston <pa...@pa...>: Allow multiple MSSQL connections.
Modified: SQLObject/trunk/sqlobject/mssql/mssqlconnection.py
===================================================================
--- SQLObject/trunk/sqlobject/mssql/mssqlconnection.py 2006-12-04 15:11:01 UTC (rev 2108)
+++ SQLObject/trunk/sqlobject/mssql/mssqlconnection.py 2006-12-04 15:13:09 UTC (rev 2109)
@@ -16,37 +16,42 @@
if not sqlmodule:
try:
import adodbapi as sqlmodule
- self.dbconnection = sqlmodule.connect
- # ADO uses unicode only (AFAIK)
- self.usingUnicodeStrings = True
+ except ImportError:
+ import pymssql as sqlmodule
- # Need to use SQLNCLI provider for SQL Server Express Edition
- if kw.get("ncli"):
- conn_str = "Provider=SQLNCLI;"
- else:
- conn_str = "Provider=SQLOLEDB;"
+ if sqlmodule.__name__ == 'adodbapi':
+ import adodbapi as sqlmodule
+ self.dbconnection = sqlmodule.connect
+ # ADO uses unicode only (AFAIK)
+ self.usingUnicodeStrings = True
- conn_str += "Data Source=%s;Initial Catalog=%s;"
+ # Need to use SQLNCLI provider for SQL Server Express Edition
+ if kw.get("ncli"):
+ conn_str = "Provider=SQLNCLI;"
+ else:
+ conn_str = "Provider=SQLOLEDB;"
- # MSDE does not allow SQL server login
- if kw.get("sspi"):
- conn_str += "Integrated Security=SSPI;Persist Security Info=False"
- self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db)]
- else:
- conn_str += "User Id=%s;Password=%s"
- self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db, keys.user, keys.password)]
+ conn_str += "Data Source=%s;Initial Catalog=%s;"
- col.popKey(kw, "sspi")
- col.popKey(kw, "ncli")
+ # MSDE does not allow SQL server login
+ if kw.get("sspi"):
+ conn_str += "Integrated Security=SSPI;Persist Security Info=False"
+ self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db)]
+ else:
+ conn_str += "User Id=%s;Password=%s"
+ self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db, keys.user, keys.password)]
- except ImportError: # raise the exceptions other than ImportError for adodbapi absence
- import pymssql as sqlmodule
- self.dbconnection = sqlmodule.connect
- sqlmodule.Binary = lambda st: str(st)
- # don't know whether pymssql uses unicode
- self.usingUnicodeStrings = False
- self.make_conn_str = lambda keys: \
- ["", keys.user, keys.password, keys.host, keys.db]
+ col.popKey(kw, "sspi")
+ col.popKey(kw, "ncli")
+
+ else: # pymssql
+ self.dbconnection = sqlmodule.connect
+ sqlmodule.Binary = lambda st: str(st)
+ # don't know whether pymssql uses unicode
+ self.usingUnicodeStrings = False
+ self.make_conn_str = lambda keys: \
+ ["", keys.user, keys.password, keys.host, keys.db]
+
self.autoCommit=int(autoCommit)
self.host = host
self.db = db
|
|
From: <sub...@co...> - 2006-12-04 15:11:19
|
Author: phd
Date: 2006-12-04 08:11:01 -0700 (Mon, 04 Dec 2006)
New Revision: 2108
Modified:
SQLObject/branches/0.7-bugfix/sqlobject/mssql/mssqlconnection.py
Log:
A patch 1603319 by Paul Johnston <pa...@pa...>: Allow multiple MSSQL connections.
Modified: SQLObject/branches/0.7-bugfix/sqlobject/mssql/mssqlconnection.py
===================================================================
--- SQLObject/branches/0.7-bugfix/sqlobject/mssql/mssqlconnection.py 2006-12-01 20:06:49 UTC (rev 2107)
+++ SQLObject/branches/0.7-bugfix/sqlobject/mssql/mssqlconnection.py 2006-12-04 15:11:01 UTC (rev 2108)
@@ -16,37 +16,41 @@
if not sqlmodule:
try:
import adodbapi as sqlmodule
- self.dbconnection = sqlmodule.connect
- # ADO uses unicode only (AFAIK)
- self.usingUnicodeStrings = True
+ except ImportError:
+ import pymssql as sqlmodule
- # Need to use SQLNCLI provider for SQL Server Express Edition
- if kw.get("ncli"):
- conn_str = "Provider=SQLNCLI;"
- else:
- conn_str = "Provider=SQLOLEDB;"
+ if sqlmodule.__name__ == 'adodbapi':
+ self.dbconnection = sqlmodule.connect
+ # ADO uses unicode only (AFAIK)
+ self.usingUnicodeStrings = True
- conn_str += "Data Source=%s;Initial Catalog=%s;"
+ # Need to use SQLNCLI provider for SQL Server Express Edition
+ if kw.get("ncli"):
+ conn_str = "Provider=SQLNCLI;"
+ else:
+ conn_str = "Provider=SQLOLEDB;"
- # MSDE does not allow SQL server login
- if kw.get("sspi"):
- conn_str += "Integrated Security=SSPI;Persist Security Info=False"
- self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db)]
- else:
- conn_str += "User Id=%s;Password=%s"
- self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db, keys.user, keys.password)]
+ conn_str += "Data Source=%s;Initial Catalog=%s;"
- col.popKey(kw, "sspi")
- col.popKey(kw, "ncli")
+ # MSDE does not allow SQL server login
+ if kw.get("sspi"):
+ conn_str += "Integrated Security=SSPI;Persist Security Info=False"
+ self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db)]
+ else:
+ conn_str += "User Id=%s;Password=%s"
+ self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db, keys.user, keys.password)]
- except ImportError: # raise the exceptions other than ImportError for adodbapi absence
- import pymssql as sqlmodule
- self.dbconnection = sqlmodule.connect
- sqlmodule.Binary = lambda st: str(st)
- # don't know whether pymssql uses unicode
- self.usingUnicodeStrings = False
- self.make_conn_str = lambda keys: \
- ["", keys.user, keys.password, keys.host, keys.db]
+ col.popKey(kw, "sspi")
+ col.popKey(kw, "ncli")
+
+ else: # pymssql
+ self.dbconnection = sqlmodule.connect
+ sqlmodule.Binary = lambda st: str(st)
+ # don't know whether pymssql uses unicode
+ self.usingUnicodeStrings = False
+ self.make_conn_str = lambda keys: \
+ ["", keys.user, keys.password, keys.host, keys.db]
+
self.autoCommit=int(autoCommit)
self.host = host
self.db = db
|
|
From: SourceForge.net <no...@so...> - 2006-11-26 19:21:48
|
Patches item #1603319, was opened at 2006-11-26 19:21 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1603319&group_id=74338 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Paul Johnston (paj28) Assigned to: Nobody/Anonymous (nobody) Summary: Allow multiple MSSQL connections Initial Comment: Hi, This patch fixes a bug in mssqlconnection. Previously, it was only possible to create one connection; subsequent connections would be missing the dbconnection attribute. The fix I've used seems sensible and it works for me. Is there any further testing I need to do? Hope this helps, Paul ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1603319&group_id=74338 |
|
From: <sub...@co...> - 2006-11-23 15:18:29
|
Author: phd
Date: 2006-11-23 08:18:24 -0700 (Thu, 23 Nov 2006)
New Revision: 2104
Modified:
SQLObject/tags/0.7.2/docs/FAQ.txt
SQLObject/tags/0.7.2/docs/News.txt
Log:
Merged the last doc update from the 0.7-bugfix branch.
Modified: SQLObject/tags/0.7.2/docs/FAQ.txt
===================================================================
--- SQLObject/tags/0.7.2/docs/FAQ.txt 2006-11-20 19:37:25 UTC (rev 2103)
+++ SQLObject/tags/0.7.2/docs/FAQ.txt 2006-11-23 15:18:24 UTC (rev 2104)
@@ -103,6 +103,51 @@
.. _SQLBuilder: SQLBuilder.html
.. _example: SQLObject.html#how-can-i-join-a-table-with-itself
+
+How can I define my own intermediate table in my Many-to-Many relationship?
+---------------------------------------------------------------------------
+
+.. note::
+ In User and Role, SQLRelatedJoin is used with createRelatedTable=False
+ so the intermediate table is not created automatically. We also set the
+ intermediate table name with intermediateTable='user_roles'.
+ UserRoles is the definition of our intermediate table.
+ UserRoles creates a unique index to make sure we don't have duplicate
+ data in the database.
+ We also added an extra field called active which has a boolean value.
+ The active column might be used to activate/deactivate a given role for
+ a user in this example.
+ Another common field to add in this an intermediate table might be a sort
+ field.
+
+We'll expand on the User and Role example and define our own UserRoles class which
+will be the intermediate table for the User and Role Many-to-Many relationship.
+
+Example::
+
+ >>> class User(SQLObject):
+ ... class sqlmeta:
+ ... table = "user_table"
+ ... username = StringCol(alternateID=True, length=20)
+ ... roles = SQLRelatedJoin('Role',
+ ... intermediateTable='user_roles',
+ ... createRelatedTable=False)
+
+ >>> class Role(SQLObject):
+ ... name = StringCol(alternateID=True, length=20)
+ ... users = SQLRelatedJoin('User',
+ ... intermediateTable='user_roles',
+ ... createRelatedTable=False)
+
+ >>> class UserRoles(SQLObject):
+ ... class sqlmeta:
+ ... table = "user_roles"
+ ... user = ForeignKey('User', notNull=True, cascade=True)
+ ... role = ForeignKey('Role', notNull=True, cascade=True)
+ ... active = BoolCol(notNull=True, default=False)
+ ... unique = index.DatabaseIndex(user, role, unique=True)
+
+
How Does Inheritance Work?
--------------------------
Modified: SQLObject/tags/0.7.2/docs/News.txt
===================================================================
--- SQLObject/tags/0.7.2/docs/News.txt 2006-11-20 19:37:25 UTC (rev 2103)
+++ SQLObject/tags/0.7.2/docs/News.txt 2006-11-23 15:18:24 UTC (rev 2104)
@@ -35,6 +35,12 @@
* A bug fix that allows to use SQLObject with DateTime from Zope.
+Documentation Added
+-------------------
+
+Added "How can I define my own intermediate table in my Many-to-Many relationship?" to FAQ.
+
+
SQLObject 0.7.1
===============
|
|
From: <sub...@co...> - 2006-11-20 19:37:31
|
Author: phd
Date: 2006-11-20 12:37:25 -0700 (Mon, 20 Nov 2006)
New Revision: 2103
Modified:
SQLObject/branches/0.7-bugfix/docs/FAQ.txt
Log:
Reformatted the example so the code doesn't overlap the note.
Modified: SQLObject/branches/0.7-bugfix/docs/FAQ.txt
===================================================================
--- SQLObject/branches/0.7-bugfix/docs/FAQ.txt 2006-11-20 19:35:42 UTC (rev 2102)
+++ SQLObject/branches/0.7-bugfix/docs/FAQ.txt 2006-11-20 19:37:25 UTC (rev 2103)
@@ -129,11 +129,15 @@
... class sqlmeta:
... table = "user_table"
... username = StringCol(alternateID=True, length=20)
- ... roles = SQLRelatedJoin('Role', intermediateTable='user_roles', createRelatedTable=False)
+ ... roles = SQLRelatedJoin('Role',
+ ... intermediateTable='user_roles',
+ ... createRelatedTable=False)
>>> class Role(SQLObject):
... name = StringCol(alternateID=True, length=20)
- ... users = SQLRelatedJoin('User', intermediateTable='user_roles', createRelatedTable=False)
+ ... users = SQLRelatedJoin('User',
+ ... intermediateTable='user_roles',
+ ... createRelatedTable=False)
>>> class UserRoles(SQLObject):
... class sqlmeta:
|
89 messages has been excluded from this view by a project administrator.
