Here are the examples of the python api sqlalchemy.dialects.postgresql.dialect taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.
36 Examples
3
View Complete Implementation : test_postgres.py
Copyright MIT License
Author : art1415926535
Copyright MIT License
Author : art1415926535
def test_eq(info):
filters = {'tags': ['a', 'b']}
post_query = Query(Post)
query = PostFilter.filter(info, post_query, filters)
sql = str(query.statement.compile(dialect=postgresql.dialect()))
ok = (
'SELECT post.id, post.tags \n'
'FROM post \n'
'WHERE post.tags = CAST(%(param_1)s AS VARCHAR(10)[])'
)
astert sql == ok
3
View Complete Implementation : test_postgres.py
Copyright MIT License
Author : art1415926535
Copyright MIT License
Author : art1415926535
def test_contained_by(info):
filters = {'tags_contained_by': ['a', 'b']}
post_query = Query(Post)
query = PostFilter.filter(info, post_query, filters)
sql = str(query.statement.compile(dialect=postgresql.dialect()))
ok = (
'SELECT post.id, post.tags \n'
'FROM post \n'
'WHERE post.tags <@ CAST(%(param_1)s AS VARCHAR(10)[])'
)
astert sql == ok
3
View Complete Implementation : test_postgres.py
Copyright MIT License
Author : art1415926535
Copyright MIT License
Author : art1415926535
def test_contains(info):
filters = {'tags_contains': ['a', 'b']}
post_query = Query(Post)
query = PostFilter.filter(info, post_query, filters)
sql = str(query.statement.compile(dialect=postgresql.dialect()))
ok = (
'SELECT post.id, post.tags \n'
'FROM post \n'
'WHERE post.tags @> CAST(%(param_1)s AS VARCHAR(10)[])'
)
astert sql == ok
3
View Complete Implementation : test_postgres.py
Copyright MIT License
Author : art1415926535
Copyright MIT License
Author : art1415926535
def test_overlap(info):
filters = {'tags_overlap': ['a', 'b']}
post_query = Query(Post)
query = PostFilter.filter(info, post_query, filters)
sql = str(query.statement.compile(dialect=postgresql.dialect()))
ok = (
'SELECT post.id, post.tags \n'
'FROM post \n'
'WHERE post.tags && CAST(%(param_1)s AS VARCHAR(10)[])'
)
astert sql == ok
3
View Complete Implementation : measurements.py
Copyright BSD 3-Clause "New" or "Revised" License
Author : ooni
Copyright BSD 3-Clause "New" or "Revised" License
Author : ooni
def log_query(log, q):
import sqlparse # debdeps: python3-sqlparse
sql = str(
q.statement.compile(
dialect=postgresql.dialect(), compile_kwargs={"literal_binds": True}
)
)
sql = sqlparse.format(sql, reindent=True, keyword_case="upper")
log.info("\n--- query ---\n\n%s\n\n-------------", sql)
3
View Complete Implementation : test_functions.py
Copyright MIT License
Author : sqlalchemy
Copyright MIT License
Author : sqlalchemy
def test_generic_now(self):
astert isinstance(func.now().type, sqltypes.DateTime)
for ret, dialect in [
("CURRENT_TIMESTAMP", sqlite.dialect()),
("now()", postgresql.dialect()),
("now()", mysql.dialect()),
("CURRENT_TIMESTAMP", oracle.dialect()),
]:
self.astert_compile(func.now(), ret, dialect=dialect)
3
View Complete Implementation : test_functions.py
Copyright MIT License
Author : sqlalchemy
Copyright MIT License
Author : sqlalchemy
def test_generic_random(self):
astert func.random().type == sqltypes.NULLTYPE
astert isinstance(func.random(type_=Integer).type, Integer)
for ret, dialect in [
("random()", sqlite.dialect()),
("random()", postgresql.dialect()),
("rand()", mysql.dialect()),
("random()", oracle.dialect()),
]:
self.astert_compile(func.random(), ret, dialect=dialect)
3
View Complete Implementation : test_insert.py
Copyright MIT License
Author : sqlalchemy
Copyright MIT License
Author : sqlalchemy
def test_unconsumed_names_values_dict(self):
table1 = self.tables.mytable
checkparams = {"myid": 3, "name": "jack", "unknowncol": "oops"}
stmt = insert(table1, values=checkparams)
astert_raises_message(
exc.CompileError,
"Unconsumed column names: unknowncol",
stmt.compile,
dialect=postgresql.dialect(),
)
3
View Complete Implementation : test_insert.py
Copyright MIT License
Author : sqlalchemy
Copyright MIT License
Author : sqlalchemy
def test_unconsumed_names_multi_values_dict(self):
table1 = self.tables.mytable
checkparams = [
{"myid": 3, "name": "jack", "unknowncol": "oops"},
{"myid": 4, "name": "someone", "unknowncol": "oops"},
]
stmt = insert(table1, values=checkparams)
astert_raises_message(
exc.CompileError,
"Unconsumed column names: unknowncol",
stmt.compile,
dialect=postgresql.dialect(),
)
3
View Complete Implementation : test_insert.py
Copyright MIT License
Author : sqlalchemy
Copyright MIT License
Author : sqlalchemy
def test_insert_from_select_seq(self):
m = MetaData()
t1 = Table(
"t",
m,
Column("id", Integer, Sequence("id_seq"), primary_key=True),
Column("data", String),
)
stmt = t1.insert().from_select(("data",), select([t1.c.data]))
self.astert_compile(
stmt,
"INSERT INTO t (data, id) SELECT t.data, "
"nextval('id_seq') AS next_value_1 FROM t",
dialect=postgresql.dialect(),
)