public void DropDatabase() { var cmd = new DropDatabaseCommand(Session.Connection) { DatabaseName = Name }; cmd.Execute(); }
public IndexDatabaseSettingProvider( FastAdapter adapter, ProviderOptionManager optionManager, IConfigurationBuilder builder, IApplicationManager applicationManager, CreateDatabaseCommand createDatabaseCommand, DropDatabaseCommand dropDatabaseCommand, MigrateUpCommand migrateUpCommand, MigrateDownCommand migrateDownCommand, GenerateMigrationCommand generateMigrationCommand, IEventAggregator eventAggregator) : base(optionManager) { this.adapter = adapter; this.builder = builder; this.applicationManager = applicationManager; this.createDatabaseCommand = createDatabaseCommand; this.dropDatabaseCommand = dropDatabaseCommand; this.migrateUpCommand = migrateUpCommand; this.migrateDownCommand = migrateDownCommand; this.generateMigrationCommand = generateMigrationCommand; this.eventAggregator = eventAggregator; this.LoadOptions(); }
public TransferObject ReadCommand(string line) { var to = new TransferObject(); try { // split line to words var words = line .Trim() .Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries); // navigate through databases if (words[0] == "#") { ChangeDatabase(words[1]); } // show info if (words[0].ToLower() == "/info") { var res = $"Uptime: {_stopwatch.Elapsed}. Version: {_settings.Version}."; var resData = new ResultData { DataType = ResultDataType.Message, Message = res }; CommandLine.WriteInfo(res); to.Data = resData; return(to); } //show databases tree if (line.ToLower() == "/show databases") { var res = GetSchemes(); var resData = new ResultData { DataType = ResultDataType.Message, Message = res }; CommandLine.WriteInfo(res); to.Data = resData; return(to); } //show databases sizes if (line.ToLower() == "/show databases size") { var res = GetDBSizes(); var resData = new ResultData { DataType = ResultDataType.Message, Message = res }; CommandLine.WriteInfo(res); to.Data = resData; return(to); } //if create database if (words[0].ToLower() == "create" && words[1].ToLower() == "database") { _logger.LogInformation($"Read command: [{line}]."); var cmd = new CreateDatabaseCommand(words); var res = CreateDatabase(cmd.DatebaseName); _logger.LogInformation($"{res}."); CommandLine.WriteInfo(res); } //if drop database if (words[0].ToLower() == "drop" && words[1].ToLower() == "database") { _logger.LogInformation($"Read command: [{line}]."); var cmd = new DropDatabaseCommand(words); var res = DropDatabase(cmd.DatebaseName); _logger.LogInformation($"{res}."); CommandLine.WriteInfo(res); } // if create table command if (words[0].ToLower() == "create" && words[1].ToLower() == "table") { _logger.LogInformation($"Read command: [{line}]."); var res = _currentDatabase?.CreateTable(line); _logger.LogInformation($"{res}."); CommandLine.WriteInfo(res); } // if insert into if (words[0].ToLower() == "insert" && words[1].ToLower() == "into") { _logger.LogInformation($"Read command: [{line}]."); var res = _currentDatabase?.InsertIntoTable(line); _logger.LogInformation($"{res}."); CommandLine.WriteInfo(res); var resData = new ResultData { Message = JsonConvert.SerializeObject(res, Formatting.Indented), DataType = ResultDataType.Message }; to.Data = resData; return(to); } // if select from #warning 'Rewrite condition' if (words[0].ToLower() == "select") { //#if Debug // ChangeDatabase("DBtest"); //#endif string info = ""; _logger.LogInformation($"Read command: [{line}]."); var res = _currentDatabase?.SelectFromTable(words, out info); CommandLine.ShowData(res); _logger.LogInformation($"{info}."); CommandLine.WriteInfo(info); res.DataType = ResultDataType.DataSet; var d = res.Values.ToList(); d.AddRange(res.Values);// d.AddRange(res.Values); var resData = new ResultData { DataType = ResultDataType.DataSet, Headers = res.Headers, Values = res.Values }; to.Data = resData; to.Time = info; return(to); } return(to); } catch (Error error) { CommandLine.WriteError($"{error}"); _logger.LogError($"{error}"); var err = new ErrorData { Message = $"{error}" }; to.Error = err; return(to); } catch (Exception ex) { CommandLine.WriteError($"System exeption, see log files."); #if DEBUG CommandLine.WriteError($"{ex}"); #endif _logger.LogCritical($"{ex}"); var err = new ErrorData { Message = $"{ex}" }; to.Error = err; return(to); } }