sqlalchemy text module

[choisungwook]

참고자료

• https://chartio.com/resources/tutorials/how-to-execute-raw-sql-in-sqlalchemy/#using-sqlalchemy
• https://www.geeksforgeeks.org/how-to-execute-raw-sql-in-sqlalchemy/

[choisungwook]

• sqlalchemy text를 이용해서 파라미터 binding
• 파라미터 binding은 dict으로
  • pynatic을 이용하면 ** 연산자가 적용안됨 ..;;

from sqlalchemy import text
statement = text("""
        INSERT INTO 
            projects (name, created_at, updated_at) 
            VALUES(:name, CURRENT_TIMESTAMP,CURRENT_TIMESTAMP)
        """)
db.execute(statement, {
    "name": request.name
})
db.commit()