使用graphqlOperation 按照页面条件查询DynamoDB的例子

使用graphqlOperation 按照页面条件查询DynamoDB的例子

import { API, graphqlOperation } from 'aws-amplify';

// 构建 GraphQL 查询
const buildQuery = (input) => {
  let query = /* GraphQL */ `
    query SearchObjects($filter: ModelObjectFilterInput) {
      searchObjects(filter: $filter) {
        items {
          id
          name
          grade
          admissionDate
        }
      }
    }
  `;
  
  // 根据输入的对象构建过滤条件
  const filter = {};

  // 检查输入对象中每个属性的值，如果存在则加入过滤条件
  if (input.id) filter.id = { eq: input.id };
  if (input.name) filter.name = { eq: input.name };
  if (input.grade) filter.grade = { eq: input.grade };
  
  // 如果同时输入了开始时间和结束时间，则构建入学时间的范围查询
  if (input.startDate && input.endDate) {
    filter.admissionDate = { between: [input.startDate, input.endDate] };
  } else if (input.startDate) {
    filter.admissionDate = { ge: input.startDate };
  } else if (input.endDate) {
    filter.admissionDate = { le: input.endDate };
  }

  // 构建 GraphQL 操作对象
  const operation = graphqlOperation(query, { filter });

  return operation;
};

// 示例：根据输入对象执行查询
const searchObjects = async (input) => {
  try {
    const operation = buildQuery(input);
    const response = await API.graphql(operation);
    console.log('Query Result:', response.data.searchObjects.items);
  } catch (error) {
    console.error('Error searching objects:', error);
  }
};

// 示例：根据输入对象执行查询
searchObjects({ id: 'someId', name: 'someName', grade: 'someGrade', startDate: '2024-01-01', endDate: '2024-12-31' });