cannot load index value from mysql database

tedpottel at gmail.com tedpottel at gmail.com
Wed Jun 25 21:12:14 CEST 2008


Hi

I am trying to right a script to keep a local copy of my mysql
database in a local access file. I was able to do this in Access
visual basic, but cannot get it to work in python.

The procedure works by storing the last index value after each
update.  Then I do a quarry for all records with a index value bigger
the the last one stored.

In python when I try to get the index value, ID it gives me a
keyword.  I know the firled exist because I am doing the following
querry


Here is the code,
Help!!!!!!

engine = win32com.client.Dispatch("DAO.DBEngine.36")
        self.db=engine.OpenDatabase(r"w:\consulting\custom-web-stats-
project\web-stat.mdb")
        access = self.db.OpenRecordset("select * from local_web_stat
where 1")
        temp = self.db.OpenRecordset("select * from lastid where 1")
        self.lastid=temp.Fields("lastid").Value

        #open mysql
        conn = MySQLdb.connect ("……….")
        cursor = conn.cursor (MySQLdb.cursors.DictCursor)
        cursor.execute ("SELECT * FROM web_stat where
ID>"+str(self.lastid))
        result_set = cursor.fetchall ()

        for row in result_set:
            last=row["ID"]b    (this does not work why???????)
            access.Edit()

            access.Fields("customer").value= row["customer"]
            t=row["time"]
            print t

            access.Fields("Time").value=t
            access.Fields("phrase").value= row["phrase"]
            access.Fields("key_word_phrase").value =
row["key_word_phrase"]
            access.Fields("from_server").value = row["from_server"]
            access.Fields("path_name").value = row["path_name"]
            id = row["PageID"]
            print id
            g=str(id)
            k=int(g)
            access.Fields("PageID").value=k
            access.Fields("server_name").value = row["server_name"]
            access.Fields("file_name").value = row["file_name"]

            access.Update()
        temp.Edit()
        temp.Fields("lastid").Value=k
        temp.Update()



More information about the Python-list mailing list