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;
}
}
