Esempio n. 1
0
    def find_infos(self, activity_name, city):
        """
        Shows all the installations, equipments and activities which match the given activity and city
        """
        database = Database('data/database.db')

        infos = database.get_infos(activity_name, city)
        view = Template(filename="view/template.html", lookup=lookup)

        try:
            render = view.render(
                rows=[[
                    item[0].number, item[0].name, item[1].number, item[1].name,
                    item[2].number, item[2].name
                ] for item in infos],
                pageTitle="Informations pour " + activity_name + " à " + city,
                tableTitle="Informations pour " + activity_name + " à " + city,
                ths=[
                    "Numéro d'installation", "Nom d'installation",
                    "Numéro d'équipement", "Nom d'équipement",
                    "Numéro d'activité", "Nom d'activité"
                ])
        except AttributeError:
            render = view.render(
                rows=[],
                pageTitle="Informations pour " + activity_name + " à " + city,
                tableTitle="Informations pour " + activity_name + " à " + city,
                ths=[
                    "Numéro d'installation", "Nom d'installation",
                    "Numéro d'équipement", "Nom d'équipement",
                    "Numéro d'activité", "Nom d'activité"
                ])

        return render
Esempio n. 2
0
	def display_Installations(self):
		"""
		Displays all installations
		"""
		html = self.add_HTML_header('Installations')
		css = Template(filename="include/css.html")
		html += (css.render())
		database = Database('data/database.db')
		insts = database.read_Installations()
		html += '''<h2>Tableau des installations</h2>
			 <table border=1>
			 	<tr>
			 		<th>Numéro</th>
			 		<th>Nom</th>
			 		<th>Adresse</th>
			 		<th>Code postal</th>
			 		<th>Ville</th>
			 		<th>Latitude</th>
			 		<th>Longitude</th>
			 	</tr>\n'''
		for i in insts:
			html += '''<tr>\n
					<td>''' + str(i.number) + '''</td>
					<td>''' + i.name + '''</td>
					<td>''' + i.address + '''</td>
					<td>''' + str(i.zipCode) + '''</td>
					<td>''' + i.city + '''</td>
					<td>''' + str(i.latitude) + '''</td>
					<td>''' + str(i.longitude) + '''</td>
				</tr>'''
		html += '''</table>'''
		return html
Esempio n. 3
0
	def display_One_Installation(self, number):
		"""
		Display one installation
		"""
		html = self.add_HTML_header('Installations ' + number)
		css = Template(filename="include/css.html")
		html += (css.render())
		database = Database('data/database.db')
		inst = database.read_One_Installation(number)
		html += '''<h2>Installation n°''' + number + '''</h2>
			<table border=1>
				<tr>
					<th>Numéro</th>
					<th>Nom</th>
					<th>Adresse</th>
					<th>Code postal</th>
					<th>Ville</th>
					<th>Latitude</th>
					<th>Longitude</th>
				</tr>'''
                
		html += '''<tr>
				<td>''' + str(inst.number) + '''</td>
				<td>''' + inst.name + '''</td>
				<td>''' + inst.address + '''</td>
				<td>''' + str(inst.zipCode) + '''</td>
				<td>''' + inst.city + '''</td>
				<td>''' + str(inst.latitude) + '''</td>
				<td>''' + str(inst.longitude) + '''</td>
			</tr>'''
		html += '''</table>'''
		return html
Esempio n. 4
0
    def show_installation(self, number):
        """
        Shows the installation which has the given number from the database
        """
        database = Database('data/database.db')
        inst = database.read_installation(number)
        view = Template(filename="view/template.html", lookup=lookup)

        try:
            render = view.render(rows=[[
                inst.number, inst.name, inst.address, inst.zip_code, inst.city,
                inst.latitude, inst.longitude
            ]],
                                 pageTitle="Installation " + number,
                                 tableTitle="Installation " + number,
                                 ths=[
                                     "Numéro", "Nom", "Adresse", "Code postal",
                                     "Ville", "Latitude", "Longitude"
                                 ])
        except AttributeError:
            render = view.render(rows=[],
                                 pageTitle="Installation " + number,
                                 tableTitle="Installation " + number,
                                 ths=[
                                     "Numéro", "Nom", "Adresse", "Code postal",
                                     "Ville", "Latitude", "Longitude"
                                 ])

        return render
Esempio n. 5
0
	def display_Informations(self, activity, city):
		"""
		Display informations about an activity and a city
		"""
		html = self.add_HTML_header("Recherche de l'activité " + activity + " dans " + city)
		css = Template(filename="include/css.html")
		html += (css.render())
		database = Database('data/database.db')
		query = database.read_Informations(activity, city)
		html += '''<h2>Résultat de la recherche</h2>
			<table border=1>
				<tr>
					<th>Numéro de l'installation</th>
					<th>Nom de l'installation</th>
					<th>Numéro de l'équipement</th>
					<th>Nom de l'équipement</th>
					<th>Numéro de l'activité</th>
					<th>Nom de l'activité</th>
				</tr>'''
                
		html += '''<tr>'''
		for q in query:
			html += '''<td>''' + q[0].number + '''</td>'''
			html += '''<td>''' + q[1].name + '''</td>'''
				#<td>''' + query[0].number + '''</td>
				#<td>''' + query[0].name + '''</td>
				#<td>''' + query[1].number + '''</td>
				#<td>''' + query[1].name + '''</td>
				#<td>''' + query[2].number + '''</td>
				#<td>''' + query[2].name + '''</td>
		html +=	'''</tr>'''
		html += '''</table>'''
		return html
Esempio n. 6
0
    def show_activities(self):
        """
        Shows all the activities from the database
        """
        database = Database('data/database.db')
        activities = database.read_activities()
        view = Template(filename="view/template.html", lookup=lookup)

        return view.render(rows=[[item.number, item.name]
                                 for item in activities],
                           pageTitle="Activités",
                           tableTitle="Liste de toutes les activités",
                           ths=["Numéro", "Nom"])
Esempio n. 7
0
    def show_equipments(self):
        """
        Shows all the equipments from the database
        """
        database = Database('data/database.db')
        equipments = database.read_equipments()
        view = Template(filename="view/template.html", lookup=lookup)

        return view.render(
            rows=[[item.number, item.name, item.installation_number]
                  for item in equipments],
            pageTitle="Équipements",
            tableTitle="Liste de tous les équipements",
            ths=["Numéro", "Nom", "Numéro d'installation"])
Esempio n. 8
0
 def __init__(self, args):
     self._args = args
     self._logger = logging.getLogger(__name__)
     self._config = Configuration()
     self._ofx_parser = OFXParser(self._config)
     self._db = Database()
     self._fs = FileSystem()
Esempio n. 9
0
    def show_installations(self):
        """
        Shows all the installations from the database
        """
        database = Database('data/database.db')
        installations = database.read_installations()
        view = Template(filename="view/template.html", lookup=lookup)

        return view.render(rows=[[
            item.number, item.name, item.address, item.zip_code, item.city,
            item.latitude, item.longitude
        ] for item in installations],
                           pageTitle="Installations",
                           tableTitle="Liste de toutes les installations",
                           ths=[
                               "Numéro", "Nom", "Adresse", "Code postal",
                               "Ville", "Latitude", "Longitude"
                           ])
Esempio n. 10
0
    async def render_put(self, request):
        data = json.loads(request.payload)\
        # TODO check if ip it's the same

        changed = True

        if data.get("brightness"):
            Database().influx_write_brightness(self._light.order,
                                               data.get("brightness"),
                                               datetime.utcnow())

        if data.get("proximity"):
            Database().influx_write_proximity(self._light.order,
                                              data.get("proximity"),
                                              datetime.utcnow())

        self.seen()

        return aiocoap.Message(code=aiocoap.CHANGED, token=request.token)
Esempio n. 11
0
    def show_activity(self, number):
        """
        Shows the activity which has the given number from the database
        """
        database = Database('data/database.db')
        activ = database.read_activity(number)
        view = Template(filename="view/template.html", lookup=lookup)

        try:
            render = view.render(rows=[[activ.number, activ.name]],
                                 pageTitle="Activité " + number,
                                 tableTitle="Activité " + number,
                                 ths=["Numéro", "Nom"])
        except AttributeError:
            render = view.render(rows=[],
                                 pageTitle="Activité " + number,
                                 tableTitle="Activité " + number,
                                 ths=["Numéro", "Nom"])

        return render
Esempio n. 12
0
def init_resource_database():
    from services.database import Database
    from resources.models import StreetLight, Mode, Range

    db = Database().db
    db.connect()
    db.create_tables([StreetLight, Mode, Range])
Esempio n. 13
0
    def show_equipment(self, number):
        """
        Shows the equipment which has the given number from the database
        """
        database = Database('data/database.db')
        equip = database.read_equipment(number)
        view = Template(filename="view/template.html", lookup=lookup)

        try:
            render = view.render(
                rows=[[equip.number, equip.name, equip.installation_number]],
                pageTitle="Équipement " + number,
                tableTitle="Équipement " + number,
                ths=["Numéro", "Nom", "Numéro d'installation"])
        except AttributeError:
            render = view.render(
                rows=[],
                pageTitle="Équipement " + number,
                tableTitle="Équipement " + number,
                ths=["Numéro", "Nom", "Numéro d'installation"])

        return render
Esempio n. 14
0
	def display_One_Activity(self, number):
		"""
		Display one activity
		"""
		html = self.add_HTML_header('Activité ' + number)
		css = Template(filename="include/css.html")
		html += (css.render())
		database = Database('data/database.db')
		act = database.read_One_Activity(number)
		html += '''<h2>Activité n°''' + number + '''</h2>
			<table border=1>
				<tr>
					<th>Numéro</th>
					<th>Nom</th>
				</tr>'''
                
		html += '''<tr>
				<td>''' + str(act.number) + '''</td>
				<td>''' + act.name + '''</td>
			</tr>'''
		html += '''</table>'''
		return html
Esempio n. 15
0
	def display_Activities(self):
		"""
		Displays all activities
		"""
		html = self.add_HTML_header('Activités')
		css = Template(filename="include/css.html")
		html += (css.render())
		database = Database('data/database.db')
		acts = database.read_Activities()
		html += '''<h2>Tableau des activitiés</h2>
			<table border=1>
				<tr>
					<th>Numéro</th>
					<th>Nom</th>
				</tr>'''
		for a in acts:
			html += '''<tr>
					<td>''' + str(a.number) + '''</td>
					<td>''' + str(a.name) + '''</td>
				</tr>'''
		html += '''</table>'''
		return html
Esempio n. 16
0
	def display_Equipments(self):
		"""
		Displays all equipments
		"""
		html = self.add_HTML_header('Equipements')
		css = Template(filename="include/css.html")
		html += (css.render())
		database = Database('data/database.db')
		equips = database.read_Equipments()
		html += '''<h2>Tableau des équipements</h2>
			<table border=1>
				<tr>
					<th>Numéro</th>
					<th>Nom</th>
					<th>Numéro de l'installation</th>
				</tr>'''
		for e in equips:
			html += '''<tr>
					<td>''' + str(e.number) + '''</td>
					<td>''' + e.name + '''</td>
					<td>''' + str(e.installationNumber) + '''</td>
				</tr>'''
		html += '''</table>'''
		return html
Esempio n. 17
0
	def display_One_Equipment(self, number):
		"""
		Display one equipment
		"""
		html = self.add_HTML_header('Equipement ' + number)
		css = Template(filename="include/css.html")
		html += (css.render())
		database = Database('data/database.db')
		equip = database.read_One_Equipment(number)
		html += '''<h2>Equipement n°''' + number + '''</h2>
			<table border=1>
				<tr>
					<th>Numéro</th>
					<th>Nom</th>
					<th>Numéro de l'installation</th>
				</tr>'''
                
		html += '''<tr>
				<td>''' + str(equip.number) + '''</td>
				<td>''' + equip.name + '''</td>
				<td>''' + str(equip.installationNumber) + '''</td>
			</tr>'''
		html += '''</table>'''
		return html
Esempio n. 18
0
def test_when_init_then_database_service_returned():
    db = Database()
    assert hasattr(db, "_logger")
    assert hasattr(db, "_config")
    assert hasattr(db, "_connections")
    assert hasattr(db, "_cursors")
    assert hasattr(db, "_sql")

    assert db._sql == {
        "create": "CREATE TABLE IF NOT EXISTS {table} ({col_spec}, PRIMARY KEY ({keys}));",
        "insert": "INSERT INTO {table}({columns}) VALUES({data});",
        "select": {
            "select_all_from": "SELECT * FROM {table};",
            "select_columns_from": "SELECT {columns} FROM {table};",
            "select_all_from_where": "SELECT * FROM {table} WHERE {where};",
            "select_columns_from_where": "SELECT {columns} FROM {table} WHERE {where};",
        },
    }
Esempio n. 19
0
def db():
    db = Database()
    db._config.paths.db_path = os.sep.join(["C:", "base", "db", "path"])
    return db
Esempio n. 20
0
from copy import deepcopy
import unittest
import json

import sys
sys.path.append('../database')
from services.database import Database
data = Database()
import app


#BAD_ITEM_URL = '{}/5'.format(BASE_URL)
#GOOD_ITEM_URL = '{}/1'.format(BASE_URL)


class TestFlaskApi(unittest.TestCase):

    def setUp(self):
        self.backup_items = deepcopy(data.storage)  # no references!
        self.app = app.app.test_client()
        self.app.testing = True

    def test_get_allUsers(self):
        BASE_URL = 'http://127.0.0.1:5000/rest/user'
        response = self.app.get(BASE_URL)
        data = json.loads(response.get_data())
        self.assertEqual(response.status_code, 200)
        self.assertEqual(len(data), 2)

    def test_get_oneUser(self):
        BASE_URL = 'http://127.0.0.1:5000/rest/user/1'
Esempio n. 21
0
#!/usr/bin/env python3.4
# -*- coding: utf-8 -*-

"""
This part of program is used to load JSON file in the database
"""

from services.readJson import ReadJSON
from services.database import Database
from model.activity import Activity
from model.equipment import Equipment
from model.installation import Installation
from progressbar import *

print("Creation of database...")
database = Database("data/database.db")
database.create_DB()
print("Database created")


print("Insertion in installation table...")
rdI = ReadJSON("data/installations.json")
rdI.readInstallation()
resultI = rdI.getResult()
print("File read")

progressBar = ProgressBar(widgets=['Writing installations to the database: ', Percentage(), ' ', ETA()])
for i in progressBar(resultI):
        database.Insert_In_Installation(i)
database.commit_DB()
print("Insertion done")
Esempio n. 22
0
from services.database import Database
from resources.models import Range, Mode, StreetLight

db = Database().db
db.connect()
db.create_tables([StreetLight, Mode, Range])

# Insert modes
mode = Mode(lamps_after=3,
            illumination_duration_seconds=10,
            proximity_refresh=5,
            brigthness_refresh=5,
            enabled=False)
mode.save()

mode = Mode(lamps_after=2,
            illumination_duration_seconds=10,
            proximity_refresh=60,
            brigthness_refresh=60,
            enabled=True)
mode.save()

# Insert ranges
ranges = [{
    "min": 20,
    "with_movement": 70,
    "without_movement": 10
}, {
    "min": 40,
    "with_movement": 80,
    "without_movement": 20
Esempio n. 23
0
def start_processes(config_ini):
    procs = []
    stoplist = []

    logger.info("Starting config service")
    conf = Config()
    proc = Process(target=conf.run, args=(config_ini,))
    procs.append(proc)
    proc.start()

    if wait_service_up(SOCK_CONFIG) is False:
        stop_services(stoplist)
        sys.exit(1)
    stoplist.append(SOCK_CONFIG)

    logger.info("Starting service-detection service")
    service_detection = ServiceDetection()
    proc = Process(target=service_detection.run, args=())
    procs.append(proc)
    proc.start()

    if wait_service_up(SOCK_SD) is False:
        stop_services(stoplist)
        sys.exit(1)
    stoplist.append(SOCK_SD)

    logger.info("Starting DNS service")
    dns = DNSAPI()
    proc = Process(target=dns.run, args=())
    procs.append(proc)
    proc.start()

    if wait_service_up(SOCK_DNS) is False:
        stop_services(stoplist)
        sys.exit(1)
    stoplist.append(SOCK_DNS)

    logger.info("Starting web-server service")
    mgmt_server = ManageWebservers()
    proc = Process(target=mgmt_server.run, args=())
    procs.append(proc)
    proc.start()

    if wait_service_up(SOCK_WEBSERVER) is False:
        stop_services(stoplist)
        sys.exit(1)
    stoplist.append(SOCK_WEBSERVER)

    logger.info("Starting module-loader service")
    module_ldr = ModuleLoader()
    proc = Process(target=module_ldr.run, args=())
    procs.append(proc)
    proc.start()

    if wait_service_up(SOCK_MODULES) is False:
        stop_services(stoplist)
        sys.exit(1)
    stoplist.append(SOCK_MODULES)

    logger.info("Starting database service")
    database = Database()
    proc = Process(target=database.run, args=())
    procs.append(proc)
    proc.start()

    if wait_service_up(SOCK_DATABASE) is False:
        stop_services(stoplist)
        sys.exit(1)
    stoplist.append(SOCK_DATABASE)

    logger.info("Starting shell-receiver service")
    shell = ShellReceiver()
    proc = Process(target=shell.run, args=())
    procs.append(proc)
    proc.start()

    # No need to wait for shell-service to be up
    logger.info("All processes have started")
    return procs
Esempio n. 24
0
 class Meta:
     database = Database().get_db()
Esempio n. 25
0
from flask import Flask, request, jsonify
from services.service import Server
from services.database import Database

database = Database()
server = Server(database)

app = Flask(__name__)


@app.route("/")
def hello():
    return "Hello World!"


class InvalidUsage(Exception):
    status_code = 400

    def __init__(self, message, status_code=None, payload=None):
        Exception.__init__(self)
        self.message = message
        if status_code is not None:
            self.status_code = status_code
        self.payload = payload

    def to_dict(self):
        rv = dict(self.payload or ())
        rv['message'] = self.message
        return rv

Esempio n. 26
0
# -*- coding: utf-8 -*-
"""
This program reads data from JSON files and writes the results to a SQLite database
"""

from progressbar import *

from services.readjson import ReadJSON
from services.database import Database

from model.activity import Activity
from model.installation import Installation
from model.equipment import Equipment

print("Creating database...", end=" ")
database = Database("data/database.db")
database.create_new()
print("Done")

rj = ReadJSON()
installations = rj.read_installations("data/Installations.json")

pbar = ProgressBar(widgets=[
    'Writing installations to the database: ',
    Percentage(), ' ',
    ETA()
])
for elem in pbar(installations):
    database.insert_installation(elem)
database.commit()