public object Post(Rockstars request)
{
var db = DbFactory.OpenDbConnection();
db.Insert(request.TranslateTo <Rockstar>());
return(Get(new Rockstars()));
}
public object Get(Rockstars request)
{
using (var db = DbFactory.OpenDbConnection())
{
if (request.Delete == "reset")
{
db.DeleteAll <Rockstar>();
db.Insert(Rockstar.SeedData);
}
else if (request.Delete.IsInt())
{
db.DeleteById <Rockstar>(request.Delete.ToInt());
}
return(new RockstarsResponse
{
Aged = request.Age,
Total = db.GetScalar <int>("select count(*) from Rockstar"),
Results = request.Id != default(int) ?
db.Select <Rockstar>(q => q.Id == request.Id)
: request.Age.HasValue ?
db.Select <Rockstar>(q => q.Age == request.Age.Value)
: db.Select <Rockstar>()
});
}
}
public void Cached_DynamoQuery_does_cached_duplicate_requests_when_MaxAge_Custom_Cached()
{
var request = new CustomQueryCacheMaxAgeDataRockstars();
var client = new CachedServiceClient(new JsonServiceClient(Config.ListeningOn));
var response = client.Get(request);
Assert.That(client.CacheHits, Is.EqualTo(0));
Assert.That(response.Results.Count, Is.EqualTo(Rockstars.Count));
response = client.Get(request);
Assert.That(client.CacheHits, Is.EqualTo(1));
Assert.That(response.Results.Count, Is.EqualTo(Rockstars.Count));
response = client.Get(new CustomQueryCacheMaxAgeDataRockstars {
Age = 27
});
Assert.That(client.CacheHits, Is.EqualTo(1));
Assert.That(response.Results.Count, Is.EqualTo(Rockstars.Count(x => x.Age == 27)));
}
public void Cached_DynamoQuery_does_return_NotModified_when_MustRevalidate()
{
var request = new QueryCacheMustRevalidateDataRockstars();
var client = new CachedServiceClient(new JsonServiceClient(Config.ListeningOn));
var response = client.Get(request);
Assert.That(client.NotModifiedHits, Is.EqualTo(0));
Assert.That(response.Results.Count, Is.EqualTo(Rockstars.Count));
response = client.Get(request);
Assert.That(client.NotModifiedHits, Is.EqualTo(1));
Assert.That(response.Results.Count, Is.EqualTo(Rockstars.Count));
response = client.Get(new QueryCacheMustRevalidateDataRockstars {
Age = 27
});
Assert.That(client.CacheHits, Is.EqualTo(0));
Assert.That(client.NotModifiedHits, Is.EqualTo(1));
Assert.That(response.Results.Count, Is.EqualTo(Rockstars.Count(x => x.Age == 27)));
}
public object Get(Rockstars request)
{
if (request.Delete == "reset")
{
Db.DeleteAll <Rockstar>();
Db.Insert(Rockstar.SeedData);
}
else if (request.Delete.IsInt())
{
Db.DeleteById <Rockstar>(request.Delete.ToInt());
}
return(new RockstarsResponse
{
Aged = request.Age,
Total = Db.Scalar <int>("select count(*) from Rockstar"),
Results = request.Id != default(int) ?
Db.Select <Rockstar>(q => q.Id == request.Id)
: request.Age.HasValue ?
Db.Select <Rockstar>(q => q.Age == request.Age.Value)
: Db.Select <Rockstar>()
});
}
public object Post(Rockstars request)
{
Db.Insert(request.ConvertTo <Rockstar>());
return(Get(new Rockstars()));
}
public object Post(Rockstars request)
{
Db.Insert(request.ConvertTo<Rockstar>());
return Get(new Rockstars());
}
public object Get(Rockstars request)
{
if (request.Delete == "reset")
{
Db.DeleteAll<Rockstar>();
Db.Insert(Rockstar.SeedData);
}
else if (request.Delete.IsInt())
{
Db.DeleteById<Rockstar>(request.Delete.ToInt());
}
return new RockstarsResponse
{
Aged = request.Age,
Total = Db.Scalar<int>("select count(*) from Rockstar"),
Results = request.Id != default(int) ?
Db.Select<Rockstar>(q => q.Id == request.Id)
: request.Age.HasValue ?
Db.Select<Rockstar>(q => q.Age == request.Age.Value)
: Db.Select<Rockstar>()
};
}
/// <summary>Post this message.</summary>
///
/// <param name="request">The request.</param>
///
/// <returns>An object.</returns>
public object Post(Rockstars request)
{
Db.Insert(request.TranslateTo<Rockstar>());
return Get(new Rockstars());
}
/// <summary>Post this message.</summary>
///
/// <param name="request">The request.</param>
///
/// <returns>An object.</returns>
public object Post(Rockstars request)
{
Db.Insert(request.TranslateTo <Rockstar>());
return(Get(new Rockstars()));
}
public object Post(Rockstars request)
{
var db = DbFactory.OpenDbConnection();
db.Insert(request.TranslateTo<Rockstar>());
return Get(new Rockstars());
}
public object Get(Rockstars request)
{
using (var db = DbFactory.OpenDbConnection())
{
if (request.Delete == "reset")
{
db.DeleteAll<Rockstar>();
db.Insert(Rockstar.SeedData);
}
else if (request.Delete.IsInt())
{
db.DeleteById<Rockstar>(request.Delete.ToInt());
}
return new RockstarsResponse
{
Aged = request.Age,
Total = db.GetScalar<int>("select count(*) from Rockstar"),
Results = request.Id != default(int) ?
db.Select<Rockstar>(q => q.Id == request.Id)
: request.Age.HasValue ?
db.Select<Rockstar>(q => q.Age == request.Age.Value)
: db.Select<Rockstar>()
};
}
}
public object Get(Rockstars request)
{
return(new RockstarsResponse {
Total = request.Age.Value + 500
});
}
