public void queryUsersByTweetCount()
{
Console.WriteLine("\n********** Query Users By Tweet Count Range **********\n");
RecordSet rs = null;
try
{
// NOTE: Index creation has been included in here for convenience and to demonstrate the syntax.
// NOTE: The recommended way of creating indexes in production env is via AQL.
IndexTask task = client.CreateIndex(null, "test", "users", "tweetcount_index", "tweetcount", IndexType.NUMERIC);
task.Wait();
// Get min and max tweet counts
int min;
int max;
Console.WriteLine("\nEnter Min Tweet Count:");
min = int.Parse(Console.ReadLine());
Console.WriteLine("Enter Max Tweet Count:");
max = int.Parse(Console.ReadLine());
string[] bins = { "username", "tweetcount" };
Statement stmt = new Statement();
stmt.SetNamespace("test");
stmt.SetSetName("users");
stmt.SetIndexName("tweetcount_index");
stmt.SetBinNames(bins);
stmt.SetFilters(Filter.Range("tweetcount", min, max));
Console.WriteLine("\nList of users with " + min + "-" + max + " tweets:\n");
rs = client.Query(null, stmt);
while (rs.Next())
{
Record r = rs.Record;
Console.WriteLine(r.GetValue("username") + " has " + r.GetValue("tweetcount") + " tweets");
}
}
finally
{
if (rs != null)
{
// Close record set
rs.Close();
}
}
}
static void Main(string[] args)
{
Console.WriteLine("***** Welcome to Aerospike Developer Training *****\n");
AerospikeClient client = null;
try
{
Console.WriteLine("INFO: Connecting to Aerospike cluster...");
// Connecting to Aerospike cluster
// Specify IP of one of the nodes in the cluster
// Note: Assign your AWS Instance Public IP address to asServerIP
string asServerIP = "54.237.175.53";
// Specity Port that the node is listening on
int asServerPort = 3000;
// TODO: Establish connection
// Exercise K1
client = new AerospikeClient(asServerIP, asServerPort);
// TODO: Check to see if the cluster connection succeeded
// Exercise K1
if (client != null && client.Connected)
{
Console.WriteLine("INFO: Connection to Aerospike cluster succeeded!\n");
// Create instance of UserService
UserService us = new UserService(client);
// Create instance of TweetService
TweetService ts = new TweetService(client);
// Present options
Console.WriteLine("What would you like to do:");
Console.WriteLine("1> Create A User");
Console.WriteLine("2> Create A Tweet By A User");
Console.WriteLine("3> Read A User Record");
Console.WriteLine("4> Batch Read Tweets For A User");
Console.WriteLine("5> Scan All Tweets For All Users");
Console.WriteLine("6> Update User Password Using CAS");
Console.WriteLine("7> Update User Password Using Record UDF");
Console.WriteLine("8> Query Tweets By Username");
Console.WriteLine("9> Query Users By Tweet Count Range");
Console.WriteLine("10> Stream UDF -- Aggregation Based on Tweet Count By Region");
Console.WriteLine("11> Create A Test Set of Users");
Console.WriteLine("12> Create A Test Set of Tweets");
Console.WriteLine("0> Exit");
Console.Write("\nSelect 0-12 and hit enter:");
byte feature = byte.Parse(Console.ReadLine());
if (feature != 0)
{
switch (feature)
{
case 1:
Console.WriteLine("\n********** Your Selection: Create A User **********\n");
us.createUser();
break;
case 2:
Console.WriteLine("\n********** Your Selection: Create A Tweet By A User **********\n");
ts.createTweet();
break;
case 3:
Console.WriteLine("\n********** Your Selection: Read A User Record **********\n");
us.getUser();
break;
case 4:
Console.WriteLine("\n********** Your Selection: Batch Read Tweets For A User **********\n");
us.batchGetUserTweets();
break;
case 5:
Console.WriteLine("\n********** Your Selection: Scan All Tweets For All Users **********\n");
ts.scanAllTweetsForAllUsers();
break;
case 6:
Console.WriteLine("\n********** Your Selection: Update User Password Using CAS **********\n");
us.updatePasswordUsingCAS();
break;
case 7:
Console.WriteLine("\n********** Your Selection: Update User Password Using Record UDF **********\n");
us.updatePasswordUsingUDF();
break;
case 8:
Console.WriteLine("\n********** Your Selection: Query Tweets By Username **********\n");
ts.queryTweetsByUsername();
break;
case 9:
Console.WriteLine("\n********** Your Selection: Query Users By Tweet Count Range **********\n");
ts.queryUsersByTweetCount();
break;
case 10:
Console.WriteLine("\n********** Your Selection: Stream UDF -- Aggregation Based on Tweet Count By Region **********\n");
us.aggregateUsersByTweetCountByRegion();
break;
case 11:
Console.WriteLine("\n********** Create A Test Set of Users **********\n");
us.createUsers();
break;
case 12:
Console.WriteLine("\n********** Create A Test Set of Tweets **********\n");
ts.createTweets();
break;
default:
Console.WriteLine("\n********** Invalid Selection **********\n");
break;
}
}
}
else
{
Console.Write("ERROR: Connection to Aerospike cluster failed! Please check IP & Port settings and try again!");
Console.ReadLine();
}
}
catch (AerospikeException e)
{
Console.WriteLine("AerospikeException - Message: " + e.Message);
Console.WriteLine("AerospikeException - StackTrace: " + e.StackTrace);
}
catch (Exception e)
{
Console.WriteLine("Exception - Message: " + e.Message);
Console.WriteLine("Exception - StackTrace: " + e.StackTrace);
}
finally
{
if (client != null && client.Connected)
{
// TODO: Close Aerospike server connection
// Exercise K1
client.Close();
}
Console.Write("\n\nINFO: Press any key to exit...");
Console.ReadLine();
}
} //main
