### Vladimir Dzhuvinov, 22.11.2007 ###
### Vladimir Dzhuvinov, 21.11.2007 ###

### Test make_payment SP call

### initial condition: 10'000 employee accounts with $5000 each
###	-> populate_tables_for_test.py

import MySQLdb
import random

# obtain the two numbers below after TABLE accounts was populated using
# SELECT MIN(id), MAX(id) FROM accounts;
acct_id_min = 10008
acct_id_max = 20007

connection = MySQLdb.connect (host='192.168.0.1', user='ttc', passwd='secret', db='ttc')
cursor = connection.cursor()

cursor.execute("SELECT VERSION()")
((r,),) = cursor.fetchall()
print "MySQL version:", r

for i in range (1, 10000):
	cursor.callproc("make_payment",
		[random.randint(acct_id_min, acct_id_max),
		 random.randint(acct_id_min, acct_id_max),
		 random.randint(1,100),
		 'ref abc'])
	((r,),)  = cursor.fetchall()
	cursor.nextset()
	aid = int(r)
	if (aid < 0):
		print 'Error make_payment;', aid
			

cursor.close()
connection.close()