Revision 303731393838 () - Diff

Link to this snippet: http://friendpaste.com/5bv3gYl3VN1eFM0sXb69ps
Embed:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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