flask的操作数据库常用增删改查

#增
def createOne():
    artcle1 = Artcle_table2(title='标题',content='内容')
    db.session.add(artcle1)
    db.session.commit()
    return '添加成功'
 
#删
def deleteis():
    results = Artcle_table2.query.filter_by(id=4).all()
    db.session.delete(results)
    db.session.commit()
    return '删除成功'
 
#改
def change():
    results = Artcle_table2.query.filter_by(id=4).all()
    print(results[0].title)
    results[0].title = 'new title'
    db.session.commit()
    return '修改成功'
 
#查
def getdata():
    results = Artcle_table2.query.filter_by(title='标题').all()
    print(results)
    resData = []
    for x in results:
        resData.append({
            'title':x.title,
            'content':x.content
        })
    print(resData)
    return '查询成功'