Schema gen index

Run
How to run the sample
The source code for this sample can be found in the javaee7-samples GitHub repository. The first thing we need to do is to get the source by downloading the repository and then go into the samples folder:
git clone git://github.com/javaee-samples/javaee7-samples.git
cd javaee7-samples/jpa/schema-gen-index/
Now we are ready to start testing. You can run all the tests in this sample by executing:
mvn test
Or you can run individual tests by executing one of the following:
mvn test -Dtest=SchemaGenIndexTest

  • Specifications in use:
    • JPA

    SchemaGenIndexTest

    Missing a description for the story. Add some javadoc to the TestClass. Show me how!
    Missing a description for the deployment. Add some javadoc to the @Deployment method. Show me how!
    @Deployment
    public static WebArchive createDeployment() {
        WebArchive war = ShrinkWrap.create(WebArchive.class)
                                   .addPackage("org.javaee7.jpa.index")
                                   .addAsResource("META-INF/persistence.xml");
        System.out.println(war.toString(true));
        return war;
    }
    Missing a description for the test scenario. Add some javadoc to the @Test method. Show me how!
    @Test
    public void testSchemaGenIndex() throws Exception {
        Path create = Paths.get("/tmp/create.sql");
        assertTrue(Files.exists(create));
    
        Path drop = Paths.get("/tmp/drop.sql");
        assertTrue(Files.exists(create));
    
        String line;
        BufferedReader reader = Files.newBufferedReader(create, Charset.defaultCharset());
        boolean createGenerated = false;
        boolean createIndex = false;
        while ((line = reader.readLine()) != null) {
            if (line.toLowerCase().contains("create table employee_schema_gen_index")) {
                createGenerated = true;
            }
    
            if (line.toLowerCase().contains("create index")) {
                createIndex = true;
            }
        }
    
        reader = Files.newBufferedReader(drop, Charset.defaultCharset());
        boolean dropGenerated = false;
        while ((line = reader.readLine()) != null) {
            if (line.toLowerCase().contains("drop table employee_schema_gen_index")) {
                dropGenerated = true;
                break;
            }
        }
    
        assertTrue(createGenerated);
        assertTrue(createIndex);
        assertTrue(dropGenerated);
    }

    Share the Knowledge

    Find this sample useful? Share on

    There's a lot more about JavaEE to cover. If you're ready to learn more, check out the other available samples.

    Help Improve

    Find a bug in the sample? Something missing? You can fix it by editing the source, making the correction and sending a pull request. Or report the problem to the issue tracker

    Recent Changelog

    • Dec 04, 2014: Added tests for schema-gen-index project by Roberto Cortez
    • Jul 15, 2014: Removed header license. the licensing is now referenced in the license file in the root of the project by Roberto Cortez
    • Nov 09, 2013: New sample to show @index usage by Arun Gupta
    How to help improve this sample
    The source code for this sample can be found in the javaee7-samples GitHub repository. The first thing you need to do is to get the source by downloading the repository and then go into the samples folder:
    git clone git://github.com/javaee-samples/javaee7-samples.git
    cd javaee7-samples/jpa/schema-gen-index/

    Do the changes as you see fit and send a pull request!

    Good Luck!