private void BuildAnalytic2() { /* * DatabaseUtilities.Table t = new DatabaseUtilities.Table(); * DatabaseUtilities.Column c = new DatabaseUtilities.Column(); * c.fields = new System.Collections.Generic.List<string>(); * c.AddField("0.5"); * c.SetColor("#000000"); * c.SetName("varchar"); * DatabaseUtilities.Column c2 = new DatabaseUtilities.Column(); * c2.fields = new System.Collections.Generic.List<string>(); * c2.AddField("0.5"); * c2.SetColor("#000055"); * c2.SetName("varchar boii"); * t.columns = new System.Collections.Generic.List<DatabaseUtilities.Column>(); * t.AddColumn(c); * t.AddColumn(c2); * DatabaseUtilities.Database d = new DatabaseUtilities.Database(); * d.tables = new System.Collections.Generic.List<DatabaseUtilities.Table>(); * d.AddTable(t); */ Database d = VedicDatabase.GetDataTypeDB(); AnalyticObject2 = ViewAssembler.GenerateAnalyticObject(d, 1); AnalyticObject2.transform.SetParent(gameObject.transform); AnalyticObject2.transform.localPosition = new Vector3(0, 0, 0); }
private void BuildAnalytic1() { Database db1 = VedicDatabase.SortTablesByColumnQuantity(); AnalyticObject1 = ViewAssembler.GenerateViewObject(db1, false, true, 0); AnalyticObject1.transform.SetParent(gameObject.transform); AnalyticObject1.transform.localPosition = new Vector3(0, 0, 0); genuineScale = AnalyticObject1.transform.localScale; }
IEnumerator GetColumnTypesQ(String input, string baseData) { string url = "http://www.williamrobertfunk.com/applications/vedic/actions/query.php"; WWWForm form = new WWWForm(); form.AddField("dbname", dbname.text); form.AddField("hostname", hostname.text); form.AddField("username", username.text); form.AddField("password", password.text); form.AddField("query", input); UnityWebRequest www = UnityWebRequest.Post(url, form); yield return(www.Send()); if (www.isError) { Debug.Log(www.error); } else { VedicDatabase.db = DatabaseBuilder.ConstructDB(dbname.text, baseData); VedicDatabase.isDatabaseNull = false; string reply = www.downloadHandler.text; string podData = reply.Substring(reply.IndexOf("##SelectTable##:{") + 17); // This Table ID sould be unlike original import // It should consist of a combo db name it came from, and select query random unique hash SelectTable sTable = new SelectTable(podData, "DTypes", "FunkDataTypesTable"); DatabaseUtilities.Table t = sTable.GetTable(); List <string> colTypes = new List <string>(); for (int i = 0; i < t.columns[0].fields.Count; i++) { colTypes.Add(t.columns[0].fields[i]); } int numOfColumns = VedicDatabase.GetNumOfColumns(); List <string> colTypes2 = new List <string>(); for (int i = (colTypes.Count - numOfColumns); i < colTypes.Count; i++) { colTypes2.Add(colTypes[i]); } int counter = 0; for (int j = 0; j < VedicDatabase.db.tables.Count; j++) { for (int k = 0; k < VedicDatabase.db.tables[j].columns.Count && counter < colTypes2.Count; k++, counter++) { VedicDatabase.db.tables[j].columns[k].SetColor(VariableColorTable.GetVariableColor(colTypes2[counter])); VedicDatabase.db.tables[j].columns[k].SetType(colTypes2[counter]); } } GetKeyColumns("SELECT CONCAT(TABLE_NAME, '.', COLUMN_NAME) AS 'foreign key', " + "CONCAT(REFERENCED_TABLE_NAME, '.', REFERENCED_COLUMN_NAME) AS 'references' FROM " + "INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_NAME IS NOT NULL"); } }
private void BuildAnalytic3(bool initial) { if (initial) { //Call the initial build of object Database dInitial = VedicDatabase.ChangeColorsForKeys("T0", "T0-C0"); AnalyticObject3 = ViewAssembler.GenerateViewObject(dInitial, false, true, 2); AnalyticObject3.transform.SetParent(gameObject.transform); AnalyticObject3.transform.localPosition = new Vector3(0, 0, 0); return; } int cacheType = cacheHandle.ReadPingType(); if (cacheType == 2) { string message = cacheHandle.ReadCacheMessage(); //Build db based off of column id retrieval from cache if (AnalyticObject3 != null) { GameObject.Destroy(AnalyticObject3); AnalyticObject3 = null; } string tableId = message.Substring(0, message.IndexOf('-')); //Build the object if we got this far with the info proivided by database (Use function to be created) Database d = VedicDatabase.ChangeColorsForKeys(tableId, message); AnalyticObject3 = ViewAssembler.GenerateViewObject(d, false, true, 2); AnalyticObject3.transform.SetParent(gameObject.transform); AnalyticObject3.transform.localPosition = new Vector3(0, 0, 0); } else { return; } }