Python cursor_close Examples

Example #1

File: bench_select_all.py Project: Axion/django-hippieturtle

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()

Example #2

File: bench_select_onequery.py Project: Axion/django-hippieturtle

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()

Example #3

File: bench_select_onefield.py Project: Axion/django-hippieturtle

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()

Example #4

File: bench_select_with_filter.py Project: Axion/django-hippieturtle

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()