The first patch in PostgreSQLObjectStore.py fixes a problem I was having where object references were returning a tuple as value, and they were not being added correctly. I took some code from elsewhere which handled this case and put it here.
The second patch to PostgreSQLSQLGenerator.py adds datetime support, by mapping it to the PostgreSQL timestamptz type.
The third patch to SQLGenerator.py puts "/c" instead of "uses" in the insertSamples.sql script.
-ww ---------------
% cvs diff Run/PostgreSQLObjectStore.py Design/PostgreSQLSQLGenerator.py Design/SQLGenerator.py
Index: Run/PostgreSQLObjectStore.py
===================================================================
RCS file: /cvsroot/webware/Webware/MiddleKit/Run/PostgreSQLObjectStore.py,v
retrieving revision 1.4
diff -r1.4 PostgreSQLObjectStore.py
124a125
> extend = values.extend
133c134,137
< append(value)
---
> if isinstance(value, str):
> append(value)
> else:
> extend(value) # value could be sequence for attrs that require multiple SQL columns
Index: Design/PostgreSQLSQLGenerator.py
===================================================================
RCS file: /cvsroot/webware/Webware/MiddleKit/Design/PostgreSQLSQLGenerator.py,v
retrieving revision 1.3
diff -r1.3 PostgreSQLSQLGenerator.py
139a140,145
> class DateTimeAttr:
>
> def sqlType(self):
> return 'timestamptz'
>
>
Index: Design/SQLGenerator.py
===================================================================
RCS file: /cvsroot/webware/Webware/MiddleKit/Design/SQLGenerator.py,v
retrieving revision 1.59
diff -r1.59 SQLGenerator.py
97c97,99
< file.write('use %s;\n\n' % self.sqlDatabaseName())
---
> # ww - for PostgreSQL
> file.write('\\c %s;\n\n' % self.sqlDatabaseName())
> # file.write('use %s;\n\n' % self.sqlDatabaseName())
------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click _______________________________________________ Webware-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-devel
