// Start is called before the first frame update
void Start()
{
// Get instance of logger.
logger = FindObjectOfType <LoggerObject>();
// send simple message.
logger.logFile.Log("Im a test message");
//More complex message.
msg.a = 10;
msg.b = 11;
msg.c = "AAA";
logger.logFile.Log("Im a test message", msg);
}
//IntializeScene. Check for excistence of key gameobjects and set reference variables.
private void InitializeScene()
{
// Create settings folders.
if (!AssetDatabase.IsValidFolder("Assets/Logs"))
{
AssetDatabase.CreateFolder("Assets", "Logs");
}
if (!AssetDatabase.IsValidFolder("Assets/VRSettings"))
{
AssetDatabase.CreateFolder("Assets", "VRSettings");
}
if (!AssetDatabase.IsValidFolder("Assets/VRSettings/PathCreator"))
{
AssetDatabase.CreateFolder("Assets/VRSettings", "PathCreator");
}
if (!AssetDatabase.IsValidFolder("Assets/VRSettings/Controllers"))
{
AssetDatabase.CreateFolder("Assets/VRSettings", "Controllers");
}
if (!AssetDatabase.IsValidFolder("Assets/VRSettings/Displays"))
{
AssetDatabase.CreateFolder("Assets/VRSettings", "Displays");
}
if (!AssetDatabase.IsValidFolder("Assets/VRSettings/Actors"))
{
AssetDatabase.CreateFolder("Assets/VRSettings", "Actors");
}
// Check for main default objects.
GameObject obj;
string[] DefaultObjects = { "Actors", "Controllers", "MQTT Client", "Paths", "Logger" };
foreach (string objName in DefaultObjects)
{
if (!GameObject.Find(objName))
{
Debug.Log(string.Format("Creating Object: {0}..", objName));
obj = new GameObject(objName);
// Special circumstances.
switch (objName)
{
case "MQTT Client":
obj.AddComponent <Gimbl.MQTTClient>();
break;
case "Logger":
_logger = obj.AddComponent <Gimbl.LoggerObject>();
Gimbl.LoggerSettings asset = CreateInstance <Gimbl.LoggerSettings>();
AssetDatabase.CreateAsset(asset, "Assets/VRSettings/LoggerSettings.asset");
_logger.settings = asset;
break;
}
// Things have changed. Mark scene for save.
UnityEditor.SceneManagement.EditorSceneManager.MarkSceneDirty(SceneManager.GetActiveScene());
}
else
{
obj = GameObject.Find(objName);
}
switch (objName)
{
// Assign for controls.
case "MQTT Client":
_client = obj.GetComponent <Gimbl.MQTTClient>();
obj.hideFlags = HideFlags.HideInHierarchy;
break;
case "Paths":
break;
case "Controllers":
obj.hideFlags = HideFlags.None;
break;
case "Logger":
_logger = obj.GetComponent <Gimbl.LoggerObject>();
_logger.settings = (LoggerSettings)AssetDatabase.LoadAssetAtPath("Assets/VRSettings/LoggerSettings.asset", typeof(LoggerSettings));
obj.hideFlags = HideFlags.HideInHierarchy;
break;
case "Actors":
break;
}
}
// Set client IP settings from stored.
_client.ip = EditorPrefs.GetString("JaneliaVR_MQTT_IP");
if (_client.ip == "")
{
_client.ip = "127.0.0.1";
}
_client.port = EditorPrefs.GetInt("JaneliaVR_MQTT_Port");
if (_client.port == 0)
{
_client.port = 1883;
}
// Set default properties.
msgSettings.sendFrameMsg = EditorPrefs.GetBool("Gimbl_sendFrameMsg", false);
sessionSettings.externalStart = EditorPrefs.GetBool("Gimbl_externalStart", false);
sessionSettings.externalLog = EditorPrefs.GetBool("Gimbl_externalLog", false);
// Check for global display settings path creator.
if (UnityEditor.AssetDatabase.FindAssets("t:GlobalDisplaySettings").Length == 0)
{
PathCreation.GlobalDisplaySettings asset = CreateInstance <PathCreation.GlobalDisplaySettings>();
AssetDatabase.CreateAsset(asset, "Assets/VRSettings/PathCreator/GlobalDisplaySettings.asset");
}
}
public DataTable SelectData(string FunctionName, DatabaseAccessObject databaseAccessObject, string cmdText, LoggerObject Log, params System.Data.SqlClient.SqlParameter[] parameterArray)
{
string parameterText = "";
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(cmdText, databaseAccessObject.Connection))
{
cmd.Transaction = databaseAccessObject.Transaction;
if (parameterArray.Length != 0)
{
int parameterCount = 0;
foreach (System.Data.SqlClient.SqlParameter parameter in parameterArray)
{
cmd.Parameters.Add(parameter);
if (parameterCount != 0)
{
parameterText += ",";
}
parameterText += parameter.ParameterName + "(" + parameter.SqlDbType + ") = " + parameter.Value;
parameterCount += 1;
}
}
Stopwatch sqlTimer = new Stopwatch();
Log.SaveFunctionLog_Start(DateTime.Now, FunctionName, "SQLIN", "", "iLibrary", "", cmd.CommandText, parameterText);
sqlTimer.Start();
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
sqlTimer.Stop();
//Log.SaveFunctionLog_End(DateTime.Now, 0, FunctionName, "SQLOUT", "", "iLibrary", sqlTimer.ElapsedMilliseconds, "", Log.ReaderToCSV(reader), "");
DataTable dt = CreateSchemaDataTable(reader);
// 結果を表示します。
while (reader.Read())
{
DataRow row = dt.NewRow();
for (int i = 0; i < reader.FieldCount; i++)
{
row[i] = reader.GetValue(i);
}
dt.Rows.Add(row);
}
Log.SaveFunctionLog_End(DateTime.Now, 0, FunctionName, "SQLOUT", "", "iLibrary", sqlTimer.ElapsedMilliseconds, "", Log.ReaderToCSV(dt), "");
reader.Close();
return(dt);
}
}
public int OperateData(string FunctionName, DatabaseAccessObject databaseAccessObject, string cmdText, LoggerObject Log, params System.Data.SqlClient.SqlParameter[] parameterArray)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(cmdText, databaseAccessObject.Connection))
{
string parameterText = "";
cmd.Transaction = databaseAccessObject.Transaction;
if (parameterArray.Length != 0)
{
int parameterCount = 0;
foreach (System.Data.SqlClient.SqlParameter parameter in parameterArray)
{
cmd.Parameters.Add(parameter);
if (parameterCount != 0)
{
parameterText += ",";
}
parameterText += parameter.ParameterName + "(" + parameter.SqlDbType + ") = " + parameter.Value;
parameterCount += 1;
}
}
Stopwatch sqlTimer = new Stopwatch();
Log.SaveFunctionLog_Start(DateTime.Now, FunctionName, "SQLIN", "", "iLibrary", "", cmd.CommandText, parameterText);
sqlTimer.Start();
int affectedRow = cmd.ExecuteNonQuery();
sqlTimer.Stop();
Log.SaveFunctionLog_End(DateTime.Now, 0, FunctionName, "SQLOUT", "", "iLibrary", sqlTimer.ElapsedMilliseconds, "", affectedRow.ToString() + " Records.", "");
return(affectedRow);
}
}
public int SelectExist(string FunctionName, DatabaseAccessObject databaseAccessObject, string cmdText, LoggerObject Log, params System.Data.SqlClient.SqlParameter[] parameterArray)
{
string parameterText = "";
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(cmdText, databaseAccessObject.Connection))
{
cmd.Transaction = databaseAccessObject.Transaction;
if (parameterArray.Length != 0)
{
int parameterCount = 0;
foreach (System.Data.SqlClient.SqlParameter parameter in parameterArray)
{
cmd.Parameters.Add(parameter);
if (parameterCount != 0)
{
parameterText += ",";
}
parameterText += parameter.ParameterName + "(" + parameter.SqlDbType + ") = " + parameter.Value;
parameterCount += 1;
}
}
using (System.Data.SqlClient.SqlDataAdapter dataAdapter = new System.Data.SqlClient.SqlDataAdapter())
{
DataTable data = new DataTable();
Stopwatch sqlTimer = new Stopwatch();
Log.SaveFunctionLog_Start(DateTime.Now, FunctionName, "SQLIN", "", "iLibrary", "", cmd.CommandText, parameterText);
sqlTimer.Start();
dataAdapter.SelectCommand = cmd;
dataAdapter.Fill(data);
sqlTimer.Stop();
Log.SaveFunctionLog_End(DateTime.Now, 0, FunctionName, "SQLOUT", "", "iLibrary", sqlTimer.ElapsedMilliseconds, "", Log.DataTableToCSV(data), "");
return(data.Rows.Count);
}
}
}
public System.Data.SqlClient.SqlDataReader SelectDataReader(string FunctionName, DatabaseAccessObject databaseAccessObject, string cmdText, LoggerObject Log, params System.Data.SqlClient.SqlParameter[] parameterArray)
{
string parameterText = "";
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(cmdText, databaseAccessObject.Connection))
{
cmd.Transaction = databaseAccessObject.Transaction;
if (parameterArray.Length != 0)
{
int parameterCount = 0;
foreach (System.Data.SqlClient.SqlParameter parameter in parameterArray)
{
cmd.Parameters.Add(parameter);
if (parameterCount != 0)
{
parameterText += ",";
}
parameterText += parameter.ParameterName + "(" + parameter.SqlDbType + ") = " + parameter.Value;
parameterCount += 1;
}
}
Stopwatch sqlTimer = new Stopwatch();
Log.SaveFunctionLog_Start(DateTime.Now, FunctionName, "SQLIN", "", "iLibrary", "", cmd.CommandText, parameterText);
sqlTimer.Start();
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
sqlTimer.Stop();
//Log.SaveFunctionLog_End(DateTime.Now, 0, FunctionName, "SQLOUT", "", "iLibrary", sqlTimer.ElapsedMilliseconds, "", Log.ReaderToCSV(reader), "");
return(reader);
}
}
public void InitTest()
{
dynamic v = new LoggerObject();
var result = v + 10;
}
