Skip to content

Instantly share code, notes, and snippets.

@xcombelle
Last active May 26, 2016 13:35
Show Gist options
  • Save xcombelle/98fc914a78950f45e2d5262892fd463d to your computer and use it in GitHub Desktop.
Save xcombelle/98fc914a78950f45e2d5262892fd463d to your computer and use it in GitHub Desktop.
alternative syntaxes for sqltemplate.py
def query_users(users,query,registred):
q = SqlQueryBuffer()
q"SELECT name, email FROM"
if users == True:
q"users"
else:
q"admin"
q"WHERE"
q(OR(
AND("name LIKE {query} OR registred={registred}",
"address LIKE '%@gmail.com'"),
"1=0")
)
return q.freeze(registred=registred,
query=query)
def query_users(users,query,registred):
q = SqlQueryBuffer()
`SELECT name, email FROM`
if users == True:
`users`
else:
`admin`
`WHERE`
q(OR(
AND("name LIKE {query} OR registred={registred}",
"address LIKE '%@gmail.com'"),
"1=0")
)
return q.freeze(registred=registred,
query=query)
def query_users(users,query,registred):
q = SqlQueryBuffer()
<SELECT name, email FROM>
if users == True:
<users>
else:
<admin>
<WHERE>
q(OR(
AND("name LIKE {query} OR registred={registred}",
"address LIKE '%@gmail.com'"),
"1=0")
)
return q.freeze(registred=registred,
query=query)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment