require 'rubygems'
require 'right_aws'

sdb = RightAws::SdbInterface.new(aws_access_key, aws_secret_access_key)

# list all SimpleDB Domains for this account
sdb.list_domains

# all pictures
sdb.query("picture")[:items]

# particular picture
uuid = sdb.query("picture")[:items].first
sdb.get_attributes("picture", uuid)

# query pictures
# everything is a string!
sdb.query("picture", "['submitdate' <= '2900']")

# no joins
sdb.query("picture", "['submitdate' <= '2900'] intersection ['status' = 'approved']")

# sorting
sdb.query("picture", "['submitdate' <= '2900'] intersection ['status' = 'approved'] sort 'submitdate'")
sdb.query("picture", "['submitdate' <= '2900'] intersection ['status' = 'approved'] sort 'submitdate' desc")

# paging!
sdb.query("picture", "['submitdate' <= '2900'] intersection ['status' = 'approved'] sort 'submitdate' desc", 11)
#proof
sdb.query("picture", "['submitdate' <= '2900'] intersection ['status' = 'approved'] sort 'submitdate' desc", 11)[:items].length