public void Run()
{
Console.WriteLine();
Console.WriteLine("Welcome to the Movie database terminal!");
Console.WriteLine("Write EXIT to quit");
Console.WriteLine();
Console.WriteLine("Example query: NOT Seen AND Score > 60");
Console.WriteLine();
while (true)
{
try
{
// Get input from the user.
string query = GetInput();
if (query.Equals("exit", StringComparison.OrdinalIgnoreCase))
{
break;
}
// Query the EF context for movies.
var movies = _provider.Query <Movie>(_context, query).ToList();
// Output the result.
OutputMovies(movies);
}
catch (Exception ex)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("ERROR: {0}", ex.Message);
Console.WriteLine();
Console.ResetColor();
}
}
}
public async Task <IActionResult> Queried([FromQuery] string q)
{
var candidates = await QueryProvider.Query <Position>(Db, q)
.ToListAsync();
return(Ok(candidates));
}
public List <TEntity> Query <TEntity>(string query)
where TEntity : class
{
if (_provider == null)
{
throw new InvalidOperationException("Query provider fixture has not been initialized.");
}
using (var context = new DataContext(_builder.Options))
{
return(_provider.Query <TEntity>(context, query).ToList());
}
}
public IActionResult Index(string query = null)
{
var movies = _provider.Query <Movie>(_context, query)
.Include(m => m.Genres).ThenInclude(g => g.Genre)
.OrderByDescending(movie => movie.Rating)
.ToList();
return(View(new SearchResultModel <Movie>
{
Movies = movies,
Query = query
}));
}
public IQueryable <TEntity> Query <TEntity>(string query)
where TEntity : class
{
return(_provider.Query <TEntity>(_context, query));
}