Package com.alibaba.druid.sql.dialect.mysql.ast

Examples of com.alibaba.druid.sql.dialect.mysql.ast.MysqlForeignKey

752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
    public MySqlForeignKey parseForeignKey() {
        accept(Token.FOREIGN);
        accept(Token.KEY);

        MySqlForeignKey fk = new MySqlForeignKey();

        accept(Token.LPAREN);
        this.names(fk.getReferencingColumns());
        accept(Token.RPAREN);

        accept(Token.REFERENCES);

        fk.setReferencedTableName(this.name());

        accept(Token.LPAREN);
        this.names(fk.getReferencedColumns());
        accept(Token.RPAREN);
        return fk;
    }
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
                    } else if (lexer.token() == (Token.KEY)) {
                        stmt.getTableElementList().add(parseConstraint());
                    } else if (lexer.token() == (Token.PRIMARY)) {
                        stmt.getTableElementList().add(parseConstraint());
                    } else if (lexer.token() == (Token.FOREIGN)) {
                        MySqlForeignKey fk = this.getExprParser().parseForeignKey();
                        stmt.getTableElementList().add(fk);
                    } else if (lexer.token() == Token.CHECK) {
                        lexer.nextToken();
                        SQLCheck check = new SQLCheck();
                        accept(Token.LPAREN);
View Full Code Here
2270
2271
2272
2273
2274
2275
2276
2277
2278
2279
2280
2281
                            SQLAlterTableAddPrimaryKey item = new SQLAlterTableAddPrimaryKey();
                            item.setPrimaryKey(primaryKey);
                            stmt.getItems().add(item);
                        } else if (lexer.token() == Token.FOREIGN) {
                            MySqlForeignKey fk = this.getExprParser().parseForeignKey();
                            fk.setName(constraintName);

                            SQLAlterTableAddForeignKey item = new SQLAlterTableAddForeignKey(fk);
                            stmt.getItems().add(item);
                        } else {
                            throw new ParserException("TODO " + lexer.token() + " " + lexer.stringVal());
View Full Code Here
2270
2271
2272
2273
2274
2275
2276
2277
2278
2279
2280
2281
                            SQLAlterTableAddPrimaryKey item = new SQLAlterTableAddPrimaryKey();
                            item.setPrimaryKey(primaryKey);
                            stmt.getItems().add(item);
                        } else if (lexer.token() == Token.FOREIGN) {
                            MySqlForeignKey fk = this.getExprParser().parseForeignKey();
                            fk.setName(constraintName);

                            SQLAlterTableAddForeignKey item = new SQLAlterTableAddForeignKey(fk);
                            stmt.getItems().add(item);
                        } else {
                            throw new ParserException("TODO " + lexer.token() + " " + lexer.stringVal());
View Full Code Here
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
    public MySqlForeignKey parseForeignKey() {
        accept(Token.FOREIGN);
        accept(Token.KEY);

        MySqlForeignKey fk = new MySqlForeignKey();

        accept(Token.LPAREN);
        this.names(fk.getReferencingColumns());
        accept(Token.RPAREN);

        accept(Token.REFERENCES);

        fk.setReferencedTableName(this.name());

        accept(Token.LPAREN);
        this.names(fk.getReferencedColumns());
        accept(Token.RPAREN);
        return fk;
    }
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
                    } else if (lexer.token() == (Token.KEY)) {
                        stmt.getTableElementList().add(parseConstraint());
                    } else if (lexer.token() == (Token.PRIMARY)) {
                        stmt.getTableElementList().add(parseConstraint());
                    } else if (lexer.token() == (Token.FOREIGN)) {
                        MySqlForeignKey fk = this.getExprParser().parseForeignKey();
                        stmt.getTableElementList().add(fk);
                    } else if (lexer.token() == Token.CHECK) {
                        lexer.nextToken();
                        SQLCheck check = new SQLCheck();
                        accept(Token.LPAREN);
View Full Code Here
2266
2267
2268
2269
2270
2271
2272
2273
2274
2275
2276
2277
                            SQLAlterTableAddPrimaryKey item = new SQLAlterTableAddPrimaryKey();
                            item.setPrimaryKey(primaryKey);
                            stmt.getItems().add(item);
                        } else if (lexer.token() == Token.FOREIGN) {
                            MySqlForeignKey fk = this.getExprParser().parseForeignKey();
                            fk.setName(constraintName);

                            SQLAlterTableAddForeignKey item = new SQLAlterTableAddForeignKey(fk);
                            stmt.getItems().add(item);
                        } else {
                            throw new ParserException("TODO " + lexer.token() + " " + lexer.stringVal());
View Full Code Here
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
   
    public MySqlForeignKey parseForeignKey() {
        accept(Token.FOREIGN);
        accept(Token.KEY);
       
        MySqlForeignKey fk = new MySqlForeignKey();
       
        accept(Token.LPAREN);
        this.names(fk.getReferencingColumns());
        accept(Token.RPAREN);
       
        accept(Token.REFERENCES);
       
        fk.setReferencedTableName(this.name());
       
        accept(Token.LPAREN);
        this.names(fk.getReferencedColumns());
        accept(Token.RPAREN);
        return fk;
    }
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
                    stmt.getTableElementList().add(parseConstraint());
                } else if (lexer.token() == (Token.FOREIGN)) {
                    lexer.nextToken();
                    accept(Token.KEY);
                   
                    MySqlForeignKey fk = new MySqlForeignKey();
                   
                    accept(Token.LPAREN);
                    this.exprParser.names(fk.getReferencingColumns());
                    accept(Token.RPAREN);
                   
                    accept(Token.REFERENCES);
                   
                    fk.setReferencedTableName(this.exprParser.name());
                   
                    accept(Token.LPAREN);
                    this.exprParser.names(fk.getReferencedColumns());
                    accept(Token.RPAREN);

                    stmt.getTableElementList().add(fk);
                } else if (lexer.token() == Token.CHECK) {
                    lexer.nextToken();
View Full Code Here
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
    public MysqlForeignKey parseForeignKey() {
        accept(Token.FOREIGN);
        accept(Token.KEY);

        MysqlForeignKey fk = new MysqlForeignKey();

        if (lexer.token() != Token.LPAREN) {
            SQLName indexName = name();
            fk.setIndexName(indexName);
        }

        accept(Token.LPAREN);
        this.names(fk.getReferencingColumns());
        accept(Token.RPAREN);

        accept(Token.REFERENCES);

        fk.setReferencedTableName(this.name());

        accept(Token.LPAREN);
        this.names(fk.getReferencedColumns());
        accept(Token.RPAREN);

        if (identifierEquals("MATCH")) {
            if (identifierEquals("FULL")) {
                fk.setReferenceMatch(Match.FULL);
            } else if (identifierEquals("PARTIAL")) {
                fk.setReferenceMatch(Match.PARTIAL);
            } else if (identifierEquals("SIMPLE")) {
                fk.setReferenceMatch(Match.SIMPLE);
            }
        }

        if (lexer.token() == Token.ON) {
            lexer.nextToken();
            if (lexer.token() == Token.DELETE) {
                fk.setReferenceOn(On.DELETE);
            } else if (lexer.token() == Token.UPDATE) {
                fk.setReferenceOn(On.UPDATE);
            } else {
                throw new ParserException("syntax error, expect DELETE or UPDATE, actual " + lexer.token() + " "
                                          + lexer.stringVal());
            }
            lexer.nextToken();

            if (lexer.token() == Token.RESTRICT) {
                fk.setReferenceOption(Option.RESTRICT);
            } else if (identifierEquals("CASCADE")) {
                fk.setReferenceOption(Option.CASCADE);
            } else if (lexer.token() == Token.SET) {
                accept(Token.NULL);
                fk.setReferenceOption(Option.SET_NULL);
            } else if (identifierEquals("ON")) {
                lexer.nextToken();
                if (identifierEquals("ACTION")) {
                    fk.setReferenceOption(Option.NO_ACTION);
                } else {
                    throw new ParserException("syntax error, expect ACTION, actual " + lexer.token() + " "
                                              + lexer.stringVal());
                }
            }
View Full Code Here
TOP

Related Classes of com.alibaba.druid.sql.dialect.mysql.ast.MysqlForeignKey

  • com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser
  • com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser
  • com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.