无法在本地查询lambda格式的dynamodb GSI

Question

const AWS = require("aws-sdk");
const db = new AWS.DynamoDB.DocumentClient({
  region: process.env.REGION,
  apiVersion: "2012-08-10",
});


 const params = {
  // ProjectionExpression: ["province", "gender", "updatedAt", "createdAt"],
  ExpressionAttributeValues: {
    ":provinceVal": "Sichuan",
  },
  IndexName: "RegistreesByProvince",
  KeyConditionExpression: "province = :provinceVal",
  TableName: process.env.API_PORTAL_SUBMISSIONSTABLE_NAME,
};

const calculateStatistics = async () => {
  try {
    const data = await db.query(params).promise();
    console.log(data);
  } catch (err) {
    console.log(err);
  }
};

const resolvers = {
  Query: {
    getStatistics: () => {
      return calculateStatistics();
    },
  },
};
exports.handler = async (event) => {
  // TODO implement
  const typeHandler = resolvers[event.typeName];
  if (typeHandler) {
    const resolver = typeHandler[event.fieldName];
    if (resolver) {
      var result = await resolver(event);
      return result;
    }
  }
}; // };

     { UnknownEndpoint: Inaccessible host: `dynamodb.us-east-1-fake.amazonaws.com'. This service may not be available in the `us-east-1-fake' region.
    at Request.ENOTFOUND_ERROR (/Users/apple/Documents/work/web/portal/amplify/backend/function/calcStatistics/src/node_modules/aws-sdk/lib/event_listeners.js:501:46)
    at Request.callListeners (/Users/apple/Documents/work/web/portal/amplify/backend/function/calcStatistics/src/node_modules/aws-sdk/lib/sequential_executor.js:106:20)
    at Request.emit (/Users/apple/Documents/work/web/portal/amplify/backend/function/calcStatistics/src/node_modules/aws-sdk/lib/sequential_executor.js:78:10)
    at Request.emit (/Users/apple/Documents/work/web/portal/amplify/backend/function/calcStatistics/src/node_modules/aws-sdk/lib/request.js:688:14)
    at ClientRequest.error (/Users/apple/Documents/work/web/portal/amplify/backend/function/calcStatistics/src/node_modules/aws-sdk/lib/event_listeners.js:339:22)
    at ClientRequest.<anonymous> (/Users/apple/Documents/work/web/portal/amplify/backend/function/calcStatistics/src/node_modules/aws-sdk/lib/http/node.js:96:19)
    at ClientRequest.emit (events.js:198:13)
    at ClientRequest.EventEmitter.emit (domain.js:448:20)
    at TLSSocket.socketErrorListener (_http_client.js:401:9)
    at TLSSocket.emit (events.js:198:13)
  message:
   'Inaccessible host: `dynamodb.us-east-1-fake.amazonaws.com\'. This service may not be available in the `us-east-1-fake\' region.',
  code: 'UnknownEndpoint',
  region: 'us-east-1-fake',
  hostname: 'dynamodb.us-east-1-fake.amazonaws.com',
  retryable: true,
  originalError:
   { Error: getaddrinfo ENOTFOUND dynamodb.us-east-1-fake.amazonaws.com dynamodb.us-east-1-fake.amazonaws.com:443
       at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:56:26)
     message:
      'getaddrinfo ENOTFOUND dynamodb.us-east-1-fake.amazonaws.com dynamodb.us-east-1-fake.amazonaws.com:443',
     errno: 'ENOTFOUND',
     code: 'NetworkingError',
     syscall: 'getaddrinfo',
     hostname: 'dynamodb.us-east-1-fake.amazonaws.com',
     host: 'dynamodb.us-east-1-fake.amazonaws.com',
     port: 443,
     region: 'us-east-1-fake',
     retryable: true,
     time: 2020-08-12T10:18:08.321Z },
  time: 2020-08-12T10:18:08.321Z }
Result:
null
Finished execution.

PS：值得一提的是，我能够通过Appsync控制台成功地查询到这些数据，这让我坚信问题出在函数本身。

Answer 1

在做了更多的研究和四处询问后，我终于明白了github上提供给我的答案

当对一个可以访问由API生成的dynamodb表的函数运行mock时。它将用假值填充env。如果您想根据部署的dynamodb表模拟lambda函数，可以编辑sdk客户机中的值，这样它就可以准确地进行调用。

总之，如果您在本地运行，那么您将无法访问您可能尝试模拟的后端变量。我希望这能帮助到某人。谢了！