private List <string> ExecuteCommand(SQLiteCommand command)
{
command.CommandText =
"SELECT t1.file_path FROM server_file_list t1 " +
"WHERE NOT EXISTS ( " +
"SELECT * FROM local_file_list t2 " +
"WHERE t1.file_path = t2.file_path) ";
using (var reader = command.ExecuteReader())
{
return(SqlReaderUtils.ReadStringList(reader));
}
}
private List <string> ExecuteCommand(SQLiteCommand command)
{
command.CommandText =
"SELECT t1.file_path FROM file_list t1 " +
"INNER JOIN local_file_list t2 " +
"ON t1.file_path = t2.file_path " +
"AND datetime(t1.file_updated_at) <> datetime(t2.file_updated_at) ";
using (var reader = command.ExecuteReader())
{
return(SqlReaderUtils.ReadStringList(reader));
}
}