forTenant method
Every key on tenant, oldest first.
Implementation
Future<List<DVApiKey>> forTenant(String tenant) async {
final List<Map<String, Object?>> rows = await database.query(
'SELECT id FROM dv_api_keys WHERE tenant = ?',
<Object?>[tenant],
);
final List<DVApiKey> keys = <DVApiKey>[
for (final Map<String, Object?> row in rows)
if (await find('${row['id']}') case final DVApiKey key) key,
]..sort((DVApiKey a, DVApiKey b) => a.createdAt.compareTo(b.createdAt));
return keys;
}