def fetch_by_subscriber(cls, db, user):
sql = Select('bld_watches_for_subscriber')
sql.add_hidden_column('subscriber_id', IntColumnFormatter())
sql.add_column('watch_id', IntColumnFormatter())
sql.add_column('name', StringColumnFormatter())
sql.set_where(StrictEqualCondition(sql, 'subscriber_id', user.id))
return cls._select(db, sql)
def fetch_by_watch(cls, db, watch):
sql = Select('p4_paths_for_watch')
sql.add_hidden_column('watch_id', IntColumnFormatter())
sql.add_column('path_id', IntColumnFormatter())
sql.add_column('path', StringColumnFormatter())
sql.set_where(StrictEqualCondition(sql, 'watch_id', watch.id))
return cls._select(db, sql)
def fetch_by_watch(cls, db, watch):
sql = Select('bld_subscribers_for_watch')
sql.add_hidden_column('watch_id', IntColumnFormatter())
sql.add_column('subscriber_id', IntColumnFormatter())
sql.add_column('email', StringColumnFormatter())
sql.set_where(StrictEqualCondition(sql, 'watch_id', watch.id))
return cls._select(db, sql)
def _add_insert_columns(cls, sql):
sql.add_column('path', StringColumnFormatter())
return sql
def _add_columns(cls, sql):
sql.add_column('id', IntColumnFormatter())
sql.add_column('path', StringColumnFormatter())
return sql
def _add_columns(cls, sql):
sql.add_column('changelist', IntColumnFormatter())
sql.add_column('username', StringColumnFormatter())
sql.add_column('watch_id', IntColumnFormatter())
sql.add_column('overtest_testrun_id', IntColumnFormatter())
return sql
def _add_columns(cls, sql):
sql.add_column('fqdn', StringColumnFormatter())
sql.add_column('smtp_fqdn', StringColumnFormatter())
sql.add_column('smtp_port', StringColumnFormatter())
return sql