def load_cow_majors(src): """ Load data into cow_majors """ session = model.SESSION() reader = csv2.DictReader(src) reader.fieldnames = [utils.camel2under(x) for x in reader.fieldnames] cnt = collections.Counter() for row in reader: ccode = row['ccode'] cnt[row['ccode']] +=1 st_date = utils.row_ymd(row, 'st_year', 'st_month', 'st_day') end_date = utils.row_ymd(row, 'end_year', 'end_month', 'end_day') session.add(model.CowMajor(ccode = ccode, interval = cnt[ccode], st_date = st_date, end_date = end_date)) session.commit()
def load_cow_majors(src): """ Load data into cow_majors """ session = model.SESSION() reader = csv2.DictReader(src) reader.fieldnames = [utils.camel2under(x) for x in reader.fieldnames] cnt = collections.Counter() for row in reader: ccode = row['ccode'] cnt[row['ccode']] += 1 st_date = utils.row_ymd(row, 'st_year', 'st_month', 'st_day') end_date = utils.row_ymd(row, 'end_year', 'end_month', 'end_day') session.add( model.CowMajor(ccode=ccode, interval=cnt[ccode], st_date=st_date, end_date=end_date)) session.commit()
def load_polityd(src): session = model.SESSION() reader = xls.DictReader(src) columns = [x.name for x in model.PolityCase.__table__.c] cnt = collections.Counter() for row in reader: ccode = row['ccode'] cnt[ccode] += 1 row['pcase'] = cnt[ccode] row['present'] = row['present'] == '1' for i in ('e', 'b'): row['%sday' % i] = utils.replmiss(row['%sday' % i], lambda x: int(x) == 99) row['%smonth' % i] = utils.replmiss(row['%smonth' % i], lambda x: int(x) == 99) row['%syear' % i] = utils.replmiss(row['%syear' % i], lambda x: int(x) == 9999) if row['byear']: row['bdate'] = utils.row_ymd(row, 'byear', 'bmonth', 'bday') if row['eyear']: row['edate'] = utils.row_ymd(row, 'eyear', 'emonth', 'eday') session.add(model.PolityCase(**utils.subset(row, columns))) session.commit()
def load_cow_states(src): """ Load data into cow_statelist and cow_system_membership """ session = model.SESSION() reader = csv2.DictReader(src) reader.fieldnames = [utils.camel2under(x) for x in reader.fieldnames] cnt = collections.Counter() for row in reader: ccode = row['ccode'] cnt[row['ccode']] +=1 if cnt[ccode] == 1: session.add(model.CowState(ccode = ccode, state_abb = row['state_abb'], state_nme = row['state_nme'])) st_date = utils.row_ymd(row, 'st_year', 'st_month', 'st_day') end_date = utils.row_ymd(row, 'end_year', 'end_month', 'end_day') session.add(model.CowSysMembership(ccode = ccode, interval = cnt[ccode], st_date = st_date, end_date = end_date)) session.commit()
def load_cow_states(src): """ Load data into cow_statelist and cow_system_membership """ session = model.SESSION() reader = csv2.DictReader(src) reader.fieldnames = [utils.camel2under(x) for x in reader.fieldnames] cnt = collections.Counter() for row in reader: ccode = row['ccode'] cnt[row['ccode']] += 1 if cnt[ccode] == 1: session.add( model.CowState(ccode=ccode, state_abb=row['state_abb'], state_nme=row['state_nme'])) st_date = utils.row_ymd(row, 'st_year', 'st_month', 'st_day') end_date = utils.row_ymd(row, 'end_year', 'end_month', 'end_day') session.add( model.CowSysMembership(ccode=ccode, interval=cnt[ccode], st_date=st_date, end_date=end_date)) session.commit()