Exemplos de cQuery em Python

Exemplo n.º 1

Arquivo: ossqkmi-omvzbgzorcgwr-ubxazbiq.py Projeto: jroger06/test-clarity

#!/usr/bin/env python
"""ossqkmi-omvzbgzorcgwr-ubxazbiq.py"""
import clarity.models as cModel
from clarity.models import Query as cQuery
from clarity.core import Clarity


cl = Clarity()
my_attr = cModel.Attribute()
query = cQuery()


# Used tables
# cliente = my_attr.use_table(
#         "da_pro", "*", table="clientes_corp", table_alias="cliente"
# )


# Query builder
# where_clause = "cod_entalfa LIKE '0182' " + "and cod_paisoalf LIKE 'ES' " + \
#                "and qnu_adultcar is not NULL"

# acargo = query.sub_query_where(
#         "cod_persctpn, qnu_adultcar", cliente, where_clause, "acargo"
# )


# Assign sql
# my_attr.sql = acargo

Exemplo n.º 2

Arquivo: exb-ifydyqukgfqyp-xmq-ehugx.py Projeto: ezeznglb/clarity_datatest

#!/usr/bin/env python
"""exb_ifydyqukgfqyp_xmq_ehugx"""
import clarity.models as cModel
from clarity.models import Query as cQuery
from clarity.core import Clarity


cl = Clarity()
my_attr = cModel.Attribute()
query = cQuery()


# Used tables
# cliente = my_attr.use_table(
#         "da_pro", "*", table="clientes_corp", table_alias="cliente"
# )


# Query builder
# where_clause = "cod_entalfa LIKE '0182' " + "and cod_paisoalf LIKE 'ES' " + \
#                "and qnu_adultcar is not NULL"

# acargo = query.sub_query_where(
#         "cod_persctpn, qnu_adultcar", cliente, where_clause, "acargo"
# )


# Assign sql
# my_attr.sql = acargo