Raw "Insert" SQL in SQLAlchemy, Flask

Question

Values are not added to the database after INSERT query. SELECT is working fine this way

  db = SQLAlchemy(app)
  ...
  session['sql_raw_reports_post'] = "insert into database (x, y) values (xa, ya)"
  r = db.session.execute(session['sql_raw_reports_post'])
  ...
  return 'success'

smwd · Accepted Answer · 2022-04-07 08:32:43Z

2

you can try add

db.commit()

ater "insert" action

answered Apr 7, 2022 at 8:32

smwd

361 bronze badge

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

Collectives™ on Stack Overflow

Raw "Insert" SQL in SQLAlchemy, Flask

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