Lines Matching full:row
32 def dict_factory(cursor, row): argument
35 d[col[0]] = row[idx]
83 row = cur.fetchone()
84 self.assertIsInstance(row, dict)
95 self.con.row_factory = lambda cur, row: list(row)
96 row = self.con.execute("select 1, 2").fetchone()
97 self.assertIsInstance(row, list)
100 self.con.row_factory = sqlite.Row
101 row = self.con.execute("select 1 as a, 2 as b").fetchone()
102 self.assertIsInstance(row, sqlite.Row)
104 col1, col2 = row["a"], row["b"]
108 col1, col2 = row["A"], row["B"]
112 self.assertEqual(row[0], 1, "by index: wrong result for column 0")
113 self.assertEqual(row[1], 2, "by index: wrong result for column 1")
114 self.assertEqual(row[-1], 2, "by index: wrong result for column -1")
115 self.assertEqual(row[-2], 1, "by index: wrong result for column -2")
118 row['c']
120 row[2]
122 row[-3]
124 row[2**1000]
127 # A sqlite.Row can be sliced like a list.
128 self.con.row_factory = sqlite.Row
129 row = self.con.execute("select 1, 2, 3, 4").fetchone()
130 self.assertEqual(row[0:0], ())
131 self.assertEqual(row[0:1], (1,))
132 self.assertEqual(row[1:3], (2, 3))
133 self.assertEqual(row[3:1], ())
135 self.assertEqual(row[1:], (2, 3, 4))
136 self.assertEqual(row[:3], (1, 2, 3))
138 self.assertEqual(row[-2:-1], (3,))
139 self.assertEqual(row[-2:], (3, 4))
141 self.assertEqual(row[0:4:2], (1, 3))
142 self.assertEqual(row[3:0:-2], (4, 2))
145 """Checks if the row object is iterable"""
146 self.con.row_factory = sqlite.Row
147 row = self.con.execute("select 1 as a, 2 as b").fetchone()
148 for col in row:
152 """Checks if the row object can be converted to a tuple"""
153 self.con.row_factory = sqlite.Row
154 row = self.con.execute("select 1 as a, 2 as b").fetchone()
155 t = tuple(row)
156 self.assertEqual(t, (row['a'], row['b']))
159 """Checks if the row object can be correctly converted to a dictionary"""
160 self.con.row_factory = sqlite.Row
161 row = self.con.execute("select 1 as a, 2 as b").fetchone()
162 d = dict(row)
163 self.assertEqual(d["a"], row["a"])
164 self.assertEqual(d["b"], row["b"])
167 """Checks if the row object compares and hashes correctly"""
168 self.con.row_factory = sqlite.Row
187 """ Checks if the row object can act like a sequence """
188 self.con.row_factory = sqlite.Row
189 row = self.con.execute("select 1 as a, 2 as b").fetchone()
191 as_tuple = tuple(row)
192 self.assertEqual(list(reversed(row)), list(reversed(as_tuple)))
193 self.assertIsInstance(row, Sequence)
201 self.con.row_factory = sqlite.Row
203 self.assertRaises(TypeError, sqlite.Row, FakeCursor(), ())
214 row = self.con.execute("select ?", (austria,)).fetchone()
215 self.assertEqual(type(row[0]), str, "type of row[0] must be unicode")
220 row = self.con.execute("select ?", (austria,)).fetchone()
221 self.assertEqual(type(row[0]), bytes, "type of row[0] must be bytes")
222 … self.assertEqual(row[0], austria.encode("utf-8"), "column must equal original data in UTF-8")
227 row = self.con.execute("select ?", (austria,)).fetchone()
228 self.assertEqual(type(row[0]), str, "type of row[0] must be unicode")
229 self.assertTrue(row[0].endswith("reich"), "column must contain original data")
239 self.assertEqual(type(a_row[0]), str, "type of non-ASCII row must be str")
240 self.assertEqual(type(d_row[0]), str, "type of ASCII-only row must be str")
253 row = self.con.execute("select value from test").fetchone()
254 self.assertIs(type(row[0]), str)
255 self.assertEqual(row[0], "a\x00b")
259 row = self.con.execute("select value from test").fetchone()
260 self.assertIs(type(row[0]), bytes)
261 self.assertEqual(row[0], b"a\x00b")
265 row = self.con.execute("select value from test").fetchone()
266 self.assertIs(type(row[0]), bytearray)
267 self.assertEqual(row[0], b"a\x00b")
272 row = self.con.execute("select value from test").fetchone()
273 self.assertIs(type(row[0]), bytes)
274 self.assertEqual(row[0], b"a\x00b")