Esempio n. 1
0
    def __init__(self):
        super().__init__('s')

        self.add_rule(self.create)
        self.add_rule(self.addQuestion)
        self.add_rule(self.getQuestions)
        self.add_rule(self.publish)
        self.add_rule(self.like)
        self.add_rule(self.getCurrentSurveyId)
        self.add_rule(self.setInfo)
        self.add_rule(self.getInfo)
        self.add_rule(self.setAnswer)
        self.add_rule(self.getAnswer)
        self.add_rule(self.getInfos, methods=['POST', 'GET'])
        self.add_rule(self.getImage, methods=['POST', 'GET'])

        self.app_config = config
        db_path = os.path.join(config['DATABASE_PATH'], config['DATABASE_NAME'])
        tables_path = os.path.join(config['DATABASE_PATH'], config['DATABASE_TABLES'])

        self.db = Database(db_path)
        self.db.execute_file(tables_path)

        self.request = Request()
        self.response = Response()
        self.security = Security()
        self.filesender = FileSender()
        self.requester = Requester(self.db)

        self.form_checker = FormChecker()
        self.error = Error()
def main():
    f = open('rawdata.csv', 'r')
    reader = csv.DictReader(f)
    trips = []
    stations = {}
    for line in reader:
        trips.append(line)
    for trip in trips:
        stations[int(trip['start station id'])] = {
            'station_name': trip['start station name'],
            'latitude': trip['start station latitude'],
            'longitude': trip['start station longitude']
        }
        stations[int(trip['end station id'])] = {
            'station_name': trip['end station name'],
            'latitude': trip['end station latitude'],
            'longitude': trip['end station longitude']
        }
    sorted_stations = (sorted(stations.items(), key=lambda item: item[0]))

    session = Database().getSession()
    for a in sorted_stations:
        nStation = station(
            id=a[0],
            station_name=a[1]['station_name'],
            latitude=a[1]['latitude'],
            longitude=a[1]['longitude']
        )
        session.add(nStation)
    session.commit()
    session.close()
Esempio n. 3
0
 def _get_possible_poi_values(self):
     db = Database()
     db.open_transaction()
     result = {}
     for tag in OSMQuery.tag_keys_types:
         r = db.get_poi_values(tag)
         r = [self._ALL] + r
         result[tag] = r
     db.close_transaction()
     return result
Esempio n. 4
0
    def __init__(self):

        db_path = os.path.join(config['DATABASE_PATH'], config['DATABASE_NAME'])
        tables_path = os.path.join(config['DATABASE_PATH'], config['DATABASE_TABLES'])

        self.db = Database(db_path)
        self.db.execute_file(tables_path)

        self.request = Request()
        self.response = Response()
        self.security = Security()
Esempio n. 5
0
    def __init__(self):
        super().__init__('s')

        self.add_rule(self.create)

        self.app_config = config

		db_path = os.path.join(config['DATABASE_PATH'], config['DATABASE_NAME'])
		tables_path = os.path.join(config['DATABASE_PATH'], config['DATABASE_TABLES'])

		self.db = Database(db_path)
		self.db.execute_file(tables_path)
Esempio n. 6
0
def init():
    Database().init(app.config['DB_CONFIG'])
    register_bps()
Esempio n. 7
0
 def __init__(self, from_date, to_date):
     self._graph = nx.DiGraph()
     self._db = Database()
     self._from_date = from_date
     self._to_date = to_date
Esempio n. 8
0
 def __init__(self, path):
     self._path = path
     self._city = {}
     self._airport = {}
     self._db = Database()
Esempio n. 9
0
 def __init__(self, radius: int):
     self._radius = radius
     self._db = Database()
     self._osm = OSM()