def test_print_created_event(self):
self.logger.prepare()
self.cursor.execute(
Query.from_(self.log_events).select(analytics.Count(
Star())).get_sql())
cnt = self.cursor.fetchone()[0]
self.connection.commit()
self.assertEqual(cnt, 0)
self.logger.print(Level.TRACE, 'msg')
self.connection.commit()
self.cursor.execute(
Query.from_(self.log_events).select(analytics.Count(
Star())).get_sql())
cnt = self.cursor.fetchone()[0]
self.connection.commit()
self.assertEqual(cnt, 1)
self.cursor.execute(
Query.from_(self.log_events).select('level', 'application_id',
'identifier_id',
'message').get_sql())
lvl, appid, idenid, msg = self.cursor.fetchone()
self.connection.commit()
self.assertEqual(lvl, int(Level.TRACE))
self.assertEqual(appid, self.logger.app_id)
self.assertEqual(idenid, self.logger.iden_id)
self.assertEqual(msg, 'msg')
def test_creates_iden_id(self):
self.cursor.execute(
Query.from_(self.log_idens).select(analytics.Count(
Star())).get_sql())
cnt = self.cursor.fetchone()[0]
self.connection.commit()
self.assertEqual(cnt, 0)
self.logger.prepare()
self.cursor.execute(
Query.from_(self.log_idens).select(analytics.Count(
Star())).get_sql())
cnt = self.cursor.fetchone()[0]
self.connection.commit()
self.assertEqual(cnt, 1)
self.cursor.execute(
Query.from_(self.log_idens).select(
self.log_idens.id, self.log_idens.identifier).get_sql())
id_, iden = self.cursor.fetchone()
self.connection.commit()
self.assertEqual(iden, self.logger.identifier)
self.assertEqual(id_, self.logger.iden_id)
def test_creates_app_id(self):
self.cursor.execute(
Query.from_(self.log_apps).select(analytics.Count(
Star())).get_sql())
cnt = self.cursor.fetchone()[0]
self.connection.commit()
self.assertEqual(cnt, 0)
self.logger.prepare()
self.cursor.execute(
Query.from_(self.log_apps).select(analytics.Count(
Star())).get_sql())
cnt = self.cursor.fetchone()[0]
self.connection.commit()
self.assertEqual(cnt, 1)
self.cursor.execute(
Query.from_(self.log_apps).select(self.log_apps.id,
self.log_apps.name).get_sql())
id_, nm = self.cursor.fetchone()
self.connection.commit()
self.assertEqual(nm, self.logger.appname)
self.assertEqual(id_, self.logger.app_id)
def test_count_range_between_unbounded_preceeding_current_row(self):
expr = an.Count(self.table_abc.fizz) \
.over(self.table_abc.foo) \
.orderby(self.table_abc.date) \
.range(an.Preceding(), an.CURRENT_ROW)
q = Query.from_(self.table_abc).select(expr)
self.assertEqual(
'SELECT '
'COUNT("fizz") '
'OVER('
'PARTITION BY "foo" ORDER BY "date" '
'RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW'
') '
'FROM "abc"', str(q))
