xk08JVM8

1import mysql.connector
2import requests
3
4cnx = mysql.connector.connect(user='testUser', password='p@ssw0rd',
5                              host='192.168.197.130',
6                              database='simpleDB')
7                                                            
8cursor = cnx.cursor()
9
10createTable = """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))"""
11
12insertQuery = """INSERT INTO users (name, luckyNumber) VALUES ('lsd', 23),('kenny', 13),('root', 1),('henry', 5)"""    
13selectQuery = "SELECT * FROM users"   
14                           
15dropQuery = "DROP TABLE users"
16               
17print "creating"
18cursor.execute(createTable)
19
20print "inserting"
21cursor.execute(insertQuery)
22
23print "select"
24cursor.execute(selectQuery)
25
26for (id, name, luckyNumber) in cursor:
27    print str(name) + " has a lucky number %i" % luckyNumber
28    r = requests.post("http://posttestserver.com/post.php", data={'username': name, 'luckyNumber': luckyNumber, 'super': True})
29    print r.status_code
30    print r.text + "\n\n"
31  
32print "dropping"
33cursor.execute(dropQuery)
34
35cursor.close()
36cnx.close()