SQL clauses

[pacos1]

Hello,

I have a sync with various filters with customWhere and have problems with the synced data.
I want to get the SQL to figure if there is a problem with the filters, so...
Is there a way to get the SQL clause generated in the client side while debugging?

If there is similar question, please redirect me to that discussion.
Thanks,

[Mimetis]

Hello,

If you are using SQL Server, you can find the related SQL Stored procedure in your database. Usually, for each tables you may find a stored procedure called "Table_changes" or something

If you are using SQLite (or any other database, even SQL Server) you can use the interceptor "OnExecuteCommand" to intercept any query to your database.

Here is an example :

agent.RemoteOrchestrator.OnExecuteCommand(args =>
{
    Console.WriteLine(args.Command.CommandText);
});

and a full version of it:

var agent = new SyncAgent(clientProvider, serverProvider, options);

agent.RemoteOrchestrator.OnExecuteCommand(args =>
{
    Console.WriteLine($"SQL SERVER: {args.Command.CommandText}");
});
agent.LocalOrchestrator.OnExecuteCommand(args =>
{
    Console.WriteLine($"SQLITE: {args.Command.CommandText}");
});

do
{
    try
    {

        Console.ForegroundColor = ConsoleColor.Green;
        var s = await agent.SynchronizeAsync(scopeName, setup, progress: progress);
        Console.WriteLine(s);
    }
    catch (SyncException e)
    {
        Console.ResetColor();
        Console.WriteLine(e.Message);
    }
    catch (Exception e)
    {
        Console.ResetColor();
        Console.WriteLine("UNKNOW EXCEPTION : " + e.Message);
    }

    Console.WriteLine("--------------------");
}
while (Console.ReadKey().Key != ConsoleKey.Escape);

Let me know if that helps

[pacos1]

Thank you, it helps me very much.
As I want to keep clean my DB, instead of raise up the version I´m deleting rows in scope_info and scope_info_client; and it seems that the stored procedures are not overwritten, driving me to error.

Is correct that the stored procedures are not overwritten? I´m using 0.9.8v

Best regards,
I don´t read fully the documentation.

[Mimetis]

I don't understand your question here
If it's not related to debug your SQL queries, as the first question, please open a new discussion or issue