summaryrefslogtreecommitdiffstats
path: root/For Weekly Test/DBProblem
diff options
context:
space:
mode:
Diffstat (limited to 'For Weekly Test/DBProblem')
-rw-r--r--For Weekly Test/DBProblem/DbClass.pycbin0 -> 7074 bytes
-rw-r--r--For Weekly Test/DBProblem/inserte.py24
-rw-r--r--For Weekly Test/DBProblem/test3.py4
3 files changed, 26 insertions, 2 deletions
diff --git a/For Weekly Test/DBProblem/DbClass.pyc b/For Weekly Test/DBProblem/DbClass.pyc
new file mode 100644
index 0000000..a10d822
--- /dev/null
+++ b/For Weekly Test/DBProblem/DbClass.pyc
Binary files differ
diff --git a/For Weekly Test/DBProblem/inserte.py b/For Weekly Test/DBProblem/inserte.py
new file mode 100644
index 0000000..c37673f
--- /dev/null
+++ b/For Weekly Test/DBProblem/inserte.py
@@ -0,0 +1,24 @@
+import sys
+#import ClientClass
+import DbClass
+#import ControllerClass
+#import classCheck
+from time import sleep
+
+
+db = DbClass.DBMySQLConnection('root', 'randompasswordSQL', 'localhost', 'gsmselftesting')
+db.connectDB()
+dbStatus = db.connectDB()
+print 'i am inserting into the table something', db.insertTaskIn2('sip','unisip',2)
+print 'i am inserting into the table something', db.insertTaskIn2('unisip','sip',2)
+print 'i am inserting into the table something', db.insertTaskIn2('sip','landline',2)
+print 'i am inserting into the table something', db.insertTaskIn2('sip','gsmeO',2)
+print 'i am inserting into the table something', db.insertTaskIn2('sip','gsmeV',2)
+print 'i am inserting into the table something', db.insertTaskIn2('sip','gsmeE',2)
+print 'i am inserting into the table something', db.insertTaskIn2('landline','sip',2)
+#print 'i am inserting into the table something', db.insertTaskIn2('landline','gsmr2',2)
+print 'i am inserting into the table something', db.insertTaskIn2('landline','unisip',2)
+#print 'i am inserting into the table something', db.insertTaskIn2('sip','gsmr2',2)
+#print 'i am inserting into the table something', db.insertTaskIn2('gsmeO','sip',2)
+#print 'i am inserting into the table something', db.insertTaskIn2('gsmeV','sip',2)
+#print 'i am inserting into the table something', db.insertTaskIn2('gsmeE','sip',2)
diff --git a/For Weekly Test/DBProblem/test3.py b/For Weekly Test/DBProblem/test3.py
index d600124..4450790 100644
--- a/For Weekly Test/DBProblem/test3.py
+++ b/For Weekly Test/DBProblem/test3.py
@@ -15,8 +15,8 @@ print 'i am inserting into the table something', db.insertTaskIn2('gsm4','sip8',
print 'i am inserting into the table something', db.insertTaskIn2('gsm4','sip8',2)
db.anyTasksToDo()
if db.anyTasksToDo() == 1:
- templist = db.tasksList
- for item in templist:
+
+ for item in db.tasksList:
taskID = item[0]
taskNo = item[1]
callFrom = item[2]