if user is None: return -1 elif user.end_night_rate > user.start_night_rate: if now > user.start_night_rate and now < user.end_night_rate: return 1 else: return 0 else: if now > user.start_night_rate or now < user.end_night_rate: return 1 else: return 0 # Configuration config = Config() # DB initialization database_url = (config.get("database_type") + "://" + config.get("username") + ":" + config.get("password") + "@" + config.get("host") + "/" + config.get("database")) engine = create_engine(database_url, echo=config.get("debug")) create_session = sessionmaker(bind=engine) database.Base.metadata.create_all(engine) try: while True: power = random.randint(0, 4000) power = math.sin(time.clock() * 2)**2 * 2000 print("New encrypted packet:" + str(power))
login = post.get("login") user = db.query(database.User).filter_by(login=login).first() password = ( config.get("salt") + hashlib.sha256(post.get("password", "").encode('utf-8')).hexdigest()) if user and user.password == password: return True else: return False # =============== # Initializations # =============== config = Config() database_url = (config.get("database_type") + "://" + config.get("username") + ":" + config.get("password") + "@" + config.get("host") + "/" + config.get("database")) engine = create_engine(database_url, echo=config.get("debug")) app = Bottle() plugin = sqlalchemy.Plugin(engine, database.Base.metadata, keyword='db', create=True, commit=True, use_kwargs=False) app.install(plugin) session_manager = PickleSession()
login = post.get("login") user = db.query(database.User).filter_by(login=login).first() password = (config.get("salt") + hashlib.sha256(post.get("password", "").encode('utf-8')) .hexdigest()) if user and user.password == password: return True else: return False # =============== # Initializations # =============== config = Config() database_url = (config.get("database_type") + "://" + config.get("username") + ":" + config.get("password") + "@" + config.get("host") + "/" + config.get("database")) engine = create_engine(database_url, echo=config.get("debug")) app = Bottle() plugin = sqlalchemy.Plugin( engine, database.Base.metadata, keyword='db', create=True, commit=True, use_kwargs=False ) app.install(plugin)
return 1 else: return 0 def get_cw_sensor(): """Returns the citizenwatt sensor object or None""" db = create_session() sensor = (db.query(database.Sensor) .filter_by(name="CitizenWatt") .first()) db.close() return sensor # Configuration config = Config() # DB initialization database_url = (config.get("database_type") + "://" + config.get("username") + ":" + config.get("password") + "@" + config.get("host") + "/" + config.get("database")) engine = create_engine(database_url, echo=config.get("debug")) create_session = sessionmaker(bind=engine) database.Base.metadata.create_all(engine) sensor = get_cw_sensor() while not sensor or not sensor.aes_key: tools.warning("Install is not complete ! " + "Visit http://citizenwatt.local first.") time.sleep(1) sensor = get_cw_sensor()
#!/usr/bin/env python3 import bisect import datetime import json import numpy import redis from libcitizenwatt import database from libcitizenwatt import tools from sqlalchemy import asc, desc from libcitizenwatt.config import Config config = Config() def do_cache_ids(sensor, watt_euros, id1, id2, db, force_refresh=False): """ Computes the cache (if needed) for the API call /api/<sensor:int>/get/<watt_euros:re:watts|kwatthours|euros>/by_id/<id1:int>/<id2:int> Returns the stored (or computed) data or None if parameters are invalid. """ r = redis.Redis(decode_responses=True) if not force_refresh: data = r.get(watt_euros + "_" + str(sensor) + "_" + "by_id" + "_" + str(id1) + "_" + str(id2)) if data: # If found in cache, return it return json.loads(data)
if now > user.start_night_rate or now < user.end_night_rate: return 1 else: return 0 def get_cw_sensor(): """Returns the citizenwatt sensor object or None""" db = create_session() sensor = (db.query(database.Sensor).filter_by(name="CitizenWatt").first()) db.close() return sensor # Configuration config = Config() # DB initialization database_url = (config.get("database_type") + "://" + config.get("username") + ":" + config.get("password") + "@" + config.get("host") + "/" + config.get("database")) engine = create_engine(database_url, echo=config.get("debug")) create_session = sessionmaker(bind=engine) database.Base.metadata.create_all(engine) sensor = get_cw_sensor() while not sensor or not sensor.aes_key: tools.warning("Install is not complete ! " + "Visit http://citizenwatt.local first.") time.sleep(1) sensor = get_cw_sensor()
login = post.get("login") user = db.query(database.User).filter_by(login=login).first() password = ( config.get("salt") + hashlib.sha256(post.get("password", "").encode('utf-8')).hexdigest()) if user and user.password == password: return True else: return False # =============== # Initializations # =============== config = Config() #flag = True logger.info(config.get("debug")) database_url = (config.get("database_type") + "://" + config.get("username") + ":" + config.get("password") + "@" + config.get("host") + "/" + config.get("database")) logger.info(database_url) #engine = create_engine(database_url, echo=config.get("debug")) engine = create_engine( "postgresql+psycopg2://citizenwatt:citizenwatt@localhost/citizenwatt") logger.info(engine)
if user is None: return -1 elif user.end_night_rate > user.start_night_rate: if now > user.start_night_rate and now < user.end_night_rate: return 1 else: return 0 else: if now > user.start_night_rate or now < user.end_night_rate: return 1 else: return 0 # Configuration config = Config() # DB initialization database_url = (config.get("database_type") + "://" + config.get("username") + ":" + config.get("password") + "@" + config.get("host") + "/" + config.get("database")) engine = create_engine(database_url, echo=config.get("debug")) create_session = sessionmaker(bind=engine) database.Base.metadata.create_all(engine) try: while True: power = random.randint(0, 4000) power = math.sin(time.clock()*2)**2 * 2000 print("New encrypted packet:" + str(power))