[SQLAlchemy] INSERT 중복방지, join 사용

직접 쿼리 작성하고 싶을 때

https://stackoverflow.com/questions/17972020/how-to-execute-raw-sql-in-flask-sqlalchemy-app

How to execute raw SQL in Flask-SQLAlchemy app

 

INSERT IGNORE

 

def insert_act(temp, table_name):

database = MySQLdb.connect (host="localhost", user="root", password="******", db="data_schema")

cursor = database.cursor()

cursor.execute("SELECT ID FROM %s" % table_name)

 

if len(cursor.fetchall()) != len(temp):

print(table_name+"들어옴")

for i in temp:

cursor.execute(query1, [i])

cursor.close()

database.commit()

 

 

SQLAlchemy(join 사용법)

https://stackoverflow.com/questions/54054787/flask-many-to-many-join-as-done-by-prefetch-related-from-django

flask many to many join as done by prefetch_related from django

https://blog.hongminhee.org/2013/10/30/65522658529/

SQLAlchemy에서 쿼리할 때 조인을 직접 명시해야 하는 경우는 별로 없다