Example #1
0
#!/usr/bin/env python
# coding:utf8
# Created on 2016-5-21
# @author: yi.zhiwu

import json
from time import sleep
from fabric.api import env, roles, run, execute, cd, run, env, hosts
from dbpool import DBPool

# 数据库配置
config = json.load(open('config.json', 'r'))
adminPool = DBPool()
adminPool.initPool(config['admin'])
CONFIG_DB_NAME = config['admin']['db']

queryResult = adminPool.querySql("select * from tb_server", True)
hot_list = {}
# hot_list = {"1": ['[email protected]:22']}
role = []
for ca in queryResult:
    service_id = str(ca['id']) + str(ca['tcpPort'])[-2:]
    hot_list[service_id] = ["appuser@" + ca['hostIP'] + ':22']
    role.append(service_id)

env.roledefs = hot_list

env.password = '******'  # 服务器统一密码

# env.password = '******'  # 服务器统一密码