Lines Matching full:row
31 def dict_factory(cursor, row): argument
34 d[col[0]] = row[idx]
82 row = cur.fetchone()
83 self.assertIsInstance(row, dict)
94 self.con.row_factory = lambda cur, row: list(row)
95 row = self.con.execute("select 1, 2").fetchone()
96 self.assertIsInstance(row, list)
99 self.con.row_factory = sqlite.Row
100 row = self.con.execute("select 1 as a_1, 2 as b").fetchone()
101 self.assertIsInstance(row, sqlite.Row)
103 self.assertEqual(row["a_1"], 1, "by name: wrong result for column 'a_1'")
104 self.assertEqual(row["b"], 2, "by name: wrong result for column 'b'")
106 self.assertEqual(row["A_1"], 1, "by name: wrong result for column 'A_1'")
107 self.assertEqual(row["B"], 2, "by name: wrong result for column 'B'")
109 self.assertEqual(row[0], 1, "by index: wrong result for column 0")
110 self.assertEqual(row[1], 2, "by index: wrong result for column 1")
111 self.assertEqual(row[-1], 2, "by index: wrong result for column -1")
112 self.assertEqual(row[-2], 1, "by index: wrong result for column -2")
115 row['c']
117 row['a_\x11']
119 row['a\x7f1']
121 row[2]
123 row[-3]
125 row[2**1000]
128 self.con.row_factory = sqlite.Row
129 row = self.con.execute("select 1 as \xff").fetchone()
130 self.assertEqual(row["\xff"], 1)
132 row['\u0178']
134 row['\xdf']
137 # A sqlite.Row can be sliced like a list.
138 self.con.row_factory = sqlite.Row
139 row = self.con.execute("select 1, 2, 3, 4").fetchone()
140 self.assertEqual(row[0:0], ())
141 self.assertEqual(row[0:1], (1,))
142 self.assertEqual(row[1:3], (2, 3))
143 self.assertEqual(row[3:1], ())
145 self.assertEqual(row[1:], (2, 3, 4))
146 self.assertEqual(row[:3], (1, 2, 3))
148 self.assertEqual(row[-2:-1], (3,))
149 self.assertEqual(row[-2:], (3, 4))
151 self.assertEqual(row[0:4:2], (1, 3))
152 self.assertEqual(row[3:0:-2], (4, 2))
155 """Checks if the row object is iterable"""
156 self.con.row_factory = sqlite.Row
157 row = self.con.execute("select 1 as a, 2 as b").fetchone()
158 for col in row:
162 """Checks if the row object can be converted to a tuple"""
163 self.con.row_factory = sqlite.Row
164 row = self.con.execute("select 1 as a, 2 as b").fetchone()
165 t = tuple(row)
166 self.assertEqual(t, (row['a'], row['b']))
169 """Checks if the row object can be correctly converted to a dictionary"""
170 self.con.row_factory = sqlite.Row
171 row = self.con.execute("select 1 as a, 2 as b").fetchone()
172 d = dict(row)
173 self.assertEqual(d["a"], row["a"])
174 self.assertEqual(d["b"], row["b"])
177 """Checks if the row object compares and hashes correctly"""
178 self.con.row_factory = sqlite.Row
211 """ Checks if the row object can act like a sequence """
212 self.con.row_factory = sqlite.Row
213 row = self.con.execute("select 1 as a, 2 as b").fetchone()
215 as_tuple = tuple(row)
216 self.assertEqual(list(reversed(row)), list(reversed(as_tuple)))
217 self.assertIsInstance(row, Sequence)
225 self.con.row_factory = sqlite.Row
227 self.assertRaises(TypeError, sqlite.Row, FakeCursor(), ())
238 row = self.con.execute("select ?", (austria,)).fetchone()
239 self.assertEqual(type(row[0]), str, "type of row[0] must be unicode")
244 row = self.con.execute("select ?", (austria,)).fetchone()
245 self.assertEqual(type(row[0]), bytes, "type of row[0] must be bytes")
246 … self.assertEqual(row[0], austria.encode("utf-8"), "column must equal original data in UTF-8")
251 row = self.con.execute("select ?", (austria,)).fetchone()
252 self.assertEqual(type(row[0]), str, "type of row[0] must be unicode")
253 self.assertTrue(row[0].endswith("reich"), "column must contain original data")
264 self.assertEqual(type(a_row[0]), str, "type of non-ASCII row must be str")
265 self.assertEqual(type(d_row[0]), str, "type of ASCII-only row must be str")
278 row = self.con.execute("select value from test").fetchone()
279 self.assertIs(type(row[0]), str)
280 self.assertEqual(row[0], "a\x00b")
284 row = self.con.execute("select value from test").fetchone()
285 self.assertIs(type(row[0]), bytes)
286 self.assertEqual(row[0], b"a\x00b")
290 row = self.con.execute("select value from test").fetchone()
291 self.assertIs(type(row[0]), bytearray)
292 self.assertEqual(row[0], b"a\x00b")
297 row = self.con.execute("select value from test").fetchone()
298 self.assertIs(type(row[0]), bytes)
299 self.assertEqual(row[0], b"a\x00b")