NOT FULL AST: foreign key, ...
NOT FULL AST: foreign key, ... not supported
Inheritance: IDdlStatement
コード例 #1
0
        /// <exception cref="System.SqlSyntaxErrorException" />
        private void CreateTableDefs(DdlCreateTableStatement stmt)
        {
            if (lexer.Token() != MySqlToken.PuncLeftParen)
            {
                return;
            }
            Match(MySqlToken.PuncLeftParen);
            IndexDefinition indexDef;
            Identifier id;
            for (var i = 0; lexer.Token() != MySqlToken.PuncRightParen; ++i)
            {
                if (i > 0)
                {
                    Match(MySqlToken.PuncComma);
                }
                switch (lexer.Token())
                {
                    case MySqlToken.KwPrimary:
                    {
                        lexer.NextToken();
                        Match(MySqlToken.KwKey);
                        indexDef = IndexDefinition();
                        stmt.SetPrimaryKey(indexDef);
                        break;
                    }

                    case MySqlToken.KwIndex:
                    case MySqlToken.KwKey:
                    {
                        lexer.NextToken();
                        if (lexer.Token() == MySqlToken.Identifier)
                        {
                            id = Identifier();
                        }
                        else
                        {
                            id = null;
                        }
                        indexDef = IndexDefinition();
                        stmt.AddIndex(id, indexDef);
                        break;
                    }

                    case MySqlToken.KwUnique:
                    {
                        switch (lexer.NextToken())
                        {
                            case MySqlToken.KwIndex:
                            case MySqlToken.KwKey:
                            {
                                lexer.NextToken();
                                break;
                            }
                        }
                        if (lexer.Token() == MySqlToken.Identifier)
                        {
                            id = Identifier();
                        }
                        else
                        {
                            id = null;
                        }
                        indexDef = IndexDefinition();
                        stmt.AddUniqueIndex(id, indexDef);
                        break;
                    }

                    case MySqlToken.KwFulltext:
                    {
                        switch (lexer.NextToken())
                        {
                            case MySqlToken.KwIndex:
                            case MySqlToken.KwKey:
                            {
                                lexer.NextToken();
                                break;
                            }
                        }
                        if (lexer.Token() == MySqlToken.Identifier)
                        {
                            id = Identifier();
                        }
                        else
                        {
                            id = null;
                        }
                        indexDef = IndexDefinition();
                        if (indexDef.IndexType != IndexType.None)
                        {
                            throw new SqlSyntaxErrorException("FULLTEXT INDEX can specify no index_type");
                        }
                        stmt.AddFullTextIndex(id, indexDef);
                        break;
                    }

                    case MySqlToken.KwSpatial:
                    {
                        switch (lexer.NextToken())
                        {
                            case MySqlToken.KwIndex:
                            case MySqlToken.KwKey:
                            {
                                lexer.NextToken();
                                break;
                            }
                        }
                        if (lexer.Token() == MySqlToken.Identifier)
                        {
                            id = Identifier();
                        }
                        else
                        {
                            id = null;
                        }
                        indexDef = IndexDefinition();
                        if (indexDef.IndexType != IndexType.None)
                        {
                            throw new SqlSyntaxErrorException("SPATIAL INDEX can specify no index_type");
                        }
                        stmt.AddSpatialIndex(id, indexDef);
                        break;
                    }

                    case MySqlToken.KwCheck:
                    {
                        lexer.NextToken();
                        Match(MySqlToken.PuncLeftParen);
                        var expr = exprParser.Expression();
                        Match(MySqlToken.PuncRightParen);
                        stmt.AddCheck(expr);
                        break;
                    }

                    case MySqlToken.Identifier:
                    {
                        var columnName = Identifier();
                        var columnDef = ColumnDefinition();
                        stmt.AddColumnDefinition(columnName, columnDef);
                        break;
                    }

                    default:
                    {
                        throw new SqlSyntaxErrorException("unsupportted column definition");
                    }
                }
            }
            Match(MySqlToken.PuncRightParen);
        }
コード例 #2
0
 public virtual void Visit(DdlCreateTableStatement node)
 {
     VisitInternal(node.Table);
 }
コード例 #3
0
        /// <summary><code>TABLE</code> has been consumed</summary>
        /// <exception cref="System.SqlSyntaxErrorException" />
        private DdlCreateTableStatement CreateTable(bool temp)
        {
            var ifNotExists = false;
            if (lexer.Token() == MySqlToken.KwIf)
            {
                lexer.NextToken();
                Match(MySqlToken.KwNot);
                Match(MySqlToken.KwExists);
                ifNotExists = true;
            }
            var table = Identifier();
            var stmt = new DdlCreateTableStatement(temp, ifNotExists, table);
            CreateTableDefs(stmt);
            var options = new DdlTableOptions();
            stmt.SetTableOptions(options);
            TableOptions(options);
            var selectOpt = CreateTableSelectOption.None;
            switch (lexer.Token())
            {
                case MySqlToken.KwIgnore:
                {
                    selectOpt = CreateTableSelectOption.Ignored;
                    if (lexer.NextToken() == MySqlToken.KwAs)
                    {
                        lexer.NextToken();
                    }
                    break;
                }

                case MySqlToken.KwReplace:
                {
                    selectOpt = CreateTableSelectOption.Replace;
                    if (lexer.NextToken() == MySqlToken.KwAs)
                    {
                        lexer.NextToken();
                    }
                    break;
                }

                case MySqlToken.KwAs:
                {
                    lexer.NextToken();
                    goto case MySqlToken.KwSelect;
                }

                case MySqlToken.KwSelect:
                {
                    break;
                }

                case MySqlToken.Eof:
                {
                    return stmt;
                }

                default:
                {
                    throw new SqlSyntaxErrorException("Ddl CREATE TABLE statement not end properly");
                }
            }
            var select = new MySqlDmlSelectParser(lexer, exprParser).Select();
            stmt.SetSelect(selectOpt, select);
            Match(MySqlToken.Eof);
            return stmt;
        }