I have a student table in postgres with the following columns Studentid | Student_name | Student_division
I am using sql alchemy and have modeled it as
Class Student: _tablename__ : 'student' __table_args__ : {'schema' : 'student'} studentid=Column('Student_name', pk=true) . . And so on for rest of the columns. #After creating object of the same stu = Student() #I want the values be updated by user. #The statement i have written is as x= session.query(Student).get(id) #id #given by user x.studentid= studentid #given by uset #models x.studentname = name session.add(x) session.commit()
How to update? This doesnt work.
Advertisement
Answer
you need to commit the changes and remove the session.add(x)
just keep session.commit()