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()