--- Revision None +++ Revision 303731393838 @@ -0,0 +1,30 @@ +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