Date: Tue, 1 Feb 2005 11:29:50 GMT From: "Choe, Cheng-Dae" <whitekid@gmail.com> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/76952: [MAINTAINER] databases/py-sqlobject: [PATCH] fix DateTime bug Message-ID: <200502011129.j11BToma010867@www.freebsd.org> Resent-Message-ID: <200502011130.j11BUODm055630@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 76952
>Category: ports
>Synopsis: [MAINTAINER] databases/py-sqlobject: [PATCH] fix DateTime bug
>Confidential: no
>Severity: non-critical
>Priority: low
>Responsible: freebsd-ports-bugs
>State: open
>Quarter:
>Keywords:
>Date-Required:
>Class: sw-bug
>Submitter-Id: current-users
>Arrival-Date: Tue Feb 01 11:30:23 GMT 2005
>Closed-Date:
>Last-Modified:
>Originator: "Choe, Cheng-Dae"
>Release: FreeBSD 5.3-STABLE i386
>Organization:
>Environment:
System: FreeBSD comdongin.com 5.3-STABLE FreeBSD 5.3-STABLE #0: Wed Jan 26 05:08:35 KST 2005
>Description:
- sqlobject v0.6.1 has bug in usage DateTime column. Ths pr fix this problem. This patch was applied in repository but It's wonder when bugfix will be released. I write this pr because it's a serious problem using sqlobject.
- see http://sourceforge.net/mailarchive/message.php?msg_id=10704546
>How-To-Repeat:
- install databases/py-sqloject
- try code below
import psycopg
from sqlobject import *
conn = connectionForURI('postgres://%s@/%s' % ('whitekid', 'whitekid') )
class Test(SQLObject):
_connection = conn
timestamp = DateTimeCol( default=sqlbuilder.func.NOW() )
try: Test.createTable()
except psycopg.ProgrammingError, e: pass
Test()
>Fix:
diff -ruN py-sqlobject.orig/Makefile py-sqlobject/Makefile
--- py-sqlobject.orig/Makefile Sat Jan 29 08:50:47 2005
+++ py-sqlobject/Makefile Tue Feb 1 19:46:38 2005
@@ -7,11 +7,15 @@
PORTNAME= sqlobject
PORTVERSION= 0.6.1
+PORTREVISION= 1
CATEGORIES= databases python
MASTER_SITES= ${MASTER_SITE_SOURCEFORGE}
MASTER_SITE_SUBDIR= ${PORTNAME}
PKGNAMEPREFIX= ${PYTHON_PKGNAMEPREFIX}
DISTNAME= SQLObject-${PORTVERSION}
+
+PATCH_SITES= http://www.comdongin.com/
+PATCHFILES= sqlobject-0.6.1.patch
MAINTAINER= whitekid@gmail.com
COMMENT= A python object for manipulation with SQL table row
diff -ruN py-sqlobject.orig/distinfo py-sqlobject/distinfo
--- py-sqlobject.orig/distinfo Sat Jan 29 08:50:47 2005
+++ py-sqlobject/distinfo Tue Feb 1 19:51:29 2005
@@ -1,2 +1,4 @@
MD5 (SQLObject-0.6.1.tar.gz) = 0dbb6ea429aa40eee734751ad48fbfbb
SIZE (SQLObject-0.6.1.tar.gz) = 147871
+MD5 (sqlobject-0.6.1.patch) = 9be5cf6a70fd8acd4ea7eab17f4bf06b
+SIZE (sqlobject-0.6.1.patch) = 1829
>Release-Note:
>Audit-Trail:
>Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200502011129.j11BToma010867>