def test_query():
conn = boto.connect_dynamodb()
table = create_table(conn)
item_data = {
'Body': 'http://url_to_lolcat.gif',
'SentBy': 'User A',
'ReceivedTime': '12/9/2011 11:36:03 PM',
}
item = table.new_item(
hash_key='the-key',
range_key='456',
attrs=item_data,
)
item.put()
item = table.new_item(
hash_key='the-key',
range_key='123',
attrs=item_data,
)
item.put()
item = table.new_item(
hash_key='the-key',
range_key='789',
attrs=item_data,
)
item.put()
results = table.query(hash_key='the-key',
range_key_condition=condition.GT('1'))
results.response['Items'].should.have.length_of(3)
results = table.query(hash_key='the-key',
range_key_condition=condition.GT('234'))
results.response['Items'].should.have.length_of(2)
results = table.query(hash_key='the-key',
range_key_condition=condition.GT('9999'))
results.response['Items'].should.have.length_of(0)
results = table.query(hash_key='the-key',
range_key_condition=condition.CONTAINS('12'))
results.response['Items'].should.have.length_of(1)
results = table.query(hash_key='the-key',
range_key_condition=condition.BEGINS_WITH('7'))
results.response['Items'].should.have.length_of(1)
results = table.query(hash_key='the-key',
range_key_condition=condition.BETWEEN('567', '890'))
results.response['Items'].should.have.length_of(1)
def test_query():
conn = boto.connect_dynamodb()
table = create_table(conn)
item_data = {
"Body": "http://url_to_lolcat.gif",
"SentBy": "User A",
"ReceivedTime": "12/9/2011 11:36:03 PM",
}
item = table.new_item(hash_key="the-key", range_key="456", attrs=item_data)
item.put()
item = table.new_item(hash_key="the-key", range_key="123", attrs=item_data)
item.put()
item = table.new_item(hash_key="the-key", range_key="789", attrs=item_data)
item.put()
results = table.query(hash_key="the-key", range_key_condition=condition.GT("1"))
results.response["Items"].should.have.length_of(3)
results = table.query(hash_key="the-key", range_key_condition=condition.GT("234"))
results.response["Items"].should.have.length_of(2)
results = table.query(hash_key="the-key", range_key_condition=condition.GT("9999"))
results.response["Items"].should.have.length_of(0)
results = table.query(
hash_key="the-key", range_key_condition=condition.CONTAINS("12")
)
results.response["Items"].should.have.length_of(1)
results = table.query(
hash_key="the-key", range_key_condition=condition.BEGINS_WITH("7")
)
results.response["Items"].should.have.length_of(1)
results = table.query(
hash_key="the-key", range_key_condition=condition.BETWEEN("567", "890")
)
results.response["Items"].should.have.length_of(1)
def main():
db = boto.connect_dynamodb()
raw_input(
"I am now going to create two tables called zipcodes and zipcodes2. Press enter to continue."
)
schema1 = db.create_schema(hash_key_name='zip codes',
hash_key_proto_value=str)
schema2 = db.create_schema(hash_key_name='town',
hash_key_proto_value=str,
range_key_name='person',
range_key_proto_value=str)
try:
table1 = createTable('zipcodes', schema1)
except:
pass
try:
table2 = createTable('zipcodes2', schema2)
except:
pass
for x in db.list_tables():
print db.get_table(x)
table1 = db.get_table('zipcodes')
table2 = db.get_table('zipcodes2')
raw_input(
"Here is a description of each table in my account. First table 1 then table 2."
)
for x in db.list_tables():
print ""
for a, b in db.describe_table(x)['Table'].items():
print a, b
raw_input("I am now going to add the data from the text file online.\n")
text = urllib2.urlopen(
"https://s3.amazonaws.com/depasquale/datasets/zipcodes.txt")
for x in range(0, 20):
y = text.readline().split(',')
zip = y[0].replace('"', '')
#print zip;
long = float(y[1].replace('"', ''))
lat = float(y[2].replace('"', ''))
town = y[3].replace('"', '')
city = y[4].replace('"', '')
lName = y[5].replace('"', '')
fName = y[6].replace('"', '')
item_data = {
'long': long,
'lat': lat,
'town': town,
'city': city,
'lName': lName,
'fName': fName,
}
item = table1.new_item(hash_key=zip, attrs=item_data)
#print item
item.put()
#for z in range(0,len(y)):
# if (z!=2 or z!=1):
# print y[z].replace('"','')
# else:
# print y[z]
raw_input("First table loaded. Time to load the second!")
#Seconds table
text2 = urllib2.urlopen(
"https://s3.amazonaws.com/depasquale/datasets/zipcodes.txt")
for x in range(0, 40):
y = text2.readline().split(',')
zip = y[0].replace('"', '')
long = float(y[1].replace('"', ''))
lat = float(y[2].replace('"', ''))
town = y[3].replace('"', '')
city = y[4].replace('"', '')
lName = y[5].replace('"', '')
fName = y[6].replace('"', '')
item_data = {
'long': long,
'lat': lat,
'town': town,
'lName': lName,
'fName': fName,
}
item = table2.new_item(hash_key=town, range_key=zip, attrs=item_data)
item.put()
#for z in range(0,len(y)):
# if (z!=2 or z!=1):
# print y[z].replace('"','')
# else:
# print y[z]
raw_input("Done loading the second table...\n")
raw_input(
"Here are the results for Table 1 Hash Key only table zips > 00610:")
print ""
result = table1.scan(scan_filter={'zip codes': condition.GT("00610")})
for x in result:
print x
print ""
raw_input("Table 2 query: City name is ARECIBO:")
print ""
result = table2.query(hash_key="ARECIBO")
for x in result:
print x
print ""
raw_input("Table 2 query: City name greater than ARECIBO:")
print ""
result = table2.scan(scan_filter={'town': condition.GT("ARECIBO")})
for x in result:
print x
print ""
zipToDelete = raw_input(
"Let's delete a record. Enter a record with a zip to delete from table1: "
)
toDelete = table1.scan(
scan_filter={'zip codes': condition.EQ(zipToDelete)})
for x in toDelete:
print x
raw_input("The tupple above is going to be removed after enter")
expected_value = {'zip codes': zipToDelete}
table1.get_item(zipToDelete).delete()
raw_input("The Vale should be deleted. Go check!")
zipToDelete = raw_input(
"Let's change a record. Enter the zip of the record to change: ")
field = raw_input("enter the name of the field to change: ")
changeTo = raw_input("What would you like to change it too?: ")
ourItem = table1.get_item(hash_key=zipToDelete)
ourItem[field] = changeTo
ourItem.put()
raw_input(
"Value changed. I am going to change the throughput for both of the tables."
)
#try:
# table1.update_throughput(2,2);
#except:
# print "error"
raw_input("Table1 throughput changed")
try:
table2.update_throughput(3, 3)
except:
print "error"
raw_input("Table2 throughput changed")
raw_input("I am now going to delete both tables. Press enter to delete.")
try:
table1.delete()
table2.delete()
except:
pass