def __DoGet_Admin_name(self, code_dict, code_country_dict):
self.log.info('begin admin_name ..')
sqlcmd = '''
select id, name,country_name
from
(
select code as id, "name" as name,"name" as country_name
from temp_country
union
select a.code as id,a."name" as name,b."name" as country_name
from temp_state as a
left join temp_country as b
on a.country_code = b.code
union
select a.code as id, a."name" as name, c."name" as country_name
from temp_city as a
left join temp_state as b
on a.state_code = b.code
left join temp_country as c
on b.country_code = c.code
)as temp_all
where name is not null
order by id, name, country_name;
'''
#test set_language
self.CreateTable2('temp_admin_name')
MultiLangName.set_language_code(code_dict)
temp_file_obj = cache_file.open('temp_admin_name_new')
rows = self.get_batch_data(sqlcmd)
for row in rows:
id = row[0]
name = row[1]
country_name = row[2]
if name:
ml_name = MultiLangName(code_country_dict[country_name], name,
NAME_TYPE_OFFICIAL)
json_name = ml_name.json_format_dump()
if not json_name:
self.log.error('Json Name is null. id=%d' % id)
else:
self.__store_name_to_temp_file(temp_file_obj, id, json_name,
code_country_dict[country_name])
# ## 把名称导入数据库
temp_file_obj.seek(0)
self.pg.copy_from2(temp_file_obj, 'temp_admin_name')
self.pg.commit2()
# close file
#temp_file_obj.close()
cache_file.close(temp_file_obj, True)
self.log.info('end admin_name ..')
def _name_to_json(self, strTTS):
code_dict = dict()
code_dict['JPN'] = None
MultiLangName.set_language_code(code_dict)
ml_name = MultiLangName('JPN', strTTS, NAME_TYPE_OFFICIAL)
strTTS_json = ml_name.json_format_dump()
return strTTS_json
def __DoGet_Admin_name(self,code_dict,code_country_dict,code_country_code):
self.log.info('begin admin_name ..')
sqlcmd = '''
select id,name,name_alt,country_name
from
(
select id,"name" as name,"names" as name_alt,"name" as country_name
from
(
select id,"name","names"
from org_area
where kind = '10'
)as temp
union
select a.id,a.stt_nme as name,a.stt_alt as name_alt,b."name" as country_name
from
(
select stt_id as id,stt_nme,stt_alt,parent_id
from org_state_region
where kind = '9'
group by stt_id,stt_nme,stt_alt,parent_id
order by stt_id,stt_nme,stt_alt,parent_id
)as a
left join
(
select id,"name"
from org_area
where kind = '10'
group by id,"name"
order by id,"name"
)as b
on a.parent_id = b.id
union
select dst_id as id,dst_nme as name,dst_alt as name_alt,d."name" as country_name
from org_district_region as c
left join
(
select state.id,country."name"
from
(
select stt_id as id,parent_id
from org_state_region
where kind = '9'
group by stt_id,parent_id
order by stt_id,parent_id
)as state
left join
(
select id,"name"
from org_area
where kind = '10'
group by id,"name"
order by id,"name"
)as country
on state.parent_id = country.id
)as d
on c.parent_id = d.id
group by dst_id,dst_nme,dst_alt,d."name"
)as temp_all
where (name is not null) or (name_alt is not null)
order by id,name,name_alt,country_name;
'''
#test set_language
MultiLangName.set_language_code(code_dict)
temp_file_obj = cache_file.open('temp_admin_name_new')
rows = self.get_batch_data(sqlcmd)
for row in rows:
id = int(row[0])
name = row[1]
namealtes = row[2]
country_name = row[3]
if name:
ml_name = MultiLangName(code_country_dict[country_name], name, NAME_TYPE_OFFICIAL)
if namealtes:
# ";" separation
for namealte in namealtes.split(';'):
alt_name = MultiLangName(code_country_dict[country_name], namealte, NAME_TYPE_ALTER)
if ml_name:
ml_name.add_alter(alt_name)
else:
ml_name = alt_name
json_name = ml_name.json_format_dump()
if not json_name:
self.log.error('Json Name is null. id=%d' % id)
else:
self.__store_name_to_temp_file(temp_file_obj, id, json_name,code_country_code[country_name])
# ## 把名称导入数据库
temp_file_obj.seek(0)
self.pg.copy_from2(temp_file_obj, 'temp_admin_name')
self.pg.commit2()
# close file
#temp_file_obj.close()
cache_file.close(temp_file_obj,True)
self.log.info('end admin_name ..')