public Dictionary<string, object> GetPinWithPinID(string owner, double pinDate)
{
Dictionary<string, object> retval = new Dictionary<string, object>();
QueryResponse response;
var config = new AmazonDynamoDBConfig();
config.ServiceURL = System.Configuration.ConfigurationManager.AppSettings["ServiceURL"];
client = new AmazonDynamoDBClient(config);
try
{
QueryRequest request = new QueryRequest()
{
TableName = "Pin",
KeyConditions = new Dictionary<string, Condition>()
{
{
"Owner",
new Condition()
{
ComparisonOperator = ComparisonOperator.EQ,
AttributeValueList = new List<AttributeValue> { new AttributeValue { S = owner } }
}
},
{
"PinDate",
new Condition()
{
ComparisonOperator = ComparisonOperator.EQ,
AttributeValueList = new List<AttributeValue> { new AttributeValue { N = pinDate.ToString() } }
}
}
}
};
response = client.Query(request);
retval.Add("Title", response.Items[0]["Title"].S);
retval.Add("Owner", response.Items[0]["Owner"].S);
retval.Add("OwnerName", response.Items[0]["UserName"].S);
retval.Add("OwnerHeadshot", response.Items[0]["HeadshotURL"].S);
retval.Add("Latitude", response.Items[0]["Latitude"].S);
retval.Add("Longitude", response.Items[0]["Longitude"].S);
retval.Add("PinDate", Convert.ToDouble(response.Items[0]["PinDate"].N));
retval.Add("Images", response.Items[0]["Images"].SS);
}
catch (AmazonDynamoDBException e) { Console.WriteLine(e.Message); }
catch (AmazonServiceException e) { Console.WriteLine(e.Message); }
catch (Exception e) { Console.WriteLine(e.Message); }
return retval;
}
public List<Dictionary<string, object>> GetPinWithUserIDs(List<string> userIDs, double since, int takeCnt)
{
List<Dictionary<string, object>> retval = new List<Dictionary<string, object>>();
Dictionary<string, object> tmpObject = null;
var config = new AmazonDynamoDBConfig();
config.ServiceURL = System.Configuration.ConfigurationManager.AppSettings["ServiceURL"];
client = new AmazonDynamoDBClient(config);
List<AttributeValue> users = new List<AttributeValue>();
foreach (string item in userIDs)
{
users.Add(new AttributeValue() { S = item });
}
try
{
ScanRequest sreq = new ScanRequest()
{
TableName = "Pin",
ScanFilter = new Dictionary<string, Condition>()
{
{ "Owner",
new Condition
{
ComparisonOperator = ComparisonOperator.IN,
AttributeValueList = users
}
},
{
"PinDate",
new Condition()
{
ComparisonOperator = ComparisonOperator.LT,
AttributeValueList = new List<AttributeValue> { new AttributeValue { N = since.ToString() } }
}
}
}
};
var response = client.Scan(sreq);
foreach (var item in response.Items)
{
tmpObject = new Dictionary<string, object>();
tmpObject.Add("Title", item["Title"].S);
tmpObject.Add("Owner", item["Owner"].S);
tmpObject.Add("OwnerName", item["UserName"].S);
tmpObject.Add("OwnerHeadshot", item["HeadshotURL"].S);
tmpObject.Add("Latitude", item["Latitude"].S);
tmpObject.Add("Longitude", item["Longitude"].S);
tmpObject.Add("PinDate", Convert.ToDouble(item["PinDate"].N));
tmpObject.Add("Images", item["Images"].SS);
retval.Add(tmpObject);
}
retval = retval.OrderByDescending(a => a["PinDate"]).ToList<Dictionary<string, object>>();
}
catch (AmazonDynamoDBException e) { Console.WriteLine(e.Message); }
catch (AmazonServiceException e) { Console.WriteLine(e.Message); }
catch (Exception e) { Console.WriteLine(e.Message); }
return retval;
}
public Dictionary<string, object> GetUser(string userID)
{
Dictionary<string, object> retval = new Dictionary<string, object>();
GetItemResponse response;
var config = new AmazonDynamoDBConfig();
config.ServiceURL = System.Configuration.ConfigurationManager.AppSettings["ServiceURL"];
client = new AmazonDynamoDBClient(config);
try
{
GetItemRequest request = new GetItemRequest
{
TableName = "User",
Key = new Dictionary<string, AttributeValue>() { { "UserID", new AttributeValue { S = userID } } },
ReturnConsumedCapacity = "TOTAL"
};
response = client.GetItem(request);
retval.Add("UserID", response.Item["UserID"].S);
retval.Add("HeadshotURL", response.Item["HeadshotURL"].S);
retval.Add("IsPayUser", Convert.ToBoolean(response.Item["IsPayUser"].S));
retval.Add("UserName", response.Item["UserName"].S);
retval.Add("RegistDate", response.Item["RegistDate"].N);
retval.Add("LastLoginDate", response.Item["LastLoginDate"].N);
retval.Add("LastSyncDate", response.Item["LastSyncDate"].N);
}
catch (AmazonDynamoDBException e) { Console.WriteLine(e.Message); }
catch (AmazonServiceException e) { Console.WriteLine(e.Message); }
catch (Exception e) { Console.WriteLine(e.Message); }
return retval;
}
public List<Dictionary<string, object>> GetPinWithUserID(string userID, double since, int takeCnt)
{
List<Dictionary<string, object>> retval = new List<Dictionary<string, object>>();
Dictionary<string, object> tmpObject = null;
QueryResponse response = null;
var config = new AmazonDynamoDBConfig();
config.ServiceURL = System.Configuration.ConfigurationManager.AppSettings["ServiceURL"];
client = new AmazonDynamoDBClient(config);
try
{
QueryRequest query = new QueryRequest()
{
TableName = "Pin",
KeyConditions = new Dictionary<string, Condition>()
{
{
"Owner",
new Condition()
{
ComparisonOperator = ComparisonOperator.EQ,
AttributeValueList = new List<AttributeValue> { new AttributeValue { S = userID } }
}
},
{
"PinDate",
new Condition()
{
ComparisonOperator = ComparisonOperator.LT,
AttributeValueList = new List<AttributeValue> { new AttributeValue { N = since.ToString() } }
}
}
},
Limit = takeCnt,
ScanIndexForward = false
};
response = client.Query(query);
foreach (var item in response.Items)
{
tmpObject = new Dictionary<string, object>();
tmpObject.Add("Title", item["Title"].S);
tmpObject.Add("Owner", item["Owner"].S);
tmpObject.Add("OwnerName", item["UserName"].S);
tmpObject.Add("OwnerHeadshot", item["HeadshotURL"].S);
tmpObject.Add("Latitude", item["Latitude"].S);
tmpObject.Add("Longitude", item["Longitude"].S);
tmpObject.Add("PinDate", Convert.ToDouble(item["PinDate"].N));
tmpObject.Add("Images", item["Images"].SS);
retval.Add(tmpObject);
}
}
catch (AmazonDynamoDBException e) { Console.WriteLine(e.Message); }
catch (AmazonServiceException e) { Console.WriteLine(e.Message); }
catch (Exception e) { Console.WriteLine(e.Message); }
return retval;
}