Parameterize the delete function sqlalchemy

Question

I have a function to delete a row from psql database

def delete_from_database():
    engine = connect_to_database()
    # define meta information
    metadata = MetaData(bind=engine)
    session = sessionmaker(bind=engine)()
    country_table = Table('countries', metadata, autoload=True)
    # delete
    delete_country_query = country_table.delete(country_table.c.id == 14)
    session.execute(delete_country_query)
    session.commit()

I can parameterize the table name but I also want to parameterize the key-value pair to be searched for and then deleted. In the above example country_table.c.id where id is the column in the table, but i want to generalize the column name

Please provide an example

willeM_ Van Onsem
– willeM_ Van Onsem

2017-08-09 12:32:48 +00:00
Commented Aug 9, 2017 at 12:32 — willeM_ Van Onsem
– willeM_ Van Onsem, Commented Aug 9, 2017 at 12:32

M Dennis · Accepted Answer · 2017-08-09 12:52:42Z

1

Because of Table.c is a collection it should be:

def delete_from_database(table_name, column_name, value):
  engine = connect_to_database()
  # define meta information
  metadata = MetaData(bind=engine)
  session = sessionmaker(bind=engine)()
  country_table = Table(table_name, metadata, autoload=True)
  # delete
  delete_country_query = country_table.delete(country_table.c[column_name] == value)
  session.execute(delete_country_query)
  session.commit()

See here

answered Aug 9, 2017 at 12:52

M Dennis

1777 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parameterize the delete function sqlalchemy

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related