def stock_telescope(self):
cf = ConfigParser.ConfigParser()
cf.read("%s/%s.ini" % (self.Config_path, self.configs['name']) )
host = cf.get("db", "host")
port = cf.get("db", "port")
user = cf.get("db", "user")
password = cf.get("db", "pass")
database = cf.get("db", "database")
conn = Mysql(
host = host,
user = user,
password = password,
database = database,
)
cid = []
if "|" in self.configs['cid']:
for i in self.configs['cid'].split('|'):
cid.append(i.strip())
else:
cid.append(self.configs['cid'])
print cid
now = int(time.time())
result = {}
for appid in cid:
sql_title = "select title from h_appmap where appid = '%s' limit 1" % appid
appmap_row = conn.fetch(sql_title)
if not appmap_row['title']: appmap_row['title'] = appid
line = appmap_row['title']
print line
result[line] = []
rangetime = 1209600
if self.configs['attr'].has_key('rangetime'):
if self.configs['attr']['rangetime'] and '|' in self.configs['attr']['rangetime']:
rangetime = self.configs['attr']['rangetime'].split('|')[1]
times = re.search("^([0-9]+)([a-z|A-Z]+)", rangetime)
n, m = int(times.group(1)), times.group(2)
if m == 'h':
m = 3600
elif m == 'd':
m = 86400
elif m == 'w':
m = 604800
rangetime = n*m
print rangetime
sql_data = "select timestamp, value from h_data where appid = '%s' and timestamp > %d order by timestamp" % (appid, now-rangetime)
data_rows = conn.fetchall(sql_data)
for row in data_rows:
result[line].append([int(row['timestamp']*1000), int(row['value'])])
#print result
return self.highstock(result, self.configs['id'], self.configs['attr'])
from controltier.node import Node
from tools.mysql import Mysql
mysql_conn = Mysql(
host = '127.0.0.1',
user = '******',
password = '******',
database = 'autorelease',
)
now = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(int(time.time())))
for project in os.listdir('/usr/local/ctier/ctl/projects'):
n = Node(project)
for k, v in n.analysis().iteritems():
result = mysql_conn.fetch("select count(id) from project_node where project = '%s' and hostname = '%s'" % (project, v['hostname']))
if result['count(id)']:
mysql_conn.save("""
update project_node set
name = '{name}',
description = '{description}',
tags = '{tags}',
ctlusername = '******',
osfamily = '{osfamily}',
osname = '{osname}',
osarch = '{osarch}',
osversion = '{osversion}',
updatetime = '{updatetime}'
where project = '{project}' and hostname = '{hostname}'
""".format(
project = project,
