def set_analyzed(self, issue_id):
params = {'analyzed': 1}
conditions = {'id': [issue_id]}
TransactionHandler.update(self,
table='issues',
params=params,
conditions=conditions)
def create(self, name, political_party, birthdate):
values = {
'name': name,
'political_party': political_party,
'birthdate': birthdate
}
TransactionHandler.insert(self, table='persons', params=values)
def create(self, name, description, established=0, disbanded=0):
params = {
'name': name,
'description': description,
'established': established,
'disbanded': disbanded
}
print(params)
TransactionHandler.insert(self, table='ministries', params=params)
def save_position(self, role, date_from, date_to, person_id, ministry_id,
cabinet_id):
values = {
'role': role,
'date_from': date_from,
'date_to': date_to,
'person_id': person_id,
'ministry_id': ministry_id,
'cabinet_id': cabinet_id
}
TransactionHandler.insert(self, table='positions', params=values)
def create(self, title, type, number, file, date):
# Analyzed is false by default when creating a new issue
values = {
'title': title,
'type': type,
'number': number,
'file': file,
'date': date,
'analyzed': 0
}
TransactionHandler.insert(self, 'issues', values)
def find_most_common_role(self, conditions, person_name):
conditions['person_name'] = [person_name]
formatted_conditions = TransactionHandler.format_conditions(self, 'raw_signatures', conditions)
query = '''
SELECT role,
COUNT(role) AS role_occurence
FROM raw_signatures
{conditions}
GROUP BY `role`
ORDER BY `role_occurence` DESC
LIMIT 1;
'''.format(conditions=formatted_conditions)
return TransactionHandler.execute_select_all(self, query=query)
def load_all_by_person_name(self, person_name, conditions = None):
joins = {'persons' : ['INNER', 'signatures.person_id = persons.id']}
if not conditions:
conditions = {}
conditions['persons.name'] = [person_name]
return TransactionHandler.select_all(self, table='signatures', conditions=conditions, joins=joins)
def update(self, id, params):
conditions = {'id': [id]}
TransactionHandler.update(self,
table='persons',
params=params,
conditions=conditions)
def load_all_by_person_name(self, person_name):
conditions = {'person_name': [person_name]}
return TransactionHandler.select_all(self, table='raw_signatures', conditions=conditions)
def load_all(self, conditions=None):
return TransactionHandler.select_all(self,
table='persons',
conditions=conditions)
def load_one(self, conditions=None):
return TransactionHandler.select_one(self, table='raw_signatures', conditions=conditions)
def load_by_title(self, title):
conditions = {'title' : [title]}
return TransactionHandler.select_one(self, table='cabinets', conditions=conditions)
def create(self, title, description, date_from, date_to):
params = {'title' : title, 'description' : description, 'date_from' : date_from,
'date_to' : date_to}
TransactionHandler.insert(self,table='cabinets',params=params)
def load_random(self, conditions=None):
return TransactionHandler.select_random(self,
table='issues',
conditions=conditions)
def create_multiple(self, inserts):
TransactionHandler.insert_multiple(self, 'raw_signatures', inserts)
def create(self, person_id, issue_id, data):
params = {'person_id': person_id, 'issue_id': issue_id, 'data': data}
TransactionHandler.insert(self, table='signatures', params=params)
def load_all(self, conditions=None, group_by=None, joins=None):
return TransactionHandler.select_all(self,
table='issues',
conditions=conditions,
joins=joins,
group_by=group_by)
def create(self, person_name, role, issue_title, issue_date):
params = {'person_name': person_name, 'role': role, 'issue_title': issue_title, 'issue_date' : issue_date}
TransactionHandler.insert(self, table='raw_signatures', params=params)
def load_all(self):
return TransactionHandler.select_all(self, 'ministries')
def load_by_name(self, name):
conditions = {'name': [name]}
return TransactionHandler.select_one(self,
'ministries',
conditions=conditions)
def load_position(self, conditions):
return TransactionHandler.select_one(self,
'positions',
conditions=conditions)
def load_all(self, conditions=None, group_by=None):
return TransactionHandler.select_all(self, table='raw_signatures', conditions=conditions, group_by=group_by)
def __init__(self, db_name='default'):
TransactionHandler.__init__(self, db_name)
def update(self, params, conditions=None):
TransactionHandler.update(self, 'raw_signatures', params, conditions)
