[Webware-devel] Re: MiddleKit PostgreSQL support

[Winston WOLFF]

I'm trying to get Jason's postgres support working, and I run into a  
little problem.  It seems the sqlIdname() method doesn't appear in  
MiddleKit.Core.Klass.  See the code and stack trace below.  I had  
noticed a similar sqlIdName() method in the Postgres support from  
before Jason checked in his new files.  Could it be that one file was  
not checked in?

-winston
--- Here is the code I was running:
from mx.DateTime import DateFrom
from MiddleKit.Run.PostgreSQLObjectStore import PostgreSQLObjectStore
from db.User import User
if __name__=='__main__':
        # Set up the store
        store = PostgreSQLObjectStore()
        store.readModelFileNamed('lib/db/mentor')
        
        u = User()
        u.setNameLast('wolff')
        u.setNameFirst('winston')
        
        store.addObject( u )
        store.saveChanges()
--- Here is the stack trace:
SQL 0001. 2004-08-29 14:14:19 select id, name from _MKClassIds;
Traceback (most recent call last):
  File "bee.py", line 26, in ?
    store.saveChanges()
  File  
"/Users/winstonw/svn/Projects/python/extern/WebWare-CVS/webware/ 
MiddleKit/Run/PostgreSQLObjectStore.py", line 78, in saveChanges
    SQLObjectStore.saveChanges(self)
  File "MiddleKit/Run/ObjectStore.py", line 310, in saveChanges
  File  
"/Users/winstonw/svn/Projects/python/extern/WebWare-CVS/webware/ 
MiddleKit/Run/SQLObjectStore.py", line 213, in commitInserts
    self._insertObject(object, unknownSerialNums)
  File  
"/Users/winstonw/svn/Projects/python/extern/WebWare-CVS/webware/ 
MiddleKit/Run/PostgreSQLObjectStore.py", line 49, in _insertObject
    seqname = "%s_%s_seq" % (object.klass().name(),  
object.klass().sqlIdName())
AttributeError: Klass instance has no attribute 'sqlIdName'

On 29-Aug-2004, at 8:36 AM, Winston WOLFF wrote:
Jason and Diogo-
I want to thank you also for this PostgreSQL support.  I just happen  
to be starting to play with middle kit, the timing of this thread is  
uncanny.  Perhaps I'll work on datetime support since I will probably  
need it.

-winston
From: Jason Hildebrand <[EMAIL PROTECTED]>
<msg.gif> Re: MiddleKit PostgreSQL support  
2004-08-26 18:31
 Hi Diogo,
 Thanks for asking.  Last year I did some work with PostgreSQL and
 MiddleKit, and had lots of local changes which I"ve been meaning to  
commit.
 Specifically, I made it so that for each table, a corresponding  
postgres
 sequence is created, which is used for getting the next serial number
 when an object is added to the data store.  There were a bunch of  
other
 changes, too, but that was the most significant.

 There are several different python bindings for PostgreSQL, but  
AFAICT
 there are only two which are maintained: the bindings included with
 PostgreSQL itself, and psycopg.  I can"t remember exactly why, but  
at that
 time I had some problems with PostgreSQL"s bindings, and so I used  
pscyopg.

 I"ve just checked in these changes, so please do a fresh CVS  
checkout (it
 may take a few hours to become available on sourceforge"s anon CVS,  
I"m not
 sure) and take a look.  Since I haven"t really used it since last  
year,
 there might be a few things which aren"t working any more (due to  
other
 changes in MK), and I think there are a few MK datatypes which still  
need to
 be implemented for PostgreSQL (i.e. datetime?).

 If you improve the support further, please submit patches via  
sourceforge,
 and maybe send me a heads-up, too, so that I notice. :)

 peace,
 Jason
 On Tue, 2004-08-24 at 09:06, Diogo Biazus wrote:
 > Hi People,
 > I"ve read some mails about recent patches to make middlekit work  
with
 > pgsql. How can I install and use these patches?
 > Can I help in any way to test or develop it?
 > I"m really in need of the PostgreSQL support, and I"m willing to  
help
 > build it.

 > Thanks in advance,
 --
 Jason D. Hildebrand
 T: 204 775 1212
 E: [EMAIL PROTECTED]



-------------------------------------------------------
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_idP47&alloc_id808&op=click
_______________________________________________
Webware-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/webware-devel