Task 3: Create storage layer application

[HannahBagtasos]

• ASP.NET core application
• Have Rest API endpoint "/query"
• Receives HTTP POST request with JSON body
• JSON body is a string with SQL query

example:

{
"query": "SELECT FROM * WHERE Timestamp > '2016-10-22 05:00' AND Level = 'e' LIMIT 19"
}

Endpoint returns array:

{
"data": [
    ["value 1", "value 2"],
    ["value 3", "value 4"]
]
}

[HannahBagtasos]

https://learn.microsoft.com/en-us/aspnet/core/web-api/?view=aspnetcore-6.0#getting-started-with-aspnet-core-web-apis

[HannahBagtasos]

[HannahBagtasos]

Original base code: Used in task 5

What I execute on localhost:

{
    "query": "SELECT * FROM storage"
}

Updated controller:

using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Data;
using Newtonsoft.Json.Linq;
using Microsoft.Data.Sqlite;

namespace storageApplication.Controllers
{
    [Route("api/[controller]")]
    [ApiController]
    public class QueryController : ControllerBase
    {
        [HttpPost("query")]
        public ActionResult query()
        {
            var data = new List<List<string>>
            {
            new List<string> { "value 1", "value 2" },
            new List<string> { "value 3", "value 4" }
            };

            var results = new { Data = data };

            return Ok(results);
        }

    }

}

Model:

    public class Query
    {
        public string query { get; set; }
    }

[HannahBagtasos]

not using the branch query controller, not needed for task