sqlobject-cvs Mailing List for SQLObject (Page 88)
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...> - 2007-07-16 11:51:28
|
Author: phd Date: 2007-07-16 05:51:25 -0600 (Mon, 16 Jul 2007) New Revision: 2752 Modified: SQLObject/docs/News.txt Log: Applied the patch 1744847: Firebird, fromDatabase generate 2 ID columns fix. Modified: SQLObject/docs/News.txt =================================================================== --- SQLObject/docs/News.txt 2007-07-16 11:51:07 UTC (rev 2751) +++ SQLObject/docs/News.txt 2007-07-16 11:51:25 UTC (rev 2752) @@ -241,6 +241,8 @@ * MySQLConnection now recognizes Enum, Double and Time columns when drawing the database scheme from DB. +* Minor fix in FirebirdConnection.fromDatabase. + SQLObject 0.7.7 =============== |
|
From: <sub...@co...> - 2007-07-16 11:51:10
|
Author: phd
Date: 2007-07-16 05:51:07 -0600 (Mon, 16 Jul 2007)
New Revision: 2751
Modified:
SQLObject/trunk/sqlobject/firebird/firebirdconnection.py
Log:
Applied the patch 1744847: Firebird, fromDatabase generate 2 ID columns fix.
Modified: SQLObject/trunk/sqlobject/firebird/firebirdconnection.py
===================================================================
--- SQLObject/trunk/sqlobject/firebird/firebirdconnection.py 2007-07-16 11:50:43 UTC (rev 2750)
+++ SQLObject/trunk/sqlobject/firebird/firebirdconnection.py 2007-07-16 11:51:07 UTC (rev 2751)
@@ -192,11 +192,13 @@
colData = self.queryAll(fieldqry % tableName.upper())
results = []
for field, t, flength, fscale, nullAllowed, thedefault, blobType in colData:
- if field == 'id':
+ field = field.strip()
+ idName = str(soClass.sqlmeta.idName or 'id').upper()
+ if field.upper() == idName:
continue
colClass, kw = self.guessClass(t, flength, fscale)
kw['name'] = soClass.sqlmeta.style.dbColumnToPythonAttr(field).strip()
- kw['dbName'] = field.strip()
+ kw['dbName'] = field
kw['notNone'] = not nullAllowed
kw['default'] = thedefault
results.append(colClass(**kw))
|
|
From: <sub...@co...> - 2007-07-16 11:50:46
|
Author: phd
Date: 2007-07-16 05:50:43 -0600 (Mon, 16 Jul 2007)
New Revision: 2750
Modified:
SQLObject/branches/0.9/docs/News.txt
SQLObject/branches/0.9/sqlobject/firebird/firebirdconnection.py
Log:
Applied the patch 1744847: Firebird, fromDatabase generate 2 ID columns fix.
Modified: SQLObject/branches/0.9/docs/News.txt
===================================================================
--- SQLObject/branches/0.9/docs/News.txt 2007-07-16 11:50:13 UTC (rev 2749)
+++ SQLObject/branches/0.9/docs/News.txt 2007-07-16 11:50:43 UTC (rev 2750)
@@ -240,6 +240,8 @@
* MySQLConnection now recognizes Enum, Double and Time columns when drawing the
database scheme from DB.
+* Minor fix in FirebirdConnection.fromDatabase.
+
SQLObject 0.7.7
===============
Modified: SQLObject/branches/0.9/sqlobject/firebird/firebirdconnection.py
===================================================================
--- SQLObject/branches/0.9/sqlobject/firebird/firebirdconnection.py 2007-07-16 11:50:13 UTC (rev 2749)
+++ SQLObject/branches/0.9/sqlobject/firebird/firebirdconnection.py 2007-07-16 11:50:43 UTC (rev 2750)
@@ -191,11 +191,13 @@
colData = self.queryAll(fieldqry % tableName.upper())
results = []
for field, t, flength, fscale, nullAllowed, thedefault, blobType in colData:
- if field == 'id':
+ field = field.strip()
+ idName = str(soClass.sqlmeta.idName or 'id').upper()
+ if field.upper() == idName:
continue
colClass, kw = self.guessClass(t, flength, fscale)
kw['name'] = soClass.sqlmeta.style.dbColumnToPythonAttr(field).strip()
- kw['dbName'] = field.strip()
+ kw['dbName'] = field
kw['notNone'] = not nullAllowed
kw['default'] = thedefault
results.append(colClass(**kw))
|
|
From: <sub...@co...> - 2007-07-16 11:50:21
|
Author: phd
Date: 2007-07-16 05:50:13 -0600 (Mon, 16 Jul 2007)
New Revision: 2749
Modified:
SQLObject/branches/0.8/docs/News.txt
SQLObject/branches/0.8/sqlobject/firebird/firebirdconnection.py
Log:
Applied the patch 1744847: Firebird, fromDatabase generate 2 ID columns fix.
Modified: SQLObject/branches/0.8/docs/News.txt
===================================================================
--- SQLObject/branches/0.8/docs/News.txt 2007-07-16 11:49:04 UTC (rev 2748)
+++ SQLObject/branches/0.8/docs/News.txt 2007-07-16 11:50:13 UTC (rev 2749)
@@ -175,6 +175,8 @@
* MySQLConnection now recognizes Enum, Double and Time columns when drawing the
database scheme from DB.
+* Minor fix in FirebirdConnection.fromDatabase.
+
SQLObject 0.7.7
===============
Modified: SQLObject/branches/0.8/sqlobject/firebird/firebirdconnection.py
===================================================================
--- SQLObject/branches/0.8/sqlobject/firebird/firebirdconnection.py 2007-07-16 11:49:04 UTC (rev 2748)
+++ SQLObject/branches/0.8/sqlobject/firebird/firebirdconnection.py 2007-07-16 11:50:13 UTC (rev 2749)
@@ -193,11 +193,13 @@
colData = self.queryAll(fieldqry % tableName.upper())
results = []
for field, t, flength, fscale, nullAllowed, thedefault, blobType in colData:
- if field == 'id':
+ field = field.strip()
+ idName = str(soClass.sqlmeta.idName or 'id').upper()
+ if field.upper() == idName:
continue
colClass, kw = self.guessClass(t, flength, fscale)
kw['name'] = soClass.sqlmeta.style.dbColumnToPythonAttr(field).strip()
- kw['dbName'] = field.strip()
+ kw['dbName'] = field
kw['notNone'] = not nullAllowed
kw['default'] = thedefault
results.append(colClass(**kw))
|
|
From: <sub...@co...> - 2007-07-16 11:49:09
|
Author: phd
Date: 2007-07-16 05:49:04 -0600 (Mon, 16 Jul 2007)
New Revision: 2748
Modified:
SQLObject/branches/0.7/docs/News.txt
SQLObject/branches/0.7/sqlobject/firebird/firebirdconnection.py
Log:
Applied the patch 1744847: Firebird, fromDatabase generate 2 ID columns fix.
Modified: SQLObject/branches/0.7/docs/News.txt
===================================================================
--- SQLObject/branches/0.7/docs/News.txt 2007-07-16 11:42:29 UTC (rev 2747)
+++ SQLObject/branches/0.7/docs/News.txt 2007-07-16 11:49:04 UTC (rev 2748)
@@ -18,6 +18,8 @@
* MySQLConnection now recognizes Enum, Double and Time columns when drawing the
database scheme from DB.
+* Minor fix in FirebirdConnection.fromDatabase.
+
SQLObject 0.7.7
===============
Modified: SQLObject/branches/0.7/sqlobject/firebird/firebirdconnection.py
===================================================================
--- SQLObject/branches/0.7/sqlobject/firebird/firebirdconnection.py 2007-07-16 11:42:29 UTC (rev 2747)
+++ SQLObject/branches/0.7/sqlobject/firebird/firebirdconnection.py 2007-07-16 11:49:04 UTC (rev 2748)
@@ -188,11 +188,13 @@
colData = self.queryAll(fieldqry % tableName.upper())
results = []
for field, t, flength, fscale, nullAllowed, thedefault, blobType in colData:
- if field == 'id':
+ field = field.strip()
+ idName = str(soClass.sqlmeta.idName or 'id').upper()
+ if field.upper() == idName:
continue
colClass, kw = self.guessClass(t, flength, fscale)
kw['name'] = soClass.sqlmeta.style.dbColumnToPythonAttr(field).strip()
- kw['dbName'] = field.strip()
+ kw['dbName'] = field
kw['notNone'] = not nullAllowed
kw['default'] = thedefault
results.append(colClass(**kw))
|
|
From: SourceForge.net <no...@so...> - 2007-07-16 11:42:56
|
Patches item #1735900, was opened at 2007-06-12 21:22 Message generated for change (Comment added) made by phd You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1735900&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: til (tkoschnick) >Assigned to: Oleg Broytmann (phd) Summary: Fix typo in new INT type classes Initial Comment: Hi, the attached patch fixes a tiny typo in the class definitions for SOTinyIntCol & Co. Without it, the new col types are created, but still with type 'INT'. Cheers, Til ---------------------------------------------------------------------- >Comment By: Oleg Broytmann (phd) Date: 2007-07-16 15:42 Message: Logged In: YES user_id=4799 Originator: NO Applied and committed in the revisions 2745-2747 (0.9 branch, the trunk, docs.) Thank you! ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1735900&group_id=74338 |
|
From: <sub...@co...> - 2007-07-16 11:42:34
|
Author: phd Date: 2007-07-16 05:42:29 -0600 (Mon, 16 Jul 2007) New Revision: 2747 Modified: SQLObject/docs/News.txt Log: Applied the patch N 1735900: Fix typo in new INT type classes. Modified: SQLObject/docs/News.txt =================================================================== --- SQLObject/docs/News.txt 2007-07-16 11:42:05 UTC (rev 2746) +++ SQLObject/docs/News.txt 2007-07-16 11:42:29 UTC (rev 2747) @@ -10,6 +10,14 @@ SQLObject (trunk) ================= +SQLObject 0.9.1 +=============== + +Bug Fixes +--------- + +* Fixed misspelled methods in col.py. + SQLObject 0.9.0 =============== |
|
From: <sub...@co...> - 2007-07-16 11:42:09
|
Author: phd
Date: 2007-07-16 05:42:05 -0600 (Mon, 16 Jul 2007)
New Revision: 2746
Modified:
SQLObject/trunk/sqlobject/col.py
Log:
Applied the patch N 1735900: Fix typo in new INT type classes.
Modified: SQLObject/trunk/sqlobject/col.py
===================================================================
--- SQLObject/trunk/sqlobject/col.py 2007-07-16 11:39:44 UTC (rev 2745)
+++ SQLObject/trunk/sqlobject/col.py 2007-07-16 11:42:05 UTC (rev 2746)
@@ -631,28 +631,28 @@
baseClass = SOIntCol
class SOTinyIntCol(SOIntCol):
- def _sqlTyps(self):
+ def _sqlType(self):
return self.addSQLAttrs("TINYINT")
class TinyIntCol(Col):
baseClass = SOTinyIntCol
class SOSmallIntCol(SOIntCol):
- def _sqlTyps(self):
+ def _sqlType(self):
return self.addSQLAttrs("SMALLINT")
class SmallIntCol(Col):
baseClass = SOSmallIntCol
class SOMediumIntCol(SOIntCol):
- def _sqlTyps(self):
+ def _sqlType(self):
return self.addSQLAttrs("MEDIUMINT")
class MediumIntCol(Col):
baseClass = SOMediumIntCol
class SOBigIntCol(SOIntCol):
- def _sqlTyps(self):
+ def _sqlType(self):
return self.addSQLAttrs("BIGINT")
class BigIntCol(Col):
|
|
From: <sub...@co...> - 2007-07-16 11:39:49
|
Author: phd
Date: 2007-07-16 05:39:44 -0600 (Mon, 16 Jul 2007)
New Revision: 2745
Modified:
SQLObject/branches/0.9/docs/News.txt
SQLObject/branches/0.9/sqlobject/col.py
Log:
Applied the patch N1735900: Fix typo in new INT type classes.
Modified: SQLObject/branches/0.9/docs/News.txt
===================================================================
--- SQLObject/branches/0.9/docs/News.txt 2007-07-12 15:32:57 UTC (rev 2744)
+++ SQLObject/branches/0.9/docs/News.txt 2007-07-16 11:39:44 UTC (rev 2745)
@@ -7,6 +7,14 @@
.. _start:
+SQLObject 0.9.1
+===============
+
+Bug Fixes
+---------
+
+* Fixed misspelled methods in col.py.
+
SQLObject 0.9.0
===============
Modified: SQLObject/branches/0.9/sqlobject/col.py
===================================================================
--- SQLObject/branches/0.9/sqlobject/col.py 2007-07-12 15:32:57 UTC (rev 2744)
+++ SQLObject/branches/0.9/sqlobject/col.py 2007-07-16 11:39:44 UTC (rev 2745)
@@ -631,28 +631,28 @@
baseClass = SOIntCol
class SOTinyIntCol(SOIntCol):
- def _sqlTyps(self):
+ def _sqlType(self):
return self.addSQLAttrs("TINYINT")
class TinyIntCol(Col):
baseClass = SOTinyIntCol
class SOSmallIntCol(SOIntCol):
- def _sqlTyps(self):
+ def _sqlType(self):
return self.addSQLAttrs("SMALLINT")
class SmallIntCol(Col):
baseClass = SOSmallIntCol
class SOMediumIntCol(SOIntCol):
- def _sqlTyps(self):
+ def _sqlType(self):
return self.addSQLAttrs("MEDIUMINT")
class MediumIntCol(Col):
baseClass = SOMediumIntCol
class SOBigIntCol(SOIntCol):
- def _sqlTyps(self):
+ def _sqlType(self):
return self.addSQLAttrs("BIGINT")
class BigIntCol(Col):
|
|
From: Espinosa <wn...@ir...> - 2007-07-13 03:08:29
|
|
From: <sub...@co...> - 2007-07-12 15:33:04
|
Author: phd Date: 2007-07-12 09:32:57 -0600 (Thu, 12 Jul 2007) New Revision: 2744 Modified: SQLObject/docs/News.txt Log: A patch by Brian Cole <br...@te...>: MySQLConnection now recognizes Time columns when drawing the database scheme from DB. Modified: SQLObject/docs/News.txt =================================================================== --- SQLObject/docs/News.txt 2007-07-12 15:32:44 UTC (rev 2743) +++ SQLObject/docs/News.txt 2007-07-12 15:32:57 UTC (rev 2744) @@ -230,7 +230,7 @@ * Minor correction in the tests: we fully support EnumCol in Postgres. -* MySQLConnection now recognizes Enum and Double columns when drawing the +* MySQLConnection now recognizes Enum, Double and Time columns when drawing the database scheme from DB. SQLObject 0.7.7 |
|
From: <sub...@co...> - 2007-07-12 15:32:50
|
Author: phd
Date: 2007-07-12 09:32:44 -0600 (Thu, 12 Jul 2007)
New Revision: 2743
Modified:
SQLObject/trunk/sqlobject/mysql/mysqlconnection.py
Log:
A patch by Brian Cole <br...@te...>:
MySQLConnection now recognizes Time columns when drawing the database scheme from DB.
Modified: SQLObject/trunk/sqlobject/mysql/mysqlconnection.py
===================================================================
--- SQLObject/trunk/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:32:23 UTC (rev 2742)
+++ SQLObject/trunk/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:32:44 UTC (rev 2743)
@@ -271,6 +271,8 @@
return col.DateTimeCol, {}
elif t.startswith('date'):
return col.DateCol, {}
+ elif t.startswith('time'):
+ return col.TimeCol, {}
elif t.startswith('timestamp'):
return col.TimestampCol, {}
elif t.startswith('bool'):
|
|
From: <sub...@co...> - 2007-07-12 15:32:33
|
Author: phd
Date: 2007-07-12 09:32:23 -0600 (Thu, 12 Jul 2007)
New Revision: 2742
Modified:
SQLObject/branches/0.9/docs/News.txt
SQLObject/branches/0.9/sqlobject/mysql/mysqlconnection.py
Log:
A patch by Brian Cole <br...@te...>:
MySQLConnection now recognizes Time columns when drawing the database scheme from DB.
Modified: SQLObject/branches/0.9/docs/News.txt
===================================================================
--- SQLObject/branches/0.9/docs/News.txt 2007-07-12 15:32:07 UTC (rev 2741)
+++ SQLObject/branches/0.9/docs/News.txt 2007-07-12 15:32:23 UTC (rev 2742)
@@ -229,7 +229,7 @@
* Minor correction in the tests: we fully support EnumCol in Postgres.
-* MySQLConnection now recognizes Enum and Double columns when drawing the
+* MySQLConnection now recognizes Enum, Double and Time columns when drawing the
database scheme from DB.
SQLObject 0.7.7
Modified: SQLObject/branches/0.9/sqlobject/mysql/mysqlconnection.py
===================================================================
--- SQLObject/branches/0.9/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:32:07 UTC (rev 2741)
+++ SQLObject/branches/0.9/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:32:23 UTC (rev 2742)
@@ -270,6 +270,8 @@
return col.DateTimeCol, {}
elif t.startswith('date'):
return col.DateCol, {}
+ elif t.startswith('time'):
+ return col.TimeCol, {}
elif t.startswith('timestamp'):
return col.TimestampCol, {}
elif t.startswith('bool'):
|
|
From: <sub...@co...> - 2007-07-12 15:32:11
|
Author: phd
Date: 2007-07-12 09:32:07 -0600 (Thu, 12 Jul 2007)
New Revision: 2741
Modified:
SQLObject/branches/0.8/docs/News.txt
SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py
Log:
A patch by Brian Cole <br...@te...>:
MySQLConnection now recognizes Time columns when drawing the database scheme from DB.
Modified: SQLObject/branches/0.8/docs/News.txt
===================================================================
--- SQLObject/branches/0.8/docs/News.txt 2007-07-12 15:31:34 UTC (rev 2740)
+++ SQLObject/branches/0.8/docs/News.txt 2007-07-12 15:32:07 UTC (rev 2741)
@@ -172,7 +172,7 @@
* Minor correction in the tests: we fully support EnumCol in Postgres.
-* MySQLConnection now recognizes Enum and Double columns when drawing the
+* MySQLConnection now recognizes Enum, Double and Time columns when drawing the
database scheme from DB.
SQLObject 0.7.7
Modified: SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py
===================================================================
--- SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:31:34 UTC (rev 2740)
+++ SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:32:07 UTC (rev 2741)
@@ -270,6 +270,8 @@
'varchar': False}
elif t.startswith('datetime'):
return col.DateTimeCol, {}
+ elif t.startswith('time'):
+ return col.TimeCol, {}
elif t.startswith('bool'):
return col.BoolCol, {}
elif t.startswith('tinyblob'):
|
|
From: <sub...@co...> - 2007-07-12 15:31:40
|
Author: phd
Date: 2007-07-12 09:31:34 -0600 (Thu, 12 Jul 2007)
New Revision: 2740
Modified:
SQLObject/branches/0.7/docs/News.txt
SQLObject/branches/0.7/sqlobject/mysql/mysqlconnection.py
Log:
A patch by Brian Cole <br...@te...>:
MySQLConnection now recognizes Time columns when drawing the database scheme from DB.
Modified: SQLObject/branches/0.7/docs/News.txt
===================================================================
--- SQLObject/branches/0.7/docs/News.txt 2007-07-12 15:25:13 UTC (rev 2739)
+++ SQLObject/branches/0.7/docs/News.txt 2007-07-12 15:31:34 UTC (rev 2740)
@@ -15,7 +15,7 @@
* Minor correction in the tests: we fully support EnumCol in Postgres.
-* MySQLConnection now recognizes Enum and Double columns when drawing the
+* MySQLConnection now recognizes Enum, Double and Time columns when drawing the
database scheme from DB.
SQLObject 0.7.7
Modified: SQLObject/branches/0.7/sqlobject/mysql/mysqlconnection.py
===================================================================
--- SQLObject/branches/0.7/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:25:13 UTC (rev 2739)
+++ SQLObject/branches/0.7/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:31:34 UTC (rev 2740)
@@ -219,6 +219,8 @@
'varchar': False}
elif t.startswith('datetime'):
return col.DateTimeCol, {}
+ elif t.startswith('time'):
+ return col.TimeCol, {}
elif t.startswith('bool'):
return col.BoolCol, {}
elif t.startswith('tinyblob'):
|
|
From: <sub...@co...> - 2007-07-12 15:25:18
|
Author: phd Date: 2007-07-12 09:25:13 -0600 (Thu, 12 Jul 2007) New Revision: 2739 Modified: SQLObject/docs/News.txt Log: A patch by Claudio Martinez <cla...@gm...>: MySQLConnection now recognizes Enum and Double columns when drawing the database scheme from DB. Modified: SQLObject/docs/News.txt =================================================================== --- SQLObject/docs/News.txt 2007-07-12 15:24:47 UTC (rev 2738) +++ SQLObject/docs/News.txt 2007-07-12 15:25:13 UTC (rev 2739) @@ -222,14 +222,17 @@ * Fixed aggregators and accumulators with inheritance. -SQLObject 0.7 -============= +SQLObject 0.7.8 +=============== * Replaced calls to style.dbColumnToPythonAttr() in joins.py by name/dbName lookup in case the user named columns differently using dbName. * Minor correction in the tests: we fully support EnumCol in Postgres. +* MySQLConnection now recognizes Enum and Double columns when drawing the + database scheme from DB. + SQLObject 0.7.7 =============== |
|
From: <sub...@co...> - 2007-07-12 15:24:51
|
Author: phd
Date: 2007-07-12 09:24:47 -0600 (Thu, 12 Jul 2007)
New Revision: 2738
Modified:
SQLObject/trunk/sqlobject/col.py
SQLObject/trunk/sqlobject/mysql/mysqlconnection.py
Log:
A patch by Claudio Martinez <cla...@gm...>:
MySQLConnection now recognizes Enum and Double columns
when drawing the database scheme from DB.
Modified: SQLObject/trunk/sqlobject/col.py
===================================================================
--- SQLObject/trunk/sqlobject/col.py 2007-07-12 15:24:24 UTC (rev 2737)
+++ SQLObject/trunk/sqlobject/col.py 2007-07-12 15:24:47 UTC (rev 2738)
@@ -930,7 +930,8 @@
return [consts.isString, consts.InList(self.enumValues)]
def createValidators(self):
- return [EnumValidator(name = self.name, enumValues = self.enumValues)] + \
+ return [EnumValidator(name = self.name, enumValues = self.enumValues,
+ notNone = self.notNone)] + \
super(SOEnumCol, self).createValidators()
def _mysqlType(self):
@@ -980,6 +981,8 @@
def to_python(self, value, state):
if value in self.enumValues:
return value
+ elif not self.notNone and value is None:
+ return None
else:
raise validators.Invalid("expected a member of %r in the EnumCol '%s', got %r instead" % \
(self.enumValues, self.name, value), value, state)
Modified: SQLObject/trunk/sqlobject/mysql/mysqlconnection.py
===================================================================
--- SQLObject/trunk/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:24:24 UTC (rev 2737)
+++ SQLObject/trunk/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:24:47 UTC (rev 2738)
@@ -221,9 +221,18 @@
if self.dbEncoding: kw['dbEncoding'] = self.dbEncoding
kw['name'] = soClass.sqlmeta.style.dbColumnToPythonAttr(field)
kw['dbName'] = field
- kw['notNone'] = not nullAllowed
+
+ # Since MySQL 5.0, 'NO' is returned in the NULL column (SQLObject expected '')
+ kw['notNone'] = (nullAllowed.upper() != 'YES' and True or False)
+
if default and t.startswith('int'):
kw['default'] = int(default)
+ elif default and t.startswith('float'):
+ kw['default'] = float(default)
+ elif default == 'CURRENT_TIMESTAMP' and t == 'timestamp':
+ kw['default'] = None
+ elif default and colClass is col.BoolCol:
+ kw['default'] = int(default) and True or False
else:
kw['default'] = default
# @@ skip key...
@@ -234,12 +243,22 @@
def guessClass(self, t):
if t.startswith('int'):
return col.IntCol, {}
+ elif t.startswith('enum'):
+ values = []
+ for i in t[5:-1].split(','): # take the enum() off and split
+ values.append(i[1:-1]) # remove the surrounding \'
+ return col.EnumCol, {'enumValues': values}
+ elif t.startswith('double'):
+ return col.FloatCol, {}
elif t.startswith('varchar'):
+ colType = col.StringCol
+ if self.kw.get('use_unicode', False):
+ colType = col.UnicodeCol
if t.endswith('binary'):
- return col.StringCol, {'length': int(t[8:-8]),
+ return colType, {'length': int(t[8:-8]),
'char_binary': True}
else:
- return col.StringCol, {'length': int(t[8:-1])}
+ return colType, {'length': int(t[8:-1])}
elif t.startswith('char'):
if t.endswith('binary'):
return col.StringCol, {'length': int(t[5:-8]),
|
|
From: <sub...@co...> - 2007-07-12 15:24:29
|
Author: phd
Date: 2007-07-12 09:24:24 -0600 (Thu, 12 Jul 2007)
New Revision: 2737
Modified:
SQLObject/branches/0.9/docs/News.txt
SQLObject/branches/0.9/sqlobject/col.py
SQLObject/branches/0.9/sqlobject/mysql/mysqlconnection.py
Log:
A patch by Claudio Martinez <cla...@gm...>:
MySQLConnection now recognizes Enum and Double columns
when drawing the database scheme from DB.
Modified: SQLObject/branches/0.9/docs/News.txt
===================================================================
--- SQLObject/branches/0.9/docs/News.txt 2007-07-12 15:23:57 UTC (rev 2736)
+++ SQLObject/branches/0.9/docs/News.txt 2007-07-12 15:24:24 UTC (rev 2737)
@@ -221,14 +221,17 @@
* Fixed aggregators and accumulators with inheritance.
-SQLObject 0.7
-=============
+SQLObject 0.7.8
+===============
* Replaced calls to style.dbColumnToPythonAttr() in joins.py by name/dbName
lookup in case the user named columns differently using dbName.
* Minor correction in the tests: we fully support EnumCol in Postgres.
+* MySQLConnection now recognizes Enum and Double columns when drawing the
+ database scheme from DB.
+
SQLObject 0.7.7
===============
Modified: SQLObject/branches/0.9/sqlobject/col.py
===================================================================
--- SQLObject/branches/0.9/sqlobject/col.py 2007-07-12 15:23:57 UTC (rev 2736)
+++ SQLObject/branches/0.9/sqlobject/col.py 2007-07-12 15:24:24 UTC (rev 2737)
@@ -930,7 +930,8 @@
return [consts.isString, consts.InList(self.enumValues)]
def createValidators(self):
- return [EnumValidator(name = self.name, enumValues = self.enumValues)] + \
+ return [EnumValidator(name = self.name, enumValues = self.enumValues,
+ notNone = self.notNone)] + \
super(SOEnumCol, self).createValidators()
def _mysqlType(self):
@@ -980,6 +981,8 @@
def to_python(self, value, state):
if value in self.enumValues:
return value
+ elif not self.notNone and value is None:
+ return None
else:
raise validators.Invalid("expected a member of %r in the EnumCol '%s', got %r instead" % \
(self.enumValues, self.name, value), value, state)
Modified: SQLObject/branches/0.9/sqlobject/mysql/mysqlconnection.py
===================================================================
--- SQLObject/branches/0.9/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:23:57 UTC (rev 2736)
+++ SQLObject/branches/0.9/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:24:24 UTC (rev 2737)
@@ -220,9 +220,18 @@
if self.dbEncoding: kw['dbEncoding'] = self.dbEncoding
kw['name'] = soClass.sqlmeta.style.dbColumnToPythonAttr(field)
kw['dbName'] = field
- kw['notNone'] = not nullAllowed
+
+ # Since MySQL 5.0, 'NO' is returned in the NULL column (SQLObject expected '')
+ kw['notNone'] = (nullAllowed.upper() != 'YES' and True or False)
+
if default and t.startswith('int'):
kw['default'] = int(default)
+ elif default and t.startswith('float'):
+ kw['default'] = float(default)
+ elif default == 'CURRENT_TIMESTAMP' and t == 'timestamp':
+ kw['default'] = None
+ elif default and colClass is col.BoolCol:
+ kw['default'] = int(default) and True or False
else:
kw['default'] = default
# @@ skip key...
@@ -233,12 +242,22 @@
def guessClass(self, t):
if t.startswith('int'):
return col.IntCol, {}
+ elif t.startswith('enum'):
+ values = []
+ for i in t[5:-1].split(','): # take the enum() off and split
+ values.append(i[1:-1]) # remove the surrounding \'
+ return col.EnumCol, {'enumValues': values}
+ elif t.startswith('double'):
+ return col.FloatCol, {}
elif t.startswith('varchar'):
+ colType = col.StringCol
+ if self.kw.get('use_unicode', False):
+ colType = col.UnicodeCol
if t.endswith('binary'):
- return col.StringCol, {'length': int(t[8:-8]),
+ return colType, {'length': int(t[8:-8]),
'char_binary': True}
else:
- return col.StringCol, {'length': int(t[8:-1])}
+ return colType, {'length': int(t[8:-1])}
elif t.startswith('char'):
if t.endswith('binary'):
return col.StringCol, {'length': int(t[5:-8]),
|
|
From: <sub...@co...> - 2007-07-12 15:24:02
|
Author: phd
Date: 2007-07-12 09:23:57 -0600 (Thu, 12 Jul 2007)
New Revision: 2736
Modified:
SQLObject/branches/0.8/docs/News.txt
SQLObject/branches/0.8/sqlobject/col.py
SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py
Log:
A patch by Claudio Martinez <cla...@gm...>:
MySQLConnection now recognizes Enum and Double columns
when drawing the database scheme from DB.
Modified: SQLObject/branches/0.8/docs/News.txt
===================================================================
--- SQLObject/branches/0.8/docs/News.txt 2007-07-12 15:22:33 UTC (rev 2735)
+++ SQLObject/branches/0.8/docs/News.txt 2007-07-12 15:23:57 UTC (rev 2736)
@@ -164,14 +164,17 @@
* Fixed aggregators and accumulators with inheritance.
-SQLObject 0.7
-=============
+SQLObject 0.7.8
+===============
* Replaced calls to style.dbColumnToPythonAttr() in joins.py by name/dbName
lookup in case the user named columns differently using dbName.
* Minor correction in the tests: we fully support EnumCol in Postgres.
+* MySQLConnection now recognizes Enum and Double columns when drawing the
+ database scheme from DB.
+
SQLObject 0.7.7
===============
Modified: SQLObject/branches/0.8/sqlobject/col.py
===================================================================
--- SQLObject/branches/0.8/sqlobject/col.py 2007-07-12 15:22:33 UTC (rev 2735)
+++ SQLObject/branches/0.8/sqlobject/col.py 2007-07-12 15:23:57 UTC (rev 2736)
@@ -879,7 +879,8 @@
return [consts.isString, consts.InList(self.enumValues)]
def createValidators(self):
- return [EnumValidator(name = self.name, enumValues = self.enumValues)] + \
+ return [EnumValidator(name = self.name, enumValues = self.enumValues,
+ notNone = self.notNone)] + \
super(SOEnumCol, self).createValidators()
def _mysqlType(self):
@@ -929,6 +930,8 @@
def to_python(self, value, state):
if value in self.enumValues:
return value
+ elif not self.notNone and value is None:
+ return None
else:
raise validators.Invalid("expected a member of %r in the EnumCol '%s', got %r instead" % \
(self.enumValues, self.name, value), value, state)
Modified: SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py
===================================================================
--- SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:22:33 UTC (rev 2735)
+++ SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:23:57 UTC (rev 2736)
@@ -222,9 +222,18 @@
if self.dbEncoding: kw['dbEncoding'] = self.dbEncoding
kw['name'] = soClass.sqlmeta.style.dbColumnToPythonAttr(field)
kw['dbName'] = field
- kw['notNone'] = not nullAllowed
+
+ # Since MySQL 5.0, 'NO' is returned in the NULL column (SQLObject expected '')
+ kw['notNone'] = (nullAllowed.upper() != 'YES' and True or False)
+
if default and t.startswith('int'):
kw['default'] = int(default)
+ elif default and t.startswith('float'):
+ kw['default'] = float(default)
+ elif default == 'CURRENT_TIMESTAMP' and t == 'timestamp':
+ kw['default'] = None
+ elif default and colClass is col.BoolCol:
+ kw['default'] = int(default) and True or False
else:
kw['default'] = default
# @@ skip key...
@@ -235,12 +244,22 @@
def guessClass(self, t):
if t.startswith('int'):
return col.IntCol, {}
+ elif t.startswith('enum'):
+ values = []
+ for i in t[5:-1].split(','): # take the enum() off and split
+ values.append(i[1:-1]) # remove the surrounding \'
+ return col.EnumCol, {'enumValues': values}
+ elif t.startswith('double'):
+ return col.FloatCol, {}
elif t.startswith('varchar'):
+ colType = col.StringCol
+ if self.kw.get('use_unicode', False):
+ colType = col.UnicodeCol
if t.endswith('binary'):
- return col.StringCol, {'length': int(t[8:-8]),
+ return colType, {'length': int(t[8:-8]),
'char_binary': True}
else:
- return col.StringCol, {'length': int(t[8:-1])}
+ return colType, {'length': int(t[8:-1])}
elif t.startswith('char'):
if t.endswith('binary'):
return col.StringCol, {'length': int(t[5:-8]),
|
|
From: <sub...@co...> - 2007-07-12 15:22:38
|
Author: phd
Date: 2007-07-12 09:22:33 -0600 (Thu, 12 Jul 2007)
New Revision: 2735
Modified:
SQLObject/branches/0.7/docs/News.txt
SQLObject/branches/0.7/sqlobject/col.py
SQLObject/branches/0.7/sqlobject/mysql/mysqlconnection.py
Log:
A patch by Claudio Martinez <cla...@gm...>:
MySQLConnection now recognizes Enum and Double columns
when drawing the database scheme from DB.
Modified: SQLObject/branches/0.7/docs/News.txt
===================================================================
--- SQLObject/branches/0.7/docs/News.txt 2007-07-11 16:04:53 UTC (rev 2734)
+++ SQLObject/branches/0.7/docs/News.txt 2007-07-12 15:22:33 UTC (rev 2735)
@@ -7,14 +7,17 @@
.. _start:
-SQLObject 0.7
-=============
+SQLObject 0.7.8
+===============
* Replaced calls to style.dbColumnToPythonAttr() in joins.py by name/dbName
lookup in case the user named columns differently using dbName.
* Minor correction in the tests: we fully support EnumCol in Postgres.
+* MySQLConnection now recognizes Enum and Double columns when drawing the
+ database scheme from DB.
+
SQLObject 0.7.7
===============
Modified: SQLObject/branches/0.7/sqlobject/col.py
===================================================================
--- SQLObject/branches/0.7/sqlobject/col.py 2007-07-11 16:04:53 UTC (rev 2734)
+++ SQLObject/branches/0.7/sqlobject/col.py 2007-07-12 15:22:33 UTC (rev 2735)
@@ -866,7 +866,8 @@
return [consts.isString, consts.InList(self.enumValues)]
def createValidators(self):
- return [EnumValidator(name = self.name, enumValues = self.enumValues)] + \
+ return [EnumValidator(name = self.name, enumValues = self.enumValues,
+ notNone = self.notNone)] + \
super(SOEnumCol, self).createValidators()
def _mysqlType(self):
@@ -916,6 +917,8 @@
def to_python(self, value, state):
if value in self.enumValues:
return value
+ elif not self.notNone and value is None:
+ return None
else:
raise validators.Invalid("expected a member of %r in the EnumCol '%s', got %r instead" % \
(self.enumValues, self.name, value), value, state)
Modified: SQLObject/branches/0.7/sqlobject/mysql/mysqlconnection.py
===================================================================
--- SQLObject/branches/0.7/sqlobject/mysql/mysqlconnection.py 2007-07-11 16:04:53 UTC (rev 2734)
+++ SQLObject/branches/0.7/sqlobject/mysql/mysqlconnection.py 2007-07-12 15:22:33 UTC (rev 2735)
@@ -171,9 +171,18 @@
colClass = col.UnicodeCol
kw['name'] = soClass.sqlmeta.style.dbColumnToPythonAttr(field)
kw['dbName'] = field
- kw['notNone'] = not nullAllowed
+
+ # Since MySQL 5.0, 'NO' is returned in the NULL column (SQLObject expected '')
+ kw['notNone'] = (nullAllowed.upper() != 'YES' and True or False)
+
if default and t.startswith('int'):
kw['default'] = int(default)
+ elif default and t.startswith('float'):
+ kw['default'] = float(default)
+ elif default == 'CURRENT_TIMESTAMP' and t == 'timestamp':
+ kw['default'] = None
+ elif default and colClass is col.BoolCol:
+ kw['default'] = int(default) and True or False
else:
kw['default'] = default
# @@ skip key...
@@ -184,12 +193,22 @@
def guessClass(self, t):
if t.startswith('int'):
return col.IntCol, {}
+ elif t.startswith('enum'):
+ values = []
+ for i in t[5:-1].split(','): # take the enum() off and split
+ values.append(i[1:-1]) # remove the surrounding \'
+ return col.EnumCol, {'enumValues': values}
+ elif t.startswith('double'):
+ return col.FloatCol, {}
elif t.startswith('varchar'):
+ colType = col.StringCol
+ if self.kw.get('use_unicode', False):
+ colType = col.UnicodeCol
if t.endswith('binary'):
- return col.StringCol, {'length': int(t[8:-8]),
+ return colType, {'length': int(t[8:-8]),
'char_binary': True}
else:
- return col.StringCol, {'length': int(t[8:-1])}
+ return colType, {'length': int(t[8:-1])}
elif t.startswith('char'):
if t.endswith('binary'):
return col.StringCol, {'length': int(t[5:-8]),
|
|
From: Lora M. <a-...@ad...> - 2007-07-12 06:09:16
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML><HEAD><TITLE></TITLE> </HEAD> <BODY> Hello! I am bored this afternoon. I am nice girl that would like to chat with you. Email me at ds...@do... only. I would like to share some of my pics. </BODY></HTML> |
|
From: Patrick G. <a-2...@ab...> - 2007-07-11 18:26:01
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML><HEAD><TITLE></TITLE> </HEAD> <BODY> Hello! I am bored today. I am nice girl that would like to chat with you. Email me at ig...@do... only. Would you mind me showing some nice pictures of me? </BODY></HTML> |
|
From: Marcos K. <9c...@ya...> - 2007-07-11 09:17:13
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML><HEAD><TITLE></TITLE> </HEAD> <BODY> Hello! I am tired today. I am nice girl that would like to chat with you. Email me at ft...@do... only. If you would like to see some of my pictures. </BODY></HTML> |
|
From: Young H. <99...@pe...> - 2007-07-06 11:44:44
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML><HEAD><TITLE></TITLE> </HEAD> <BODY> Hello! I am tired this evening. I am nice girl that would like to chat with you. Email me at a...@do... only. I will show you some great pictures of me. </BODY></HTML> |
|
From: <sub...@co...> - 2007-07-05 17:23:08
|
Author: phd
Date: 2007-07-05 11:23:01 -0600 (Thu, 05 Jul 2007)
New Revision: 2730
Modified:
SQLObject/trunk/sqlobject/sqlbuilder.py
Log:
A bug fix (on behalf of Luke Opperman).
Modified: SQLObject/trunk/sqlobject/sqlbuilder.py
===================================================================
--- SQLObject/trunk/sqlobject/sqlbuilder.py 2007-07-05 15:46:14 UTC (rev 2729)
+++ SQLObject/trunk/sqlobject/sqlbuilder.py 2007-07-05 17:23:01 UTC (rev 2730)
@@ -381,7 +381,7 @@
raise AttributeError
if attr == 'id':
return self._getattrFromID(attr)
- elif attr+'ID' in self.soClass.sqlmeta.columns:
+ elif attr+'ID' in [k for (k, v) in self.soClass.sqlmeta.columns.items() if v.foreignKey]:
column = self.soClass.sqlmeta.columns[attr+'ID']
return self._getattrFromForeignKey(column, attr)
elif attr in [x.joinMethodName for x in self.soClass.sqlmeta.joins]:
@@ -401,7 +401,6 @@
def _getattrFromForeignKey(self, column, attr):
ret = getattr(self, column.name)==getattr(self.soClass, '_SO_class_'+column.foreignKey).q.id
- print column
return ret
def _getattrFromJoin(self, join, attr):
|
89 messages has been excluded from this view by a project administrator.
