def update( self, title=None, hosts=None, counters=None, screen_id=None, timespan=None, graph_type=None, method=None, position=None, ): title = self.title if title is None else title hosts = self.hosts if hosts is None else hosts hosts = hosts and ENDPOINT_DELIMITER.join(hosts) or "" counters = self.counters if counters is None else counters counters = counters and ENDPOINT_DELIMITER.join(counters) or "" screen_id = screen_id or self.screen_id timespan = timespan or self.timespan graph_type = graph_type or self.graph_type method = method if method is not None else self.method position = position or self.position db_conn.execute( """update dashboard_graph set title=%s, hosts=%s, counters=%s, screen_id=%s, timespan=%s, graph_type=%s, method=%s, position=%s where id=%s""", (title, hosts, counters, screen_id, timespan, graph_type, method, position, self.id), ) db_conn.commit() return DashboardGraph.get(self.id)
def update(self, title=None, hosts=None, counters=None, screen_id=None, timespan=None, graph_type=None, method=None, position=None): title = self.title if title is None else title hosts = self.hosts if hosts is None else hosts hosts = hosts and ENDPOINT_DELIMITER.join(hosts) or "" counters = self.counters if counters is None else counters counters = counters and ENDPOINT_DELIMITER.join(counters) or "" screen_id = screen_id or self.screen_id timespan = timespan or self.timespan graph_type = graph_type or self.graph_type method = method if method is not None else self.method position = position or self.position db_conn.execute( '''update dashboard_graph set title=%s, hosts=%s, counters=%s, screen_id=%s, timespan=%s, graph_type=%s, method=%s, position=%s where id=%s''', (title, hosts, counters, screen_id, timespan, graph_type, method, position, self.id)) db_conn.commit() return DashboardGraph.get(self.id)
def add(cls, tmp_id, type, data): cursor = db_conn.execute('''insert ignore into domeos_graph (tmp_id, type, data) values(%s, %s, %s) ON DUPLICATE KEY UPDATE id=LAST_INSERT_ID(id)''', (tmp_id, type, data)) id_ = cursor.lastrowid db_conn.commit() cursor and cursor.close() return id_
def update_multi(cls, rows): for x in rows: id = x["id"] hosts = x["hosts"] or [] counters = x["counters"] or [] db_conn.execute('''update dashboard_graph set hosts=%s, counters=%s where id=%s''', (ENDPOINT_DELIMITER.join(hosts) or "", ENDPOINT_DELIMITER.join(counters) or "", id)) db_conn.commit()
def update(self, pid=None, name=None): pid = pid or self.pid name = name or self.name db_conn.execute( '''update dashboard_screen set pid=%s, name=%s where id=%s''', (pid, name, self.id)) db_conn.commit() return DashboardScreen.get(self.id)
def add(cls, pid, name): cursor = db_conn.execute( '''insert into dashboard_screen (pid, name) values(%s, %s)''', (pid, name)) id_ = cursor.lastrowid db_conn.commit() cursor.close() return cls.get(id_)
def add(cls, endpoints, counters): es = endpoints and ENDPOINT_DELIMITER.join(sorted(endpoints)) or "" cs = counters and COUNTER_DELIMITER.join(sorted(counters)) or "" ck = hashlib.md5("%s:%s" %(es.encode("utf8"), cs.encode("utf8"))).hexdigest() cursor = db_conn.execute('''insert ignore into tmp_graph (endpoints, counters, ck) values(%s, %s, %s) ON DUPLICATE KEY UPDATE id=LAST_INSERT_ID(id),time_=%s''', (es, cs, ck, datetime.datetime.now())) id_ = cursor.lastrowid db_conn.commit() cursor and cursor.close() return id_
def update_multi(cls, rows): for x in rows: id = x["id"] hosts = x["hosts"] or [] counters = x["counters"] or [] db_conn.execute( '''update dashboard_graph set hosts=%s, counters=%s where id=%s''', (ENDPOINT_DELIMITER.join(hosts) or "", ENDPOINT_DELIMITER.join(counters) or "", id)) db_conn.commit()
def add(cls, endpoints, counters): es = endpoints and ENDPOINT_DELIMITER.join(sorted(endpoints)) or "" cs = counters and COUNTER_DELIMITER.join(sorted(counters)) or "" ck = hashlib.md5("%s:%s" % (es.encode("utf8"), cs.encode("utf8"))).hexdigest() cursor = db_conn.execute( '''insert ignore into tmp_graph (endpoints, counters, ck) values(%s, %s, %s) ON DUPLICATE KEY UPDATE time_=%s''', (es, cs, ck, datetime.datetime.now())) id_ = cursor.lastrowid db_conn.commit() cursor and cursor.close() return id_
def add(cls, title, hosts, counters, screen_id, timespan=3600, graph_type='h', method='', position=0): cursor = db_conn.execute('''insert into dashboard_graph (title, hosts, counters, screen_id, timespan, graph_type, method, position) values(%s, %s, %s, %s, %s, %s, %s, %s)''', (title, ENDPOINT_DELIMITER.join(hosts) or "", ENDPOINT_DELIMITER.join(counters) or "", screen_id, timespan, graph_type, method, position)) id_ = cursor.lastrowid db_conn.execute('''update dashboard_graph set position=%s where id=%s''', (id_, id_)) db_conn.commit() cursor and cursor.close() return cls.get(id_)
def add(cls, endpoints, counters): es = endpoints and ENDPOINT_DELIMITER.join(sorted(endpoints)) or "" cs = counters and COUNTER_DELIMITER.join(sorted(counters)) or "" ck = hashlib.md5("%s:%s" %(es.encode("utf8"), cs.encode("utf8"))).hexdigest() cursor = db_conn.execute('''insert ignore into tmp_graph (endpoints, counters, ck) values(%s, %s, %s) ON DUPLICATE KEY UPDATE time_=%s''', (es, cs, ck, datetime.datetime.now())) id_ = cursor.lastrowid if not id_: cursor = db_conn.execute("select id from tmp_graph where ck='" + ck + "'") id_ = cursor.fetchone()[0] db_conn.commit() cursor and cursor.close() return id_
def add(cls, endpoints, counters): es = endpoints and ENDPOINT_DELIMITER.join(sorted(endpoints)) or "" cs = counters and COUNTER_DELIMITER.join(sorted(counters)) or "" ck = hashlib.md5("%s:%s" % (es.encode("utf8"), cs.encode("utf8"))).hexdigest() cursor = db_conn.execute( '''insert ignore into tmp_graph (endpoints, counters, ck) values(%s, %s, %s) ON DUPLICATE KEY UPDATE id=LAST_INSERT_ID(id),time_=%s''', (es, cs, ck, datetime.datetime.now())) id_ = cursor.lastrowid if not id_: cursor = db_conn.execute("select id from tmp_graph where ck='" + ck + "'") id_ = cursor.fetchone()[0] db_conn.commit() cursor and cursor.close() return id_
def teardown_request(exception): from rrd.store import dashboard_db_conn as db_conn try: db_conn and db_conn.commit() except ProgrammingError: pass from rrd.store import graph_db_conn try: graph_db_conn and graph_db_conn.commit() except ProgrammingError: pass
def add(cls, title, hosts, counters, screen_id, timespan=3600, graph_type='h', method='', position=0): cursor = db_conn.execute( '''insert into dashboard_graph (title, hosts, counters, screen_id, timespan, graph_type, method, position) values(%s, %s, %s, %s, %s, %s, %s, %s)''', (title, ENDPOINT_DELIMITER.join(hosts) or "", ENDPOINT_DELIMITER.join(counters) or "", screen_id, timespan, graph_type, method, position)) id_ = cursor.lastrowid db_conn.execute( '''update dashboard_graph set position=%s where id=%s''', (id_, id_)) db_conn.commit() cursor and cursor.close() return cls.get(id_)
def update(self, pid=None, name=None): pid = pid or self.pid name = name or self.name db_conn.execute('''update dashboard_screen set pid=%s, name=%s where id=%s''', (pid, name, self.id)) db_conn.commit() return DashboardScreen.get(self.id)
def remove(cls, id): db_conn.execute('''delete from dashboard_screen where id=%s''', (id,)) db_conn.commit()
def add(cls, pid, name): cursor = db_conn.execute('''insert into dashboard_screen (pid, name) values(%s, %s)''', (pid, name)) id_ = cursor.lastrowid db_conn.commit() cursor.close() return cls.get(id_)
def remove(cls, id): db_conn.execute("""delete from dashboard_graph where id=%s""", (id,)) db_conn.commit()
def remove(cls, id): db_conn.execute('''delete from dashboard_graph where id=%s''', (id, )) db_conn.commit()