def test_mssql_query_uses_double_quote_chars(self):
q = MSSQLQuery.from_(self.table_abc).select(
self.table_abc.foo
).groupby(
self.table_abc.foo
).having(
self.table_abc.buz == 'fiz'
)
self.assertEqual("SELECT \"foo\" FROM \"abc\" GROUP BY \"foo\" HAVING \"buz\"='fiz'", str(q))
def __init__(self, d: dt, minesite='FortHills', **kw):
super().__init__(**kw)
a, b = pk.Tables('UnitID', 'UnitSMR')
d_lower = dt(d.year, d.month, 1)
dates = (d_lower, d_lower + relativedelta(months=1)
) # (2020-12-01, 2021-01-01)
cols = [a.Unit, b.DateSMR, b.SMR]
q = Query.from_(a).select(*cols) \
.left_join(b).on_field('Unit') \
.where((a.MineSite == minesite) & (b.DateSMR.isin(dates) & (a.ExcludeMA.isnull())))
f.set_self(vars())
def __init__(self, unit, d_rng=None, **kw):
super().__init__(**kw)
a = T('UnitSMR')
if d_rng is None:
d_upper = dt.now()
d_lower = d_upper + delta(days=-60)
d_rng = (d_lower, d_upper)
cols = ['Unit', 'DateSMR', 'SMR']
q = Query.from_(a) \
.where(a.Unit == unit) \
.where(a.DateSMR.between(d_rng[0], d_rng[1]))
f.set_self(vars())
def test_mssql_query_uses_double_quote_chars(self):
q = MSSQLQuery.from_(self.t).groupby(self.t.foo).select(self.t.foo)
self.assertEqual('SELECT "foo" FROM "abc" GROUP BY "foo"', str(q))
def test_mssql_query_uses_double_quote_chars(self):
q = MSSQLQuery.from_('abc').select('foo', 'bar')
self.assertEqual('SELECT "foo","bar" FROM "abc"', str(q))