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
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,