/// <summary> /// Renders the database tab. /// </summary> private void RenderDatabaseTab() { EditorGUILayout.BeginHorizontal(); { EditorGUILayout.LabelField("Query", EditorStyles.boldLabel, GUILayout.MaxWidth(50f)); Query = EditorGUILayout.TextArea(Query, GUILayout.ExpandWidth(true), GUILayout.MaxHeight(100f)); } EditorGUILayout.EndHorizontal(); EditorGUILayout.BeginHorizontal(); { EditorGUILayout.LabelField("Execute", EditorStyles.boldLabel, GUILayout.MaxWidth(50f)); try { if(GUILayout.Button("Execute Reader")) { _Table = June.BasicDB.Database.ExecuteReader(Query); _Result = null == _Table ? "<NULL>" : null; } if(GUILayout.Button("Execute Scalar")) { _Result = June.BasicDB.Database.ExecuteScalar(Query).ToString(); } if(GUILayout.Button("Execute Non Query")) { _Result = June.BasicDB.Database.ExecuteNonQuery(Query).ToString(); } if(GUILayout.Button("Execute Script")) { _Result = June.BasicDB.Database.ExecuteScript(Query).ToString(); } } catch(Exception ex) { _Result = ex.ToString(); } } EditorGUILayout.EndHorizontal(); EditorGUILayout.BeginHorizontal(); { EditorGUILayout.LabelField("Result", EditorStyles.boldLabel, GUILayout.ExpandWidth(true)); if(GUILayout.Button("Clear", GUILayout.MaxWidth(50f))) { _Result = string.Empty; _Table = null; } } EditorGUILayout.EndHorizontal(); EditorGUILayout.Separator(); if(!string.IsNullOrEmpty(_Result)) { EditorGUILayout.TextField(_Result, GUILayout.ExpandWidth(true), GUILayout.ExpandHeight(true)); } else if(null != _Table) { RenderDataTable(_Table); } }
/// <summary> /// Refresh's the settings table. /// </summary> private void RefreshSettingsTable() { _SettingsTable = June.BasicDB.Database.ExecuteReader("SELECT * FROM " + June.BasicDB.Database.DB_SETTINGS_TABLE_NAME); }