[Feature Request] GetMaxKey & GetMinKey functions

[thepra]

Having a way to get the min or max key of a storage would be nice given that I can implement logic about automatic cleanup of a table(here's where it comes from).

Something like:

await manager.GetMaxKey<long>(nameof(ClientLogs));
await manager.GetMinKey<long>(nameof(ClientLogs));

[tfrank7415]

I'm working this issue. I want to ensure I understand the intent of the requested functions.

1. GetMaxKey(string storeName): This function would return the max (largest) index value for a given store. For instance, in the below image GetMaxKey() would return '2'.
2. GetMinKey(string storeName): This function would return the min (smallest) index value for a given store. For instance, in the below image GetMinKey() would return '0'.

Is my understanding above correct? If so, I propose we name the functions something like GetFirstIndex(storeName) and GetLastIndex(storeName). GetMaxKey() implies we are getting the maximum value of the Key column. I use guids as ids in my Key column, so getting the max and min value will not be useful. However, getting the index of the first and last entry could be useful for cleanup tasks.

@thepra @nwestfall

[thepra]

Yep, correct. I'm good with "index" too :)

[tfrank7415]

Perfect. I'll start working on it.