pgspecial-1.13.0/tests/test_specials.py

14     rows = [
26     expected = [title, rows, headers, status]
35     rows = [
47     expected = [title, rows, headers, status]
56     rows = [
65     expected = [title, rows, headers, status]
73     rows = [
79     expected = [title, rows, headers, status]
88     rows = [
92     assert rows == results[1]
103     rows = [
113     expected = [title, rows, headers, status]
117     rows = [
123     expected = [title, rows, headers, status]
133     rows = [
145     expected = [title, rows, headers, status]
149     rows = [
164     expected = [title, rows, headers, status]
172     rows = [["c3", "circle", ""]]
175     expected = [title, rows, headers, status]
183     rows = [
193     expected = [title, rows, headers, status]
202     rows = [
209     status = "SELECT %s" % len(rows)
210     expected = [title, rows, headers, status]
219     rows = [
238     status = "SELECT %s" % len(rows)
239     expected = [title, rows, headers, status]
248     rows = [("public", "inh2", "table", None, "", "")]
257     status = "SELECT %s" % len(rows)
258     expected = [title, rows, headers, status]
267     rows = [("public", "inh2", "table", None, "", "")]
276     status = "SELECT %s" % len(rows)
277     expected = [title, rows, headers, status]
286     rows = [
297     status = "SELECT %s" % len(rows)
298     expected = [title, rows, headers, status]
307     rows = [("postgres", "schema2", "table", "test_role=arwdDxt/postgres")]
314     status = "SELECT %s" % len(rows)
315     expected = [title, rows, headers, status]
324     rows = [
332     status = "SELECT %s" % len(rows)
333     expected = [title, rows, headers, status]
342     rows = [
350     status = "SELECT %s" % len(rows)
351     expected = [title, rows, headers, status]
491     rows = [("public", "foo", None), ("public", "gender_t", None)]
493     status = "SELECT %s" % len(rows)
494     expected = [title, rows, headers, status]
503     rows = [
513     expected = [title, rows, headers, status]
517     rows = [
521     status = "SELECT %s" % len(rows)
522     expected = [title, rows, headers, status]
539     rows = [
551     expected = [title, rows, headers, status]
555     rows = [("schema1", "bigint_t", "bigint", "", "", None, "a really large integer")]
557     expected = [title, rows, headers, status]
563     title, rows, header, status = executor(r"\dF")
566     assert ("pg_catalog", "spanish", "configuration for spanish language") in rows
571     assert ("pg_catalog", "russian", "configuration for russian language") in rows
576     assert ("pg_catalog", "german", "configuration for german language") in rows
597     title, rows, header, status = executor(r"\db")
600     assert "pg_default" in rows[0]
606     title, rows, header, status = executor(r"\db pg_default")
609     assert "pg_default" in rows[0]
617     rows = [("public", "func1", "integer", "", "normal")]
620     expected = [title, rows, headers, status]
877     rows = [
887     expected = [title, rows, headers, status]
905     rows = [
915     expected = [title, rows, headers, status]
923     rows = [
933     expected = [title, rows, headers, status]
943         rows = [("public", "foreign_foo", "foreign table", "postgres")]
946         expected = [title, rows, headers, status]
956         rows = [("public", "foreign_foo", "foreign table", "postgres")]
959         expected = [title, rows, headers, status]
966         rows = []
968         expected = [title, rows, headers, status]
978         rows = [("public", "foreign_foo", "foreign table", "postgres", "0 bytes", None)]
981         expected = [title, rows, headers, status]