Exemple #1
0
        public async Task <ActionResult> GetByName(string name)
        {
            var command = new CommandSchemaTable(name);
            await _dbCon.ExecuteAsync(command);

            if (command.IsSuccessful)
            {
                return(Ok(command.Data));
            }

            return(NotFound());
        }
Exemple #2
0
        public async Task <ActionResult> Create(string name, [FromBody] Column[] tableColumns)
        {
            var command = new CommandCreateTable(name, tableColumns);
            await _dbCon.ExecuteAsync(command);

            if (command.IsSuccessful)
            {
                var cmd = new CommandSchemaTable(name);
                await _dbCon.ExecuteAsync(cmd);

                if (cmd.IsSuccessful)
                {
                    return(Created($"api/Table/{name}", cmd.Data));
                }
            }

            return(Conflict(command.Error));
        }