Class DatabaseManager

Inheritance
System.Object
DatabaseManager
SqliteDatabaseManager
Namespace: Microsoft.CST.AttackSurfaceAnalyzer.Utils
Assembly: AsaLib.dll
Syntax
public abstract class DatabaseManager : object

Properties

| Improve this Doc View Source

FirstRun

Declaration
public bool FirstRun { get; }
Property Value
Type Description
System.Boolean
| Improve this Doc View Source

HasElements

Declaration
public abstract bool HasElements { get; }
Property Value
Type Description
System.Boolean
| Improve this Doc View Source

Location

Declaration
public string Location { get; }
Property Value
Type Description
System.String
| Improve this Doc View Source

QueueSize

Declaration
public abstract int QueueSize { get; }
Property Value
Type Description
System.Int32

Methods

| Improve this Doc View Source

BeginTransaction()

Declaration
public abstract void BeginTransaction()
| Improve this Doc View Source

CloseDatabase()

Declaration
public abstract void CloseDatabase()
| Improve this Doc View Source

Commit()

Declaration
public abstract void Commit()
| Improve this Doc View Source

DeleteCompareRun(String, String, String)

Declaration
public abstract void DeleteCompareRun(string firstRunid, string secondRunid, string analysisHash)
Parameters
Type Name Description
System.String firstRunid
System.String secondRunid
System.String analysisHash
| Improve this Doc View Source

DeleteRun(String)

Declaration
public abstract void DeleteRun(string runid)
Parameters
Type Name Description
System.String runid
| Improve this Doc View Source

Destroy()

Declaration
public abstract void Destroy()
| Improve this Doc View Source

Destroy(String)

Declaration
public static void Destroy(string sqliteFilename)
Parameters
Type Name Description
System.String sqliteFilename
| Improve this Doc View Source

GetAllMissing(String, String)

Declaration
public abstract IEnumerable<WriteObject> GetAllMissing(string firstRunId, string secondRunId)
Parameters
Type Name Description
System.String firstRunId
System.String secondRunId
Returns
Type Description
IEnumerable<WriteObject>
| Improve this Doc View Source

GetCommonResultTypes(String, String)

Declaration
public List<RESULT_TYPE> GetCommonResultTypes(string baseId, string compareId)
Parameters
Type Name Description
System.String baseId
System.String compareId
Returns
Type Description
List<RESULT_TYPE>
| Improve this Doc View Source

GetCompareRuns()

Declaration
public abstract 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>>
| Improve this Doc View Source

GetComparisonCompleted(Nullable<String>, String, String)

Declaration
public abstract 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
| Improve this Doc View Source

GetComparisonResults(String, String, String, RESULT_TYPE)

Declaration
public abstract List<CompareResult> GetComparisonResults(string baseId, string compareId, string analysesHash, RESULT_TYPE exportType)
Parameters
Type Name Description
System.String baseId
System.String compareId
System.String analysesHash
RESULT_TYPE exportType
Returns
Type Description
List<CompareResult>
| Improve this Doc View Source

GetComparisonResults(String, String, String, RESULT_TYPE, Int32, Int32)

Declaration
public abstract List<CompareResult> GetComparisonResults(string baseId, string compareId, string analysesHash, RESULT_TYPE resultType, int offset, int numResults)
Parameters
Type Name Description
System.String baseId
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

GetComparisonResultsCount(String, String, String, Int32)

Declaration
public abstract int GetComparisonResultsCount(string baseId, string compareId, string analysesHash, int resultType)
Parameters
Type Name Description
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 abstract DBSettings GetCurrentSettings()
Returns
Type Description
DBSettings
| Improve this Doc View Source

GetLatestRunIds(Int32, RUN_TYPE)

Declaration
public abstract List<string> GetLatestRunIds(int numberOfIds, RUN_TYPE type)
Parameters
Type Name Description
System.Int32 numberOfIds
RUN_TYPE type
Returns
Type Description
List<System.String>
| Improve this Doc View Source

GetMissingFromFirst(String, String)

Declaration
public abstract IEnumerable<WriteObject> GetMissingFromFirst(string firstRunId, string secondRunId)
Parameters
Type Name Description
System.String firstRunId
System.String secondRunId
Returns
Type Description
IEnumerable<WriteObject>
| Improve this Doc View Source

GetModified(String, String)

Declaration
public abstract 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>>
| Improve this Doc View Source

GetMonitorResults(String, Int32, Int32)

Declaration
public abstract 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>
| Improve this Doc View Source

GetMonitorRuns()

Declaration
public List<string> GetMonitorRuns()
Returns
Type Description
List<System.String>
| Improve this Doc View Source

GetNumMonitorResults(String)

Declaration
public abstract int GetNumMonitorResults(string runId)
Parameters
Type Name Description
System.String runId
Returns
Type Description
System.Int32
| Improve this Doc View Source

GetNumResults(RESULT_TYPE, String)

Declaration
public abstract int GetNumResults(RESULT_TYPE ResultType, string runId)
Parameters
Type Name Description
RESULT_TYPE ResultType
System.String runId
Returns
Type Description
System.Int32
| Improve this Doc View Source

GetResultModels(RUN_STATUS)

Declaration
public abstract List<DataRunModel> GetResultModels(RUN_STATUS runStatus)
Parameters
Type Name Description
RUN_STATUS runStatus
Returns
Type Description
List<DataRunModel>
| Improve this Doc View Source

GetResultsByRunid(String)

Declaration
public abstract IEnumerable<WriteObject> GetResultsByRunid(string runid)
Parameters
Type Name Description
System.String runid
Returns
Type Description
IEnumerable<WriteObject>
| Improve this Doc View Source

GetResultTypesAndCounts(String)

Declaration
public abstract Dictionary<RESULT_TYPE, int> GetResultTypesAndCounts(string runId)
Parameters
Type Name Description
System.String runId
Returns
Type Description
Dictionary<RESULT_TYPE, System.Int32>
| Improve this Doc View Source

GetRun(String)

Declaration
public abstract AsaRun GetRun(string RunId)
Parameters
Type Name Description
System.String RunId
Returns
Type Description
AsaRun
| Improve this Doc View Source

GetRuns()

Declaration
public abstract List<string> GetRuns()
Returns
Type Description
List<System.String>
| Improve this Doc View Source

GetRuns(RUN_TYPE)

Declaration
public abstract List<string> GetRuns(RUN_TYPE type)
Parameters
Type Name Description
RUN_TYPE type
Returns
Type Description
List<System.String>
| Improve this Doc View Source

GetSerializedMonitorResults(String)

Declaration
public abstract List<FileMonitorEvent> GetSerializedMonitorResults(string runId)
Parameters
Type Name Description
System.String runId
Returns
Type Description
List<FileMonitorEvent>
| Improve this Doc View Source

GetSettings()

Declaration
public abstract Settings GetSettings()
Returns
Type Description
Settings
| Improve this Doc View Source

InsertAnalyzed(CompareResult)

Declaration
public abstract void InsertAnalyzed(CompareResult objIn)
Parameters
Type Name Description
CompareResult objIn
| Improve this Doc View Source

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

Declaration
public abstract 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
| Improve this Doc View Source

InsertRun(AsaRun)

Declaration
public abstract void InsertRun(AsaRun run)
Parameters
Type Name Description
AsaRun run
| Improve this Doc View Source

ModuloString(String, Int32)

Declaration
public static int ModuloString(string identity, int shardingFactor)
Parameters
Type Name Description
System.String identity
System.Int32 shardingFactor
Returns
Type Description
System.Int32
| Improve this Doc View Source

RollBack()

Declaration
public abstract void RollBack()
| Improve this Doc View Source

RunIdToPlatform(String)

Declaration
public abstract PLATFORM RunIdToPlatform(string runid)
Parameters
Type Name Description
System.String runid
Returns
Type Description
PLATFORM
| Improve this Doc View Source

SetSettings(Settings)

Declaration
public abstract void SetSettings(Settings settings)
Parameters
Type Name Description
Settings settings
| Improve this Doc View Source

Setup()

Declaration
public abstract ASA_ERROR Setup()
Returns
Type Description
ASA_ERROR
| Improve this Doc View Source

TrimToLatest()

Declaration
public abstract void TrimToLatest()
| Improve this Doc View Source

UpdateCompareRun(Nullable<String>, String, RUN_STATUS)

Declaration
public abstract void UpdateCompareRun(string? firstRunId, string secondRunId, RUN_STATUS runStatus)
Parameters
Type Name Description
System.Nullable<System.String> firstRunId
System.String secondRunId
RUN_STATUS runStatus
| Improve this Doc View Source

Vacuum()

Declaration
public abstract void Vacuum()
| Improve this Doc View Source

WaitUntilFlushed()

Used for testing.

Declaration
public void WaitUntilFlushed()
| Improve this Doc View Source

Write(CollectObject, Nullable<String>)

Declaration
public abstract void Write(CollectObject colObj, string? runId)
Parameters
Type Name Description
CollectObject colObj
System.Nullable<System.String> runId