static void primeProuctCache()
{
if (!confirmOperation("YOUR CACHE WILL BE FLUSHED! ALL EXISTING INDEXES WILL BE REPLACED! Are you sure?"))
{
return;
}
CloudStorageAccount account = CloudStorageAccount.Parse(mStorageConnectionString);
var client = account.CreateCloudTableClient();
var table = client.GetTableReference("products");
var query = from c in table.CreateQuery <Product>()
select c;
var connection = new BookSleeve.RedisConnection(mCacheUrl2, allowAdmin: true,
password: mCachePassword2);
connection.Open();
//connection.Server.FlushDb(0);
foreach (var c in query)
{
string key = string.Format("{0}:{1}:{2}:{3}:{4}", c.PartitionKey, c.RowKey, c.Name, c.Price, c.Rate);
Console.WriteLine("{0}:{1}", key, c.Name);
connection.SortedSets.Add(0, "cat:" + c.Category, key, c.Price);
connection.SortedSets.Add(0, "rate:" + c.Category, key, c.Rate);
connection.Strings.Set(0, "prod:" + c.Category + ":" + c.Name.Replace(' ', ':'), key);
}
connection.Close(false);
}
private List <Product> getProducts(string category, double start, double end)
{
List <Product> ret = new List <Product>();
BookSleeve.RedisConnection connection = new BookSleeve.RedisConnection(redisUrl2,
password: redisPassword2);
connection.Open();
var list = connection.SortedSets.Range(0, "cat:" + category, min: start, max: end, ascending: false).Result;
foreach (var item in list)
{
string[] parts = Encoding.ASCII.GetString(item.Key).Split(':');
if (parts.Length == 5)
{
ret.Add(new Product
{
Category = parts[0],
Name = parts[2],
Price = (int)(double.Parse(parts[3]) * 100) / 100.0,
Rate = int.Parse(parts[4])
});
}
}
connection.Close(false);
return(ret);
}
public List<string> Get(string prefix)
{
List<string> ret = new List<string>();
BookSleeve.RedisConnection connection = new BookSleeve.RedisConnection(".redis.cache.windows.net",
password:"");
connection.Open();
var list = connection.Wait(connection.Keys.Find(0, "cust:" + prefix.Replace(' ', ':') + "*"));
for (int i = 0; i < Math.Min(5, list.Length); i++)
{
ret.Add(list[i].Substring(5).Replace(':',' '));
}
connection.Close(false);
return ret;
}
public List<string> Get(string prefix)
{
List<string> ret = new List<string>();
BookSleeve.RedisConnection connection = new BookSleeve.RedisConnection(ConfigurationManager.AppSettings["mCacheUrl"],
password: ConfigurationManager.AppSettings["mCachePassword"]);
connection.Open();
var list = connection.Wait(connection.Keys.Find(0, "cust:" + prefix.Replace(' ', ':') + "*"));
for (int i = 0; i < Math.Min(5, list.Length); i++)
{
ret.Add(list[i].Substring(5).Replace(':',' '));
}
connection.Close(false);
return ret;
}
public List<string> Get(string prefix, string category)
{
List<string> ret = new List<string>();
BookSleeve.RedisConnection connection = new BookSleeve.RedisConnection(".redis.cache.windows.net",
password: "");
connection.Open();
var list = connection.Wait(connection.Keys.Find(0, "prod:" + category + ":" + prefix.Replace(' ', ':') + "*"));
for (int i = 0; i < Math.Min(5, list.Length); i++)
{
string s = list[i].Substring(5);
s = s.Substring(s.IndexOf(':') + 1);
ret.Add(s.Replace(':',' '));
}
connection.Close(false);
return ret;
}
public List <string> Get(string prefix)
{
List <string> ret = new List <string>();
BookSleeve.RedisConnection connection = new BookSleeve.RedisConnection(".redis.cache.windows.net",
password: "");
connection.Open();
var list = connection.Wait(connection.Keys.Find(0, "cust:" + prefix.Replace(' ', ':') + "*"));
for (int i = 0; i < Math.Min(5, list.Length); i++)
{
ret.Add(list[i].Substring(5).Replace(':', ' '));
}
connection.Close(false);
return(ret);
}
private List <string> getTopKeys(string category, int top)
{
List <string> ret = new List <string>();
BookSleeve.RedisConnection connection = new BookSleeve.RedisConnection(redisUrl2,
password: redisPassword2);
connection.Open();
var list = connection.SortedSets.Range(0, "rate:" + category, start: 0, stop: top - 1, ascending: false).Result;
foreach (var item in list)
{
ret.Add(Encoding.ASCII.GetString(item.Key));
}
connection.Close(false);
return(ret);
}
public List<string> Get(string prefix, string category)
{
List<string> ret = new List<string>();
BookSleeve.RedisConnection connection = new BookSleeve.RedisConnection(ConfigurationManager.AppSettings["mCacheUrl2"],
password: ConfigurationManager.AppSettings["mCachePassword2"]);
connection.Open();
var list = connection.Wait(connection.Keys.Find(0, "prod:" + category + ":" + prefix.Replace(' ', ':') + "*"));
for (int i = 0; i < Math.Min(5, list.Length); i++)
{
string s = list[i].Substring(5);
s = s.Substring(s.IndexOf(':') + 1);
ret.Add(s.Replace(':',' '));
}
connection.Close(false);
return ret;
}
public List <string> Get(string prefix)
{
List <string> ret = new List <string>();
BookSleeve.RedisConnection connection = new BookSleeve.RedisConnection(ConfigurationManager.AppSettings["mCacheUrl"],
password: ConfigurationManager.AppSettings["mCachePassword"]);
connection.Open();
var list = connection.Wait(connection.Keys.Find(0, "cust:" + prefix.Replace(' ', ':') + "*"));
for (int i = 0; i < Math.Min(5, list.Length); i++)
{
ret.Add(list[i].Substring(5).Replace(':', ' '));
}
connection.Close(false);
return(ret);
}
public List <string> Get(string prefix, string category)
{
List <string> ret = new List <string>();
BookSleeve.RedisConnection connection = new BookSleeve.RedisConnection(ConfigurationManager.AppSettings["mCacheUrl2"],
password: ConfigurationManager.AppSettings["mCachePassword2"]);
connection.Open();
var list = connection.Wait(connection.Keys.Find(0, "prod:" + category + ":" + prefix.Replace(' ', ':') + "*"));
for (int i = 0; i < Math.Min(5, list.Length); i++)
{
string s = list[i].Substring(5);
s = s.Substring(s.IndexOf(':') + 1);
ret.Add(s.Replace(':', ' '));
}
connection.Close(false);
return(ret);
}
public async static void BooksleeveIncrement()
{
var sw = new System.Diagnostics.Stopwatch();
sw.Start();
using (var conn = new BookSleeve.RedisConnection("localhost"))
{
await conn.Open();
await conn.Keys.Remove(0, "Increment");
for (int i = 0; i < iterations; i++)
{
conn.Strings.Increment(0, "Increment");
}
var x = await conn.Strings.Get(0, "Increment");
sw.Stop();
Console.WriteLine(x);
Console.WriteLine(sw.ElapsedMilliseconds);
}
}
static void primeProuctCache()
{
if (!confirmOperation("YOUR CACHE WILL BE FLUSHED! ALL EXISTING INDEXES WILL BE REPLACED! Are you sure?"))
return;
CloudStorageAccount account = CloudStorageAccount.Parse(mStorageConnectionString);
var client = account.CreateCloudTableClient();
var table = client.GetTableReference("products");
var query = from c in table.CreateQuery<Product>()
select c;
var connection = new BookSleeve.RedisConnection(mCacheUrl2, allowAdmin: true,
password: mCachePassword2);
connection.Open();
connection.Server.FlushDb(0);
foreach (var c in query)
{
string key = string.Format("{0}:{1}:{2}:{3}:{4}", c.PartitionKey, c.RowKey, c.Name, c.Price, c.Rate);
Console.WriteLine("{0}:{1}", key, c.Name);
connection.SortedSets.Add(0, "cat:" + c.Category, key, c.Price);
connection.SortedSets.Add(0, "rate:" + c.Category, key, c.Rate);
connection.Strings.Set(0, "prod:" + c.Category + ":" + c.Name.Replace(' ', ':'), key);
}
connection.Close(false);
}
private List<string> getTopKeys(string category, int top)
{
List<string> ret = new List<string>();
BookSleeve.RedisConnection connection = new BookSleeve.RedisConnection(redisUrl2,
password: redisPassword2);
connection.Open();
var list = connection.SortedSets.Range(0, "rate:" + category, start:0, stop:top, ascending: false).Result;
foreach (var item in list)
ret.Add(Encoding.ASCII.GetString(item.Key));
connection.Close(false);
return ret;
}
private List<Product> getProducts(string category, double start, double end)
{
List<Product> ret = new List<Product>();
BookSleeve.RedisConnection connection = new BookSleeve.RedisConnection(redisUrl2,
password: redisPassword2);
connection.Open();
var list = connection.SortedSets.Range(0, "cat:" + category, min:start, max:end, ascending:false).Result;
foreach (var item in list)
{
string[] parts = Encoding.ASCII.GetString(item.Key).Split(':');
if (parts.Length == 5)
ret.Add(new Product
{
Category = parts[0],
Name = parts[2],
Price = (int)(double.Parse(parts[3]) * 100) / 100.0,
Rate = int.Parse(parts[4])
});
}
connection.Close(false);
return ret;
}
public async static void BooksleeveIncrement()
{
var sw = new System.Diagnostics.Stopwatch();
sw.Start();
using (var conn = new BookSleeve.RedisConnection("localhost"))
{
await conn.Open();
await conn.Keys.Remove(0, "Increment");
for (int i = 0; i < iterations; i++)
{
conn.Strings.Increment(0, "Increment");
}
var x = await conn.Strings.Get(0, "Increment");
sw.Stop();
Console.WriteLine(x);
Console.WriteLine(sw.ElapsedMilliseconds);
}
}
