Dirty dirty python code to convert giant sql json appendicies for config files
No One
Actions

Authored By

	Lokal_Profil
	May 20 2017, 1:30 PM

Size

2 KB

Referenced Files

None

Subscribers

None

Dirty dirty python code to convert giant sql json appendicies for config files
View Options

	#!/usr/bin/python
	# -- coding: utf-8 --
	from __future__ import unicode_literals
	import codecs


	def parse(entry):
	text = ''
	lines = entry.strip().split('\n')
	country, _, lang = lines.pop(0).strip('/* ').partition(' in ')
	lines.pop(0) # REPLACE INTO
	lines.pop(0) # SELECT
	text += ',\n "sql_lang": "{}"'.format(lang)
	text += ',\n "sql_country": "{}"'.format(country)
	text += ',\n "sql_data": {'
	template = '\n "%s": {\n "value": "%s",\n "type": "%s"\n },'
	country_code = lang_code = where = None
	for l in lines:
	l = l.strip()
	if not l:
	continue
	if l.startswith('WHERE'):
	where = l[len('WHERE '):].rstrip(';')
	continue
	l = l.split(' /* ')[0]
	val, _, label = l.rstrip(',').partition(' AS ')
	label = label.strip('`')
	typ = None
	if val.startswith("'"):
	val = val.strip("'")
	typ = 'Text'
	elif val.startswith("`"):
	val = val.strip("`")
	typ = 'Field'
	else:
	typ = 'Raw'
	text += template % (label, val, typ)
	if label == 'country':
	country_code = val
	elif label == 'lang':
	lang_code = val
	text = text.rstrip(',') + '\n }'
	if where:
	text += ',\n "sql_where": "{}"'.format(where)
	filename = '{}_{}.json'.format(country_code, lang_code)
	return text, filename


	def load_sql():
	f = codecs.open('sql/temp.sql', 'r', 'utf-8')
	return f.read().split('¤')


	def mod_json(text, filename):
	f = codecs.open('monuments_config/{}'.format(filename), 'r', 'utf-8')
	j = f.read().rstrip()
	f.close()
	j = j[:-2] + text + j[-2:]
	f = codecs.open('monuments_config/{}'.format(filename), 'w', 'utf-8')
	f.write(j)
	f.close()


	def run_all():
	silly_map = {
	'dk-bygninger_da.json': 'dk-bygning_da.json',
	'dk-fortidsminder_da.json': 'dk-fortids_da.json',
	'es_gl.json': 'es-gl_gl.json'
	}
	entries = load_sql()
	for entry in entries:
	if not entry.strip():
	continue
	text, filename = parse(entry)
	if filename in silly_map:
	filename = silly_map[filename]
	mod_json(text, filename)


	if __name__ == "__main__":
	run_all()

File Metadata

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 4658145
Default Alt Text: Dirty dirty python code to convert giant sql json appendicies for config files (2 KB)

Dirty dirty python code to convert giant sql json appendicies for config filesNo OneActions

Dirty dirty python code to convert giant sql json appendicies for config filesView Options

File Metadata

Event Timeline

Dirty dirty python code to convert giant sql json appendicies for config files
No One
Actions

Dirty dirty python code to convert giant sql json appendicies for config files
View Options