def get_products():
conf = ut.getConfig()
da = DataAccess(conf)
query = "select * from products"
result = da.select_row(query)
return result
def render(self):
env = Environment(loader=FileSystemLoader('templates'),
autoescape=select_autoescape(['html', 'xml']),
trim_blocks=True,
lstrip_blocks=True)
dataAccess = DataAccess()
data = dataAccess.get_formatted_location_data()
template = env.get_template('template.html')
rendered_output = template.render(locations=data)
return rendered_output
def move_time():
da = DataAccess()
name_1 = input("距離計算の場所を一つ入力してください")
name_2 = input("距離計算の場所を、もう一つ入力してください")
spot_list = da.get_latitude_longitude(name_1)
x = da.get_latitude_longitude(name_2)
a = np.array([])
b = np.array([])
for spot, i in zip(spot_list, x):
a = np.append(a, spot, axis=0)
b = np.append(b, i, axis=0)
move_time = space_calc(a[1], a[0], b[1], b[0])
print(move_time / 4.0)
def proc(raw):
dataaccess = DataAccess(raw)
elements = dataaccess.get_level_data()
evals = dataaccess.get_evals()
classes = dataaccess.get_classes()
relative_weights = dataaccess.get_weight_result()
mem_grades = calculate_membership_grade(evals, classes)
tree = ElementTree(elements)
tree.set_membership_grade(mem_grades)
weights = calculate_weight(relative_weights, tree.get_pids(), tree.get_nodes())
tree.set_weight(weights)
final_weight = tree.fuzzy_synthetic_evaluation()
final_score = calculate_final_score(final_weight, classes)
res = {}
res["_result"] = final_score
res["_errorno"] = 0
return res
def createProduct():
try:
p_name = request.json['name']
p_desc = request.json['description']
p_price = request.json['price']
p_int_price = float(p_price)
conf = ut.getConfig()
da = DataAccess(conf)
query = "INSERT INTO products (`name`, `description`, `price`) VALUES ('{0}', '{1}', {2})".format(
p_name, p_desc, str(p_price))
print query
da.execute_query(query)
p_obj = dict(success=True, error="")
except Exception as ex:
p_obj = dict(success=False, error=str(ex))
return json.dumps(p_obj)
from dataaccess import DataAccess
import numpy as np
da = DataAccess()
#時間的計算（内積）
name = input("調べたい場所を入力してください")
time = da.get_spots_by_time(name)
time = np.array(time)
spot_list = da.get_time()
a = np.array([])
for spot in spot_list:
a = np.append(a, spot, axis=0)
a = a.reshape(5, 3)
kekka = []
for item in a:
kekka.append(
[item[0],
np.sum(item[1:].astype(np.float) * time.astype(np.float))])
print(kekka)
from dataaccess import DataAccess
import itertools
import math
hoge = DataAccess()
count = 0
list_latitude = {}
list_longitude = {}
#赤道、極半径
red_rad = 6378.137
pol_rad = 6356.752
name = {}
name_ex = {}
name_box = []
time_box = []
#化成緯度、経度それぞれ辞書型に格納
for id_n in range(1, 11):
x = list(itertools.chain.from_iterable(hoge.get_spots(id_n)))
#化成緯度のリスト
list_latitude[count] = x[2]
list_longitude[count] = x[3]
name[count] = x[0]
name_ex[count] = x[0]
name_box.append(x[0])
count += 1
def make_dist(point_A, point_B):
#print(point_A + "から" + point_B + "までの時間")
#適当なidを取得
def __init__(self):
self.data = DataAccess()
self.location_data = None