public async Task LoadSystemTables(DatabaseInfo dbInf) { _dbInfo = dbInf; var table = new List<ITableViewModel>(); await Task.Run(() => { using (var con = new FbConnection(_dbInfo.ConnectionString)) { con.Open(); foreach (var item in _dbInfo.GetSystemTables(con)) { var vm = new TableViewModel(item.TableName, true); foreach (var colums in item.GetColums(con)) { vm.Colums.Add(new ColumViewMoodel(colums)); } table.Add(vm); } } }); Tables.AddRange(table); CollectionViewSource.GetDefaultView(Tables).Refresh(); RaisePropertyChanged(nameof(Tables)); }
public async Task LoadDatabase(DatabaseInfo dbInf) { _dbInfo = dbInf; var table = new List<ITableViewModel>(); await Task.Run(() => { using (var con = new FbConnection(_dbInfo.ConnectionString)) { con.Open(); foreach (var item in _dbInfo.GetTables(con)) { var vm = new TableViewModel(item.TableName); foreach (var colums in item.GetColums(con)) { vm.Colums.Add(new ColumViewMoodel(colums)); } foreach (var trigger in item.GetTrigger(con)) { vm.Triggers.Add(new TriggerViewModel(trigger)); } foreach (var idx in item.GetIndex(con)) { vm.Indexs.Add(new IndexViewModel(idx)); } table.Add(vm); } foreach (var item in _dbInfo.GetViews(con)) { var vm = new TableViewViewModel(item.ViewName, item.Source); foreach (var colums in item.GetColums(con)) { vm.Colums.Add(new ColumViewMoodel(colums)); } table.Add(vm); } } }); Tables = table; AdditionalInfo = new AdditionalDbInfoControl(this); RaisePropertyChanged(nameof(Tables)); RaisePropertyChanged(nameof(AdditionalInfo)); }
public ConnectionSettingsViewModel(DatabaseInfo inf) { _inf = inf; Init(); OkCommand = new RelayCommand(() => { var properties = _inf.Builder.GetType().GetProperties(BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly); foreach (var item in NotInputList.Where(x => x.Value != null).Union(InputedList)) { _inf.Builder[_synonyms[item.Name]] = item.Value; } MessengerInstance.Send(new MessageBase(this, "WindowClose")); }); }
public async Task CreateDatabase(string path, FirebirdType type, FbCharset charset) { var dbInfo = new DatabaseInfo(new FirebirdInfo(path, type, charset)); dbInfo.CreateDatabase(); await LoadDatabase(dbInfo); }
public void SetCommand() { CreateDatabase = new RelayCommand(async () => { var vm = new NewDatabaseSettingsViewModel(); MessengerInstance.Send(new MessageBase(vm, "NewDbSettingsWindowOpen")); if (string.IsNullOrEmpty(vm.Path)) return; var db = new DbViewModel(); await db.CreateDatabase(vm.Path, vm.Type, vm.CharSet); Databases.Add(db); _history.DataAdd(vm.Path); }); LoadDatabase = new RelayCommand<string>(async (path) => { if (string.IsNullOrEmpty(path)) return; if (!File.Exists(path)) return; var dbInf = new DatabaseInfo(new FirebirdInfo(path)); if (!dbInf.CanLoadDatabase) return; var db = new DbViewModel(); Databases.Add(db); await db.LoadDatabase(dbInf); _history.DataAdd(path); }); ExecuteQuery = new RelayCommand(async () => { if (CurrentDatabase == null || !CurrentDatabase.CanExecute()) return; if (TagSelectedValue.IsNewResult && 0 < Datasource[0].Result.Count) Datasource[0].Pined = true; var QueryResult = Datasource[0]; QueryResult.Result.Clear(); await Task.Run(() => { var inf = new QueryInfo { ShowExecutePlan = TagSelectedValue.IsShowExecutionPlan }; QueryResult.GetExecuteResult(inf, CurrentDatabase.ConnectionString, TagSelectedValue.Query); }); }); DropFile = new RelayCommand<string>((string path) => { InputPath = path; RaisePropertyChanged(nameof(InputPath)); }); DbListDropFile = new RelayCommand<string>((string path) => { LoadDatabase.Execute(path); }); SetSqlTemplate = new RelayCommand<SqlKind>((SqlKind sqlKind) => { TagSelectedValue.Query = CreateSqlSentence(SelectedTableItem, sqlKind); RaisePropertyChanged(nameof(Queries)); }); ExecLimitedSql = new RelayCommand<string>((count) => { TagSelectedValue.Query = CreateSqlSentence(SelectedTableItem, SqlKind.Select, int.Parse(count)); RaisePropertyChanged(nameof(Queries)); ExecuteQuery.Execute(null); }); ExecSqlTemplate = new RelayCommand<SqlKind>((SqlKind sqlKind) => { SetSqlTemplate.Execute(sqlKind); ExecuteQuery.Execute(null); }); ShutdownDatabase = new RelayCommand(() => { Databases.Remove(CurrentDatabase); }); ChangeConfig = new RelayCommand(() => { if (CurrentDatabase == null) return; var vm = new ConnectionSettingsViewModel(CurrentDatabase.DbInfo); MessengerInstance.Send(new MessageBase(vm, "WindowOpen")); }); ShowEntity = new RelayCommand(() => { if (CurrentDatabase == null) return; var vm = new EntityRelationshipViewModel(CurrentDatabase); MessengerInstance.Send(new MessageBase(vm, "EintityWindowOpen")); }); AddTab = new RelayCommand(() => { TagSelectedValue.Header = $"Query{Queries.Count}"; Queries.Add(QueryTabViewModel.GetNewInstance()); RaisePropertyChanged(nameof(Queries)); }); DeleteTabItem = new RelayCommand(() => { var item = TagSelectedValue; var idx = Queries.IndexOf(item); TagSelectedIndex = idx - 1; RaisePropertyChanged(nameof(TagSelectedIndex)); Queries.Remove(item); }); LoadHistry = new RelayCommand(() => _history.LoadData(Path.GetDirectoryName(Assembly.GetEntryAssembly().Location))); SaveHistry = new RelayCommand(() => _history.SaveData(Path.GetDirectoryName(Assembly.GetEntryAssembly().Location))); OpenGitPage = new RelayCommand(() => System.Diagnostics.Process.Start("https://github.com/degarashi0913/FAManagementStudio")); PinedCommand = new RelayCommand(() => { Datasource[0].Header = $"Pin{Datasource.Count}"; Datasource.Insert(0, new QueryResultViewModel("Result")); SelectedResultIndex = 0; RaisePropertyChanged(nameof(SelectedResultIndex)); }, () => 0 < Datasource[0].Result.Count); ReleasePinCommand = new RelayCommand<QueryResultViewModel>((data) => { Datasource.Remove(data); }); SetSqlDataTemplate = new RelayCommand<string>((s) => { var table = GetTreeViewTableName(CurrentDatabase, SelectedTableItem); var result = ""; if (s == "table") { result = table.GetDdl(CurrentDatabase); } else if (s == "insert") { if (table is TableViewViewModel) return; var colums = table.Colums.Select(x => x.ColumName).ToArray(); var escapedColumsStr = string.Join(", ", colums.Select(x => EscapeKeyWord(x)).ToArray()); var insertTemplate = $"insert into {table.TableName} ({escapedColumsStr})"; var qry = new QueryInfo(); var res = qry.ExecuteQuery(CurrentDatabase.ConnectionString, CreateSelectStatement(table.TableName, colums, 0)).First(); var sb = new StringBuilder(); foreach (DataRow row in res.View.Rows) { sb.Append(insertTemplate + " values("); sb.Append(string.Join(", ", row.ItemArray.Select(x => x.GetType() == typeof(string) ? $"\'{x}\'" : $"{x}").ToArray())); sb.AppendLine(");"); } result = sb.ToString(); } var idx = Queries.IndexOf(TagSelectedValue); Queries[idx].Query = result; RaisePropertyChanged(nameof(Queries)); }); ShowPathSettings = new RelayCommand(() => { var vm = new BasePathSettingsViewModel(QueryProjects); MessengerInstance.Send(new MessageBase(vm, "BasePathSettingsWindowOpen")); }); ProjectItemOpen = new RelayCommand<object>((obj) => { var item = obj as QueryProjectFileViewModel; if (item == null) return; var idx = Queries.IndexOf(TagSelectedValue); try { Queries[idx].Header = Path.GetFileNameWithoutExtension(item.FullPath); Queries[idx].Query = Queries[idx].FileLoad(item.FullPath, Encoding.UTF8); } catch (IOException) { } }); ProjectItemDrop = new RelayCommand<string>((string path) => { QueryProjects.Add(QueryProjectViewModel.GetData(path).First()); AppSettingsManager.QueryProjectBasePaths.Add(path); }); }