public void queryTweetsByUsername()
{
Console.WriteLine("\n********** Query Tweets By Username **********\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", "tweets", "username_index", "username", IndexType.STRING);
task.Wait();
// Get username
string username;
Console.WriteLine("\nEnter username:");
username = Console.ReadLine();
if (!string.IsNullOrEmpty (username)) {
string[] bins = { "tweet" };
Statement stmt = new Statement ();
stmt.SetNamespace ("test");
stmt.SetSetName ("tweets");
stmt.SetIndexName ("username_index");
stmt.SetBinNames (bins);
stmt.SetFilters (Filter.Equal ("username", username));
Console.WriteLine ("\nHere's " + username + "'s tweet(s):\n");
rs = client.Query (null, stmt);
while (rs.Next ()) {
Record r = rs.Record;
Console.WriteLine (r.GetValue ("tweet"));
}
} else {
Console.WriteLine ("ERROR: User record not found!");
}
}
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