| | |
|---|
| | | __industry_map = {} |
|---|
| | | mysqldb = mysql_data.Mysqldb() |
|---|
| | | results = mysqldb.select_all("select _id,second_industry from ths_industry_codes") |
|---|
| | | for r in results: |
|---|
| | | code = r[0] |
|---|
| | | industry = r[1] |
|---|
| | | __code_map[code] = industry |
|---|
| | | if __industry_map.get(industry) is None: |
|---|
| | | __industry_map[industry] = set() |
|---|
| | | __industry_map[industry].add(code) |
|---|
| | | if results: |
|---|
| | | for r in results: |
|---|
| | | code = r[0] |
|---|
| | | industry = r[1] |
|---|
| | | __code_map[code] = industry |
|---|
| | | if __industry_map.get(industry) is None: |
|---|
| | | __industry_map[industry] = set() |
|---|
| | | __industry_map[industry].add(code) |
|---|
| | | return __code_map, __industry_map |
|---|
| | | |
|---|
| | | |
|---|
