protected BaseFileViewModel(DbStudioViewModel solutionViewModel, string fileName, string exportFilesExtensions) : base(false)
{
// Asigna las propiedades
SolutionViewModel = solutionViewModel;
ExportFilesExtensions = exportFilesExtensions;
FileName = fileName;
ActualPage = 1;
Pages = 0;
Records = 0;
RecordsPerPage = 10_000;
// Asigna los comandos
NextPageCommand = new BaseCommand(_ => GoToPage(ActualPage + 1), _ => ActualPage < Pages)
.AddListener(this, nameof(Records))
.AddListener(this, nameof(RecordsPerPage));
PreviousPageCommand = new BaseCommand(_ => GoToPage(ActualPage - 1), _ => ActualPage > 1)
.AddListener(this, nameof(Records))
.AddListener(this, nameof(RecordsPerPage));
FirstPageCommand = new BaseCommand(_ => GoToPage(1), _ => ActualPage > 1)
.AddListener(this, nameof(Records))
.AddListener(this, nameof(RecordsPerPage));
LastPageCommand = new BaseCommand(_ => GoToPage(Pages), _ => ActualPage < Pages)
.AddListener(this, nameof(Records))
.AddListener(this, nameof(RecordsPerPage));
FilePropertiesCommand = new BaseCommand(_ => OpenFileProperties());
}
public CreateSchemaReportingXmlViewModel(DbStudioViewModel solutionViewModel)
{
// Inicializa las propiedades
SolutionViewModel = solutionViewModel;
// Inicializa el viewModel
InitViewModel();
}
public ExecuteQueryViewModel(DbStudioViewModel solutionViewModel, string selectedConnection, string query) : base(false)
{
// Asigna los viewModel
SolutionViewModel = solutionViewModel;
QueryViewModel = new QueryViewModel(solutionViewModel, selectedConnection, query, false);
// Asigna las propiedades
Header = "Consulta";
}
public CsvFilePropertiesViewModel(DbStudioViewModel solutionViewModel, CsvFileViewModel fileViewModel)
{
// Inicializa las propiedades
SolutionViewModel = solutionViewModel;
FileViewModel = fileViewModel;
// Inicializa el viewModel
InitViewModel();
}
public CreateSchemaXmlViewModel(DbStudioViewModel solutionViewModel)
{
// Inicializa las propiedades
SolutionViewModel = solutionViewModel;
ComboConnections = new Connections.ComboConnectionsViewModel(SolutionViewModel, string.Empty);
// Inicializa el viewModel
InitViewModel();
}
public ExecuteFilesViewModel(DbStudioViewModel solutionViewModel, List <string> files) : base(false)
{
// Asigna las propiedades
SolutionViewModel = solutionViewModel;
Header = "Ejecución de archivos";
// Carga la lista de archivos
LoadListFiles(files);
}
public ExportDatabaseViewModel(DbStudioViewModel solutionViewModel)
{
// Inicializa las propiedades
SolutionViewModel = solutionViewModel;
ComboConnections = new Connections.ComboConnectionsViewModel(SolutionViewModel, string.Empty);
// Inicializa el viewModel
InitViewModel();
}
public DeploymentViewModel(DbStudioViewModel solutionViewModel, DeploymentModel deployment)
{
// Inicializa las propiedades
SolutionViewModel = solutionViewModel;
IsNew = deployment == null;
Deployment = deployment ?? new DeploymentModel(solutionViewModel.Solution);
// Inicializa el viewModel
InitViewModel();
}
public StorageViewModel(DbStudioViewModel solutionViewModel, StorageModel storage)
{
// Inicializa las propiedades
SolutionViewModel = solutionViewModel;
IsNew = storage == null;
Storage = storage ?? new StorageModel(solutionViewModel.Solution);
// Inicializa el viewModel
InitViewModel();
}
public ConnectionViewModel(DbStudioViewModel solutionViewModel, ConnectionModel connection)
{
// Inicializa las propiedades
SolutionViewModel = solutionViewModel;
IsNew = connection == null;
Connection = connection ?? new ConnectionModel(solutionViewModel.Solution);
// Inicializa el viewModel
InitViewModel();
}
public TreeConnectionsViewModel(DbStudioViewModel solutionViewModel) : base(solutionViewModel)
{
NewConnectionCommand = new BaseCommand(_ => OpenConnection(null), _ => CanExecuteAction(nameof(NewConnectionCommand)))
.AddListener(this, nameof(SelectedNode));
NewDeploymentCommand = new BaseCommand(_ => OpenDeployment(null), _ => CanExecuteAction(nameof(NewDeploymentCommand)))
.AddListener(this, nameof(SelectedNode));
NewQueryCommand = new BaseCommand(parameter => OpenQuery(null));
ExecuteDeploymentCommand = new BaseCommand(_ => ExecuteDeployment(), _ => CanExecuteAction(nameof(ExecuteDeploymentCommand)))
.AddListener(this, nameof(SelectedNode));
}
public ExecuteEtlConsoleViewModel(DbStudioViewModel solutionViewModel, string projectFileName) : base(false)
{
// Inicializa las propiedades
SolutionViewModel = solutionViewModel;
// Inicializa el viewModel
InitViewModel(projectFileName);
// Inicializa los comandos
ExecuteScriptCommand = new BaseCommand(async _ => await PrepareExecuteScriptAsync());
ExecuteConsoleCommand = new BaseCommand(_ => ExecuteConsole(), _ => !string.IsNullOrWhiteSpace(EtlConsoleFileName))
.AddListener(this, nameof(EtlConsoleFileName));
}
public CreateValidationScriptsViewModel(DbStudioViewModel solutionViewModel)
{
// Inicializa las propiedades
SolutionViewModel = solutionViewModel;
ComboConnections = new Connections.ComboConnectionsViewModel(SolutionViewModel, string.Empty);
ComboConnections.Connections.PropertyChanged += (sender, args) => {
if (args.PropertyName.Equals(nameof(ComboConnections.Connections.SelectedItem)))
{
TreeConnection.LoadConnection(ComboConnections.GetSelectedConnection());
}
};
TreeConnection = new Explorers.Connections.TreeConnectionTablesViewModel(SolutionViewModel);
// Inicializa el viewModel
InitViewModel();
}
public ConnectionExecutionViewModel(DbStudioViewModel solutionViewModel)
{
// Asigna la solución y el viewmodel de parámetros de ejecución
SolutionViewModel = solutionViewModel;
// Asigna los comandos
ExecuteFileCommand = new BaseCommand(parameter => ExecuteFolderFile(parameter));
ExecuteScriptCommand = new BaseCommand(async _ => await ExecuteScriptAsync(), _ => !IsExecuting)
.AddListener(this, nameof(IsExecuting));
CancelScriptExecutionCommand = new BaseCommand(_ => CancelScriptExecution(), _ => IsExecuting)
.AddListener(this, nameof(IsExecuting));
UpdateParametersFileCommand = new BaseCommand(_ => UpdateParametersFile());
OpenParametersFileCommand = new BaseCommand(_ => OpenParametersFile(), _ => !string.IsNullOrWhiteSpace(ConnectionParametersFileName))
.AddListener(this, nameof(ConnectionParametersFileName));
ExportDataBaseCommand = new BaseCommand(async _ => await ExportDataBaseAsync());
}
public TreeStorageViewModel(DbStudioViewModel solutionViewModel)
{
SolutionViewModel = solutionViewModel;
NewStorageCommand = new BaseCommand(_ => OpenStorage(null));
NewContainerCommand = new BaseCommand(async _ => await NewContainerAsync(), _ => CanExecuteAction(nameof(NewContainerCommand)))
.AddListener(this, nameof(SelectedNode));
DeleteAsyncCommand = new BaseCommand(async _ => await DeleteItemAsync(), _ => SelectedNode != null)
.AddListener(this, nameof(SelectedNode));
UploadFileAsyncCommand = new BaseCommand(async _ => await UploadFileAsync(), _ => CanExecuteAction(nameof(UploadFileAsyncCommand)))
.AddListener(this, nameof(SelectedNode));
UploadFolderAsyncCommand = new BaseCommand(async _ => await UploadFolderAsync(), _ => CanExecuteAction(nameof(UploadFolderAsyncCommand)))
.AddListener(this, nameof(SelectedNode));
DownloadAsyncCommand = new BaseCommand(async _ => await DownloadAsync(), _ => CanExecuteAction(nameof(DownloadAsyncCommand)))
.AddListener(this, nameof(SelectedNode));
}
public QueryViewModel(DbStudioViewModel solutionViewModel, string selectedConnection, string query, bool raisePrepareExecution) : base(false)
{
// Asigna los viewModel
SolutionViewModel = solutionViewModel;
ChartViewModel = new ChartViewModel(this);
// Asigna las propiedades
Query = query;
PaginateQuery = false;
ActualPage = 1;
PageSize = 10_000;
// Carga el combo de conexiones
ComboConnections = new ComboConnectionsViewModel(solutionViewModel, selectedConnection);
// Asigna los comandos
if (raisePrepareExecution)
{
ProcessCommand = new BaseCommand(_ => RaiseEventPrepareExecution(), _ => !IsExecuting)
.AddListener(this, nameof(IsExecuting));
}
else
{
ProcessCommand = new BaseCommand(async _ => await ExecuteQueryAsync(), _ => !IsExecuting)
.AddListener(this, nameof(IsExecuting));
}
CancelQueryCommand = new BaseCommand(_ => CancelQuery(), _ => IsExecuting)
.AddListener(this, nameof(IsExecuting));
ShowExecutionPlanCommand = new BaseCommand(async _ => await ShowExecutionPlanAsync(), _ => !IsExecuting)
.AddListener(this, nameof(IsExecuting));
ExportCommand = new BaseCommand(async _ => await ExportAsync(), _ => !IsExecuting)
.AddListener(this, nameof(IsExecuting));
FirstPageCommand = new BaseCommand(async _ => await GoPageAsync(1), _ => PaginateQuery && !IsExecuting)
.AddListener(this, nameof(IsExecuting))
.AddListener(this, nameof(PaginateQuery));
PreviousPageCommand = new BaseCommand(async _ => await GoPageAsync(ActualPage - 1), _ => PaginateQuery && ActualPage > 1 && !IsExecuting)
.AddListener(this, nameof(IsExecuting))
.AddListener(this, nameof(PaginateQuery));
NextPageCommand = new BaseCommand(async _ => await GoPageAsync(ActualPage + 1), _ => PaginateQuery && !IsExecuting)
.AddListener(this, nameof(IsExecuting))
.AddListener(this, nameof(PaginateQuery));
LastPageCommand = new BaseCommand(async _ => await GoPageAsync(ActualPage + 1), _ => PaginateQuery && !IsExecuting)
.AddListener(this, nameof(IsExecuting))
.AddListener(this, nameof(PaginateQuery));
}
public ScriptFileViewModel(DbStudioViewModel solutionViewModel, string fileName) : base(solutionViewModel.MainController.PluginController, fileName)
{
SolutionViewModel = solutionViewModel;
}
public TreeSolutionBaseViewModel(DbStudioViewModel solutionViewModel)
{
SolutionViewModel = solutionViewModel;
}
public CsvFileViewModel(DbStudioViewModel solutionViewModel, string fileName) : base(solutionViewModel, fileName, "parquet")
{
}
public ComboConnectionsViewModel(DbStudioViewModel solutionViewModel, string selectedConnection)
{
SolutionViewModel = solutionViewModel;
LoadComboConnections(selectedConnection);
}
public ParquetFileViewModel(DbStudioViewModel solutionViewModel, string fileName) : base(solutionViewModel, fileName, "csv")
{
}
public TreeConnectionTablesViewModel(DbStudioViewModel solutionViewModel) : base(solutionViewModel)
{
}
public ReportingSolutionViewModel(DbStudioViewModel solutionViewModel)
{
SolutionViewModel = solutionViewModel;
ReportingSolutionManager = new ReportingSolutionManager();
TreeReportingViewModel = new Explorers.TreeReportingViewModel(this);
}
