Login | Register
My pages Projects Community openCollabNet

Discussions > commits > svn commit: r279 - trunk/current/db: . mysql

Project highlights: Stable Version: 1.6.1, Development Version: 1.7.6

current
Discussion topic

Back to topic list

svn commit: r279 - trunk/current/db: . mysql

Reply

Author jjneely
Full name Jack Neely
Date 2006-09-08 20:21:55 PDT
Message Author: jjneely
Date: 2006-09-08 20:21:55-0700
New Revision: 279

Modified:
   trunk/current/db/mys​ql/schema.py
   trunk/current/db/profile.py

Log:
Make sure that "release" is always quoted as mysql believes it to be a
reserved word. Store the floats that time.time() gives us as doubles in
mysql otherwise sessions don't work very well.


Modified: trunk/current/db/mys​ql/schema.py
Url: http://current.tigri​s.org/source/browse/​current/trunk/curren​t/db/mysql/schema.py​?view=diff&rev=2​79&p1=trunk/curr​ent/db/mysql/schema.​py&p2=trunk/curr​ent/db/mysql/schema.​py&r1=278&r2​=279
====================​====================​====================​==================
--- trunk/current/db/mys​ql/schema.py (original)
+++ trunk/current/db/mys​ql/schema.py 2006-09-08 20:21:55-0700
@@ -92,8 +92,8 @@
 create table SESSIONS (
    session_id INTEGER PRIMARY KEY auto_increment,
    sid varchar(40) unique not null,
- createtime float not null,
- timeout float not null,
+ createtime double not null,
+ timeout double not null,
    data text,
 
    index(sid)

Modified: trunk/current/db/profile.py
Url: http://current.tigri​s.org/source/browse/​current/trunk/curren​t/db/profile.py?view​=diff&rev=279​&p1=trunk/current/d​b/profile.py&p2=​trunk/current/db/pro​file.py&r1=278​&r2=279
====================​====================​====================​==================
--- trunk/current/db/profile.py (original)
+++ trunk/current/db/profile.py 2006-09-08 20:21:55-0700
@@ -220,7 +220,7 @@
                                         epoch, issource)
         if not package_id:
             self.cursor.execute('''insert into PACKAGE
- (name, version, release, epoch, issource)
+ (name, version, `release`, epoch, issource)
                         values (%s, %s, %s, %s, %s)''',
                         (name, version, release, epoch, issource))
             # PM2006, we really should be using last_insert_id

« Previous message in topic | 1 of 1 | Next message in topic »

Messages

Show all messages in topic

svn commit: r279 - trunk/current/db: . mysql jjneely Jack Neely 2006-09-08 20:21:55 PDT
Messages per page: