def getBusinessNameFromSql():
words = []
type = "_业务名称"
sql = """
select distinct F002 from stk039
where isvalid = '1'
and f001 = '2'
"""
data = getData(sql)
if data is None:
failExit("access postgresql error!")
for item in data:
if item.find('(') < 0 and item.find('（') < 0:
for subProduct in re.split(",|，|;|；|、", item):
words.append(subProduct.strip())
#print subProduct.strip()
else:
words.append(item.strip())
#print item.strip()
sql = """
select distinct products from
(
select f001V_stk219 as products,
t1.declaredate_stk219 as valid_date,
max(t1.declaredate_stk219) over (partition by t1.orgid_stk219) as latest
from STK219 t1 join stk001 t2 on t2.comcode = t1.ORGID_STK219
where t1.isvalid = 1 and t2.isvalid = 1 and f001V_stk219 not like '%B、C、D%'
) t where valid_date = latest """
data = getData(sql)
if data is None:
failExit("access postgresql error!")
for item in data:
item = item.replace(' ', '')
item = item.replace(' ', '')
if item.find('(') < 0 and item.find('（') < 0:
for product in re.split(",|，|;|；|、", item):
words.append(product.strip())
#print product.strip()
else:
for product in item.strip().split('、'):
if product.find('(') < 0 and product.find('（') < 0:
for subProduct in re.split(",|，|;|；|、", product):
words.append(subProduct.strip())
#print subProduct.strip()
else:
words.append(product.strip())
#print product.strip()
new_data = []
for item in words:
if item != "" and not isDigit(item.lower()):
new_data.append(GetOneDictLine.getOneDictLine(item,type))
return new_data
def getAnalystName():
new_data = []
type="_分析师姓名"
sql = """
select distinct t.f003v_yb002 from yb002 t where t.f003v_yb002 != ''
"""
data = getData(sql)
if data is None:
failExit("access postgresql error!")
for line in data:
new_data.append(GetOneDictLine.getOneDictLine(line,type));
return new_data
def changeToDictLine(dictType,data,from_where):
new_data=[]
for line in data:
cols = line.split('\t')
id = ''
for col in cols:
if(col == cols[0]):
id = col
if dictType=="_上证a股代码" or dictType=="_深证a股代码":
new_data.append(GetOneDictLine.getOneDictLineWithId(col,dictType,cols[0],""));
continue
elif(col != ''):
if(id != ''):
new_data.append(GetOneDictLine.getOneDictLineWithId(col,dictType,id,from_where));
else:
new_data.append(GetOneDictLine.getOneDictLine(col,dictType,from_where));
return new_data