def count():
Session = openSeesion()
session = Session()
result = session.query(func.count(EconomyNewsDto.no)).one()[0]
session.close()
return result
def count():
Session = openSeesion()
session = Session()
result = session.query(func.count(CovidStatusDto.no)).one()[0]
session.close()
return result
def count():
Session = openSeesion()
session = Session()
result = session.query(func.count(CovidExtractionWordDto.no)).one()[0]
session.close()
return result
def find_all(self):
Session = openSeesion()
session = Session()
result = session.query(CovidStatusDto).all()
session.close()
return result
def save_data_bulk(datas):
Session = openSeesion()
session = Session()
session.bulk_insert_mappings(CovidStatusDto,
datas.to_dict(orient='records'))
session.commit()
session.close()
def save_data_bulk(datas):
Session = openSeesion()
session = Session()
session.bulk_insert_mappings(EconomyExtractionWordDto,
datas.to_dict(orient='records'))
session.commit()
session.close()
def find_all(self):
Session = openSeesion()
session = Session()
result = session.query(EconomyNewsDto).all()
session.close()
return result
def find_all(self):
Session = openSeesion()
session = Session()
result = session.query(EconomyExtractionWordDto).all()
session.close()
return result
# import sys
# sys.path.insert(0, '/c/Users/Admin/VscProject/BlackTensor_Test/com_blacktensor/cop/fin/model/')
import csv
import pandas as pd
from com_blackTensor.ext.db import db, openSeesion, engine
from sqlalchemy import func
from com_blackTensor.resources.fin.model.finance_kdd import FinanceKdd
from com_blackTensor.resources.fin.model.finance_dfo import FinanceDfo
from com_blackTensor.resources.fin.model.finance_dto import FinanceDto
from com_blackTensor.resources.emo.model.emotion_kdd import keyword, key1, key2, key3
Session = openSeesion()
session = Session()
class FinanceDao(FinanceDto):
@staticmethod
def bulk():
finance_dfo = FinanceDfo()
finance = session.query(FinanceDto).filter(
FinanceDto.keyword.like(f'%{keyword}%')).all()
for k, m in enumerate(keyword):
if m == key1:
if finance == []:
dfo = finance_dfo.fina_pro(key1)
session.bulk_insert_mappings(FinanceDto,
dfo.to_dict(orient='records'))
session.commit()
session.close()
if m == key2:
if finance == []: