我如何配置颤动使用两个不同的API？

Question

我有一个Flutter应用程序，我想调用使用不同数据库的多个API端点。

我不知道我应该在后端还是前端进行此操作。

api1.php：

<?php // header('Content-Type: application/json');
include "config.php";$sql = "select inventeries.pic_inv,inventeries.name,site.Sname,users.number from inventeries,site,users";
$stmt = $con->prepare($sql);
$stmt->execute();
$med = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($med);
?>

api_2.php：

<?php
// header('Content-Type: application/json');
include "config.php";
$sql = "select users.pic_inv,users.name,site.Sname,users.number from users,site,users";
$stmt = $con->prepare($sql);
$stmt->execute();
$med = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($med);
?>

当前它们使用相同的数据库，因此两个API的结果相同：

{"pic_inv":"ACICAL-PLUS.jpg","name":"Aclcal","Sname":"flowers pharma","number":"7894561231"}
{"pic_inv":"ACICAL-PLUS.jpg","name":"Aclcal","Sname":"flowers pharma","number":"123456789"}
{"pic_inv":"what-a-treatment-for-migraine-headache.jpg","name":"foar","Sname":"flowers pharma","number":"7894561231"}
{"pic_inv":"what-a-treatment-for-migraine-headache.jpg","name":"foar","Sname":"flowers pharma","number":"123456789"}
{"pic_inv":"syrunj.png","name":"AMLO","Sname":"flowers pharma","number":"7894561231"}
{"pic_inv":"syrunj.png","name":"AMLO","Sname":"flowers pharma","number":"123456789"}
{"pic_inv":"cap.jpg","name":"pandol","Sname":"flowers pharma","number":"7894561231"}
{"pic_inv":"cap.jpg","name":"pandol","Sname":"flowers pharma","number":"123456789"}

Answer 1

好吧，正如我已经说过的，我没有PHP的经验，并且在API中都会更容易。

但是您可以在扑朔迷离的应用中制作一个模型，例如您从 db1 endpoint中获得的数据 是这样的

{   
    "inventeries.pic_inv" : "something",
    "inventeries.name" : "something",
    "site.Sname" : "something",
    "users.number" : "something"
}

，您从 db2端点获得的数据就是这样

{   
    "users.pic_inv" : "something",
    "users.name" : "something",
    "site.Sname" : "something",
    "users.number" : "something"
}

，然后您准备了一个将所有内容组合在一起的模型。.让我们称其为 mixchmodel

{   
    //Mixed both data and get only the data you want..
    "users.pic_inv" : "something",
    "users.name" : "something",
    "inventeries.pic_inv" : "something",
    "inventeries.name" : "something"
    "site.Sname" : "something",
    "users.number" : "something",
}

您可以使用 https://app.quicktype.io/ 生成数据的模型。

然后，您可以制作一个可以调用两个端点的函数
我正在使用 dio package 进行API呼叫。

Future<List<MixedModel>> GetDataFromADatabase() async {
  try{
    String URL_ENDPOINT_ONE = "URL TO ENDPOINT 1";
    String URL_ENDPOINT_TWO = "URL TO ENDPOINT 2";

    var ResponseOne = await Dio().get(URL_ENDPOINT_ONE);
    var ResponseTwo = await Dio().get(URL_ENDPOINT_TWO);

    if(ResponseOne.statusCode == 200 && ResponseTwo.statusCode == 200){
      // only if both requests are successful
      var data = jsonDecode(ResponseOne.data.toString()) as List<MixedModel>;
//combine data
      data.addAll(json.decode(ResponseTwo.data.toString()) as List<MixedModel>);
      return data;
      
    }
    List<MixedModel> empty = [];
    return empty;
  }
  catch (ex){
    List<MixedModel> empty = [];
    
    if(ex is dio.DioError){
      print( ex.response);
    }
    return empty;
  }
}

我希望您得到这个想法