ports/76952: [MAINTAINER] databases/py-sqlobject: [PATCH] fix DateTime bug

[Choe, Cheng-Dae]

>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 at 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: