Class DatabaseManager

Inheritance
System.Object
DatabaseManager
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: AttackSurfaceAnalyzer.Utils
Assembly: AsaLib.dll
Syntax
public static class DatabaseManager

Fields

| Improve this Doc View Source

LOW_MEMORY_CUTOFF

Declaration
public const int LOW_MEMORY_CUTOFF = 1000
Field Value
Type Description
System.Int32

Properties

| Improve this Doc View Source

Connections

Declaration
public static List<SqlConnectionHolder> Connections { get; }
Property Value
Type Description
System.Collections.Generic.List<SqlConnectionHolder>
| Improve this Doc View Source

FirstRun

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

HasElements

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

MainConnection

Declaration
public static SqlConnectionHolder MainConnection { get; }
Property Value
Type Description
SqlConnectionHolder
| Improve this Doc View Source

QueueSize

Declaration
public static int QueueSize { get; }
Property Value
Type Description
System.Int32
| Improve this Doc View Source

SqliteFilename

Declaration
public static string SqliteFilename { get; }
Property Value
Type Description
System.String

Methods

| Improve this Doc View Source

BeginTransaction()

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

CloseDatabase()

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

Commit()

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

DeleteRun(String)

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

Destroy()

Declaration
public static 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

EstablishMainConnection()

Declaration
public static bool EstablishMainConnection()
Returns
Type Description
System.Boolean
| Improve this Doc View Source

GetAllMissing(String, String)

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

GetAllMissing2(String, String)

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

GetAllMissingExplicit(String, String)

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

GetCommonResultTypes(String, String)

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

GetComparisonCompleted(String, String)

Declaration
public static bool GetComparisonCompleted(string firstRunId, string secondRunId)
Parameters
Type Name Description
System.String firstRunId
System.String secondRunId
Returns
Type Description
System.Boolean
| Improve this Doc View Source

GetComparisonResults(String, String, RESULT_TYPE)

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

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

Declaration
public static List<CompareResult> GetComparisonResults(string baseId, string compareId, int resultType, int offset, int numResults)
Parameters
Type Name Description
System.String baseId
System.String compareId
System.Int32 resultType
System.Int32 offset
System.Int32 numResults
Returns
Type Description
System.Collections.Generic.List<CompareResult>
| Improve this Doc View Source

GetComparisonResultsCount(String, String, Int32)

Declaration
public static int GetComparisonResultsCount(string baseId, string compareId, int resultType)
Parameters
Type Name Description
System.String baseId
System.String compareId
System.Int32 resultType
Returns
Type Description
System.Int32
| Improve this Doc View Source

GetCurrentSettings()

Declaration
public static DBSettings GetCurrentSettings()
Returns
Type Description
DBSettings
| Improve this Doc View Source

GetLatestRunIds(Int32, RUN_TYPE)

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

GetMissingFromFirst(String, String)

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

GetModified(String, String)

Declaration
public static IEnumerable<(WriteObject, WriteObject)> GetModified(string firstRunId, string secondRunId)
Parameters
Type Name Description
System.String firstRunId
System.String secondRunId
Returns
Type Description
System.Collections.Generic.IEnumerable<System.ValueTuple<WriteObject, WriteObject>>
| Improve this Doc View Source

GetMonitorResults(String, Int32, Int32)

Declaration
public static List<FileMonitorObject> GetMonitorResults(string runId, int offset, int numResults)
Parameters
Type Name Description
System.String runId
System.Int32 offset
System.Int32 numResults
Returns
Type Description
System.Collections.Generic.List<FileMonitorObject>
| Improve this Doc View Source

GetMonitorRuns()

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

GetNumMonitorResults(String)

Declaration
public static 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 static 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 static List<DataRunModel> GetResultModels(RUN_STATUS runStatus)
Parameters
Type Name Description
RUN_STATUS runStatus
Returns
Type Description
System.Collections.Generic.List<DataRunModel>
| Improve this Doc View Source

GetResultsByRunid(String)

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

GetResultTypesAndCounts(String)

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

GetRun(String)

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

GetRuns()

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

GetRuns(RUN_TYPE)

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

GetSerializedMonitorResults(String)

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

GetTelemetryEnabled()

Declaration
public static bool GetTelemetryEnabled()
Returns
Type Description
System.Boolean
| Improve this Doc View Source

InsertAnalyzed(CompareResult)

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

InsertCompareRun(String, String, RUN_STATUS)

Declaration
public static void InsertCompareRun(string firstRunId, string secondRunId, RUN_STATUS runStatus)
Parameters
Type Name Description
System.String firstRunId
System.String secondRunId
RUN_STATUS runStatus
| Improve this Doc View Source

InsertRun(AsaRun)

Declaration
public static 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

PopulateConnections()

Declaration
public static int PopulateConnections()
Returns
Type Description
System.Int32
| Improve this Doc View Source

RollBack()

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

RunIdToPlatform(String)

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

SetTelemetryEnabled(Boolean)

Declaration
public static void SetTelemetryEnabled(bool Enabled)
Parameters
Type Name Description
System.Boolean Enabled
| Improve this Doc View Source

Setup(String, DBSettings)

Declaration
public static ASA_ERROR Setup(string filename, DBSettings dbSettingsIn = null)
Parameters
Type Name Description
System.String filename
DBSettings dbSettingsIn
Returns
Type Description
ASA_ERROR
| Improve this Doc View Source

StallIfHighMemoryUsageAndLowMemoryModeEnabled()

Declaration
public static void StallIfHighMemoryUsageAndLowMemoryModeEnabled()
| Improve this Doc View Source

TrimToLatest()

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

UpdateCompareRun(String, String, RUN_STATUS)

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

Vacuum()

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

WaitUntilFlushed()

Used for testing.

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

Write(CollectObject, String)

Declaration
public static void Write(CollectObject colObj, string runId)
Parameters
Type Name Description
CollectObject colObj
System.String runId
| Improve this Doc View Source

WriteFileMonitor(FileMonitorObject, String)

Declaration
public static void WriteFileMonitor(FileMonitorObject fmo, string RunId)
Parameters
Type Name Description
FileMonitorObject fmo
System.String RunId