| | 42 | #6254: fetchone, fetchmany, fetchall return strings as unicode objects |
|---|
| | 43 | >>> Person(first_name="John", last_name="Doe").save() |
|---|
| | 44 | >>> Person(first_name="Jane", last_name="Doe").save() |
|---|
| | 45 | >>> Person(first_name="Mary", last_name="Agnelline").save() |
|---|
| | 46 | >>> Person(first_name="Peter", last_name="Parker").save() |
|---|
| | 47 | >>> Person(first_name="Clark", last_name="Kent").save() |
|---|
| | 48 | >>> opts2 = Person._meta |
|---|
| | 49 | >>> f3, f4 = opts2.get_field('first_name'), opts2.get_field('last_name') |
|---|
| | 50 | >>> query2 = ('SELECT %s, %s FROM %s ORDER BY %s' |
|---|
| | 51 | ... % (qn(f3.column), qn(f4.column), t_convert(opts2.db_table), |
|---|
| | 52 | ... qn(f3.column))) |
|---|
| | 53 | >>> cursor.execute(query2) and None or None |
|---|
| | 54 | >>> cursor.fetchone() |
|---|
| | 55 | (u'Clark', u'Kent') |
|---|
| | 56 | |
|---|
| | 57 | >>> list(cursor.fetchmany(2)) |
|---|
| | 58 | [(u'Jane', u'Doe'), (u'John', u'Doe')] |
|---|
| | 59 | |
|---|
| | 60 | >>> list(cursor.fetchall()) |
|---|
| | 61 | [(u'Mary', u'Agnelline'), (u'Peter', u'Parker')] |
|---|
| | 62 | |
|---|