如何将列表映射到具有重复值的列

data_list = ['A', 'B', 'A', 'C', 'B']

CREATE TABLE example_table (
    id INT PRIMARY KEY,
    category VARCHAR(255),
    value INT
);

from sqlalchemy import create_engine, Table, Column, Integer, String, MetaData
from sqlalchemy.orm import sessionmaker

# 创建数据库连接
engine = create_engine('sqlite:///example.db')
metadata = MetaData(bind=engine)
Session = sessionmaker(bind=engine)
session = Session()

# 定义表结构
example_table = Table('example_table', metadata,
    Column('id', Integer, primary_key=True),
    Column('category', String),
    Column('value', Integer)
)

# 创建表
metadata.create_all()

# 插入数据
data_list = ['A', 'B', 'A', 'C', 'B']
for i, category in enumerate(data_list):
    session.execute(example_table.insert().values(category=category, value=i))

session.commit()

# 查询数据
result = session.execute("SELECT * FROM example_table").fetchall()
print(result)

[(1, 'A', 0), (2, 'B', 1), (3, 'A', 2), (4, 'C', 3), (5, 'B', 4)]

for i, category in enumerate(data_list):
    session.execute(example_table.insert().values(category=category, value=i)).\
        on_conflict_do_update(index_elements=['category'], set_=dict(value=i))