Justin
Justin

Reputation: 9801

Enumerate keys in Amazon SimpleDB

I'm trying to enumerate keys in Amazon SimpleDB. In SQL, it would be something like:

select unique itemName() from domain;

I've searched around but didn't find any way to do this. Any help?

Upvotes: 5

Views: 505

Answers (2)

Darryl
Darryl

Reputation: 1541

By definition, items in a domain are unique, so you were almost there:

select itemName() from domain

Upvotes: 6

Alex Martelli
Alex Martelli

Reputation: 882133

AFAIK SimpleDB doesn't do unique, but apart from that:

select itemName() from mydomain order by itemName()

should work, and you can remove duplicates (if any) very easily, since you're getting the names in sorted order (e.g. itertools.groupby in Python, and whatever analogous mechanism in whatever is your favorite language).

Upvotes: 1

Related Questions