def test_create_temporary_view(self):
table = create_table("table")
view = View("view", select([table.c.id]), temporary=True)
stmt = CreateView(view)
self.assertEqual(
'CREATE TEMPORARY VIEW view AS SELECT "table".id \n'
'FROM "table"', literal_compile(stmt))
def test_plain_create_view(self):
table = create_table("table")
view = View("view", select([table.c.id]))
stmt = CreateView(view)
self.assertEqual(
'CREATE VIEW view AS SELECT "table".id \n'
'FROM "table"', literal_compile(stmt))
def test_create_or_replace_view(self):
table = create_table("table")
view = View("view", select([table.c.id]))
stmt = CreateView(view, or_replace=True)
self.assertEqual(
'CREATE OR REPLACE VIEW view AS SELECT "table".id \n'
'FROM "table"', literal_compile(stmt))
def test_create_view_with_check_option(table):
view = View("view", select(table.c.id), check_option='cascaded')
stmt = CreateView(view)
assert literal_compile(stmt) == ('CREATE VIEW view '
'AS SELECT "table".id \n'
'FROM "table" '
'WITH CASCADED CHECK OPTION')
def test_create_view_with_check_option(self):
table = create_table("table")
view = View("view", select([table.c.id]), check_option='cascaded')
stmt = CreateView(view)
self.assertEqual(
'CREATE VIEW view '
'AS SELECT "table".id \n'
'FROM "table" '
'WITH CASCADED CHECK OPTION', literal_compile(stmt))
def test_create_view_with_view_options(table):
view = View("view",
select(table.c.id),
view_options=[
('check_option', 'cascaded'),
('security_barrier', 't'),
])
stmt = CreateView(view)
assert literal_compile(stmt) == (
'CREATE VIEW view '
'WITH (check_option = cascaded, security_barrier = t) '
'AS SELECT "table".id \n'
'FROM "table"')
def test_create_view_with_view_options(self):
table = create_table("table")
view = View("view",
select([table.c.id]),
view_options=[
('check_option', 'cascaded'),
('security_barrier', 't'),
])
stmt = CreateView(view)
self.assertEqual(
'CREATE VIEW view '
'WITH (check_option = cascaded, security_barrier = t) '
'AS SELECT "table".id \n'
'FROM "table"', literal_compile(stmt))
def test_create_temporary_view(table):
view = View("view", select(table.c.id), temporary=True)
stmt = CreateView(view)
assert literal_compile(stmt) == (
'CREATE TEMPORARY VIEW view AS SELECT "table".id \n'
'FROM "table"')
def test_create_or_replace_view(table):
view = View("view", select(table.c.id))
stmt = CreateView(view, or_replace=True)
assert literal_compile(stmt) == (
'CREATE OR REPLACE VIEW view AS SELECT "table".id \n'
'FROM "table"')
def test_plain_create_view(table):
view = View("view", select(table.c.id))
stmt = CreateView(view)
assert literal_compile(stmt) == ('CREATE VIEW view AS SELECT "table".id \n'
'FROM "table"')