Re: [Webware-devel] Test cases for PostgreSQL middle kit

[Winston WOLFF]

I have some patches to the Postgres files to fix a few of the test 
cases.  It fixes the MKDateTime.mkmodel and MKList.mkmodel tests.  
Although the middle file is not a proper fix because it will break 
MySQL and MSSQL.  It changes USES to \c which obviously is Postgres 
specific.

-ww
---------
% cvs diff Run/PostgreSQLObjectStore.py Design/SQLGenerator.py 
Design/PostgreSQLSQLGenerator.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/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())
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'
>
>


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