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