void OnGUI() { Rect rect = new Rect(0, 0, 100, 20); // Create database first if (!db.Exists) { if (GUI.Button(new Rect(Screen.width / 2 - 125, Screen.height / 2 - 40, 250, 80), "Create DB")) { CreateDB(); } return; } // after creating database and a table in DB if (isTableCreated) { GUI.Label(rect, "ID"); rect.x = 150; GUI.Label(rect, "Name"); rect.y = 30; rect.x = 0; if (btnName_SaveUpdate == "Save") { _id = GUI.TextField(rect, _id); } else { GUI.TextField(rect, _id); } rect.x = 150; _name = GUI.TextField(rect, _name); rect.x = rect.x + rect.width + 10; if (GUI.Button(rect, btnName_SaveUpdate)) { if (btnName_SaveUpdate == "Save") { AddRow(_id, _name); } else if (btnName_SaveUpdate == "Update") { UpdateRow(_id, _name); } } } // Display all data from database rect.x = 0; rect.y = 60; rect.width = Screen.width; rect.height = Screen.height - 120; scrollPos = GUI.BeginScrollView(rect, scrollPos, new Rect(0, 0, rect.width - 30, allIDs.Count * 30)); rect.width = 125; rect.height = 25; for (int i = 0; i < allIDs.Count; i++) { // id label rect.x = 0; rect.y = i * 25; GUI.Label(rect, allIDs[i]); // name rect.x += 130; GUI.Label(rect, allNames[i]); // update button rect.x += 130; if (GUI.Button(rect, "Edit")) { _id = allIDs[i]; _name = allNames[i]; btnName_SaveUpdate = "Update"; } // remove button rect.x += 130; if (GUI.Button(rect, "Delete")) { DeleteRow(allIDs[i]); } } GUI.EndScrollView(); // clear table rect.y = Screen.height - 25; rect.x = 0; rect.width = 100; rect.height = 20; GUI.enabled = isTableCreated; if (GUI.Button(rect, "Clear Table")) { db.ClearTable("Users"); Refresh(); } GUI.enabled = true; // delete table rect.x += 110; if (GUI.Button(rect, btnName_CreateDeleteTable)) { if (btnName_CreateDeleteTable == "Delete Table" && db.DeleteTable("Users")) { allIDs.Clear(); allNames.Clear(); btnName_CreateDeleteTable = "Create Table"; isTableCreated = false; } else if (btnName_CreateDeleteTable == "Create Table") { if (CreateTable()) { btnName_CreateDeleteTable = "Delete Table"; isTableCreated = true; } } } // delete table rect.x += 110; if (GUI.Button(rect, "Delete DB")) { if (db.DeleteDatabase()) { allIDs.Clear(); allNames.Clear(); btnName_CreateDeleteTable = "Create Table"; isTableCreated = false; } } }
public void Truncate() { _db.ClearTable(_tableIdentifier); }