def test_bike_api(db_file, table, rt_db_file):
rows_before_fetch = db.get_all_data(db_file, table)
assert len(rows_before_fetch) % 113 == 0
df.fetch_bike_api_data(db_file, table, rt_db_file)
rows_after_fetch = db.get_all_data(db_file, table)
assert len(rows_after_fetch) % 113 == 0
assert len(rows_after_fetch) - len(rows_before_fetch) == 113
rows_rt_fetch = db.get_all_data(rt_db_file, table)
assert len(rows_rt_fetch) == 113
def test_pollution_api(db_file, table, rt_db_file):
bike_db_file = "rt_bike"
lat = db.read_column_from_db(bike_db_file, 'lat', 'dublin_bike')
lon = db.read_column_from_db(bike_db_file, 'lng', 'dublin_bike')
bid = db.read_column_from_db(bike_db_file, 'number', 'dublin_bike')
coord = (bid, lat, lon)
latlonid = dp.clean_lat_lon_id(coord)
rows_before_fetch = db.get_all_data(db_file, table)
assert len(rows_before_fetch) % 113 == 0
df.fetch_pollution_api_data(db_file, table, latlonid[0], latlonid[1],
latlonid[2], rt_db_file)
rows_after_fetch = db.get_all_data(db_file, table)
assert len(rows_after_fetch) % 113 == 0
assert len(rows_after_fetch) - len(rows_before_fetch) == 113
rows_rt_fetch = db.get_all_data(rt_db_file, table)
assert len(rows_rt_fetch) == 113
def __init__(self, *args, **kwargs):
super(MainFrame, self).__init__(*args, **kwargs)
self.__setup_menubar()
self.__setup_toolbar()
self.__init_table()
self.CenterOnScreen()
self.SetSize((600,400))
self.main_box = wx.BoxSizer(wx.VERTICAL)
self.SetSizer(self.main_box)
self.main_panel = wx.Panel(self)
self.main_box.Add(self.main_panel, 2, wx.EXPAND|wx.ALL, 2)
self.main_panel.SetSizer(wx.BoxSizer(wx.VERTICAL))
self.splitter = wx.SplitterWindow(self.main_panel, style=wx.SP_LIVE_UPDATE)
self.main_panel.GetSizer().Add(self.splitter, 3, wx.EXPAND|wx.ALL, 2)
self.vbox_kiri = wx.BoxSizer(wx.VERTICAL)
self.panel_kiri = wx.Panel(self.splitter, style=wx.BORDER_SUNKEN)
self.panel_kiri.SetSizer(self.vbox_kiri)
self.vbox_kanan = wx.BoxSizer(wx.VERTICAL)
self.panel_kanan = wx.Panel(self.splitter, style=wx.BORDER_SUNKEN)
self.panel_kanan.SetSizer(self.vbox_kanan)
self.splitter.SetMinimumPaneSize(200)
self.splitter.SplitVertically(self.panel_kiri, self.panel_kanan, -100)
_list_data = [list(hasil) for hasil in db.get_all_data()]
list_data = []
for i in _list_data:
list_data.append(str(i[0] + ' - ' + i[1]))
self.list_judul = wx.ListBox(self.panel_kiri,
choices=list_data,
style=wx.LB_SINGLE|wx.LB_NEEDED_SB|wx.LB_SORT)
self.vbox_kiri.Add(self.list_judul, 2, wx.EXPAND|wx.ALL, 2)
self.lirik_viewer = wx.TextCtrl(self.panel_kanan, style=wx.TE_MULTILINE)
self.vbox_kanan.Add(self.lirik_viewer, 2, wx.EXPAND|wx.ALL, 2)
self.main_box.Layout()
# ----------------- Event
self.Bind(wx.EVT_LISTBOX, self.__list_judul_clicked, self.list_judul)
self.Bind(wx.EVT_MENU, self.__on_add, self.menu_file_add)
self.Bind(wx.EVT_MENU, self.__on_rollback, self.menu_file_rollback)
self.Bind(wx.EVT_MENU, self.__on_commit, self.menu_file_commit)
self.Bind(wx.EVT_MENU, self.__on_exit, self.menu_file_exit)
def update_tabelle(self):
"""
Löscht zuerst etwaige columntree Inhalte und populiert columntree dann
neu. Setzt auch die unterschiedlichen Hintergrundfarben und resetet das
Stundenlabel.
"""
all_items = self.columntree.get_children()
for item in all_items:
self.columntree.delete(item)
i = 0
for entry in db.get_all_data():
entry = list(entry)
stunden = self.calculate_stunden(entry[3], entry[4])
entry.append("{:.2f}".format(stunden))
if i % 2:
self.columntree.insert("", 0, text=entry[0], values=(entry),
tags=("oddrow"))
else:
self.columntree.insert("", 0, text=entry[0], values=(entry),
tags=("evenrow"))
i+=1
self.columntree.tag_configure("oddrow", background="#d0e2f9")
self.columntree.tag_configure("evenrow", background="#eff2f5")
self.stunden_variable.set("Stunden:")
def lista(self):
print("------------------")
print("Lista de contactos")
print("------------------")
get_all_data()
def get_all_data():
return jsonify(db.get_all_data()), SUCCESS
from db import get_all_data, NUM_FEATURES
import collections
data = []
target = []
for row in get_all_data():
data.append([row['feat' + str(i)] for i in range(NUM_FEATURES)])
target.append(row['sign'])
def test_read_write_db(db_file, table, data):
db.write_to_db(db_file, table, data)
rows = db.get_all_data(db_file, table)
assert rows[0][2] == 'REAL'
assert rows[0][3] == 'REAL'
assert rows[0][4] == 'TEXT'
import db
#rows = db.get_all_data('bike', 'dublin_bike')
#rows = db.get_all_data('rt_bike', 'dublin_bike')
#rows = db.get_all_data('pollution', 'pol_data')
#rows = db.get_all_data('rt_pollution', 'pol_data')
#db.select_all_tasks('bus_stations', 'station_data')
#rows = db.get_all_data('events', 'event_data')
rows = db.get_all_data('traffic', 'traffic_data')
#print(len(rows))
for row in rows:
print(row)
from db import get_all_data, NUM_FEATURES
import collections
data = []
target = []
for row in get_all_data():
data.append([row['feat' + str(i)] for i in range(NUM_FEATURES)])
target.append(row['sign'])
