Changeset 1721

Show
Ignore:
Timestamp:
12/20/06 17:15:32 (2 years ago)
Author:
codeFiend
Message:

MantisImportScript:

changed the 'get ticket id' to use database-independent function call

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • mantisimportscript/mantis2trac.py

    r1720 r1721  
    405405        self.db().commit() 
    406406         
    407 ##        SELECT last_insert_rowid() 
    408         c.execute('''SELECT LAST_INSERT_ID()''') 
    409         return c.fetchall()[0][0] 
    410         #return self.db().db.sqlite_last_insert_rowid() 
     407        ## TODO: add database-specific methods to get the last inserted ticket's id... 
     408        ## PostgreSQL: 
     409        # c.execute('''SELECT currval("ticket_id_seq")''') 
     410        ## SQLite: 
     411        # c.execute('''SELECT last_insert_rowid()''') 
     412        ## MySQL: 
     413        # c.execute('''SELECT LAST_INSERT_ID()''') 
     414        # Oh, Trac db abstraction layer already has a function for this... 
     415        return self.db().get_last_id(c,'ticket') 
    411416     
    412417    def addTicketComment(self, ticket, time, author, value): 
    …… 
    509514 
    510515    # init Trac environment 
    511     print "Trac SQLite('%s'): connecting..." % (_env) 
     516    print "Trac database('%s'): connecting..." % (_env) 
    512517    trac = TracDatabase(_env) 
    513518