def dictpop(lang = "en"): # Should always be "en"
"""Given a language abbreviation, pulls all of the table rows out
of the SQL database into a dict for fast processing without excessive
network usage.
This function hasn't been written yet.
"""
lines = []
config = {}
try:
with codecs.open('manatee.conf','rU','utf-8') as conf:
lines = conf.readlines()
conf.close()
except IOError as e:
print(" Could not open configuration file: %s" % e)
exit(2)
for line in lines:
try:
line = line.strip()
if line:
values = [x.strip() for x in line.split('=')]
config[values[0]] = values[1]
except Exception as e:
print("There was an error in the configuration file: %s" % e)
exit(3)
# TODO: Any strings from the config file that might be displayed or passed into the SQL server need to be validated here.
dict = {}
# Create connection to SQL server (currently MySQL)
engine = create_engine("%(host)s/%(base)s" % {'host':config["host"],'base':config["base"] } )
sqlconn = engine.connect()
# send the query to grab all rows from the categories_en table
cmd = "SHOW TABLES LIKE 'categories_" + lang + "';"
result = sqlconn.execute(cmd)
if result.rowcount:
cmd = "SELECT * FROM categories_" + lang + ";"
result = sqlconn.execute(cmd)
if result.rowcount:
for row in result:
# for each row, set dict['ccode'] = 'ctext'[:5]
code = row['ccode']
code = code.replace('o','x')
dict[code] = row['ctext'][:5] # We don't need to store the whole text, just enough to check for [Un...
else:
print("Language not found!")
sqlconn.close()
exit(4)
# Oh, and do error checking along the way. (TODO)
sqlconn.close()
return (dict, config)
def main():
"""Run if the program is called from the shell, of course."""
print "Content-Type: text/html\n\n",
config = loadConfig()
var = {}
here = os.path.dirname(os.path.abspath(__file__))
env = Environment(loader=FileSystemLoader(here))
template = env.get_template(os.path.join("templates",'ccowhelp.jtl'))
# Create connection to SQL server (currently MySQL)
engine = create_engine("%(host)s/%(base)s" % {'host':config["host"],'base':config["base"] } )
sqlconn = engine.connect()
# Grab GET data from URL
query = cgi.FieldStorage()
lang = query.getvalue("lang","en")[:2]
var['lang'] = lang
langarg = query.getvalue("lang",None) # needed for query present, language not
code = query.getvalue("cowc","XXXX")
code = str(cleanCode(code))
style = query.getvalue("style",None)
if style: var['style'] = "style=" + style
style = chooseStyle(style)
if style: var['custom'] = style
if "site" not in config:
config['site'] = "Manatee"
# check for query string
if len(query) == 0 or langarg == None:
# if no query, offer lang selection
var['title'] = "Select Language"
else:
# if query provided, show a page...
var['code'] = code
var['title'] = var['code']
var['dosnip'] = True
showsubs = False
stage = getStage(var['code'])
cat00 = str(code[:stage])
if stage > 0:
var['cattrim'] = cat00
if stage < 4:
showsubs = True
for i in range(4 - stage): cat00 += '0'
var['catmul'] = cat00
var['muldesc'] = glot(cat00,sqlconn,lang,4) # the multiplicity topic desc will be stage 4.
var['catname'] = glot(code,sqlconn,lang,stage)
if code[0] == 'y': # Explanation key
if code[3] == 'x': # explain subcats
var['expl'] = True
var['catname'] = glot("sxpl",sqlconn,lang)
stage = 3 # the subcat explanations are stage 4, so we need to consider yxxx to be stage 3.
else: # explain a single subcat type
del var['catmul']
var['cattrim'] = '*' + code[3]
stage = 4 # make sure we don't show subcats
del var['dosnip']
showsubs = False
var['stage'] = stage
var['catinf'] = os.path.join("cats",lang,code)
var['crumbs'] = glotCrumbs(sqlconn,code,stage,lang)
if len(var['crumbs']) > 0 and code[0] != 'X' and code[0] != 'x': var['crumbdiv'] = True
var['border'] = cat00[:3]
if showsubs:
var['subcats'] = glotSubs(sqlconn,code,stage,lang)
var['progress'] = glot("spro",sqlconn,lang)
# print "<!-- Code: " + var['code'] + " stage " + str(var['stage']) + " language: " + var['lang'] + " -->"
print template.render({'config': config, 'var': var}).encode("utf-8")
sqlconn.close()
exit(0)
