Trees | Indices | Help |
---|
|
1 _dbutils = {} 26 10 11 # Disabled: better safe than sorry 12 ## def next_id(self, cursor, table): 13 ## # XXX brain-dead! Hopefully, the database will enforce PK unicity.. 14 ## table = self.tname(table) 15 ## sql = r"select 1+max(%s_id) from %s" % (table, table) 16 ## cursor.execute(sql) 17 ## rv = cursor.fetchone() 18 ## return rv[0] 1931 35 _dbutils["MySQLdb"] = Mysql_dbutils 3621 # XXX: Unsafe without transactions isolation 22 table = self.tname(table) 23 sql = r"select max(%s_id) from %s" % table 24 cursor.execute(sql) 25 rv = cursor.fetchone() 26 return rv[0]2754 _dbutils["psycopg"] = Psycopg_dbutils 5539 table = self.tname(table) 40 sql = r"select nextval('%s_pk_seq')" % table 41 cursor.execute(sql) 42 rv = cursor.fetchone() 43 return rv[0]4446 table = self.tname(table) 47 sql = r"select currval('%s_pk_seq')" % table 48 cursor.execute(sql) 49 rv = cursor.fetchone() 50 return rv[0]5153 conn.autocommit(y)57 """Add support for pgdb in the PyGreSQL database connectivity package. 58 """75 76 _dbutils["pgdb"] = Pgdb_dbutils 77 8360 table = self.tname(table) 61 sql = r"select nextval('%s_pk_seq')" % table 62 cursor.execute(sql) 63 rv = cursor.fetchone() 64 return rv[0]6567 table = self.tname(table) 68 sql = r"select currval('%s_pk_seq')" % table 69 cursor.execute(sql) 70 rv = cursor.fetchone() 71 return rv[0]72
Trees | Indices | Help |
---|
Generated by Epydoc 3.0.1 on Thu Feb 7 11:51:46 2008 | http://epydoc.sourceforge.net |