Feb-05-2020, 05:49 PM
iwant to pass the arguments for where clause in the below code as a argument (keyword/positional) through outside the code. how do i do this ?
from sqlalchemy import create_engine
engine = create_engine('sqlite://', echo=False)
df.to_sql('star', con=engine)
rs=engine.execute("""
WITH moon AS ( select
column1
, column2
from cig
where column1 <= 100)
""").fetchall()
from sqlalchemy import create_engine
engine = create_engine('sqlite://', echo=False)
df.to_sql('star', con=engine)
rs=engine.execute("""
WITH moon AS ( select
column1
, column2
from cig
where column1 <= 100)
""").fetchall()