def count():
Session = openSession()
session = Session()
result = session.query(func.count(CovidNewsDto.no)).one()[0]
session.close()
return result
def count():
Session = openSession()
session = Session()
result = session.query(func.count(
EconomyExtractionWordDto.no)).one()[0]
session.close()
return result
def save_data_bulk(datas):
Session = openSession()
session = Session()
session.bulk_insert_mappings(CovidExtractionWordDto,
datas.to_dict(orient='records'))
session.commit()
session.close()
def find_all(self):
Session = openSession()
session = Session()
result = session.query(CovidNewsDto).all()
session.close()
return result
def find_all(self):
Session = openSession()
session = Session()
result = session.query(CovidExtractionWordDto).all()
session.close()
return result
def save_data_bulk(datas):
Session = openSession()
session = Session()
session.bulk_insert_mappings(EconomyNewsDto,
datas.to_dict(orient='records'))
session.commit()
session.close()
from collections import Counter
from com_blacktensor.ext.db import db, openSession
from sqlalchemy import func
import json
from flask import jsonify
from sqlalchemy import Column, Integer, String, Date
from com_blacktensor.cop.emo.model.emotion_kdd import EmotionKdd
from com_blacktensor.cop.emo.model.emotion_dto import EmotionDto, StockNewsDto
from com_blacktensor.cop.emo.model.emotion_dfo import EmotionDfo
from com_blacktensor.cop.emo.model.emotion_kdd import keyword
# import time
# import multiprocessing
Session = openSession()
session = Session()
class EmotionDao(EmotionDto):
@staticmethod
def bulk():
emotion_dfo = EmotionDfo()
dfo = emotion_dfo.data_pro(keyword)
session.bulk_insert_mappings(EmotionDto, dfo.to_dict(orient='records'))
session.commit()
session.close()
@staticmethod
def save(emotion):
session.add(emotion)
