def all_host_dict(cls):
rows = db.query_all('SELECT id, hostname FROM host')
ret = {}
if rows:
for row in rows:
ret[row[0]] = row[1]
return ret
def select(cls,
cols=None,
where=None,
params=None,
order=None,
limit=None,
page=None,
offset=None):
if cols is None:
cols = cls._cols
if params is None:
params = []
sql = 'SELECT %s FROM %s' % (cols, cls._tbl)
if where:
sql = '%s WHERE %s' % (sql, where)
if order:
sql = '%s ORDER BY %s' % (sql, order)
if limit is not None:
sql = '%s LIMIT %s' % (sql, limit)
if offset is not None:
sql = '%s OFFSET %s' % (sql, offset)
if page is not None:
offset = (int(page) - 1) * int(limit)
if offset < 0:
offset = 0
sql = '%s OFFSET %s' % (sql, offset)
print sql
return db.query_all(sql, params)
def select(cls, cols=None, where=None, params=None, order=None, limit=None, page=None, offset=None):
if cols is None:
cols = cls._cols
if params is None:
params = []
sql = 'SELECT %s FROM `%s`' % (cols, cls._tbl)
if where:
sql = '%s WHERE %s' % (sql, where)
if order:
sql = '%s ORDER BY %s' % (sql, order)
if limit is not None:
sql = '%s LIMIT %s' % (sql, limit)
if offset is not None:
sql = '%s OFFSET %s' % (sql, offset)
if page is not None:
offset = (int(page) - 1) * int(limit)
if offset < 0:
offset = 0
sql = '%s OFFSET %s' % (sql, offset)
return db.query_all(sql, params)
def all_host_dict(cls):
rows = db.query_all('SELECT id, hostname FROM host')
ret = {}
if rows:
for row in rows:
ret[row[0]] = row[1]
return ret
def all_set(cls):
sql = 'select id, grp_name from %s' % cls._tbl
rows = db.query_all(sql)
name_set = dict()
name_id = dict()
for row in rows:
name = row[1]
name_set[name] = set(name.split('_'))
name_id[name] = row[0]
return name_set, name_id
def all_set(cls):
sql = 'select id, grp_name from %s' % cls._tbl
rows = db.query_all(sql)
name_set = dict()
name_id = dict()
for row in rows:
name = row[1]
name_set[name] = set(name.split('_'))
name_id[name] = row[0]
return name_set, name_id
def all_group_dict(cls):
rows = db.query_all('select id, grp_name from grp where come_from = 0')
return [{'id': row[0], 'name': row[1]} for row in rows]
def all_group_dict(cls):
rows = db.query_all('select id, grp_name from grp where come_from = 0')
return [{'id': row[0], 'name': row[1]} for row in rows]
