summaryrefslogtreecommitdiffstats
path: root/For Weekly Test/12-09-2011/inserttest.py
diff options
context:
space:
mode:
authorgsmselgtest2011-08-29 18:50:13 +0200
committergsmselgtest2011-08-29 18:50:13 +0200
commitc0b40d8a45289bc25ea65d1043137e3b28ca6f1e (patch)
tree3017dbbdc9d05513485969efbbb6d87ded1bf8e3 /For Weekly Test/12-09-2011/inserttest.py
parentadd sip true table (diff)
downloadgsm-selftest-c0b40d8a45289bc25ea65d1043137e3b28ca6f1e.tar.gz
gsm-selftest-c0b40d8a45289bc25ea65d1043137e3b28ca6f1e.tar.xz
gsm-selftest-c0b40d8a45289bc25ea65d1043137e3b28ca6f1e.zip
managing file for test folder.
Diffstat (limited to 'For Weekly Test/12-09-2011/inserttest.py')
-rw-r--r--For Weekly Test/12-09-2011/inserttest.py28
1 files changed, 28 insertions, 0 deletions
diff --git a/For Weekly Test/12-09-2011/inserttest.py b/For Weekly Test/12-09-2011/inserttest.py
new file mode 100644
index 0000000..4987242
--- /dev/null
+++ b/For Weekly Test/12-09-2011/inserttest.py
@@ -0,0 +1,28 @@
+#!/usr/bin/python
+# -*- coding: utf-8 -*-
+
+import MySQLdb as mdb
+import sys
+
+try:
+ conn = mdb.connect('localhost', 'root', 'randompasswordSQL', 'gsmselftesting')
+
+ cursor = conn.cursor()
+
+ cursor.execute("INSERT INTO TempTaskTable(`taskID`, `taskNo`, `from`, `to`,`status` ) VALUES('1', '2', 'sip', 'GSMExt.O2', '0')")
+ cursor.execute("INSERT INTO TempTaskTable(`taskID`, `taskNo`, `from`, `to`,`status` ) VALUES('2', '2', 'sip', 'GSMExt.Voda', '0')")
+ cursor.execute("INSERT INTO TempTaskTable(`taskID`, `taskNo`, `from`, `to`,`status` ) VALUES('3', '2', 'sip', 'GSMExt.Tm', '0')")
+ cursor.execute("INSERT INTO TempTaskTable(`taskID`, `taskNo`, `from`, `to`,`status` ) VALUES('4', '2', 'sip', 'GSMExt.Eplus', '0')")
+ cursor.execute("INSERT INTO TempTaskTable(`taskID`, `taskNo`, `from`, `to`,`status` ) VALUES('5', '2', 'sip', 'landline', '0')")
+ #cursor.execute("INSERT INTO TempTaskTable(`taskID`, `taskNo`, `from`, `to`,`status` ) VALUES('6', '2', 'sip', 'unisip', '0')")
+ #cursor.execute("INSERT INTO TempTaskTable(`taskID`, `taskNo`, `from`, `to`,`status` ) VALUES('7', '2', 'unisip', 'sip', '0')")
+
+ conn.commit()
+
+ cursor.close()
+ conn.close()
+
+except mdb.Error, e:
+
+ print "Error %d: %s" % (e.args[0],e.args[1])
+ sys.exit(1)