public bool SaveQuery(string path)
{
var fileName = GenerateFileName(path);
var parameters = new StorageParameters {
FileName = fileName
};
var query = GenerateQuery();
if (query == null)
{
return(false);
}
_storage.SaveQuery(query, parameters);
LinqQuery = "";
SqlQuery = "";
if (!ValidationResults.Any())
{
var schemaFileName = Path.Combine(path, $"Schema.json");
LinqQuery = _linqGenerator.GenerateQuery(schemaFileName, fileName);
}
return(true);
}
public async Task <string> GenerateSql(DatabaseTableSolutionItem item)
{
IDatabaseTableData?tableData = await LoadTable(item);
if (tableData == null)
{
return($"-- Unable to load data for {item} from the database");
}
item.UpdateEntitiesWithOriginalValues(tableData.Entities);
return(queryGenerator.GenerateQuery(item.Entries.Select(e => e.Key).ToList(), tableData));
}
private void ExecuteSql(EventRequestGenerateSqlArgs args)
{
if (args.Item is not DatabaseTableSolutionItem dbEditItem)
{
return;
}
if (!SolutionItem.Equals(dbEditItem))
{
return;
}
args.Sql = queryGenerator.GenerateQuery(GenerateKeys(), new DatabaseTableData(tableDefinition, Entities));
}
public virtual Task <IQuery> GenerateQuery()
{
return(Task.FromResult(queryGenerator
.GenerateQuery(GenerateKeys(), GenerateDeletedKeys(), new DatabaseTableData(tableDefinition, Entities))));
}
public Task <string> GenerateQuery()
{
return(Task.FromResult(queryGenerator
.GenerateQuery(GenerateKeys(), new DatabaseTableData(tableDefinition, Entities)).QueryString));
}