protected void InsertPublishedWorkbookMetadata(LogsharkRunMetadata metadata)
{
using (IDbConnection db = connectionFactory.OpenDbConnection())
{
db.InsertAll(metadata.PublishedWorkbookMetadataRecords);
}
}
protected void InsertPluginExecutionMetadata(LogsharkRunMetadata metadata)
{
using (IDbConnection db = connectionFactory.OpenDbConnection())
{
db.InsertAll(metadata.PluginExecutionMetadataRecords);
}
}
public LogsharkPluginExecutionMetadata(IPluginResponse pluginResponse, LogsharkRunMetadata runMetadata, DateTime timestamp, string pluginVersion)
{
this.runMetadata = runMetadata;
PluginVersion = pluginVersion;
PluginName = pluginResponse.PluginName;
IsSuccessful = pluginResponse.SuccessfulExecution;
FailureReason = pluginResponse.FailureReason;
Timestamp = timestamp;
ElapsedSeconds = pluginResponse.PluginRunTime.TotalSeconds;
}
public void WritePublishedWorkbookMetadata(LogsharkRequest request)
{
try
{
var metadata = new LogsharkRunMetadata(request);
InsertPublishedWorkbookMetadata(metadata);
}
catch (Exception ex)
{
throw new MetadataWriterException(String.Format("Failed to insert Logshark published workbook metadata for run '{0}' to database: {1}", request.RunId, ex.Message), ex);
}
}
public void WritePluginExecutionMetadata(LogsharkRequest request)
{
try
{
var metadata = new LogsharkRunMetadata(request);
InsertPluginExecutionMetadata(metadata);
}
catch (Exception ex)
{
throw new MetadataWriterException(String.Format("Failed to insert Logshark plugin execution metadata records for run '{0}' in database: {1}", request.RunId, ex.Message));
}
}
public LogsharkPublishedWorkbookMetadata(LogsharkRequest request, LogsharkRunMetadata runMetadata, PublishedWorkbookResult publishedWorkbook)
{
this.runMetadata = runMetadata;
PluginName = publishedWorkbook.Request.PluginName;
Uri = publishedWorkbook.Uri.ToString();
Hostname = request.Configuration.TableauConnectionInfo.Hostname;
Port = request.Configuration.TableauConnectionInfo.Port;
PublishingUsername = request.Configuration.TableauConnectionInfo.Username;
SiteId = publishedWorkbook.Request.SiteId;
SiteName = publishedWorkbook.Request.SiteName;
ProjectId = publishedWorkbook.Request.ProjectId;
ProjectName = publishedWorkbook.Request.ProjectName;
WorkbookId = publishedWorkbook.WorkbookId;
WorkbookName = publishedWorkbook.Request.WorkbookName;
Tags = String.Join(",", publishedWorkbook.Request.Tags);
}
protected void UpdateExistingMetadataRecord(LogsharkRequest request)
{
try
{
var metadata = new LogsharkRunMetadata(request);
Log.DebugFormat("Updating metadata about the {0} phase of this Logshark run in database..", metadata.CurrentProcessingPhase);
using (IDbConnection db = connectionFactory.OpenDbConnection())
{
db.Update(metadata);
}
}
catch (Exception ex)
{
throw new MetadataWriterException(String.Format("Failed to update Logshark metadata for run '{0}' to database: {1}", request.RunId, ex.Message));
}
}
/// <summary>
/// Writes metadata about this Logshark run to the backing database.
/// </summary>
/// <returns>Id of the inserted metadata record.</returns>
protected int CreateInitialMetadataRecord(LogsharkRequest request)
{
try
{
var metadata = new LogsharkRunMetadata(request);
Log.Debug("Creating metadata record for this Logshark run in database..");
using (IDbConnection db = connectionFactory.OpenDbConnection())
{
db.Insert(metadata);
int insertedRecordId = Convert.ToInt32(db.GetLastInsertId());
return(insertedRecordId);
}
}
catch (Exception ex)
{
throw new MetadataWriterException(String.Format("Failed to create Logshark metadata record for run '{0}' in database: {1}", request.RunId, ex.Message), ex);
}
}
public LogsharkCustomMetadata(KeyValuePair <string, object> requestMetadataItem, LogsharkRunMetadata runMetadata)
{
this.requestMetadataItem = requestMetadataItem;
this.runMetadata = runMetadata;
}
