Class SqliteDatabaseManager

Inheritance

System.Object

DatabaseManager

SqliteDatabaseManager

Inherited Members

DatabaseManager.FirstRun

DatabaseManager.Location

DatabaseManager.Destroy(String)

DatabaseManager.ModuloString(String, Int32)

DatabaseManager.GetAllMissing(String, String)

DatabaseManager.GetCommonResultTypes(String, String)

DatabaseManager.GetComparisonResults(String, String, String, RESULT_TYPE)

DatabaseManager.GetComparisonResults(String, String, String, RESULT_TYPE, Int32, Int32)

DatabaseManager.GetComparisonResultsCount(String, String, String, Int32)

DatabaseManager.GetMonitorRuns()

DatabaseManager.WaitUntilFlushed()

Namespace: Microsoft.CST.AttackSurfaceAnalyzer.Utils

Assembly: AsaLib.dll

Syntax

public class SqliteDatabaseManager : DatabaseManager

Constructors

| Improve this Doc View Source

SqliteDatabaseManager(String, DBSettings)

Declaration

public SqliteDatabaseManager(string filename, DBSettings dbSettingsIn = null)

Parameters

Type	Name	Description
System.String	filename
DBSettings	dbSettingsIn

Fields

| Improve this Doc View Source

LOW_MEMORY_CUTOFF

Declaration

public const int LOW_MEMORY_CUTOFF = null

Field Value

Type	Description
System.Int32

Properties

| Improve this Doc View Source

Connections

Declaration

public List<SqlConnectionHolder> Connections { get; }

Property Value

Type	Description
List<SqlConnectionHolder>

| Improve this Doc View Source

HasElements

Declaration

public override bool HasElements { get; }

Property Value

Type	Description
System.Boolean

Overrides

DatabaseManager.HasElements

| Improve this Doc View Source

MainConnection

Declaration

public SqlConnectionHolder MainConnection { get; }

Property Value

Type	Description
SqlConnectionHolder

| Improve this Doc View Source

QueueSize

Declaration

public override int QueueSize { get; }

Property Value

Type	Description
System.Int32

Overrides

DatabaseManager.QueueSize

Methods

| Improve this Doc View Source

BeginTransaction()

Declaration

public override void BeginTransaction()

Overrides

DatabaseManager.BeginTransaction()

| Improve this Doc View Source

CloseDatabase()

Declaration

public override void CloseDatabase()

Overrides

DatabaseManager.CloseDatabase()

| Improve this Doc View Source

Commit()

Declaration

public override void Commit()

Overrides

DatabaseManager.Commit()

| Improve this Doc View Source

DeleteCompareRun(String, String, String)

Declaration

public override void DeleteCompareRun(string firstRunId, string secondRunId, string analysesHash)

Parameters

Type	Name	Description
System.String	firstRunId
System.String	secondRunId
System.String	analysesHash

Overrides

DatabaseManager.DeleteCompareRun(String, String, String)

| Improve this Doc View Source

DeleteRun(String)

Declaration

public override void DeleteRun(string runid)

Parameters

Type	Name	Description
System.String	runid

Overrides

DatabaseManager.DeleteRun(String)

| Improve this Doc View Source

Destroy()

Declaration

public override void Destroy()

Overrides

DatabaseManager.Destroy()

| Improve this Doc View Source

EstablishMainConnection()

Declaration

public bool EstablishMainConnection()

Returns

Type	Description
System.Boolean

| Improve this Doc View Source

GetAllMissing(Nullable<String>, String)

Declaration

public override IEnumerable<WriteObject> GetAllMissing(string? firstRunId, string secondRunId)

Parameters

Type	Name	Description
System.Nullable<System.String>	firstRunId
System.String	secondRunId

Returns

Type	Description
IEnumerable<WriteObject>

| Improve this Doc View Source

GetAllMissing2(String, String)

Declaration

public IEnumerable<WriteObject> GetAllMissing2(string firstRunId, string secondRunId)

Parameters

Type	Name	Description
System.String	firstRunId
System.String	secondRunId

Returns

Type	Description
IEnumerable<WriteObject>

| Improve this Doc View Source

GetAllMissingExplicit(String, String)

Declaration

public IEnumerable<WriteObject> GetAllMissingExplicit(string firstRunId, string secondRunId)

Parameters

Type	Name	Description
System.String	firstRunId
System.String	secondRunId

Returns

Type	Description
IEnumerable<WriteObject>

| Improve this Doc View Source

GetCompareRuns()

Declaration

public override List<(string firstRunId, string secondRunId, string analysesHash, RUN_STATUS runStatus)> GetCompareRuns()

Returns

Type	Description
List<System.ValueTuple<System.String, System.String, System.String, RUN_STATUS>>

Overrides

DatabaseManager.GetCompareRuns()

| Improve this Doc View Source

GetComparisonCompleted(Nullable<String>, String, String)

Declaration

public override bool GetComparisonCompleted(string? firstRunId, string secondRunId, string analysesHash)

Parameters

Type	Name	Description
System.Nullable<System.String>	firstRunId
System.String	secondRunId
System.String	analysesHash

Returns

Type	Description
System.Boolean

Overrides

DatabaseManager.GetComparisonCompleted(Nullable<String>, String, String)

| Improve this Doc View Source

GetComparisonResults(Nullable<String>, Nullable<String>, String, RESULT_TYPE, Int32, Int32)

Declaration

public override List<CompareResult> GetComparisonResults(string? baseId, string? compareId, string analysesHash, RESULT_TYPE resultType, int offset, int numResults)

Parameters

Type	Name	Description
System.Nullable<System.String>	baseId
System.Nullable<System.String>	compareId
System.String	analysesHash
RESULT_TYPE	resultType
System.Int32	offset
System.Int32	numResults

Returns

Type	Description
List<CompareResult>

| Improve this Doc View Source

GetComparisonResults(Nullable<String>, String, String, RESULT_TYPE)

Declaration

public override List<CompareResult> GetComparisonResults(string? baseId, string compareId, string analysesHash, RESULT_TYPE exportType)

Parameters

Type	Name	Description
System.Nullable<System.String>	baseId
System.String	compareId
System.String	analysesHash
RESULT_TYPE	exportType

Returns

Type	Description
List<CompareResult>

| Improve this Doc View Source

GetComparisonResultsCount(Nullable<String>, String, String, Int32)

Declaration

public override int GetComparisonResultsCount(string? baseId, string compareId, string analysesHash, int resultType)

Parameters

Type	Name	Description
System.Nullable<System.String>	baseId
System.String	compareId
System.String	analysesHash
System.Int32	resultType

Returns

Type	Description
System.Int32

| Improve this Doc View Source

GetCurrentSettings()

Declaration

public override DBSettings GetCurrentSettings()

Returns

Type	Description
DBSettings

Overrides

DatabaseManager.GetCurrentSettings()

| Improve this Doc View Source

GetLatestRunIds(Int32, RUN_TYPE)

Declaration

public override List<string> GetLatestRunIds(int numberOfIds, RUN_TYPE type)

Parameters

Type	Name	Description
System.Int32	numberOfIds
RUN_TYPE	type

Returns

Type	Description
List<System.String>

Overrides

DatabaseManager.GetLatestRunIds(Int32, RUN_TYPE)

| Improve this Doc View Source

GetMissingFromFirst(String, String)

Declaration

public override IEnumerable<WriteObject> GetMissingFromFirst(string firstRunId, string secondRunId)

Parameters

Type	Name	Description
System.String	firstRunId
System.String	secondRunId

Returns

Type	Description
IEnumerable<WriteObject>

Overrides

DatabaseManager.GetMissingFromFirst(String, String)

| Improve this Doc View Source

GetModified(String, String)

Declaration

public override IEnumerable<(WriteObject, WriteObject)> GetModified(string firstRunId, string secondRunId)

Parameters

Type	Name	Description
System.String	firstRunId
System.String	secondRunId

Returns

Type	Description
IEnumerable<System.ValueTuple<WriteObject, WriteObject>>

Overrides

DatabaseManager.GetModified(String, String)

| Improve this Doc View Source

GetMonitorResults(String, Int32, Int32)

Declaration

public override IEnumerable<FileMonitorObject> GetMonitorResults(string runId, int offset = 0, int numResults = null)

Parameters

Type	Name	Description
System.String	runId
System.Int32	offset
System.Int32	numResults

Returns

Type	Description
IEnumerable<FileMonitorObject>

Overrides

DatabaseManager.GetMonitorResults(String, Int32, Int32)

| Improve this Doc View Source

GetNumMonitorResults(String)

Declaration

public override int GetNumMonitorResults(string runId)

Parameters

Type	Name	Description
System.String	runId

Returns

Type	Description
System.Int32

Overrides

DatabaseManager.GetNumMonitorResults(String)

| Improve this Doc View Source

GetNumResults(RESULT_TYPE, String)

Declaration

public override int GetNumResults(RESULT_TYPE ResultType, string runId)

Parameters

Type	Name	Description
RESULT_TYPE	ResultType
System.String	runId

Returns

Type	Description
System.Int32

Overrides

DatabaseManager.GetNumResults(RESULT_TYPE, String)

| Improve this Doc View Source

GetResultModels(RUN_STATUS)

Declaration

public override List<DataRunModel> GetResultModels(RUN_STATUS runStatus)

Parameters

Type	Name	Description
RUN_STATUS	runStatus

Returns

Type	Description
List<DataRunModel>

Overrides

DatabaseManager.GetResultModels(RUN_STATUS)

| Improve this Doc View Source

GetResultsByRunid(String)

Declaration

public override IEnumerable<WriteObject> GetResultsByRunid(string runid)

Parameters

Type	Name	Description
System.String	runid

Returns

Type	Description
IEnumerable<WriteObject>

Overrides

DatabaseManager.GetResultsByRunid(String)

| Improve this Doc View Source

GetResultTypesAndCounts(String)

Declaration

public override Dictionary<RESULT_TYPE, int> GetResultTypesAndCounts(string runId)

Parameters

Type	Name	Description
System.String	runId

Returns

Type	Description
Dictionary<RESULT_TYPE, System.Int32>

Overrides

DatabaseManager.GetResultTypesAndCounts(String)

| Improve this Doc View Source

GetRun(String)

Declaration

public override AsaRun GetRun(string RunId)

Parameters

Type	Name	Description
System.String	RunId

Returns

Type	Description
AsaRun

Overrides

DatabaseManager.GetRun(String)

| Improve this Doc View Source

GetRuns()

Declaration

public override List<string> GetRuns()

Returns

Type	Description
List<System.String>

Overrides

DatabaseManager.GetRuns()

| Improve this Doc View Source

GetRuns(RUN_TYPE)

Declaration

public override List<string> GetRuns(RUN_TYPE type)

Parameters

Type	Name	Description
RUN_TYPE	type

Returns

Type	Description
List<System.String>

Overrides

DatabaseManager.GetRuns(RUN_TYPE)

| Improve this Doc View Source

GetSerializedMonitorResults(String)

Declaration

public override List<FileMonitorEvent> GetSerializedMonitorResults(string runId)

Parameters

Type	Name	Description
System.String	runId

Returns

Type	Description
List<FileMonitorEvent>

Overrides

DatabaseManager.GetSerializedMonitorResults(String)

| Improve this Doc View Source

GetSettings()

Declaration

public override Settings GetSettings()

Returns

Type	Description
Settings

Overrides

DatabaseManager.GetSettings()

| Improve this Doc View Source

InsertAnalyzed(CompareResult)

Declaration

public override void InsertAnalyzed(CompareResult objIn)

Parameters

Type	Name	Description
CompareResult	objIn

Overrides

DatabaseManager.InsertAnalyzed(CompareResult)

| Improve this Doc View Source

InsertCompareRun(Nullable<String>, String, String, RUN_STATUS)

Declaration

public override void InsertCompareRun(string? firstRunId, string secondRunId, string analysesHash, RUN_STATUS runStatus)

Parameters

Type	Name	Description
System.Nullable<System.String>	firstRunId
System.String	secondRunId
System.String	analysesHash
RUN_STATUS	runStatus

Overrides

DatabaseManager.InsertCompareRun(Nullable<String>, String, String, RUN_STATUS)

| Improve this Doc View Source

InsertRun(AsaRun)

Declaration

public override void InsertRun(AsaRun run)

Parameters

Type	Name	Description
AsaRun	run

Overrides

DatabaseManager.InsertRun(AsaRun)

| Improve this Doc View Source

PopulateConnections()

Declaration

public int PopulateConnections()

Returns

Type	Description
System.Int32

| Improve this Doc View Source

RollBack()

Declaration

public override void RollBack()

Overrides

DatabaseManager.RollBack()

| Improve this Doc View Source

RunIdToPlatform(String)

Declaration

public override PLATFORM RunIdToPlatform(string runid)

Parameters

Type	Name	Description
System.String	runid

Returns

Type	Description
PLATFORM

Overrides

DatabaseManager.RunIdToPlatform(String)

| Improve this Doc View Source

SetSettings(Settings)

Declaration

public override void SetSettings(Settings settings)

Parameters

Type	Name	Description
Settings	settings

Overrides

DatabaseManager.SetSettings(Settings)

| Improve this Doc View Source

Setup()

Declaration

public override ASA_ERROR Setup()

Returns

Type	Description
ASA_ERROR

Overrides

DatabaseManager.Setup()

| Improve this Doc View Source

StallIfHighMemoryUsageAndLowMemoryModeEnabled()

Declaration

public void StallIfHighMemoryUsageAndLowMemoryModeEnabled()

| Improve this Doc View Source

TrimToLatest()

Declaration

public override void TrimToLatest()

Overrides

DatabaseManager.TrimToLatest()

| Improve this Doc View Source

UpdateCompareRun(Nullable<String>, String, RUN_STATUS)

Declaration

public override void UpdateCompareRun(string? firstRunId, string secondRunId, RUN_STATUS runStatus)

Parameters

Type	Name	Description
System.Nullable<System.String>	firstRunId
System.String	secondRunId
RUN_STATUS	runStatus

Overrides

DatabaseManager.UpdateCompareRun(Nullable<String>, String, RUN_STATUS)

| Improve this Doc View Source

Vacuum()

Declaration

public override void Vacuum()

Overrides

DatabaseManager.Vacuum()

| Improve this Doc View Source

Write(CollectObject, Nullable<String>)

Declaration

public override void Write(CollectObject colObj, string? runId)

Parameters

Type	Name	Description
CollectObject	colObj
System.Nullable<System.String>	runId

Overrides

DatabaseManager.Write(CollectObject, Nullable<String>)