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()
