public void insert_maxim()
{
var dao = new MaximSpaDAO();
for (int i = 0; i < 10; i++)
{
var newMaxim = new MaximEntity();
newMaxim.Name = "hello";
newMaxim.Content = "world";
var insertOperation = TableOperation.InsertOrReplace(newMaxim);
dao.MaximTable.Execute(insertOperation);
}
var query = new TableQuery <MaximEntity>();
var maximList = dao.MaximTable.ExecuteQuery(query).ToList();
//var query = new TableQuery<AzureTableLogEntity>();
//var maxRowKey = table.ExecuteQuery(query).Max(item => long.Parse(item.RowKey));
//var log = new AzureTableLogEntity();
//log.PartitionKey = tmpLog.Level;
//log.LogLevel = tmpLog.Level;
//log.Log = tmpLog.Log;
//var insertOperation = TableOperation.InsertOrReplace(log);
//table.Execute(insertOperation);
}
public List <MaximEntity> Get()
{
var dao = new MaximSpaDAO();
var query = new TableQuery <MaximEntity>();
var result = dao.MaximTable.ExecuteQuery(query).ToList();
return(result);
}
public async Task Delete()
{
var dao = new MaximSpaDAO();
var batchOp = new TableBatchOperation();
var query = new TableQuery <MaximEntity>();
foreach (var item in dao.MaximTable.ExecuteQuery(query))
{
var delOp = TableOperation.Delete(item);
batchOp.Add(delOp);
}
var res = dao.MaximTable.ExecuteBatch(batchOp);
}
public MaximEntity Get(string id)
{
var dao = new MaximSpaDAO();
var op = TableOperation.Retrieve <MaximEntity>("PartitionKey", id);
var opResult = dao.MaximTable.Execute(op);
var result = (MaximEntity)opResult.Result;
if (result == null)
{
var msg = new HttpResponseMessage();
msg.StatusCode = HttpStatusCode.NotFound;
msg.Content = new StringContent("id not found in maxim db");
throw new HttpResponseException(msg);
}
return(result);
}
public MaximEntity Post([FromBody] MaximEntity inMaxim)
{
if (inMaxim == null)
{
var msg = new HttpResponseMessage();
msg.StatusCode = HttpStatusCode.BadRequest;
msg.Content = new StringContent("inMaxim is null, bad request, bad json");
throw new HttpResponseException(msg);
}
var dao = new MaximSpaDAO();
var newMaxim = new MaximEntity();
newMaxim.Name = inMaxim.Name;
newMaxim.Content = inMaxim.Content;
var op = TableOperation.InsertOrReplace(newMaxim);
dao.MaximTable.Execute(op);
return(newMaxim);
}
public void cleanup_maxim()
{
var dao = new MaximSpaDAO();
dao.MaximTable.DeleteIfExists();
}
