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_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]