summaryrefslogtreecommitdiffstats
path: root/For Weekly Test/30-07-2011/test6.py
blob: fa1779875fb47af668e825e453a7433abf2b1102 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
import sys
import pjsua as pj
import os
import re
import time
import MySQLdb
import subprocess
from time import sleep
from datetime import datetime


try:
    	mydb = MySQLdb.connect('localhost', 'root', 'randompasswordSQL','gsmselftesting');  	
	db=mydb.cursor()
except MySQLdb.Error, e:
	print "Error %d: %s" % (e.args[0],e.args[1])
	sys.exit(1)

db.execute("SELECT * FROM TempTaskTable")
rows = db.fetchall()

global tasksList		
tasksList = list()
print rows
for row in rows:
	columns = list()
	print row
	for rowe in rows:
		columns.append(str(row))
	print tasksList.append(columns)
	#print taskList
#	print "%s, %s" % (row[0], row[1])
#	print "Number of rows returned: %d" % db.rowcount