Examples of CreateIndex

Examples of net.sf.jsqlparser.statement.create.index.CreateIndex

20
21
22
23
24
25
26
27
28
29
30
31
32
  }

  public void testCreateIndex() throws JSQLParserException {
    String statement =
      "CREATE INDEX myindex ON mytab (mycol, mycol2)";
    CreateIndex createIndex = (CreateIndex) parserManager.parse(new StringReader(statement));
    assertEquals(2, createIndex.getIndex().getColumnsNames().size());
    assertEquals("myindex", createIndex.getIndex().getName());
    assertNull(createIndex.getIndex().getType());
    assertEquals("mytab", createIndex.getTable().getFullyQualifiedName());
    assertEquals("mycol", createIndex.getIndex().getColumnsNames().get(0));
    assertEquals(statement, ""+createIndex);
  }
View Full Code Here

Examples of net.sf.jsqlparser.statement.create.index.CreateIndex

32
33
34
35
36
37
38
39
40
41
42
43
44
  }

  public void testCreateIndex2() throws JSQLParserException {
    String statement =
      "CREATE mytype INDEX myindex ON mytab (mycol, mycol2)";
    CreateIndex createIndex = (CreateIndex) parserManager.parse(new StringReader(statement));
    assertEquals(2, createIndex.getIndex().getColumnsNames().size());
    assertEquals("myindex", createIndex.getIndex().getName());
    assertEquals("mytype", createIndex.getIndex().getType());
    assertEquals("mytab", createIndex.getTable().getFullyQualifiedName());
    assertEquals("mycol2", createIndex.getIndex().getColumnsNames().get(1));
    assertEquals(statement, ""+createIndex);
  }
View Full Code Here

Examples of net.sf.jsqlparser.statement.create.index.CreateIndex

44
45
46
47
48
49
50
51
52
53
54
55
  }

  public void testCreateIndex3() throws JSQLParserException {
    String statement =
      "CREATE mytype INDEX myindex ON mytab (mycol ASC, mycol2, mycol3)";
    CreateIndex createIndex = (CreateIndex) parserManager.parse(new StringReader(statement));
    assertEquals(3, createIndex.getIndex().getColumnsNames().size());
    assertEquals("myindex", createIndex.getIndex().getName());
    assertEquals("mytype", createIndex.getIndex().getType());
    assertEquals("mytab", createIndex.getTable().getFullyQualifiedName());
    assertEquals("mycol3", createIndex.getIndex().getColumnsNames().get(2));
  }
View Full Code Here

Examples of net.sf.jsqlparser.statement.create.index.CreateIndex

55
56
57
58
59
60
61
62
63
64
65
66
  }

  public void testCreateIndex4() throws JSQLParserException {
    String statement =
      "CREATE mytype INDEX myindex ON mytab (mycol ASC, mycol2 (75), mycol3)";
    CreateIndex createIndex = (CreateIndex) parserManager.parse(new StringReader(statement));
    assertEquals(3, createIndex.getIndex().getColumnsNames().size());
    assertEquals("myindex", createIndex.getIndex().getName());
    assertEquals("mytype", createIndex.getIndex().getType());
    assertEquals("mytab", createIndex.getTable().getFullyQualifiedName());
    assertEquals("mycol3", createIndex.getIndex().getColumnsNames().get(2));
  }
View Full Code Here

Examples of net.sf.jsqlparser.statement.create.index.CreateIndex

66
67
68
69
70
71
72
73
74
75
76
77
  }

  public void testCreateIndex5() throws JSQLParserException {
    String statement =
      "CREATE mytype INDEX myindex ON mytab (mycol ASC, mycol2 (75), mycol3) mymodifiers";
    CreateIndex createIndex = (CreateIndex) parserManager.parse(new StringReader(statement));
    assertEquals(3, createIndex.getIndex().getColumnsNames().size());
    assertEquals("myindex", createIndex.getIndex().getName());
    assertEquals("mytype", createIndex.getIndex().getType());
    assertEquals("mytab", createIndex.getTable().getFullyQualifiedName());
    assertEquals("mycol3", createIndex.getIndex().getColumnsNames().get(2));
  }
View Full Code Here

Examples of org.h2.command.ddl.CreateIndex

3832
3833
3834
3835
3836
3837
3838
3839
3840
3841
3842
3843
3844
3845
3846
3847
3848
3849
                }
            }
            read("ON");
            String tableName = readIdentifierWithSchema();
            checkSchema(oldSchema);
            CreateIndex command = new CreateIndex(session, getSchema());
            command.setIfNotExists(ifNotExists);
            command.setHash(hash);
            command.setPrimaryKey(primaryKey);
            command.setTableName(tableName);
            command.setUnique(unique);
            command.setIndexName(indexName);
            command.setComment(readCommentIf());
            read("(");
            command.setIndexColumns(parseIndexColumnList());
            return command;
        }
    }
View Full Code Here

Examples of org.h2.command.ddl.CreateIndex

5006
5007
5008
5009
5010
5011
5012
5013
5014
5015
5016
5017
5018
5019
5020
5021
5022
5023
5024
5025
5026
5027
5028
5029
5030
5031
5032
5033
5034
5035
5036
5037
5038
5039
5040
5041
5042
5043
5044
5045
5046
5047
5048
5049
5050
5051
5052
5053
5054
5055
5056
5057
5058
5059
5060
5061
5062
5063
5064
5065
5066
5067
5068
                command.setIndex(getSchema().findIndex(session, indexName));
            }
            return command;
        } else if (database.getMode().indexDefinitionInCreateTable && (readIf("INDEX") || readIf("KEY"))) {
            // MySQL
            CreateIndex command = new CreateIndex(session, schema);
            command.setComment(comment);
            command.setTableName(tableName);
            if (!readIf("(")) {
                command.setIndexName(readUniqueIdentifier());
                read("(");
            }
            command.setIndexColumns(parseIndexColumnList());
            return command;
        }
        AlterTableAddConstraint command;
        if (readIf("CHECK")) {
            command = new AlterTableAddConstraint(session, schema, ifNotExists);
            command.setType(CommandInterface.ALTER_TABLE_ADD_CONSTRAINT_CHECK);
            command.setCheckExpression(readExpression());
        } else if (readIf("UNIQUE")) {
            readIf("KEY");
            readIf("INDEX");
            command = new AlterTableAddConstraint(session, schema, ifNotExists);
            command.setType(CommandInterface.ALTER_TABLE_ADD_CONSTRAINT_UNIQUE);
            if (!readIf("(")) {
                constraintName = readUniqueIdentifier();
                read("(");
            }
            command.setIndexColumns(parseIndexColumnList());
            if (readIf("INDEX")) {
                String indexName = readIdentifierWithSchema();
                command.setIndex(getSchema().findIndex(session, indexName));
            }
        } else if (readIf("FOREIGN")) {
            command = new AlterTableAddConstraint(session, schema, ifNotExists);
            command.setType(CommandInterface.ALTER_TABLE_ADD_CONSTRAINT_REFERENTIAL);
            read("KEY");
            read("(");
            command.setIndexColumns(parseIndexColumnList());
            if (readIf("INDEX")) {
                String indexName = readIdentifierWithSchema();
                command.setIndex(schema.findIndex(session, indexName));
            }
            read("REFERENCES");
            parseReferences(command, schema, tableName);
        } else {
            if (constraintName != null) {
                throw getSyntaxError();
            }
            return null;
        }
        if (readIf("NOCHECK")) {
            command.setCheckExisting(false);
        } else {
            readIf("CHECK");
            command.setCheckExisting(true);
        }
        command.setTableName(tableName);
        command.setConstraintName(constraintName);
        command.setComment(comment);
        return command;
    }
View Full Code Here

Examples of org.h2.command.ddl.CreateIndex

3838
3839
3840
3841
3842
3843
3844
3845
3846
3847
3848
3849
3850
3851
3852
3853
3854
3855
                }
            }
            read("ON");
            String tableName = readIdentifierWithSchema();
            checkSchema(oldSchema);
            CreateIndex command = new CreateIndex(session, getSchema());
            command.setIfNotExists(ifNotExists);
            command.setHash(hash);
            command.setPrimaryKey(primaryKey);
            command.setTableName(tableName);
            command.setUnique(unique);
            command.setIndexName(indexName);
            command.setComment(readCommentIf());
            read("(");
            command.setIndexColumns(parseIndexColumnList());
            return command;
        }
    }
View Full Code Here

Examples of org.h2.command.ddl.CreateIndex

5040
5041
5042
5043
5044
5045
5046
5047
5048
5049
5050
5051
5052
5053
5054
5055
5056
5057
5058
5059
5060
5061
5062
5063
5064
5065
5066
5067
5068
5069
5070
5071
5072
5073
5074
5075
5076
5077
5078
5079
5080
5081
5082
5083
5084
5085
5086
5087
5088
5089
5090
5091
5092
5093
5094
5095
5096
5097
5098
5099
5100
5101
5102
                // known data type
                parseIndex = start;
                read();
                return null;
            }
            CreateIndex command = new CreateIndex(session, schema);
            command.setComment(comment);
            command.setTableName(tableName);
            if (!readIf("(")) {
                command.setIndexName(readUniqueIdentifier());
                read("(");
            }
            command.setIndexColumns(parseIndexColumnList());
            return command;
        }
        AlterTableAddConstraint command;
        if (readIf("CHECK")) {
            command = new AlterTableAddConstraint(session, schema, ifNotExists);
            command.setType(CommandInterface.ALTER_TABLE_ADD_CONSTRAINT_CHECK);
            command.setCheckExpression(readExpression());
        } else if (readIf("UNIQUE")) {
            readIf("KEY");
            readIf("INDEX");
            command = new AlterTableAddConstraint(session, schema, ifNotExists);
            command.setType(CommandInterface.ALTER_TABLE_ADD_CONSTRAINT_UNIQUE);
            if (!readIf("(")) {
                constraintName = readUniqueIdentifier();
                read("(");
            }
            command.setIndexColumns(parseIndexColumnList());
            if (readIf("INDEX")) {
                String indexName = readIdentifierWithSchema();
                command.setIndex(getSchema().findIndex(session, indexName));
            }
        } else if (readIf("FOREIGN")) {
            command = new AlterTableAddConstraint(session, schema, ifNotExists);
            command.setType(CommandInterface.ALTER_TABLE_ADD_CONSTRAINT_REFERENTIAL);
            read("KEY");
            read("(");
            command.setIndexColumns(parseIndexColumnList());
            if (readIf("INDEX")) {
                String indexName = readIdentifierWithSchema();
                command.setIndex(schema.findIndex(session, indexName));
            }
            read("REFERENCES");
            parseReferences(command, schema, tableName);
        } else {
            if (constraintName != null) {
                throw getSyntaxError();
            }
            return null;
        }
        if (readIf("NOCHECK")) {
            command.setCheckExisting(false);
        } else {
            readIf("CHECK");
            command.setCheckExisting(true);
        }
        command.setTableName(tableName);
        command.setConstraintName(constraintName);
        command.setComment(comment);
        return command;
    }
View Full Code Here

Examples of org.h2.command.ddl.CreateIndex

3834
3835
3836
3837
3838
3839
3840
3841
3842
3843
3844
3845
3846
3847
3848
3849
3850
3851
                }
            }
            read("ON");
            String tableName = readIdentifierWithSchema();
            checkSchema(oldSchema);
            CreateIndex command = new CreateIndex(session, getSchema());
            command.setIfNotExists(ifNotExists);
            command.setHash(hash);
            command.setPrimaryKey(primaryKey);
            command.setTableName(tableName);
            command.setUnique(unique);
            command.setIndexName(indexName);
            command.setComment(readCommentIf());
            read("(");
            command.setIndexColumns(parseIndexColumnList());
            return command;
        }
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.