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)