Here I list all the functions that are being used in SQL Deleter
SQLDeleter.Connection
Connection(string connectionString)
Send in a standard sql connection string
ConnectionObject GetSyncWithDB()
Checks the database directly for its structure instead of loading a saved version.
void Save(ConnectionObject obj, string tableName)
Save the synced object to the database.
ConnectionObject Load(string version)
Load a specific version from the server.
ConnectionObject LoadLatestInserted()
Loads the latest inserted object from the database.
ConnectionObject LoadLatestInserted(out string version)
Loads the latest inserted object from the database. The version of the object will be set in the version parameter.
List<string> GetSortedVersions()
Retrieve all versions sorted in ascending order (lowest to highest).
SQLDeleter.ConnectionObject
string Generate(string deleteQuery)
Takes a SQL delete query and generates a full delete query from it.
int GenerateAndExecute(Connection connection, string input)
Warning: Only use if you are certain that the generated query will work correctly. This function generates and executes the result.
bool CompareResult(ConnectionObject connection2, string input)
Returns true if the generated result from the input matches that of the other object; otherwise, false.
Dictionary<string, int> WillAffectRows(Connection connection, string input)
Will show you how many rows from each table that will be affected by executing the query