def save(userdata):
cursor = dbconfig.cursor()
for entry in userdata:
cursor.execute(
"INSERT INTO `tests_user` (`name`, `email`, `age`, `power_level`, `info`) VALUES (%(name)s, %(email)s, %(age)s, %(power_level)s, %(info)s)",
entry,
)
def test():
cursor = dbconfig.cursor()
d = None
for pk in xrange(1,SELECT_ITERATIONS):
cursor.execute ("SELECT `tests_user`.`id`, `tests_user`.`name`, `tests_user`.`email`, `tests_user`.`age`, `tests_user`.`power_level`, `tests_user`.`info` FROM `tests_user` WHERE `tests_user`.`id` = %(pk)s", {'pk' : pk})
row = cursor.fetchone()
d = row[4]
d = None
cursor = dbconfig.cursor_close()
def test():
cursor = dbconfig.cursor()
d = None
cursor.execute ("SELECT `tests_user`.`id`, `tests_user`.`name`, `tests_user`.`email`, `tests_user`.`age`, `tests_user`.`power_level`, `tests_user`.`info` FROM `tests_user` LIMIT %s", SELECT_ITERATIONS)
result_set = cursor.fetchall ()
for row in result_set:
d = row[4]
d = None
cursor = dbconfig.cursor_close()
def test():
cursor = dbconfig.cursor()
d = None
for pk in xrange(1, SELECT_ITERATIONS):
cursor.execute(
"SELECT `tests_user`.`power_level` FROM `tests_user` WHERE `tests_user`.`id` = %(pk)s", {"pk": pk}
)
row = cursor.fetchone()
d = row[0]
d = None
cursor = dbconfig.cursor_close()
def test():
cursor = dbconfig.cursor()
for x in xrange(SELECTS_ITERATIONS):
cursor.execute ("SELECT `tests_user`.`id`, `tests_user`.`name`, `tests_user`.`email`, `tests_user`.`age`, `tests_user`.`power_level`, `tests_user`.`info` FROM `tests_user` LIMIT %s", SUB_SELECT_ITERATIONS+x)
results = cursor.fetchall()
"""
for row in results:
id = row[0]
name = row[1]
email = row[2]
age = row[3]
power_level = row[4]
info = row[5]
"""
cursor = dbconfig.cursor_close()
