copywriting_production/tests/mytest/t_product_sql.py

from sqlmodel import SQLModel, create_engine, Session, select, Field
from src.manager import DbManager,StorageManager
from src.models.asin_model import TrafficKeywordModel, ProductInfoModel,AsinExtraResultModel
from src.models.product_model import ProductKeyword, ProductVariant, Product, ProductFinancial, ProductCompetitorLink,MarketingInfo
from utils.logu import get_logger
logger = get_logger('test')

def main():
    db_manager = DbManager()
    marketting = MarketingInfo(
        selling_point=["1","2","3"],
        product_style="style1",
        referent={"amazone":{
            'url': '133',
            'asin': '45616'
        }},
    )
    with Session(db_manager.engine) as session:
        product = Product(
            title="product1",
            main_category_id=1,
            marketing=marketting
        )
        session.add(product)
        session.commit()
        session.refresh(product)
        logger.info(f"{product}")
        
if __name__ == "__main__":
    main()