date
unknown
javascript
3 years ago
1.3 kB
6
Indexable
const params = {
ExpressionAttributeValues: {
':pkValue': `TENANT#${tenantUuid}#ACADEMIC_CALENDAR_SCHOOL_DATE_RELATION`,
':skValue': 'ACADEMIC_CALENDAR_SCHOOL_DATE_RELATION',
':schoolDate': '2022-09',
':academicCalendarId': 10595,
},
KeyConditionExpression: 'pk = :pkValue AND begins_with(sk, :skValue)',
FilterExpression: 'attribute_not_exists(deleted_at) AND academic_calendar_id = :academicCalendarId AND begins_with(school_date, :schoolDate)',
TableName: 'date',
};
let dates = [];
let lastEvaluatedKey = null;
do {
// Start Key To Query (Like Offset In SQL)
if (lastEvaluatedKey) {
params.ExclusiveStartKey = {
'pk': lastEvaluatedKey.pk,
'sk': lastEvaluatedKey.sk,
};
}
// Get Query Result
const result = await dynamoDB.query(params).promise();
// console.log('lel', result);
// If Last Evaluated Key Exists it Means There is Still Data on DynamoDB
lastEvaluatedKey =
typeof result.LastEvaluatedKey !== 'undefined' ? result.LastEvaluatedKey : null;
// Merge Query Data to Questions
dates = [...dates, ...result.Items];
} while(lastEvaluatedKey);
Editor is loading...