def search(cls, host_ids):
if not host_ids:
return []
holders = ["%s" for x in host_ids]
placeholder = ",".join(holders)
args = host_ids
cursor = db_conn.execute('''select id, hostname from host where id in (''' + placeholder + ''')''', args)
rows = cursor.fetchall()
cursor and cursor.close()
return [cls(*row) for row in rows]
def search(cls, group_ids):
if not group_ids:
return []
holders = ["%s" for x in group_ids]
placeholder = ",".join(holders)
args = group_ids
cursor = db_conn.execute('''select grp_id, host_id from grp_host where grp_id in (''' + placeholder + ''')''', args)
rows = cursor.fetchall()
cursor and cursor.close()
return [cls(*row) for row in rows]
def search(cls, host_ids):
if not host_ids:
return []
holders = ["%s" for x in host_ids]
placeholder = ",".join(holders)
args = host_ids
cursor = db_conn.execute("""select id, hostname from host where id in (""" + placeholder + """)""", args)
rows = cursor.fetchall()
cursor and cursor.close()
return [cls(*row) for row in rows]
def gets_by_group(cls, groups):
if not groups:
return []
holders = ["%s" for x in groups]
placeholder = ",".join(holders)
args = groups
cursor = db_conn.execute('''select id, grp_name from grp where grp_name in (''' + placeholder + ''')''', args)
rows = cursor.fetchall()
cursor and cursor.close()
return [cls(*row) for row in rows]
def search(cls, qs):
args = []
for q in qs:
args.append("%"+q+"%")
sql = '''select id, grp_name from grp where id > 0'''
for q in qs:
sql += ''' and grp_name like %s'''
cursor = db_conn.execute(sql, args)
rows = cursor.fetchall()
cursor and cursor.close()
return [cls(*row) for row in rows]
def search(cls, qs):
args = []
for q in qs:
args.append("%" + q + "%")
sql = '''select id, grp_name from grp where id > 0'''
for q in qs:
sql += ''' and grp_name like %s'''
cursor = db_conn.execute(sql, args)
rows = cursor.fetchall()
cursor and cursor.close()
return [cls(*row) for row in rows]
def gets_by_group(cls, groups):
if not groups:
return []
holders = ["%s" for x in groups]
placeholder = ",".join(holders)
args = groups
cursor = db_conn.execute(
'''select id, grp_name from grp where grp_name in (''' +
placeholder + ''')''', args)
rows = cursor.fetchall()
cursor and cursor.close()
return [cls(*row) for row in rows]
