private static async Task CreateSchema()
{
var client = new CrateClient("http://clccontainer1.cloudapp.net:4200");
var response = await client.CreateTable <Tweet>(4);
Console.WriteLine("CreateSchema");
Console.WriteLine(response);
}
private static async Task Query()
{
var client = new CrateClient("http://clccontainer1.cloudapp.net:4200");
var statement = "select * from tweeeeets where id >= 14";
var response = await client.SubmitQuery <Tweet>(statement) as SuccessResponse <Tweet>;
Console.WriteLine("Query");
Console.WriteLine(response);
if (response.Result == null)
{
return;
}
foreach (var entry in response.Result)
{
Console.WriteLine(entry);
}
}
private static async Task Insert()
{
var client = new CrateClient("http://clccontainer1.cloudapp.net:4200");
var tweet1 = new Tweet {
Content = "NoSqlExplorer rocks", DoubleProp = 13.37, FloatProp = 6.999999f, Id = 1, Retweeted = false, Created = DateTime.UtcNow
};
var tweet2 = new Tweet {
Content = "NoSqlExplorer still rocks", DoubleProp = 13.37, FloatProp = 6.999999f, Id = 2, Retweeted = false, Created = DateTime.UtcNow
};
var response = await client.Insert(tweet1);
var response2 = await client.Insert(tweet2);
Console.WriteLine("Insert(1)");
Console.WriteLine(response);
Console.WriteLine("Insert(2)");
Console.WriteLine(response2);
}
private static async Task BulkInsert()
{
var client = new CrateClient("http://clccontainer1.cloudapp.net:4200");
var tweets = new List <Tweet>()
{
new Tweet {
Content = "NoSqlExplorer rocks in bulks", DoubleProp = 13.37, FloatProp = 6.999999f, Id = 13, Retweeted = false, Created = DateTime.UtcNow
},
new Tweet {
Content = "NoSqlExplorer still rocks in bulks", DoubleProp = 13.37, FloatProp = 6.999999f, Id = 14, Retweeted = false, Created = DateTime.UtcNow
},
new Tweet {
Content = "NoSqlExplorer still rocks in bulks", DoubleProp = 13.37, FloatProp = 6.999999f, Id = 15, Retweeted = false, Created = DateTime.UtcNow
},
};
var response = await client.BulkInsert(tweets);
Console.WriteLine("BulkInsert");
Console.WriteLine(response);
}
public GetAverageFollowersQueryHandler(CrateClient crateClient) : base(crateClient)
{
}
public GetTweetsWithHashtagQueryHandler(CrateClient crateClient) : base(crateClient)
{
}
public async Task BulkInsertAsync(IList <Tweet> tweets)
{
var crateClient = new CrateClient(_crateUrl);
await Retry.TryAwait <ICrateResponse, HttpRequestException>(() => crateClient.BulkInsert(tweets.Select(t => new CrateTweet(t))));
}
public async Task EnsureTableExistsAsync()
{
var crateClient = new CrateClient(_crateUrl);
await crateClient.CreateTable <CrateTweet>(_shards);
}
protected CrateQueryHandler(CrateClient crateClient)
{
CrateClient = crateClient;
}
