//
// Returns a quote given a quote ID.
//
public Quote Find(string quoteId)
{
if (null == _dbConn)
{
return(null);
}
Quote quote = null;
if (PrincipalTable.TableExists())
{
quote = PrincipalTable.GetQuoteByQid(quoteId);
}
return(quote);
}
//
// Output via the console a single quote given the quote ID
// from the commandline argument "--qid".
//
public static void GetQuoteByQid(IConfiguration config)
{
_logger.Trace("Retrieving quote...");
string cs = null;
try
{
cs = GetConnectionString();
}
catch (System.ArgumentException ex)
{
_logger.Fatal($"Cannot get connection string: {ex.Message}");
Console.WriteLine($"Error: Operation aborted - {ex.Message}.");
return;
}
catch (Exception ex)
{
_logger.Fatal($"Unable to access database : {ex.Message}");
Console.WriteLine($"Error: Operation aborted - {ex.Message}.");
return;
}
MySqlConnection conn = new MySqlConnection(cs);
PrincipalTable.DatabaseConnection = conn;
if (!PrincipalTable.TableExists())
{
_logger.Fatal("Table does not already exist, " +
"cannot locate quotes by ID.");
Console.WriteLine("Error: Operation aborted.");
return;
}
string quoteId = config["qid"];
string qid = config["qid"];
Quote quote = null;
if (null != qid)
{
quote = PrincipalTable.GetQuoteByQid(qid);
}
if (null == quote)
{
string message = $"No quote with ID '{qid}' found.";
_logger.Info(message);
Console.WriteLine(message);
return;
}
_logger.Info("Quote = " + quote.ToString());
Console.WriteLine("-- Quote ID = {0}.", quote.ID);
Console.WriteLine("-- Ext Ref ID = {0}.", quote.ExternalRefID);
Console.WriteLine("-- Quote text = {0}.", quote.Content);
Console.WriteLine("-- Quote source = {0}.", quote.Source);
Console.WriteLine("-- Source URL = {0}.", quote.SourceUrl);
Console.WriteLine("-- Quote entry datetime = {0}.",
quote.EntryDatetime);
Console.WriteLine("-- Quote last mod = {0}.",
quote.ModTimestamp);
Console.WriteLine("-- Quote = {0}.", quote.ToString());
}
