o ۵g @sddlmZmZddlmZmZmZmZmZm Z m Z m Z ddl m Z ddlmZddlmZddlmZddlZddlZddlmZGd d d eZdS) ) UploadFilelogger)ColumnStringIntegerTextJSONDateTimeIndex ForeignKey)BIGINT) relationship)Base)nowN)BytesIOc@seZdZdZeddeddedddfZeedd ddd Zee d d d Z ee d d Z ee edd d Zee d d Zee d ddZeedd Zee d ddZeed edZeed eedZeddddZedddddZeddZdededefd d!Z d"S)#ProductproductsZ idx_statusstatusZ idx_pointspoints_requiredZidx_product_category category_idT)unsigned) primary_key autoincrementF)nullablezproduct_categories.idr)rdefault)rronupdatecCstddgdjS)Nzapp.models.product_categoryProductCategory)fromlist) __import__rr!r!/app/app/models/product.pyszProduct.)back_populates ProductImagezProductImage.sort_orderproductzall, delete-orphan)order_byr$cascadecCs|jr |jdjSdS)zqReturns the thumbnail image for the product. If there are multiple images, returns the first one; otherwise None.rN)imagesZ image_url)selfr!r!r" thumbnail(s zProduct.thumbnail upload_file folder_pathreturnc Csd|d}z||Wnty,}ztd|dt|WYd}~nd}~ww|j}tj|d}t |}||}|j } t | } |j dt| } |jj|j|| | |jdtd |d |jd|} | S) a Uploads the given file to the media server under the path: product/{folder_path}/{unique_filename} This method creates the folder structure if needed, uploads the file, and returns the public URL of the uploaded image. zproduct//zFolder creation failed for z: Nrr) content_typez)Uploaded image to media server with key: z0https://adimsayar.s3.eu-central-1.amazonaws.com/)Z create_folder Exceptionrerrorstrfilenameospathsplitextuuiduuid4filereadlenseekrclientZ put_object bucket_namer0info) r*r,r-Z full_foldereZoriginal_filename extensionZunique_filenameZfile_keycontent file_sizeZin_memory_fileurlr!r!r" upload_image/s2 &  zProduct.upload_imageN)!__name__ __module__ __qualname__ __tablename__r __table_args__rr idrnamer descriptionrr rrZstockrZspecificationsrr r created_at updated_atr categoryr)propertyr+rr3rFr!r!r!r"r s4     r)fastapirr sqlalchemyrrrrrr r r Zsqlalchemy.dialects.mysqlr sqlalchemy.ormr app.db.baser app.core.timerr5r8iorrr!r!r!r"s(