private void FromDatabaseGUI()
{
EditorGUILayout.BeginVertical(GUI.skin.box);
GUILayout.Label("From-Database Fields", EditorStyles.boldLabel);
databaseName = EditorGUILayout.TextField("Database Name", databaseName);
fromTableNameInDatabase = EditorGUILayout.TextField("Table Name in Database", fromTableNameInDatabase);
if (GUILayout.Button("Load Session ID Information"))
{
DBInterfaceForSensorReadings.InitialiseDatabaseConnection(databaseName);
sessionIDMin = DBInterfaceForSensorReadings.GetEarliestSessionIDInDatabaseTable(fromTableNameInDatabase);
sessionIDMax = DBInterfaceForSensorReadings.GetLatestSessionIDInDatabaseTable(fromTableNameInDatabase);
DBInterfaceForSensorReadings.CloseDatabaseConnection();
informationLoaded = true;
}
EditorGUILayout.EndVertical();
}
private void TransferToDatabaseGUI()
{
if (informationLoaded)
{
EditorGUILayout.BeginVertical(GUI.skin.box);
GUILayout.Label("Transfer-To-Database Fields", EditorStyles.boldLabel);
toTableNameInDatabase = EditorGUILayout.TextField("Table Name in Database", toTableNameInDatabase);
sessionIDStart = EditorGUILayout.IntSlider("Session ID Start", sessionIDStart, sessionIDMin, sessionIDMax);
sessionIDEnd = EditorGUILayout.IntSlider("Session ID End", sessionIDEnd, sessionIDMin, sessionIDMax);
if (GUILayout.Button("Transfer Sensor Readings"))
{
DBInterfaceForSensorReadings.InitialiseDatabaseConnection(databaseName);
DBInterfaceForSensorReadings.TransferSensorReadings(fromTableNameInDatabase, toTableNameInDatabase, sessionIDStart, sessionIDEnd);
DBInterfaceForSensorReadings.CloseDatabaseConnection();
}
EditorGUILayout.EndVertical();
}
}
/// <summary>
/// Helper method for inserting sensor readings into a specific table in a connected database.
/// </summary>
/// <param name="sensorReadings">Sensor readings to be inserted.</param>
/// <param name="bookmarkName">Sensor bookmark name associated with the sensor readings.</param>
/// <param name="sessionID">Unique identifier associated with the sensor readings.</param>
public void InsertSensorReadingsListInDatabaseTable(List <BaseSensorReading> sensorReadings, string bookmarkName, int sessionID)
{
DBInterfaceForSensorReadings.InsertSensorReadingsInDatabaseTable(sensorReadings, bookmarkName, sessionID, TABLE_NAME);
}
public void OnDestroy()
{
DBInterfaceForSensorReadings.CloseDatabaseConnection();
}
public void Awake()
{
DBInterfaceForSensorReadings.InitialiseDatabaseConnection(SQL_DB_NAME);
}
