def get_sector_list():
dbcon = DatabaseConnector('chase')
cur = dbcon.connect()
cur.execute("""SELECT gid FROM sectors""")
row = cur.fetchall()
sector_list = [r[0] for r in row]
return sector_list
def get_sector_list():
dbcon = DatabaseConnector('chase')
cur = dbcon.connect()
cur.execute("""SELECT gid FROM sectors""")
row = cur.fetchall()
sector_list = [r[0] for r in row]
return sector_list
def test(self):
database = DatabaseConnector(None, None, "test.db", None, None)
database.execute_statement("CREATE TABLE test (c1 Int, c2 Text);")
database.execute_statement("INSERT INTO test VALUES (1, 'hallo');")
database.execute_statement("SELECT * FROM test;")
column_names = ["c1", "c2"]
column_type = [None, None]
data = [(1, 'hallo')]
result = database.get_current_query_result()
self.assertEqual(result.get_column_names(), column_names)
self.assertEqual(result.get_column_types(), column_type)
self.assertSequenceEqual(result.get_data()[0], data[0])
self.assertIsNone(database.get_error_message())
import numpy as np
from keras_preprocessing.image import img_to_array
from tensorflow.keras.applications.mobilenet_v2 import preprocess_input
from tensorflow.python.keras.models import load_model
from an_connector import ANConnector
from assets.messages import Messages
from database_connector import DatabaseConnector
from utils.average_utility import AverageUtility
from utils.benchmark_utility import BenchmarkUtility
from utils.image_utility import ImageUtility
an_connector = ANConnector()
average_utility = AverageUtility()
benchmark_utility = BenchmarkUtility()
database_connector = DatabaseConnector()
listener_thread = threading.Thread(target=an_connector.subscribe_person_update,
daemon=True)
class InputHandler:
last_predict = None
benchmark_mode_activated = False
frame_rescaling_activated = False
frame_width = 0
frame_height = 0
def __init__(self):
self.activate_benchmark_mode()
self.activate_frame_rescaling()
listener_thread.start()
def __init__(self):
dbcon = DatabaseConnector('chase')
self.cur = dbcon.connect()
return self.cur
#import osgeo.ogr
import os
import re
import datetime as dtime
import pytz
from database_connector import DatabaseConnector
import datetime
if __name__ == '__main__':
dbcon = DatabaseConnector('chase2018')
cur = dbcon.connect()
def shape_load(shape_path):
"""
Loads shapes from given path to sectors table in WKT format in WGS84
:param shape_path: path to shapefile
:return: None
"""
cur.execute("ALTER SEQUENCE sectors_id_seq RESTART WITH 1") # zeroing id in table sectors
shapefile = osgeo.ogr.Open(shape_path) # open and read shapefile
layer = shapefile.GetLayer(0)
for i in range(layer.GetFeatureCount()): # get features
feature = layer.GetFeature(i)
name = feature.GetField("STREFA").decode("utf-8") # get field value
num = feature.GetField("NUMER").decode("utf-8")
wkt = feature.GetGeometryRef().ExportToWkt() # export geometry to WKT
cur.execute("INSERT INTO sectors (gid,shape,name) VALUES ('%s', ST_GeometryFromText('%s', 4326), '%s')" %
(num.encode("utf-8"), wkt, name.encode("UTF8"))) # write all the data into table
def __init__(self):
self.connection = DatabaseConnector().connection
self.cursor = DatabaseConnector().cursor
def __init__(self):
dbcon = DatabaseConnector('chase')
self.cur = dbcon.connect()
return self.cur
from flask import Flask, jsonify, request, render_template, redirect, url_for
from flask_assets import Bundle, Environment
from flask_login import LoginManager, UserMixin, login_required, login_user, current_user, logout_user
from database_connector import DatabaseConnector
from database_manager import ItemManager, TagManager
from product_manager import ProductManager
from image_manager import ImageManager
from image_manager import AwsConnector
from config import DatabaseConf, ImageConf
from response import Response
import login_config
CONFIG = login_config.get_config()
database_connector = DatabaseConnector(database=CONFIG.DB,
host=CONFIG.HOST,
user=CONFIG.USER,
password=CONFIG.PASSWORD)
database_connector.create_database(CONFIG.DB)
database_connector.create_tables()
connection = database_connector.get_connection()
item_manager = ItemManager(database_connector)
tag_manager = TagManager(database_connector)
s3_resource = AwsConnector(CONFIG.BOTO3_PROFILE).get_s3_resource()
image_manager = ImageManager(s3_resource, CONFIG.BUCKET)
product_manager = ProductManager(item_manager, tag_manager, image_manager)
application = Flask(__name__)
application.secret_key = CONFIG.SECRET_KEY
login_manager = LoginManager()
login_manager.init_app(application)
import osgeo.ogr
import os
import re
import datetime as dtime
import pytz
from database_connector import DatabaseConnector
import datetime
if __name__ == '__main__':
dbcon = DatabaseConnector('chase')
cur = dbcon.connect()
def shape_load(shape_path):
"""
Loads shapes from given path to sectors table in WKT format in WGS84
:param shape_path: path to shapefile
:return: None
"""
cur.execute("ALTER SEQUENCE sectors_id_seq RESTART WITH 1"
) # zeroing id in table sectors
shapefile = osgeo.ogr.Open(shape_path) # open and read shapefile
layer = shapefile.GetLayer(0)
for i in range(layer.GetFeatureCount()): # get features
feature = layer.GetFeature(i)
name = feature.GetField("STREFA").decode("utf-8") # get field value
num = feature.GetField("NUMER").decode("utf-8")
wkt = feature.GetGeometryRef().ExportToWkt() # export geometry to WKT
cur.execute(
"INSERT INTO sectors (gid,shape,name) VALUES ('%s', ST_GeometryFromText('%s', 4326), '%s')"
% (num.encode("utf-8"), wkt,