testCase.py

import mysql.connector
import requests

cnx = mysql.connector.connect(user='testUser', password='p@ssw0rd',
                              host='192.168.197.130',
                              database='simpleDB')

cursor = cnx.cursor()

createTable = """CREATE TABLE IF NOT EXISTS users (id INT(10) NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, luckyNumber INT(10) NOT NULL, PRIMARY KEY(id))"""

insertQuery = """INSERT INTO users (name, luckyNumber) VALUES ('lsd', 23),('kenny', 13),('root', 1),('henry', 5)"""
selectQuery = "SELECT * FROM users"

dropQuery = "DROP TABLE users"

print "creating"
cursor.execute(createTable)

print "inserting"
cursor.execute(insertQuery)

print "select"
cursor.execute(selectQuery)

for (id, name, luckyNumber) in cursor:
    print str(name) + " has a lucky number %i" % luckyNumber
    r = requests.post("http://posttestserver.com/post.php", data={'username': name, 'luckyNumber': luckyNumber, 'super': True})
    print r.status_code
    print r.text + "\n\n"

print "dropping"
cursor.execute(dropQuery)

cursor.close()
cnx.close()