def main():
if len(sys.argv) < 3:
print 'Usage: %s TXT NICKNAMES' % os.path.basename(sys.argv[0])
sys.exit(1)
filename = sys.argv[1]
nicks = Nicknames(sys.argv[2])
country = _country_name(filename)
outfilename = '%s%s%sPovertyLines.sql' % (country.capitalize(), nicks.year(country), nicks.questionsVersionText(country, ''))
with open(outfilename, 'w') as f:
f.write('\n'.join(inserts(filename, nicks)) + '\n')
def main():
if len(sys.argv) < 3:
print 'Usage: %s TXT NICKNAMES' % os.path.basename(sys.argv[0])
sys.exit(1)
filename = sys.argv[1]
nicks = Nicknames(sys.argv[2])
country = _country_name(filename)
outfilename = '%s%s%sPovertyLines.sql' % (
country.capitalize(), nicks.year(country),
nicks.questionsVersionText(country, ''))
with open(outfilename, 'w') as f:
f.write('\n'.join(inserts(filename, nicks)) + '\n')
if '.' not in line.strip() and line.strip().isdigit():
answers[-1] = (answers[-1], int(line.strip()))
if 'Total score' in line:
yield (question, answers)
return
if __name__ == '__main__':
if len(sys.argv) < 3:
print 'Usage: %s TXT NICKNAMES' % os.path.basename(sys.argv[0])
sys.exit(1)
filename = sys.argv[1]
country_name = os.path.basename(filename.split()[0])
if '.' in country_name:
country_name = country_name.split('.')[0]
nicks = Nicknames(sys.argv[2])
year = nicks.year(country_name)
title = nicks.questionsTitle(country_name)
qs = list(parse_questions(filename))
xml_country_version = country_name.upper() + str(
year) + nicks.questionsVersionText(country_name, '')
properties_out = properties(qs, country_name, nicks, title,
xml_country_version)
sql_out = sql(qs, country_name, nicks, title)
xml_out = xml(qs, country_name, nicks, title)
tmp_sql_filename = 'generated/scoringEtl/%s%s%sPPIScore.sql' % (
country_name.capitalize(), year,
nicks.questionsVersionText(country_name, ''))
letter = letter_it.next()
if '.' not in line.strip() and line.strip().isdigit():
answers[-1] = (answers[-1], int(line.strip()))
if 'Total score' in line:
yield (question, answers)
return
if __name__ == '__main__':
if len(sys.argv) < 3:
print 'Usage: %s TXT NICKNAMES' % os.path.basename(sys.argv[0])
sys.exit(1)
filename = sys.argv[1]
country_name = os.path.basename(filename.split()[0])
if '.' in country_name:
country_name = country_name.split('.')[0]
nicks = Nicknames(sys.argv[2])
year = nicks.year(country_name)
title = nicks.questionsTitle(country_name)
qs = list(parse_questions(filename))
xml_country_version = country_name.upper() + str(year) + nicks.questionsVersionText(country_name,'')
properties_out = properties(qs, country_name, nicks, title, xml_country_version)
sql_out = sql(qs, country_name, nicks, title)
xml_out = xml(qs, country_name, nicks, title)
tmp_sql_filename = 'generated/scoringEtl/%s%s%sPPIScore.sql' % (country_name.capitalize(), year, nicks.questionsVersionText(country_name,''))
with open(tmp_sql_filename, 'w') as sql_f:
sql_f.write(sql_out)
print 'SQL written to ' + tmp_sql_filename
