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))