def load_file(request, id): cursor = connection.cursor() sql = """ select tp.name, tp.group, tp.gradation from task_content tc left join task_project tp on tc.project = tp.name and tc.env = tp.gradation where tc.id = '%s' """ % id cursor.execute(sql) row = cursor.fetchone() project, group, percent = row[0], row[1], row[2] #print project, group, percent l = Log(project, group, "%d%%" % percent) content = l.load() return render_to_response("log_view.html", {"config":config, "content":content})
def load_file(request, id): cursor = connection.cursor() sql = """ select tp.name, tp.group, tp.gradation from task_content tc left join task_project tp on tc.project = tp.name and tc.env = tp.gradation where tc.id = '%s' """ % id cursor.execute(sql) row = cursor.fetchone() project, group, percent = row[0], row[1], row[2] #print project, group, percent l = Log(project, group, "%d%%" % percent) content = l.load() return render_to_response("log_view.html", { "config": config, "content": content })
os.putenv('JAVA_HOME', '/usr/local/jdk') os.putenv('PATH', '/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/root/bin:/jre/bin') os.putenv('CLASSPATH', '/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/root/bin:/jre/bin:/lib/tools.jar:/lib/dt.jar') os.putenv('JETTY_HOME', '/usr/local/ctier/pkgs/jetty-6.1.21') os.putenv('CTL_BASE', '/usr/local/ctier/ctl/') id, run_id, project, group, percent, stat = sys.argv[1:] #stat: u(update) ro r(rollback) try: int(percent) except: l = Log(project, group, percent) else: l = Log(project, group, "%s%%" % percent) mysql_conn = Mysql( host = '127.0.0.1', user = '******', password = '******', database = 'autorelease', ) mongo_conn = Mongo( host = '127.0.0.1',
def main(id, run_id, project, group, percent, stat): """ A demo daemon main routine, write a datestamp to /tmp/daemon-log every 10 seconds. """ import time mysql_conn = Mysql( host='127.0.0.1', user='******', password='******', database='autorelease', ) mongo_conn = Mongo( host='127.0.0.1', database='log', table='log_' + id, ) #stat: u(update) ro r(rollback) try: int(percent) except: l = Log(project, group, percent) else: l = Log(project, group, "%s%%" % percent) content = l.load() mongo_conn.drop() mongo_conn.insert( id=id, run_id=run_id, content="", update_time=time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(int(time.time()))) ) while True: content = l.load() result = os.popen("/usr/local/ctier/pkgs/ctl-3.6.1/bin/ctl-queue").read() if run_id in result: mongo_conn.update(condition={'id': id}, data={"content": content}) continue else: mongo_conn.update(condition={'id': id}, data={"content": content}) if stat == 'u': mysql_conn.save( "update task_content set finish_time = '%s', status = '102' where id = '%s'" % (int(time.time()), id)) time.sleep(10) send("", id, project, 102) #history content_result = Content.objects.filter(id=id, project=project, env=percent).order_by('-finish_time').values()[0] h = History( task_id=content_result['id'], type=content_result['type'], project=content_result['project'], env=content_result['env'], run_id=content_result['run_id'], version=content_result['version'], status=content_result['status'], deploy_time=content_result['deploy_time'], finish_time=content_result['finish_time'], create_user=content_result['create_user'], deploy_user=content_result['deploy_user'], ) h.save() elif stat == 'r': mysql_conn.save( "update task_content set finish_time = '%s', status = '105' where id = '%s'" % (int(time.time()), id)) time.sleep(10) rollback_history_id = Rollback.objects.filter(task_id=id).order_by('-start_time').values()[0]['id'] Rollback.objects.filter(id=rollback_history_id, task_id=id).update(finish_time=int(time.time())) send("", id, project, 105) exit() time.sleep(10)