def del_subscription(db, _user_id, _school_id, _class): if not _user_id: raise ValueError("user id must be not null for a valid subscription!") if not _school_id: raise ValueError("school id must be not null for a valid subscription!") if not _class: raise ValueError("class must be not null for a valid subscription!") dic = create_dictionary(_user_id=_user_id, _school_id=_school_id, _class=_class) return database.submit_db(db, sql_commands.SQL_SUB_DELETE_ENTRY, dic)
def delete_day(self, db, param, commit=True): submit_db(db, SQL_SCHEDULE_DELETE_ENTRY, {'_school': param['_school'], '_date': param['_date']}, commit)
def update_user_reg_id(db, _id, _new_reg_id): if not _new_reg_id: raise ValueError("reg id must be not null!") dic = create_dictionary(_id=_id, _reg_id=_new_reg_id) return database.submit_db(db, sql_commands.SQL_USER_UPDATE_REG_ID, dic)
def del_user_reg_id(db, _reg_id): if not _reg_id: raise ValueError("reg id must be not null!") dic = create_dictionary(_reg_id=_reg_id) return database.submit_db(db, sql_commands.SQL_USER_DELETE_REG_ID, dic)