import csv,sys,copy,random
import MySQLdb

sqlserver=''
sqluser=''
sqlpass=''
sqldb=''

conn = MySQLdb.connect(sqlserver,sqluser,sqlpass,sqldb);
cursor = conn.cursor();

idanddate = []
cursor.execute("select qid,tstamp from botquestions")
rec = cursor.fetchone()
while rec:
    idanddate.append([rec[0],rec[1],copy.deepcopy(rec[1])])
    rec = cursor.fetchone()

for j in range(10):
    for i in range(len(idanddate)):
        tmp = idanddate[i][1];
        swap = random.randint(0,len(idanddate)-1-i)+i;
        idanddate[i][1] = idanddate[swap][1];
        idanddate[swap][1] = tmp;

for qid,tstamp0,tstamp1 in idanddate:
    print "qid %s, tstamp %s::%s" % (qid,tstamp0,tstamp1)
    cursor.execute("update botquestions set tstamp = '%s' where qid = '%s'" % (tstamp0,qid))