Azure-数据未显示在Easy Tables上 [英] Azure - Data not showing on Easy Tables

问题描述

我正在为Xamarin移动应用程序使用Azure SQL后端.我正在使用带有Node.JS的Easy表来处理我的后端.我已经使用简易表创建向导创建了一些表，但是现在我希望手动将一些旧的MySQL表(例如名为users的表)从另一个数据库手动迁移到新的Azure SQL数据库中.

I am using an Azure SQL back-end for my Xamarin mobile application. I am using Easy tables with Node.JS to handle my back-end. I have created a few tables using the easy tables creation wizard, but now I wish to manually migrate some of my old MySQL tables, such as my table named users from another database into my new Azure SQL database.

1)我已经使用SqlMigration3工具将MySQL表转换为Azure SQL，将架构更改为与Easy Table的架构相同，并且它们现在位于我的Azure SQL数据库中

1) I have used the SqlMigration3 tool to convert the MySQL tables into Azure SQL, changed the schema to be the same as the Easy Table's schema, and they are now in my Azure SQL Database

2)我已经在App Service Editor中创建了Node.JS文件users.js和users.json，现在我的表显示在简单表中

2) I have created the Node.JS files users.js and users.json in my App Service Editor and now my table is showing in easy tables

users.js

var table = module.exports = require('azure-mobile-apps').table();

// table.read(function (context) {
//     return context.execute();
// });

// table.read.use(customMiddleware, table.operation);   

users.json

  {
  "softDelete" : true,
  "autoIncrement": false,
  "insert": {
    "access": "anonymous"
  },
  "update": {
    "access": "anonymous"
  },
  "delete": {
    "access": "anonymous"
  },
  "read": {
    "access": "anonymous"
  },
  "undelete": {
    "access": "anonymous"
  }}

users表显示在Easy Tables中，但没有数据显示，尽管SQL Server Management Studio 2017中显示了数据.我错过了一步吗?我在做什么错了?

The users table is showing up in Easy Tables but there is no data showing, despite the data displaying in SQL Server Management Studio 2017. Have I missed a step? What am I doing wrong?

推荐答案

在我的测试中，当我执行与您相同的步骤时，我也无法看到Azure门户中的数据.我认为门户网站可能需要一些时间来加载数据，因为它可能有很多记录.

In my test, I am also unable to see the data from Azure portal when I do the same steps as yours. I think the portal needs time to load the data since it might have many records.

由于将Read permission设置为Allow anonymous access，因此我建议通过REST API访问该表:

Since you set Read permission to Allow anonymous access, I would recommend accessing the table via REST API:

https://[YourAppName].azurewebsites.net/tables/users?ZUMO-API-VERSION=2.0.0

这篇关于Azure-数据未显示在Easy Tables上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！