Peewee从一个嵌套字典中获取包含某些列的表

from peewee import *

# 定义数据库连接
db = SqliteDatabase('my_database.db')

# 定义模型类
class MyTable(Model):
    column1 = CharField()
    column2 = IntegerField()
    column3 = FloatField()

    class Meta:
        database = db

# 创建表
db.create_tables([MyTable])

# 嵌套字典数据
nested_dict = {
    'row1': {
        'column1': 'value1',
        'column2': 1,
        'column3': 1.23
    },
    'row2': {
        'column1': 'value2',
        'column2': 2,
        'column3': 3.45
    }
}

# 从嵌套字典中获取数据并保存到表中
for key, data in nested_dict.items():
    MyTable.create(column1=data['column1'], column2=data['column2'], column3=data['column3'])

# 查询表中的数据
query = MyTable.select()
for row in query:
    print(row.column1, row.column2, row.column3)