On Thursday 23 August 2007 15:02, Uwe Grauer wrote:
> johnf wrote:
> > On Thursday 23 August 2007 14:39, Ed Leafe wrote:
> >> On Aug 23, 2007, at 5:02 PM, johnf wrote:
> >>> I have a parent and several child waiting to be saved.
> >>> isTransactionManager = True
> >>>
> >>> parent is inserted into the DB
> >>>
> >>> then getLastInsertID() is called because the children need the PKID
> >>> of the
> >>> parent
> >>>
> >>> But no commit has occurred.
> >>>
> >>> getLastInsertID() fails because of no commit.
> >>>
> >>> I don't think this can work? Anybody have a suggestion on how I
> >>> might fix
> >>> this?
> >>
> >> Is there any other way to query the value without committing?
> >
> > Yes nextval() will return the next value of the sequence.
> >
> >> If
> >> not, you should probably use sequence instead, and pre-fetch it using
> >> the dbPostgreSQL.pregenPK() method (which doesn't exist yet).
> >
> > Writing the code for pregenPK() would not be that big of a deal. Assume
> > that the code is available. How does Dabo use the method?
> >
> >> -- Ed Leafe
> >> -- http://leafe.com
> >> -- http://dabodev.com
> >
> > However, it would be a very big deal to change the code for our current
> > forms. Any form that uses children (and I have one that uses
> > grandchildren) depends on the self.FillLinkFromParent = True. Please
> > explain how the current Dabo is suppose to deal with the Saveall().
>
> Dabos dbFirebird module does use pregenPK in a way that works as expected.
> I did a quick search on what the default way in postgresql is and found
> out that there is a currval() method which gets the last inserted
> sequence id for the given connection.
>
> >From the postgresql faq:
>
> 4.11.3) Doesn't currval() lead to a race condition with other users?
>
> No. currval() returns the current value assigned by your session, not by
> all sessions.
I am using currval() in dbPostgres.py. Maybe I doing something wrong - take a
look:
tableNameBreak=cursor.Table.split('.',1)
localSchemaName = tableNameBreak[0]
localTableName = tableNameBreak[1]
tempCursor = self._cursor.AuxCursor
sqltablestr = """SELECT seq.relname::text
FROM pg_class src, pg_class seq, pg_namespace, pg_attribute,
pg_depend
WHERE
pg_depend.refobjsubid = pg_attribute.attnum AND
pg_depend.refobjid = src.oid AND
seq.oid = pg_depend.objid AND
src.relnamespace = pg_namespace.oid AND
pg_attribute.attrelid = src.oid AND
pg_namespace.nspname = '%s' AND
src.relname = '%s' AND
pg_attribute.attname = '%s'""" %
(localSchemaName,localTableName,cursor.KeyField)
tempCursor.execute(sqltablestr)
rs = tempCursor.fetchall()
sqlWithseq_name="""select currval('%s') as curval""" % (rs[0][0],)
tempCursor.execute(sqlWithseq_name)
rs = tempCursor.fetchall()
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/dabo-dev/[EMAIL PROTECTED]
