Eloquent

SQL.py

# Insert
if request.method == 'POST':
	
	user = User(
		fname=request.form['fname'],
		lname=request.form['lname']
	)

	db.session.add(user)
	db.session.commit()




# Fetch record using ID or Username

user = User.query.filter_by(id=request.form['id']).first()

(OR)

user = User.query.filter_by(username=request.form['username']).first()



# Update existing record

user = User.query.filter_by(id=request.form['id']).first()

user.fname = request.form['fname']
user.lname = request.form['lname']
user.email = request.form['email']

db.session.add(user)
db.session.commit()


# Delete record with ID

User.query.filter_by(id=request.form['id']).delete()