时间戳

首页 > 解决方案 > 如何交互从数据库接收的数据？

python - 如何交互从数据库接收的数据？

问题描述

我正在从数据库获取数据，但我想将几个特定的​​列返回到我的 Get API 调用。

我正在获取多个字典。

driver_data = MasterDriver.query.filter_by(Driver_Status_id=2, is_driver_verified=1)

 return drivers_schema.jsonify(driver_data)


[
    {

        "email_id": "abjhgfjhgc@xyz.com",
        "first_name": "manoj",
        "isActive": null,
        "last_name": "sayi",
        "license": null,
        "mobile_number": "+917780187505",

    },
{

        "email_id": "abjhgfjhgc@xyz.com",
        "first_name": "manoj",
        "isActive": null,
        "last_name": "sayi",
        "license": null,
        "mobile_number": "+917780187505",

    },
{

        "email_id": "abjhgfjhgc@xyz.com",
        "first_name": "manoj",
        "isActive": null,
        "last_name": "sayi",
        "license": null,
        "mobile_number": "+917780187505",

    }

]

标签： pythonjsonflask-sqlalchemy

解决方案

nullPython 中不存在，您可能正在寻找None.

您正在尝试做的是一个非常基本的for x in array操作。

我建议从 Python 的基础开始，以便能够解决您的问题。不过，这是一个检索数组中元素的有效解决方案

arr = [
    {

        "email_id": "abjhgfjhgc@xyz.com",
        "first_name": "manoj",
        "isActive": None,
        "last_name": "sayi",
        "license": None,
        "mobile_number": "+917780187505",

    },
{

        "email_id": "abjhgfjhgc@xyz.com",
        "first_name": "manoj",
        "isActive": None,
        "last_name": "sayi",
        "license": None,
        "mobile_number": "+917780187505",

    },
{

        "email_id": "abjhgfjhgc@xyz.com",
        "first_name": "manoj",
        "isActive": None,
        "last_name": "sayi",
        "license": None,
        "mobile_number": "+917780187505",

    }

]

for elem in arr:
    print(elem["email_id"])
    print(elem["first_name"])
    print(elem["isActive"])
    print(elem["last_name"])
    print(elem["license"])
    print(elem["mobile_number"])

您可以查看repl.it来执行它。

推荐阅读