def g_copy_history(self, endclock):
        lastclock = self._get_lastcopyclock()
        startclock = cf.clockaddminutes(endclock, -D_HISTORY_COPY_CLOCK_RANGE)
        if lastclock <= 0:
            lastclock = startclock
        if startclock > lastclock and lastclock > 0:
            endclock2 = cf.clockaddminutes(lastclock, +D_HISTORY_COPY_CLOCK_RANGE*2)
            endclock = min(endclock, endclock2)
        startclock = startclock

        condlist = ["itemid in (%s)" % ",".join(cf.list2strlist(self._itemids))]
        condlist.append("clock >= %s" % str(startclock))
        condlist.append("clock <= %s" % str(endclock))
        strwhere = sf.list2where(condlist)

        strsql = "select itemid, clock, value from history %s;" % (strwhere)
        if DEBUG:
            print strsql
            cf.log(strsql)

        g_zbx = sf.g_get_data(MYSQL_ZBX, strsql)
        strsql = ""
        for row in g_zbx:
            (itemid, clock, value) = row
            yield row
            strsql = "%sreplace into history (itemid, clock, value) values(%s,%s,%s);\n" \
                % (strsql, itemid, clock, value)
        sf.exec_updsql(MYSQL_JUBATUS, strsql)
        self._upd_lastcopyclock(endclock)
    def remove_history(self, basendclock):
        limitclock = basendclock - D_DATA_KEEP_PERIOD*60
        condlist = ["itemid in (%s)" % ",".join(cf.list2strlist(self._itemids))]
        condlist.append("clock <= %s" % str(limitclock))
        strwhere = sf.list2where(condlist)

        strsql = "delete from history %s;" % (strwhere)

        sf.exec_updsql(MYSQL_JUBATUS, strsql)
Beispiel #3
0
from config import *
from lib.db_connector import *
import lib.sql_funcs as sf

user = confget("mysql_jubatus", "user")
password = confget("mysql_jubatus", "password")
database = confget("mysql_jubatus", "database")


sf.exec_updsql("mysql", "create database if not exists %s;" % (database))
sf.exec_updsql("mysql", "grant select on " + database + ".* to " + user + " identified by '" + password + "';")
sf.create_table("mysql_jubatus", "history")
sf.create_table("mysql_jubatus", "last_clock")
sf.create_table("mysql_jubatus", "target_items")
 def _upd_lastcopyclock(self, clock):
     sf.exec_updsql(MYSQL_JUBATUS, "truncate table last_copy;\ninsert into last_copy(clock) values(%s);" % (str(clock)))