def total(cls, where=None, params=None): sql = 'SELECT COUNT(1) FROM %s' % cls._tbl if not where: ret = db.query_column(sql) return ret[0] sql += ' WHERE ' + where ret = db.query_column(sql, params) return ret[0]
def total(cls, where=None, params=None): sql = 'SELECT COUNT(1) FROM `%s`' % cls._tbl if not where: ret = db.query_column(sql) return ret[0] sql += ' WHERE ' + where ret = db.query_column(sql, params) return ret[0]
def api_pings_get(): names = db.query_column("select hostname from host") return jsonify(hosts=names)