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 == []: