Esempio n. 1
0
 def save_regist_user(form):
     session = ORM.db()
     flag = True
     try:
         user = User(
             name=form.data['name'],
             pwd=generate_password_hash(form.data['pwd']),
             email=form.data['email'],
             phone=form.data['phone'],
             sex=None,
             constellation=None,
             face=None,
             info=None,
             createAt=get_datetime(),
             updateAt=get_datetime(),
         )
         session.add(user)
     except Exception as e:
         session.rollback()
         flag = False
     else:
         session.commit()
     finally:
         session.close()
     return flag
Esempio n. 2
0
 def on_message(self, message):
     session = ORM.db()
     try:
         data = dict()
         if message == "system":
             kw = session.query(Kongqiwendu).order_by(
                 Kongqiwendu.create_dt.desc()).first()
             ks = session.query(Kongqishidu).order_by(
                 Kongqishidu.create_dt.desc()).first()
             tw = session.query(Turangwendu).order_by(
                 Turangwendu.create_dt.desc()).first()
             ts = session.query(Turangshidu).order_by(
                 Turangshidu.create_dt.desc()).first()
             gq = session.query(Guangzhao).order_by(
                 Guangzhao.create_dt.desc()).first()
             data = dict(
                 kongqiwendu=str(kw.percent),
                 nt=str(kw.create_dt),
                 kongqishidu=str(ks.percent),
                 turangwendu=str(tw.percent),
                 turangshidu=str(ts.percent),
                 guangzhao=str(gq.percent),
             )
         #把消息推送到虽有连接客户端
         self.broadcast(self.waiters, json.dumps(data))
     except Exception as e:
         print(e)
Esempio n. 3
0
 def data_mm(self, method="Day", format="%Y%m%d%H"):
     session = ORM.db()
     attr_kongqiwendu, vals_kongqiwendu_max, vals_kongqiwendu_min, vals_kongqiwendu_avg = None, None, None, None
     attr_kongqishidu, vals_kongqishidu_max, vals_kongqishidu_min, vals_kongqishidu_avg = None, None, None, None
     attr_turangwendu, vals_turangwendu_max, vals_turangwendu_min, vals_turangwendu_avg = None, None, None, None
     attr_turangshidu, vals_turangshidu_max, vals_turangshidu_min, vals_turangshidu_avg = None, None, None, None
     attr_guangzhao, vals_guangzhao_max, vals_guangzhao_min, vals_guangzhao_avg = None, None, None, None
     try:
         #空气温度
         kongqiwendu = self.three_query(Kongqiwendu, session, method,
                                        format)
         attr_kongqiwendu = [v[0] for v in kongqiwendu]
         vals_kongqiwendu_max = [float(v[1]) for v in kongqiwendu]
         vals_kongqiwendu_min = [float(v[2]) for v in kongqiwendu]
         vals_kongqiwendu_avg = [round(float(v[3]), 1) for v in kongqiwendu]
         # 空气湿度
         kongqishidu = self.three_query(Kongqishidu, session, method,
                                        format)
         attr_kongqishidu = [v[0] for v in kongqishidu]
         vals_kongqishidu_max = [float(v[1]) for v in kongqishidu]
         vals_kongqishidu_min = [float(v[2]) for v in kongqishidu]
         vals_kongqishidu_avg = [round(float(v[3]), 1) for v in kongqishidu]
         # 土壤温度
         turangwendu = self.three_query(Turangwendu, session, method,
                                        format)
         attr_turangwendu = [v[0] for v in turangwendu]
         vals_turangwendu_max = [float(v[1]) for v in turangwendu]
         vals_turangwendu_min = [float(v[2]) for v in turangwendu]
         vals_turangwendu_avg = [round(float(v[3]), 1) for v in turangwendu]
         # 土壤湿度
         turangshidu = self.three_query(Turangshidu, session, method,
                                        format)
         attr_turangshidu = [v[0] for v in turangshidu]
         vals_turangshidu_max = [float(v[1]) for v in turangshidu]
         vals_turangshidu_min = [float(v[2]) for v in turangshidu]
         vals_turangshidu_avg = [round(float(v[3]), 1) for v in turangshidu]
         # 光照强度
         guangzhao = self.three_query(Guangzhao, session, method, format)
         attr_guangzhao = [v[0] for v in guangzhao]
         vals_guangzhao_max = [float(v[1]) for v in guangzhao]
         vals_guangzhao_min = [float(v[2]) for v in guangzhao]
         vals_guangzhao_avg = [round(float(v[3]), 1) for v in guangzhao]
     except Exception as e:
         session.rollback()
     else:
         session.commit()
     finally:
         session.close()
     return attr_kongqiwendu,vals_kongqiwendu_max,vals_kongqiwendu_min,vals_kongqiwendu_avg, \
         attr_kongqishidu, vals_kongqishidu_max, vals_kongqishidu_min, vals_kongqishidu_avg, \
         attr_turangwendu, vals_turangwendu_max, vals_turangwendu_min, vals_turangwendu_avg, \
         attr_turangshidu, vals_turangshidu_max, vals_turangshidu_min, vals_turangshidu_avg, \
         attr_guangzhao, vals_guangzhao_max, vals_guangzhao_min, vals_guangzhao_avg
Esempio n. 4
0
 def post(self, *args, **kwargs):
     account = self.get_argument('username')
     passwd = self.get_argument('password')
     session = ORM.db()
     rows = session.query(User).filter(User.name==account)
     if rows:
         name = [v.name for v in rows]
         passw = [v.passwd for v in rows]
         if account==name[0] and passwd==passw[0]:
             self.write('ok')
         else:
             self.write("noeq")
Esempio n. 5
0
 def get_response(self):
     id = self.get_argument('id')
     nzt = self.get_argument('zt')
     session = ORM.db()
     kw = session.query(Facility).filter(Facility.id == id).first()
     if nzt == "打开":
         if kw.stat == "打开":
             kw.stat = "关闭"
             session.commit()
             session.close()
         else:
             pass
     ret = {'states': '成功', 'message': ''}
     self.write(json.dumps(ret))
Esempio n. 6
0
 def post(self, *args, **kwargs):
     account = self.get_argument('zhanghao')
     passwd = self.get_argument('passwd')
     session = ORM.db()
     rows = session.query(User).filter(User.name==account)
     if rows:
         name = [v.name for v in rows]
         passw = [v.passwd for v in rows]
         if account==name[0] and passwd==passw[0]:
             self.redirect('/')
         else:
             self.write("<h1>账号或密码错误</h1>")
     else:
         self.write("<h1>账号或密码错误</h1>")
Esempio n. 7
0
def save_log():
    """保存日志的函数"""
    m = Monitor()
    cpu_info, swap_info, mem_info = m.cpu(), m.swap(), m.mem()
    _date_time, _date, _time = dt()
    # 1.创建会话
    session = ORM.db()
    try:
        # cpu
        cpu = Cpu(
            percent=cpu_info['percent_avg'],
            create_date=_date,
            create_time=_time,
            create_dt=_date_time,
        )
        # 交换分区
        swap = Swap(
            percent=swap_info['percent'],
            total=swap_info['total'],
            used=swap_info['used'],
            free=swap_info['free'],
            create_date=_date,
            create_time=_time,
            create_dt=_date_time,
        )
        # 内存
        mem = Mem(
            percent=mem_info['percent'],
            total=mem_info['total'],
            used=mem_info['used'],
            free=mem_info['free'],
            create_date=_date,
            create_time=_time,
            create_dt=_date_time,
        )

        # 提交至数据库
        session.add(cpu)
        session.add(swap)
        session.add(mem)
    except Exception as e:
        session.rollback()  # 出错回滚
        print('出错回滚:{}'.format(e))
    else:
        session.commit()  # 正常,提交
        print('正常,提交')
    finally:
        session.close()  # 关闭会话
        print('关闭会话')
Esempio n. 8
0
 def data_by_hour(self):
     now_time, next_time = self.dt_range()
     attr_kongqiwendu, attr_kongqishidu, attr_turangwendu, attr_turangshidu, attr_guangzhao = None, None, None, None, None
     vals_kongqiwendu, vals_kongqishidu, vals_turangwendu, vals_turangshidu, vals_guangzhao = None, None, None, None, None
     session = ORM.db()
     try:
         #空气温度
         kw = self.one_hour_query(Kongqiwendu, session, now_time, next_time)
         if kw:
             attr_kongqiwendu = [
                 v.create_time.strftime("%H:%M:%S") for v in kw
             ]
             vals_kongqiwendu = [float(v.percent) for v in kw]
         # 空气湿度
         ks = self.one_hour_query(Kongqishidu, session, now_time, next_time)
         if ks:
             attr_kongqishidu = [
                 v.create_time.strftime("%H:%M:%S") for v in ks
             ]
             vals_kongqishidu = [float(v.percent) for v in ks]
         # 土壤温度
         tw = self.one_hour_query(Turangwendu, session, now_time, next_time)
         if tw:
             attr_turangwendu = [
                 v.create_time.strftime("%H:%M:%S") for v in tw
             ]
             vals_turangwendu = [float(v.percent) for v in tw]
         # 土壤湿度
         ts = self.one_hour_query(Turangshidu, session, now_time, next_time)
         if ts:
             attr_turangshidu = [
                 v.create_time.strftime("%H:%M:%S") for v in ts
             ]
             vals_turangshidu = [float(v.percent) for v in ts]
         #光照强度
         gq = self.one_hour_query(Guangzhao, session, now_time, next_time)
         if gq:
             attr_guangzhao = [
                 v.create_time.strftime("%H:%M:%S") for v in gq
             ]
             vals_guangzhao = [float(v.percent) for v in gq]
     except Exception as e:
         session.rollback()
     else:
         session.commit()
     finally:
         session.close()
     return attr_kongqiwendu, attr_kongqishidu, attr_turangshidu, attr_turangwendu, attr_guangzhao, vals_guangzhao, vals_kongqiwendu, vals_turangshidu, vals_turangwendu, vals_kongqishidu
Esempio n. 9
0
def save_log():
    m = SysInfoMonitor()
    cpu_info, mem_info, swap_info = m.cpuinfo(), m.meminfo(), m.swapinfo()
    _date, _time, _date_time = dt()
    # 1.create session
    session = ORM.db()
    try:
        # CPU
        cpu = Cpu(
            percent=cpu_info["percent_avg"],
            create_date=_date,
            create_time=_time,
            create_dt=_date_time
        )
        # memory
        mem = Mem(
            percent=mem_info['percent'],
            total=mem_info['total'],
            used=mem_info['used'],
            free=mem_info['free'],
            create_date=_date,
            create_time=_time,
            create_dt=_date_time
        )
        # swap
        swap = Swap(
            percent=swap_info['percent'],
            total=swap_info['total'],
            used=swap_info['used'],
            free=swap_info['free'],
            create_date=_date,
            create_time=_time,
            create_dt=_date_time
        )
        # commit to db
        session.add(cpu)
        session.add(mem)
        session.add(swap)
    except Exception as e:
        #rollback
        session.rollback()
    else:
        session.commit()
    finally:
        session.close()
Esempio n. 10
0
def save_log():
    #空气温度湿度 土壤温度湿度 光照强度
    _date, _time, _date_time = dt()
    #1创建会话
    session = ORM.db()
    try:
        # 空气温度
        kongqiwendu = Kongqiwendu(percent=random.uniform(0, 35),
                                  create_date=_date,
                                  create_time=_time,
                                  create_dt=_date_time)
        # 空气湿度
        kongqishidu = Kongqishidu(percent=random.uniform(0, 100),
                                  create_date=_date,
                                  create_time=_time,
                                  create_dt=_date_time)
        # 土壤温度
        turangwendu = Turangwendu(percent=random.uniform(15, 35),
                                  create_date=_date,
                                  create_time=_time,
                                  create_dt=_date_time)
        # 土壤湿度
        turangshidu = Turangshidu(percent=random.uniform(-20, 55),
                                  create_date=_date,
                                  create_time=_time,
                                  create_dt=_date_time)
        # 光照强度
        guangzhao = Guangzhao(percent=random.uniform(0, 2000),
                              create_date=_date,
                              create_time=_time,
                              create_dt=_date_time)
        # 提交至数据块
        session.add(kongqiwendu)
        session.add(kongqishidu)
        session.add(turangwendu)
        session.add(turangshidu)
        session.add(guangzhao)
    except Exception as e:
        session.rollback()
        print(e)
    else:
        session.commit()
    finally:
        session.close()
Esempio n. 11
0
def save_log():
    m = Monitor()
    cpu_info, mem_info, swap_info = m.cpu(), m.mem(), m.swap()
    _date, _time, _date_time = dt()
    # 1.创建会话
    session = ORM.db()
    try:
        # CPU
        cpu = Cpu(
            percent=cpu_info["percent_avg"],
            create_date=_date,
            create_time=_time,
            create_dt=_date_time
        )
        # 内存
        mem = Mem(
            percent=mem_info['percent'],
            total=mem_info['total'],
            used=mem_info['used'],
            free=mem_info['free'],
            create_date=_date,
            create_time=_time,
            create_dt=_date_time
        )
        # 交换分区
        swap = Swap(
            percent=swap_info['percent'],
            total=swap_info['total'],
            used=swap_info['used'],
            free=swap_info['free'],
            create_date=_date,
            create_time=_time,
            create_dt=_date_time
        )
        # 提交至数据块
        session.add(cpu)
        session.add(mem)
        session.add(swap)
    except Exception as e:
        session.rollback()  # 如果发送异常回滚
    else:
        session.commit()  # 没有异常提交
    finally:
        session.close()  # 无论是否发生异常关闭
Esempio n. 12
0
    def data_by_hour(self):
        """获取一小时内的数据"""
        now_time, last_time = self.date_range()
        attr_cpu, attr_swap, attr_mem = None, None, None  # 属性
        vals_cpu, vals_swap, vals_mem = None, None, None  # 值

        session = ORM.db()
        try:
            # cpu
            cpu = self.one_hour_query(model=Cpu,
                                      session=session,
                                      now_time=now_time,
                                      last_time=last_time)
            if cpu:
                attr_cpu = [v.create_time.strftime("%H:%M:%S") for v in cpu]
                vals_cpu = [float(v.percent) for v in cpu]

            # 交换区
            swap = self.one_hour_query(model=Swap,
                                       session=session,
                                       now_time=now_time,
                                       last_time=last_time)
            if swap:
                attr_swap = [v.create_time.strftime("%H:%M:%S") for v in swap]
                vals_swap = [float(v.percent) for v in swap]

            # 内存
            mem = self.one_hour_query(model=Mem,
                                      session=session,
                                      now_time=now_time,
                                      last_time=last_time)
            if mem:
                attr_mem = [v.create_time.strftime("%H:%M:%S") for v in mem]
                vals_mem = [float(v.percent)
                            for v in mem]  # decimal不能转化为json,需要转换为float
        except Exception as e:
            session.rollback()
        else:
            session.commit()
        finally:
            session.close()

        return attr_cpu, attr_swap, attr_mem, vals_cpu, vals_swap, vals_mem
Esempio n. 13
0
 def user_unique(data, flag=1):
     session = ORM.db()
     user = None
     try:
         query = session.query(User)
         if 1 == flag:  # flag=1 检查用户名是否存在
             user = query.filter_by(name=data).first()
         if 2 == flag:  # flag=2 检查邮箱是否存在
             user = query.filter_by(email=data).first()
         if 3 == flag:  # flag=3 检查手机是否存在
             user = query.filter_by(phone=data).first()
     except Exception as e:
         session.rollback()
     else:
         session.commit()
     finally:
         session.close()
     if user:
         return True
     else:
         return False
Esempio n. 14
0
 def data_by_three(self, method='day', format="%Y-%m-%d %H"):
     """按照小时和天查询今天和本月最大最小值"""
     session = ORM.db()
     attr_mem, vals_mem_min, vals_mem_max, vals_mem_avg = None, None, None, None
     attr_swap, vals_swap_min, vals_swap_max, vals_swap_avg = None, None, None, None
     attr_cpu, vals_cpu_min, vals_cpu_max, vals_cpu_avg = None, None, None, None
     try:
         # 内存
         mem = self.three_query(Mem, session, method, format)
         if mem:
             attr_mem = [v[0] for v in mem]
             vals_mem_min = [float(v[1]) for v in mem]
             vals_mem_max = [float(v[2]) for v in mem]
             vals_mem_avg = [round(float(v[3]), 1) for v in mem]
         # 交换分区
         swap = self.three_query(Swap, session, method, format)
         if swap:
             attr_swap = [v[0] for v in swap]
             vals_swap_min = [float(v[1]) for v in swap]
             vals_swap_max = [float(v[2]) for v in swap]
             vals_swap_avg = [round(float(v[3]), 1) for v in swap]
         # CPU
         cpu = self.three_query(Cpu, session, method, format)
         if cpu:
             attr_cpu = [v[0] for v in cpu]
             vals_cpu_min = [float(v[1]) for v in cpu]
             vals_cpu_max = [float(v[2]) for v in cpu]
             vals_cpu_avg = [round(float(v[3]), 1) for v in cpu]
     except Exception as e:
         print('获取失败:{}'.format(e))
         session.rollback()
     else:
         session.commit()
     finally:
         session.close()
     return attr_mem, vals_mem_min, vals_mem_max, vals_mem_avg, \
            attr_swap, vals_swap_min, vals_swap_max, vals_swap_avg, \
            attr_cpu, vals_cpu_min, vals_cpu_max, vals_cpu_avg
Esempio n. 15
0
    def data_by_hour(self):
        now_time, next_time = self.dt_range()
        attr_cpu, attr_mem, attr_swap = None, None, None  # 属性
        vals_cpu, vals_mem, vals_swap = None, None, None  # 值
        session = ORM.db()  # 创建会话
        try:
            # 执行代码块
            # 内存
            mem = self.one_hour_query(Mem, session, now_time, next_time)
            if mem:
                attr_mem = [v.create_time.strftime("%H:%M:%S") for v in mem]
                vals_mem = [float(v.percent) for v in mem]

            # 交换分区
            swap = self.one_hour_query(Swap, session, now_time, next_time)
            if swap:
                attr_swap = [v.create_time.strftime("%H:%M:%S") for v in swap]
                vals_swap = [float(v.percent) for v in swap]

            # CPU
            cpu = self.one_hour_query(Cpu, session, now_time, next_time)
            if cpu:
                attr_cpu = [v.create_time.strftime("%H:%M:%S") for v in cpu]
                vals_cpu = [float(v.percent) for v in cpu]

        except Exception as e:
            # 发生异常
            session.rollback()  # 回滚
        else:
            # 没有发生异常
            session.commit()  # 提交会话
        finally:
            # 无论是否发生异常都要执行
            session.close()  # 关闭会话

        return attr_cpu, attr_mem, attr_swap, vals_cpu, vals_mem, vals_swap
Esempio n. 16
0
 def get_response(self):
     session = ORM.db()
     data = session.query(Facility).filter(Facility.kind == '光照').all()
     self.html("faci_gunag.html", data1=dict(faci=data))
Esempio n. 17
0
 def get_response(self):
     session = ORM.db()
     data = session.query(Facility).all()
     auto = session.query(AutoFaci).one()
     self.html("faci.html", data1=dict(faci=data, auto=auto))
Esempio n. 18
0
from app.models.models import Kongqishidu, Kongqiwendu, Turangshidu, Turangwendu, Guangzhao
from app.tools.orm import ORM

session = ORM.db()
kw = session.query(Kongqiwendu).order_by(Kongqiwendu.create_dt.desc()).first()
print(kw.percent)