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