#! /usr/bin/python3
# -*- coding: utf-8 -*-
#
#	excel_python_update.py
#
#					Sep/05/2014
#
import	math
import	cgi
import	string
import	sys
import	json
#
sys.path.append ('/var/www/data_base/common/python_common')
from excel_manipulate import excel_read_proc
from excel_manipulate import excel_write_proc
from text_manipulate import dict_update_proc
from cgi_manipulate import parse_parameter
# ---------------------------------------------------------------
#
print ("Content-type: text/html\n\n")
#
excel_file = "/var/tmp/excel/cities.xls"
dict_aa = excel_read_proc (excel_file)
#
#
array_bb = parse_parameter ()
#
for it in range (len(array_bb)):
	id_in = array_bb[it]['id']
	population_in = int (array_bb[it]['population'])
	print ("id_in = %s<br />" % id_in)
	print ("population_in = %d<br />" % population_in)
	dict_aa = dict_update_proc (dict_aa,id_in,population_in)
#
#
excel_write_proc (excel_file,dict_aa)
#
#
print ("*** OK ***<br />")
#
# ---------------------------------------------------------------