def dump(self):
"""
Dumps the database into a .csv files.
"""
config = g.Configuration()
filename_base = config.parser['paths'].get('dump')
for table in self.get_tables():
self.dump_table(table)
def add_topic_entry(topic):
"""
Creates a form where you can add a new entry to a topic.
"""
config = g.Configuration()
db = g.Database(config.parser['paths'].get('german'))
columns = db.get_columns(topic)
return flask.render_template(
'enter.html',
action = 'Add',
topic = topic,
columns = columns,
)
def dump_table(self, table):
"""
Dumps a table from the database into a .csv file.
Parameters
----------
table : string
The name of the table to dump.
"""
config = g.Configuration()
filename_base = config.parser['paths'].get('dump')
df = self.table_to_dataframe(table)
filename = '{}{}.csv'.format(filename_base, table)
df.to_csv(filename, encoding='utf-8-sig')
def return_new_topic():
"""
Returns the values of the new topic you added.
"""
config = g.Configuration()
db = g.Database(config.parser['paths'].get('german'))
if flask.request.method == 'POST':
result = flask.request.form
with open(config.parser['paths'].get('translations'), 'r') as f:
translations = yaml.full_load(f)
translations[result['table_name']] = result['translation']
with open(config.parser['paths'].get('translations'), 'w') as f:
yaml.dump(translations, f)
columns = []
for key in result.keys():
if result[key]:
if 'column' in key:
columns.append(result[key])
db.add_table(
result['table_name'],
columns = columns,
)
another = 'add'
return flask.render_template(
'return.html',
next = another,
result = result,
topic = 'new_topic',
)
def add_new_topic():
"""
Creates a form where you can add a new topic.
"""
config = g.Configuration()
db = g.Database(config.parser['paths'].get('german'))
columns = [
'table_name',
'translation',
]
for i in range(0, 10):
columns.append('column_{}'.format(i))
return flask.render_template(
'enter.html',
topic = 'new_topic',
columns = columns,
)
def return_topic(topic):
"""
Returns the values of the entry you added or edited.
"""
config = g.Configuration()
db = g.Database(config.parser['paths'].get('german'))
if flask.request.method == 'POST':
result = flask.request.form
if 'meaning' in result.keys():
db.add_to_table(
topic,
list(result.keys()),
list(result.values())
)
another = 'add'
else:
columns = db.get_columns(topic)
db.edit_row(
table = topic,
column_search = columns[0],
value_search = result['expression'],
column_edit = result['column'],
value_edit = result['value'],
)
another = 'edit'
return flask.render_template(
'return.html',
next = another,
result = result,
topic = topic,
)
def home():
"""
Displays the home of the webapp with the list of topics.
"""
config = g.Configuration()
db = g.Database(config.parser['paths'].get('german'))
tables = db.get_tables()
with open(config.parser['paths'].get('translations'), 'r') as f:
translations = yaml.full_load(f)
topics = [
(t, translations[t])
if t in translations.keys() else (t, t)
for t in tables
]
return flask.render_template(
'home.html',
topics = topics,
)
def topic(topic):
"""
Displays a page with a table regarding the topic.
"""
config = g.Configuration()
db = g.Database(config.parser['paths'].get('german'))
table = db.table_to_dataframe(topic)
if topic == 'lexicon':
table['module'] = pd.to_numeric(table['module'])
table = table.sort_values(
by = ['module', 'category', 'sort_value'],
ascending = [False, True, True],
)
else:
table = table.sort_values(
by = ['sort_value'],
ascending = [True],
)
table = table.drop(columns = ['sort_value'])
table = table.reset_index(drop = True)
with open(config.parser['paths'].get('translations'), 'r') as f:
translations = yaml.full_load(f)
return flask.render_template(
'data.html',
title = translations[topic],
category = topic,
data = table.to_html(
justify = 'left',
index = False,
border = 0,
),
)