def update(review, review_no):
Session = openSession()
session = Session()
session.query(ReviewDto).filter(ReviewDto.review_no == review.review_no)\
.update({ReviewDto.review_title: review.review_title,
ReviewDto.review_detail: review.review_detail})
session.commit()
def insert_many():
service = UserService()
Session = openSession()
session = Session()
df = service.hook()
print(df.head())
session.bulk_insert_mappings(UserDto, df.to_dict(orient="records"))
session.commit()
session.close()
def save(review):
Session = openSession()
session = Session()
session.add(review)
session.commit()
from com_cheese_api.cop.rev.review.model.review_dto import ReviewDto
from com_cheese_api.cop.rev.review.model.review_dfo import ReviewDfo
from com_cheese_api.ext.db import db, openSession
from sqlalchemy import func, and_, or_
# ==============================================================
# ==================== =====================
# ==================== Modeling =====================
# ==================== =====================
# ==============================================================
# DB에 있는 데이터 가져오는 작업
Session = openSession()
session = Session()
class ReviewDao(ReviewDto):
# No value for argument 'review_dfo'
# in classmethod callpylint(no-value-for-parameter)
# @classmethod
# def bulk(cls, review_dfo):
# dfo = review_dfo.create()
# print("리뷰 데이터 insert!!!")
# print(dfo.head())
# session.bulk_insert_mappings(cls, dfo.to_dict(orient="records"))
# session.commit()
# session.close()
@staticmethod
def save(order):
Session = openSession()
session = Session()
session.add(order)
session.commit()
def save(cheese):
Session = openSession()
session = Session()
session.add(cheese)
session.commit()
def delete(cls, rev_id):
Session = openSession()
session = Session()
cls.query(ReviewDto.review_no == review.review_no).delete()
session.commit()
