SQLalchemy 增删改查

from sqlalchemy import func
# 插入一条
with get_session() as session:
    session.add(user_table(_id=111, u_id=222, _name="aaa",
                          _data="aaa"))
    session.commit()
    
# 多条
with get_session() as session:
    session.execute(user_table.__table__.insert(), [
        {"mode_id": i["mode_id"], "user_id": 111, "user_id": 'aaaa', "mode_data": 'aaaa'} for i in data_list])
    session.commit()    

# 更新
with get_session() as session:
    session.query(user_table).filter(user_table._id == 1111).update({"user_id": 0})
    session.commit()

# 查询count
with get_session() as session:
    user_mode_count = session.query(
        func.count(user_table._id)
    ).filter(
        user_mode.user_id == userId,
        user_mode.state == 1
    ).first() or (0, '')

# order_by / in / substring / group_concat / distinct方法
with get_session() as session:
    user_mode_count = session.query(
        user_table.mode_name,
        user_table.mode_data,
        user_table.mode_id,
        func.substring(user_table.create_time, 1, 19),
        func.group_concat(func.distinct(user_table.mode_name))
    ).filter(
        user_table.mode_id.in_(['3','4','5','6'])
    ).order_by(user_table.create_time.desc(),user_table.mode_id.desc()).all()