Lines Matching refs:csv
9 import csv
36 self.assertRaises(csv.Error, ctor, arg, 'foo')
44 quoting=csv.QUOTE_ALL, quotechar='')
46 quoting=csv.QUOTE_ALL, quotechar=None)
49 self._test_arg_valid(csv.reader, [])
50 self.assertRaises(OSError, csv.reader, BadIterable())
53 self._test_arg_valid(csv.writer, StringIO())
58 self.assertRaises(OSError, csv.writer, BadWriter())
68 self.assertEqual(obj.dialect.quoting, csv.QUOTE_MINIMAL)
79 self._test_default_attrs(csv.reader, [])
82 self._test_default_attrs(csv.writer, StringIO())
88 quoting=csv.QUOTE_NONE, skipinitialspace=True,
96 self.assertEqual(obj.dialect.quoting, csv.QUOTE_NONE)
101 self._test_kw_attrs(csv.reader, [])
104 self._test_kw_attrs(csv.writer, StringIO())
114 quoting=csv.QUOTE_ALL
124 self.assertEqual(obj.dialect.quoting, csv.QUOTE_ALL)
129 self._test_dialect_attrs(csv.reader, [])
132 self._test_dialect_attrs(csv.writer, StringIO())
137 writer = csv.writer(fileobj, **kwargs)
145 writer = csv.writer(fileobj, **kwargs)
152 self._write_error_test(csv.Error, None)
155 self._write_error_test(csv.Error, [None], quoting = csv.QUOTE_NONE)
178 self._write_error_test(csv.Error, ['a',1,'p,q'],
179 quoting = csv.QUOTE_NONE)
181 quoting = csv.QUOTE_MINIMAL)
183 quoting = csv.QUOTE_NONNUMERIC)
185 quoting = csv.QUOTE_ALL)
187 quoting = csv.QUOTE_ALL)
192 self._write_error_test(csv.Error, ['a',1,'p,"q"'],
197 escapechar='\\', quoting = csv.QUOTE_MINIMAL)
199 escapechar='\\', quoting = csv.QUOTE_MINIMAL,
202 escapechar='\\', quoting = csv.QUOTE_NONE)
204 escapechar='\\', quoting = csv.QUOTE_NONE)
206 escapechar='\\', quoting=csv.QUOTE_NONE)
208 escapechar='\\', quoting=csv.QUOTE_MINIMAL)
210 escapechar='\\', quoting=csv.QUOTE_ALL)
212 escapechar='\\', quoting=csv.QUOTE_MINIMAL)
214 escapechar='\\', quoting=csv.QUOTE_NONE)
216 escapechar='\\', quoting=csv.QUOTE_MINIMAL)
218 escapechar='\\', quoting=csv.QUOTE_MINIMAL)
225 self._write_error_test(csv.Error, iter([None]), quoting=csv.QUOTE_NONE)
232 writer = csv.writer(BrokenFile())
236 writer = csv.writer(fileobj)
244 writer = csv.writer(fileobj)
250 writer = csv.writer(fileobj)
256 writer = csv.writer(fileobj)
263 writer = csv.writer(fileobj)
274 writer = csv.writer(fileobj)
280 reader = csv.reader(input, **kwargs)
287 self.assertRaises(csv.Error, self._read_test,
290 self.assertRaises(csv.Error, self._read_test,
294 self.assertRaises(csv.Error, self._read_test,
303 self.assertRaises(csv.Error, self._read_test, ['a,b\rc,d'], [])
304 self.assertRaises(csv.Error, self._read_test, ['a,b\nc,d'], [])
305 self.assertRaises(csv.Error, self._read_test, ['a,b\r\nc,d'], [])
311 self.assertRaises(csv.Error, self._read_test, ['a,"'], [], strict=True)
312 self.assertRaises(csv.Error, self._read_test, ['"a'], [], strict=True)
313 self.assertRaises(csv.Error, self._read_test,
329 quoting=csv.QUOTE_NONE, escapechar='\\')
332 quoting=csv.QUOTE_NONNUMERIC)
336 quoting=csv.QUOTE_NONNUMERIC)
341 limit = csv.field_size_limit()
347 csv.field_size_limit(size)
349 self.assertEqual(csv.field_size_limit(), size)
350 csv.field_size_limit(size-1)
351 self.assertRaises(csv.Error, self._read_test, [bigline], [])
352 self.assertRaises(TypeError, csv.field_size_limit, None)
353 self.assertRaises(TypeError, csv.field_size_limit, 1, None)
355 csv.field_size_limit(limit)
358 r = csv.reader(['line,1', 'line,2', 'line,3'])
371 writer = csv.writer(fileobj)
375 for i, row in enumerate(csv.reader(fileobj)):
380 writer = csv.writer(fileobj,quoting=csv.QUOTE_NONE,escapechar="\\")
384 for i, row in enumerate(csv.reader(fileobj,quoting=csv.QUOTE_NONE,escapechar="\\")):
389 self.assertRaises(TypeError, csv.list_dialects, None)
390 self.assertRaises(TypeError, csv.get_dialect)
391 self.assertRaises(csv.Error, csv.get_dialect, None)
392 self.assertRaises(csv.Error, csv.get_dialect, "nonesuch")
393 self.assertRaises(TypeError, csv.unregister_dialect)
394 self.assertRaises(csv.Error, csv.unregister_dialect, None)
395 self.assertRaises(csv.Error, csv.unregister_dialect, "nonesuch")
396 self.assertRaises(TypeError, csv.register_dialect, None)
397 self.assertRaises(TypeError, csv.register_dialect, None, None)
398 self.assertRaises(TypeError, csv.register_dialect, "nonesuch", 0, 0)
399 self.assertRaises(TypeError, csv.register_dialect, "nonesuch",
401 self.assertRaises(TypeError, csv.register_dialect, "nonesuch",
403 self.assertRaises(TypeError, csv.register_dialect, [])
406 class myexceltsv(csv.excel):
409 expected_dialects = csv.list_dialects() + [name]
411 csv.register_dialect(name, myexceltsv)
412 self.addCleanup(csv.unregister_dialect, name)
413 self.assertEqual(csv.get_dialect(name).delimiter, '\t')
414 got_dialects = sorted(csv.list_dialects())
419 csv.register_dialect(name, delimiter=';')
420 self.addCleanup(csv.unregister_dialect, name)
421 self.assertEqual(csv.get_dialect(name).delimiter, ';')
422 self.assertEqual([['X', 'Y', 'Z']], list(csv.reader(['X;Y;Z'], name)))
425 class myexceltsv(csv.Dialect):
427 self.assertRaises(csv.Error, myexceltsv)
430 class space(csv.excel):
432 quoting = csv.QUOTE_NONE
438 reader = csv.reader(fileobj, dialect=space())
446 writer = csv.writer(fileobj, *writeargs, **kwwriteargs)
452 class testA(csv.excel):
454 class testB(csv.excel):
456 class testC(csv.excel):
458 class testUni(csv.excel):
465 csv.register_dialect('testC', testC)
479 csv.unregister_dialect('testC')
483 self.assertRaises(TypeError, csv.reader, [], bad_attr = 0)
485 self.assertRaises(TypeError, csv.reader, [], delimiter = None)
486 self.assertRaises(TypeError, csv.reader, [], quoting = -1)
487 self.assertRaises(TypeError, csv.reader, [], quoting = 100)
490 for name in csv.list_dialects():
491 dialect = csv.get_dialect(name)
495 for name in csv.list_dialects():
496 dialect = csv.get_dialect(name)
505 reader = csv.reader(fileobj, dialect = self.dialect)
511 writer = csv.writer(fileobj, dialect = self.dialect)
613 class EscapedExcel(csv.excel):
614 quoting = csv.QUOTE_NONE
635 class QuotedEscapedExcel(csv.excel):
636 quoting = csv.QUOTE_NONNUMERIC
653 writer = csv.DictWriter(fileobj, fieldnames = ["f1", "f2", "f3"])
659 writer = csv.DictWriter(fileobj, fieldnames = ["f1", "f2", "f3"])
670 writer = csv.DictWriter(fileobj, fieldnames=["f1", "f2", "f3"])
680 self.assertRaises(TypeError, csv.DictWriter, fileobj)
684 writer = csv.DictWriter(fileobj, fieldnames = ["f1", "f2", "f3"])
696 self.assertRaises(ValueError, csv.DictWriter, fileobj, ['f1', 'f2'],
701 writer = csv.DictWriter(fileobj, ['f1', 'f2'], extrasaction="raise")
703 self.assertRaises(ValueError, csv.DictWriter.writerow, writer, dictrow)
707 writer = csv.DictWriter(fileobj, ['f1', 'f2'], extrasaction="ignore")
709 csv.DictWriter.writerow(writer, dictrow)
716 reader = csv.DictReader(fileobj,
724 reader = csv.DictReader(fileobj)
734 reader = csv.DictReader(fileobj,
735 fieldnames=next(csv.reader(fileobj)))
744 reader = csv.DictReader(fileobj)
754 reader = csv.DictReader(fileobj,
763 reader = csv.DictReader(fileobj,
772 reader = csv.DictReader(fileobj, restkey="_rest")
781 reader = csv.DictReader(fileobj,
797 reader = csv.DictReader(sample,
806 reader = csv.DictReader(["1,2,abc,4,5,6\r\n","\r\n",
815 reader = csv.DictReader(["1;2;abc;4;5;6\r\n"],
828 writer = csv.writer(fileobj, dialect="excel")
839 writer = csv.writer(fileobj, dialect="excel")
850 writer = csv.writer(fileobj, dialect="excel")
861 writer = csv.writer(fileobj, dialect="excel")
869 class mydialect(csv.Dialect):
875 quoting = csv.QUOTE_NONE
877 self.assertEqual(d.quoting, csv.QUOTE_NONE)
880 self.assertRaises(csv.Error, mydialect)
883 mydialect.quoting = csv.QUOTE_ALL
886 self.assertEqual(d.quoting, csv.QUOTE_ALL)
891 with self.assertRaises(csv.Error) as cm:
897 with self.assertRaises(csv.Error) as cm:
903 class mydialect(csv.Dialect):
909 quoting = csv.QUOTE_NONE
914 with self.assertRaises(csv.Error) as cm:
920 with self.assertRaises(csv.Error) as cm:
926 with self.assertRaises(csv.Error) as cm:
932 with self.assertRaises(csv.Error) as cm:
938 with self.assertRaises(csv.Error) as cm:
944 class mydialect(csv.Dialect):
950 quoting = csv.QUOTE_NONE
955 with self.assertRaisesRegex(csv.Error, '"escapechar" must be a 1-character string'):
959 with self.assertRaisesRegex(csv.Error, '"escapechar" must be string or None, not bytes'):
963 with self.assertRaisesRegex(csv.Error, '"escapechar" must be string or None, not int'):
967 class mydialect(csv.Dialect):
973 quoting = csv.QUOTE_NONE
982 with self.assertRaises(csv.Error) as cm:
989 class mydialect(csv.Dialect):
996 self.assertRaises(csv.Error, create_invalid, field_name, "")
997 self.assertRaises(csv.Error, create_invalid, field_name, "abc")
998 self.assertRaises(csv.Error, create_invalid, field_name, b'x')
999 self.assertRaises(csv.Error, create_invalid, field_name, 5)
1078 sniffer = csv.Sniffer()
1084 sniffer = csv.Sniffer()
1089 sniffer = csv.Sniffer()
1094 sniffer = csv.Sniffer()
1099 sniffer = csv.Sniffer()
1109 sniffer = csv.Sniffer()
1121 sniffer = csv.Sniffer()
1147 sniffer = csv.Sniffer()
1174 csv.reader(["a,b,c\r\n"])
1175 csv.reader(["a,b,c\r\n"])
1176 csv.reader(["a,b,c\r\n"])
1190 csv.writer(s)
1191 csv.writer(s)
1192 csv.writer(s)
1206 rdr = csv.reader(rows)
1223 writer = csv.writer(s)
1242 reader = csv.reader(fileobj)
1248 writer = csv.writer(fileobj)
1260 dw = csv.DictWriter(fileobject, keys)
1263 dr = csv.DictReader(fileobject)
1280 self.assertEqual(list(csv.DictReader(data)),
1288 self.assertEqual(list(csv.DictReader(data, restkey='OtherInfo')),
1297 self.assertEqual(list(csv.DictReader(data, fieldnames=['fname', 'lname'])),
1309 support.check__all__(self, csv, ('csv', '_csv'), extra=extra)
1313 class Foo(csv.Error): ...