def usacco(self): for item in self.items: #return len(self.items) try: s_id = sector_id(item['sector'].lower(), item['district'].lower()) usacco = UmurengeSacco(count=item['count'], name=item['name'], year=item['year'], sector_id=s_id) db.session.add(usacco) db.session.commit() except IntegrityError: db.session.rollback() return 1
def mfi(self): for item in self.items: #return len(self.items) try: s_id = sector_id(item['sector'].lower(), item['district'].lower()) mfi = Mfi(count=item['count'], name=item['mfis'], year=item['year'], sector_id=s_id) db.session.add(mfi) db.session.commit() except IntegrityError: db.session.rollback() return 1
def bank(self): for item in self.items: #return len(self.items) try: s_id = sector_id(item['sector'].lower(), item['district'].lower()) bank = Bank(count=item['branch_count'], name=item['banks'], year=item['year'], sector_id=s_id) db.session.add(bank) db.session.commit() except IntegrityError: db.session().rollback() return 1
def todb(self): for data in self.json_data: try: s_id = sector_id(data['sector'], data['district']) saving = SavingGroup( name=data['saving_group_name'], year=data['sgs_year_of_creation'], member_female=data['sgs_members__female'], member_male=data['sgs_members__male_'], sector_id=s_id, sector_name=None, district_name=None, sg_status=data['sgs_status_(supervised/graduated)'], regDate=None) db.session.add(saving) db.session.commit() except IntegrityError: db.session().rollback() saving = SavingGroup.query.filter_by( name=data['saving_group_name']).first() # Amount saving_amount = data['saved_amount'] if data['saved_amount'] == 'N/A': saving_amount = -1 borrowing_amount = data['outstanding_loans'] if data['outstanding_loans'] == 'N/A': borrowing_amount = -1 amount = Amount(saving=saving_amount, borrowing=borrowing_amount, year=data['year_amount'], sg_id=saving.id) db.session.add(amount) db.session.commit() # International NGO try: ngo = Ngo(name=data['international_ngo'].upper(), email=None, telephone=None, website=None, category=1, picture=None, address=None) db.session.add(ngo) db.session.commit() intl_ngo_id = ngo.id except IntegrityError: db.session().rollback() ngo = Ngo.query.filter_by( name=data['international_ngo'].upper()).first() intl_ngo_id = ngo.id # Local NGO try: ngo = Ngo(name=data['local_ngo'].upper(), email=None, telephone=None, website=None, category=0, picture=None, address=None) db.session.add(ngo) db.session.commit() local_ngo_id = ngo.id except IntegrityError: db.session().rollback() ngo = Ngo.query.filter_by( name=data['local_ngo'].upper()).first() local_ngo_id = ngo.id # SGS sgs = Sgs(partner_id=local_ngo_id, funding_id=intl_ngo_id, sg_id=saving.id) db.session.add(sgs) db.session.commit() return 1
def sector(self): sector, district = self.identifier sector = sector_id(sector, district) if sector: return True return False