public void updateData(int max = -1) { autoUpdate = false; if (dataBase != "" && dataBase != null) { client.CloseDb(); client.OpenDb(dataBase); Package.Response response = client.Query($"select * from {Name} { ((max == -1) ? "" : $"limit {max}")}"); string[][] columnNames = client.Query($"pragma table_info({Name});").Data; ColumnNames.Clear(); bool first = true; foreach (string[] columnName in columnNames) { if (first) { first = false; continue; } ColumnNames.Add(columnName[1], columnName[2]); } if (response.Data.Length != 0 && response.Data != null) { if (response.Data.Length >= 2) { Data.Clear(); for (int i = 1; i <= response.Data.Length - 1; i++) { List <string> workingList = response.Data[i].ToList(); Data.Add(workingList); } } } client.CloseDb(); }
public bool TestCon() { if (!this.connection.isReady) { throw (new Exception("Connection not Ready")); } if (!this.isLoged) { throw (new Exception("Connection isnt Logged")); } Package.Response response = sendCommand("test"); if (response.Result == "OK" && response.Message == "OK") { return(true); } return(false); }
public Client(Connection connection) { this.connection = connection; NewDb = arg => sendCommand("new", arg); DelDb = arg => sendCommand("del", arg); Query = arg => sendCommand("exec", arg); //OpenDb = arg => sendCommand("open", arg); OpenDb = arg => { Package.Response result = sendCommand("open", arg); if (result.Result == resultType[0]) { Session.DataBase = arg; } return(result); }; GetTables = () => sendCommand("exec", $"SELECT name FROM sqlite_master WHERE type = 'table'"); CloseDb = () => { Session.DataBase = null; return(sendCommand("close", "")); }; GetDBs = () => sendCommand("list", ""); GetDBsI = () => { Package.Response response = sendCommand("list", ""); String[][] data = response.Data; for (int i = 0; i < response.Data[0].Length; i++) { if (response.Data[0][i] == Session.DataBase) { data[0][i] = "* " + data[0][i]; } } return(response); }; }
public Package.Response?Login(string user, string password) { if (connection.isReady) { Package.Login loginPackage = new Package.Login(); loginPackage.User = user; loginPackage.Password = password; connection.Send(JsonSerializer.Serialize(loginPackage)); Package.Response response = new Package.Response(); try { response = JsonSerializer.Deserialize <Package.Response>(connection.Recv()); } catch (Exception E) { return(null); } if (response.Result == resultType[0]) { isLoged = true; Session = new Cache(user, ""); } return(response); } return(null); }