如何使用Dynamoose使用筛选器扫描所有记录

Question

我正在尝试使用Dynamoose搜索所有可用记录的单词。我尝试了下面的代码，但没有用...

let buscarEmails = async (email, sistema) => {
  createDynamooseInstance()
  const Email = dynamoose.model('enviar_email', enviarEmailSchema.enviarEmailSchema)

  const filter = {
    FilterExpression: '#destinatario = :email',
    ExpressionAttributeNames: {
      '#destinatario': 'destinatario'
    },
    ExpressionAttributeValues: {
      ':email': email
    }
  }

  const options = {
    'all': { 'delay': 0, 'max': 99 }
  }

  const buscarEmails = Email.scan(filter).all().exec().then(function (emails) {
    return emails
  })
    .catch(function (err) {
      return err.toString()
    })

  return buscarEmails
}

Answer 1

我使用了以下代码，它工作得很好：

​

let buscarEmails = async (email, sistema) => {
  createDynamooseInstance()
  const Email = dynamoose.model(process.env.TABELA_EMAIL_ENVIAR, enviarEmailSchema.enviarEmailSchema, { update: true })

  const buscarEmails = Email.scan('destinatario').eq(email).where('sistema').eq(sistema).all(0, 0).exec().then(function (emails) {
    return emails
  })
    .catch(function (err) {
      return err.toString()
    })

  return buscarEmails
}

​