# -*- coding: utf-8 -*- import pyutil.common.sys_utf8 as utf8 import os import sys import json import pyutil.db.mellow as mellow import pyconf.db.manna_apps as manna_apps mysql = mellow.mellow(manna_apps.config) def parse(pid, modules): records = [] for module in modules: record = {} record["module_id"] = module["id"] record.update({ k: module[k] for k in module if k in ["name", "route", "type", "desc"] }) record["module_pid"] = pid record["auth"] = module["authorization"] records.append(record) if module.get("children"): records.extend(parse(module["id"], module["children"])) return records if __name__ == '__main__':
#!/usr/local/bin/python # -*- coding: utf8 -*- from flask import request from flask_restful import Resource, reqparse import json import math from pyutil.db.mellow import mellow from dotage.fire_investigation_dbconfig import config as dbconfig mellow = mellow(dbconfig) parser = reqparse.RequestParser() parser.add_argument('data', type=str) ${WHO}_TABLE_NAME = '${table_name}' class ${WHO}ListApi(Resource): def get(self): result = {} count = int(query_dict.get("size", 20)) start = int(query_dict.get("page", 0)*count) fields = ${table_name}.get("filter") query_dict = dict(filter(lambda x: x[0] in fields, request.args.items())) result['data'] = mellow.Find( ${WHO}_TABLE_NAME, [], query_dict, limit=(start,count), out=dict ) result['total'] = mellow.Count( ${WHO}_TABLE_NAME, query_dict ) result['code'] = 1 result['msg'] = '' return result, 201 def post(self): result = {}
import pyutil.common.sys_utf8 as sys_utf8 import pyutil.db.mellow as mellow import pyconf.db.realtime_db as realtime_db mysql = mellow.mellow(realtime_db.config) class center: def get_info(self, id): row = mysql.Find("info_center", [], {"id": id}, out=dict) return row def get_company_ids(self): company_ids = [] for row in self.mysql.Find("relation_company_center", [ "company_id", ], {"center_id": center_id}, out=list): if not row[0]: continue company_ids.append(row[0]) return company_ids if __name__ == '__main__': print sys_utf8.Utf8(center().get_info(1101004))
def __init__(self): self.mysql = mellow.mellow(manna.config) self.mysql_old = mellow.mellow(realtime_db.config) self.dtu_protocol_map = {}
#!/usr/local/bin/python # -*- coding: utf8 -*- ''' code generated by dotage on ${TIME} ''' import pyutil.common.sys_utf8 as utf8 import storage_api.manna_statistic.lib.settings as settings import storage_api.lib.thing as thing from pyutil.common.singleton import singleton @singleton class ${table_name}(thing.thing): def __init__(self, dbproxy, redis): self.redis_cache = redis self.dbproxy = dbproxy self.TABLE_NAME = "${table_name}" self.TABLE_ID = "${table_id}" self.all = {} if settings.LOAD: self.load() if __name__ == '__main__': import pyutil.db.mellow as mellow import pyconf.db.manna_statistic as manna_statistic from pyutil.fb_redis.redis_cache import redis_cache import pyconf.redis.redis as redis_conf mysql = mellow.mellow(manna_statistic.config) redis = redis_cache(config_dic = redis_conf.config) print utf8.Utf8(${table_name}(mysql, redis).get(1))
ret = excel_read_xlrd.read_excel( u'/Users/gunther/Desktop/import_maint_equips.xls', sheet_name="Sheet1") # excel_read_xlrd.Print(ret["Sheet1"], indent=4) enum_system_list, enum_sub_system_list, enum_equip_type_list, enum_equip_check_item_list = equip_importer.assemble_mt_equips( ret["Sheet1"]) db_config_local = { "host": "127.0.0.1", "port": 3306, "database": "manna_maint", "user": "******", "password": "******", "charset": "utf8", } db_config_dev = { "host": "172.16.15.252", "port": 3366, "database": "manna_maint", "user": "******", "password": "******", "charset": "utf8", } mysql = mellow.mellow(db_config_dev) equip_importer.insert_list(mysql, "enum_system_type", enum_system_list) equip_importer.insert_list(mysql, "enum_sub_system_type", enum_sub_system_list) equip_importer.insert_list(mysql, "enum_equip_type", enum_equip_type_list) equip_importer.insert_list(mysql, "enum_equip_check_item", enum_equip_check_item_list)
def __init__(self): self.class_name = self.__class__.__name__ self.mysql = mellow.mellow(dbconfig_realtime_shenyang.config)
# -*- coding: utf-8 -*- import pyutil.common.sys_utf8 import pyutil.db.mellow as mellow import pyconf.db.realtime_shenyang as realtime_shenyang import pyconf.db.realtime_db as realtime_db import time import sys start = time.time() mysql_w = mellow.mellow(realtime_db.config_w) if len(sys.argv)==2 and sys.argv[1] == "shenyang": mysql_w = mellow.mellow(realtime_shenyang.config_w) print "cost:", time.time() - start
# -*- coding: utf-8 -*- import pyutil.db.mellow as mellow import pyconf.db.manna as manna mysql = mellow.mellow(manna.config) def main(): water_cover = { "thing_id": 31290890999, "thing_type": "info_device_dtu", "equipment_id": 123981, "enum_device_class": 10011, "enum_device_type": 10008, "enum_device_model": 10008, "enum_device_status": 402 } water_cover_index = { "thing_id": 31290890999, "thing_type": "info_device_dtu" } water_press = { "thing_id": 31290890888, "thing_type": "info_device_dtu", "equipment_id": 123981, "enum_device_class": 10011, "enum_device_type": 10003, "enum_device_model": 10003,
import pyutil.db.mellow as mellow if __name__ == '__main__': import pyutil.db.db_config_example as db_config_example mellow = mellow.mellow(db_config_example.config) print mellow.Update("user", {"name": "1111"}, {"id": 4}) print mellow.Find("user", ["`id`", "name as uame"], limit=(2, 2), out=dict)
import pyutil.db.mellow as mellow import pyutil.db.db_config_example as config mellow = mellow.mellow(config.config) def main(): rows = mellow.Find("user", [], out=dict) print rows mellow.Insert("user", {"name": "liuzhuohua", "age": 12, "weight": 123.2}) mellow.Insert("user", {"name": "zhuohua", "age": 12, "weight": 123.2}) mellow.Delete("user", {"name": "zhuohua"}) print mellow.Find("user", [], "name='liuzhuohua'", out=dict) print mellow.FieldInt("user", "id", "name='must'", default=-1) if __name__ == '__main__': main()