Examples of UpdateScript

marauroa.server.db.UpdateScript
updates the structure of the database to the newest versoin @author hendrik
org.apache.metamodel.UpdateScript
Represents any updating operation or update script that can be executed on a {@link UpdateableDataContext}. Users of MetaModel should implement their own {@link UpdateScript} and submit them to the{@link UpdateableDataContext#executeUpdate(UpdateScript)} method forexecution. @author Kasper Sørensen
org.eobjects.metamodel.UpdateScript

Examples of org.apache.metamodel.UpdateScript

        } catch (SQLException e) {
            // do nothing
        }


        final JdbcDataContext dc = new JdbcDataContext(conn);
        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback callback) {
                Table table = callback.createTable(dc.getDefaultSchema(), "test_table").withColumn("foo")
                        .ofType(ColumnType.INTEGER).withColumn("bar").ofType(ColumnType.VARCHAR).execute();
                callback.insertInto(table).value("foo", 1).value("bar", "hello").execute();
                callback.insertInto(table).value("foo", 2).value("bar", "there").execute();
                callback.insertInto(table).value("foo", 3).value("bar", "world").execute();
            }
        });


        Table table = dc.getTableByQualifiedLabel("test_table");
        Query query = new Query().from(table, "a").from(table, "b");
        query.select(table.getColumnByName("foo"), query.getFromClause().getItem(0));
        query.select(table.getColumnByName("foo"), query.getFromClause().getItem(1));
        query.where(new SelectItem(table.getColumnByName("bar"), query.getFromClause().getItem(0)), OperatorType.EQUALS_TO,
                "hello");


        assertEquals(
                "SELECT a.\"FOO\", b.\"FOO\" FROM PUBLIC.\"TEST_TABLE\" a, PUBLIC.\"TEST_TABLE\" b WHERE a.\"BAR\" = 'hello'",
                query.toSql());


        DataSet ds = dc.executeQuery(query);
        assertTrue(ds.next());
        assertEquals("Row[values=[1, 1]]", ds.getRow().toString());
        assertTrue(ds.next());
        assertEquals("Row[values=[1, 2]]", ds.getRow().toString());
        assertTrue(ds.next());
        assertEquals("Row[values=[1, 3]]", ds.getRow().toString());
        assertFalse(ds.next());
        ds.close();


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback callback) {
                callback.dropTable("test_table").execute();
            }
        });

View Full Code Here

Examples of org.apache.metamodel.UpdateScript


    private JdbcDataContext createLimitAndOffsetTestData() {
        final JdbcDataContext dc = new JdbcDataContext(conn);


        if (dc.getTableByQualifiedLabel("test_table") != null) {
            dc.executeUpdate(new UpdateScript() {
                @Override
                public void run(UpdateCallback callback) {
                    callback.dropTable("test_table").execute();
                }
            });
        }


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback callback) {
                Table table = callback.createTable(dc.getDefaultSchema(), "test_table").withColumn("foo")
                        .ofType(ColumnType.INTEGER).withColumn("bar").ofType(ColumnType.VARCHAR).execute();
                callback.insertInto(table).value("foo", 1).value("bar", "hello").execute();

View Full Code Here

Examples of org.apache.metamodel.UpdateScript

      connection = DriverManager.getConnection(CONNECTION_STRING,
          USERNAME, PASSWORD);


      JdbcDataContext dc = new JdbcDataContext(connection);
      final Schema schema = dc.getDefaultSchema();
      dc.executeUpdate(new UpdateScript() {
        @Override
        public void run(UpdateCallback cb) {
          Table table = cb.createTable(schema, "my_table")
              .withColumn("id").ofType(ColumnType.INTEGER)
              .ofNativeType("SERIAL").nullable(false)

View Full Code Here

Examples of org.apache.metamodel.UpdateScript


        if (dc.getTableByQualifiedLabel("test_table") != null) {
            dc.executeUpdate(new DropTable(schema, "test_table"));
        }


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback cb) {
                ColumnCreationBuilder createTableBuilder = cb.createTable(schema, "test_table").withColumn("id")
                        .ofType(ColumnType.FLOAT).withColumn("code").ofType(ColumnType.VARCHAR).ofSize(10);
                Table table = createTableBuilder.execute();

View Full Code Here

Examples of org.apache.metamodel.UpdateScript


        if (dc.getTableByQualifiedLabel("test_table") != null) {
            dc.executeUpdate(new DropTable("test_table"));
        }


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback cb) {
                ColumnCreationBuilder createTableBuilder = cb.createTable(schema, "test_table").withColumn("id")
                        .ofType(ColumnType.FLOAT).withColumn("code").ofType(ColumnType.VARCHAR).ofSize(10);
                Table table = createTableBuilder.execute();

View Full Code Here

Examples of org.apache.metamodel.UpdateScript


        final JdbcDataContext dc = new JdbcDataContext(conn);
        final Schema schema = dc.getDefaultSchema();


        if (dc.getTableByQualifiedLabel("test_table") != null) {
            dc.executeUpdate(new UpdateScript() {
                @Override
                public void run(UpdateCallback cb) {
                    cb.dropTable("test_table").execute();
                }
            });
        }


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback cb) {
                ColumnCreationBuilder createTableBuilder = cb.createTable(schema, "test_table").withColumn("id")
                        .ofType(ColumnType.INTEGER).withColumn("code").ofType(ColumnType.CHAR).ofSize(1);
                String sql = createTableBuilder.toSql();

View Full Code Here

Examples of org.apache.metamodel.UpdateScript

        assertFalse(conn.isReadOnly());


        JdbcDataContext dc = new JdbcDataContext(conn);
        final Schema schema = dc.getDefaultSchema();


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback cb) {
                Table table = cb.createTable(schema, "test_table").withColumn("id").ofType(ColumnType.INTEGER)
                        .withColumn("birthdate1").ofType(ColumnType.DATE).withColumn("birthdate2")
                        .ofType(ColumnType.TIMESTAMP).execute();


                cb.insertInto(table).value("id", "1").value("birthdate1", null).execute();
                cb.insertInto(table).value("id", 2).value("birthdate1", "2011-12-21")
                        .value("birthdate2", "2011-12-21 14:00:00").execute();
            }
        });


        DataSet ds = dc.query().from("test_table").select("id").and("birthdate1").execute();
        assertTrue(ds.next());
        assertEquals("Row[values=[1, null]]", ds.getRow().toString());
        assertEquals("java.lang.Integer", ds.getRow().getValue(0).getClass().getName());
        assertTrue(ds.next());
        assertEquals("Row[values=[2, 2011-12-21]]", ds.getRow().toString());
        assertEquals("java.sql.Date", ds.getRow().getValue(1).getClass().getName());
        assertFalse(ds.next());
        ds.close();


        Query query = dc.query().from("test_table").select("id").where("birthdate2")
                .lessThan(DateUtils.get(2011, Month.DECEMBER, 20)).toQuery();
        try {
            ds = dc.executeQuery(query);
        } catch (Exception e) {
            System.out.println("Failing query was: " + dc.getQueryRewriter().rewriteQuery(query));
            throw e;
        }
        assertFalse(ds.next());
        ds.close();


        ds = dc.query().from("test_table").select("id").where("birthdate2")
                .greaterThan(DateUtils.get(2011, Month.DECEMBER, 20)).execute();
        assertTrue(ds.next());
        assertEquals("Row[values=[2]]", ds.getRow().toString());
        assertFalse(ds.next());
        ds.close();


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback callback) {
                callback.deleteFrom("test_table").where("id").in(Arrays.<String> asList("1", "2")).execute();
            }
        });


        ds = dc.query().from("test_table").selectCount().where("id").eq(2).or("id").eq(1).execute();
        assertTrue(ds.next());
        assertEquals(0, ((Number) ds.getRow().getValue(0)).intValue());
        assertFalse(ds.next());
        ds.close();


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback callback) {
                callback.dropTable("test_table").execute();
            }
        });

View Full Code Here

Examples of org.apache.metamodel.UpdateScript

    }


    public static void createInsertAndUpdateDateTypes(final JdbcDataContext dc, final Schema schema,
            final String tableName) throws Exception {
        if (schema.getTableByName(tableName) != null) {
            dc.executeUpdate(new UpdateScript() {
                @Override
                public void run(UpdateCallback callback) {
                    callback.dropTable(schema.getTableByName(tableName)).execute();
                }
            });
        }


        dc.executeUpdate(new BatchUpdateScript() {
            @Override
            public void run(UpdateCallback cb) {
                Table table = cb.createTable(schema, tableName).withColumn("id").asPrimaryKey()
                        .ofType(ColumnType.INTEGER).withColumn("birthdate").ofType(ColumnType.DATE)
                        .withColumn("wakemeup").ofType(ColumnType.TIME).execute();


                // insert record 1
                {
                    // create a 7:55 time.
                    Calendar cal = Calendar.getInstance();
                    cal.setTimeInMillis(0);
                    cal.set(Calendar.HOUR_OF_DAY, 7);
                    cal.set(Calendar.MINUTE, 55);
                    Date wakeUpTime = cal.getTime();
                    cb.insertInto(table).value("id", 1).value("birthdate", DateUtils.get(1982, Month.APRIL, 20))
                            .value("wakemeup", wakeUpTime).execute();
                }


                // insert record 2
                {
                    // create a 18:35 time.
                    Calendar cal = Calendar.getInstance();
                    cal.setTimeInMillis(0);
                    cal.set(Calendar.HOUR_OF_DAY, 18);
                    cal.set(Calendar.MINUTE, 35);
                    Date wakeUpTime = cal.getTime();
                    cb.insertInto(table).value("id", 2).value("birthdate", DateUtils.get(1982, Month.APRIL, 21))
                            .value("wakemeup", wakeUpTime).execute();
                }
            }
        });


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback cb) {
                cb.insertInto(schema.getTableByName(tableName)).value("id", 3).value("birthdate", "2011-12-21")
                        .value("wakemeup", "12:00").execute();
            }
        });


        DataSet ds = dc.query().from(schema.getTableByName(tableName)).select("id", "birthdate", "wakemeup")
                .orderBy("id").execute();
        assertTrue(ds.next());
        assertEquals("1", ds.getRow().getValue(0).toString());
        assertEquals("1982-04-20", ds.getRow().getValue(1).toString());
        assertTrue("Actual value was: " + ds.getRow().getValue(2),
                ds.getRow().getValue(2).toString().startsWith("07:55:00"));


        assertTrue(ds.next());
        assertEquals("2", ds.getRow().getValue(0).toString());
        assertEquals("1982-04-21", ds.getRow().getValue(1).toString());
        assertTrue("Actual value was: " + ds.getRow().getValue(2),
                ds.getRow().getValue(2).toString().startsWith("18:35:00"));


        assertTrue(ds.next());
        assertEquals("3", ds.getRow().getValue(0).toString());
        assertEquals("2011-12-21", ds.getRow().getValue(1).toString());
        assertTrue("Actual value was: " + ds.getRow().getValue(2),
                ds.getRow().getValue(2).toString().startsWith("12:00"));


        assertFalse(ds.next());
        ds.close();


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback callback) {
                // update record 1


                // create a 08:00 time.
                Calendar cal = Calendar.getInstance();
                cal.setTimeInMillis(0);
                cal.set(Calendar.HOUR_OF_DAY, 8);
                cal.set(Calendar.MINUTE, 00);
                Date wakeUpTime = cal.getTime();


                callback.update(schema.getTableByName(tableName))
                        .value("birthdate", DateUtils.get(1982, Month.APRIL, 21)).value("wakemeup", wakeUpTime)
                        .where("birthdate").isEquals(DateUtils.get(1982, Month.APRIL, 20)).execute();
            }
        });


        ds = dc.query().from(schema.getTableByName(tableName)).select("id", "birthdate", "wakemeup").orderBy("id")
                .execute();
        assertTrue(ds.next());
        assertEquals("1", ds.getRow().getValue(0).toString());
        assertEquals("1982-04-21", ds.getRow().getValue(1).toString());
        assertTrue("Actual value was: " + ds.getRow().getValue(2),
                ds.getRow().getValue(2).toString().startsWith("08:00:00"));


        assertTrue(ds.next());
        assertEquals("2", ds.getRow().getValue(0).toString());
        assertEquals("1982-04-21", ds.getRow().getValue(1).toString());
        assertTrue("Actual value was: " + ds.getRow().getValue(2),
                ds.getRow().getValue(2).toString().startsWith("18:35:00"));


        assertTrue(ds.next());
        assertEquals("3", ds.getRow().getValue(0).toString());
        assertEquals("2011-12-21", ds.getRow().getValue(1).toString());
        assertTrue("Actual value was: " + ds.getRow().getValue(2),
                ds.getRow().getValue(2).toString().startsWith("12:00"));


        assertFalse(ds.next());
        ds.close();


        if (schema.getTableByName(tableName) != null) {
            dc.executeUpdate(new UpdateScript() {
                @Override
                public void run(UpdateCallback callback) {
                    callback.dropTable(schema.getTableByName(tableName)).execute();
                }
            });

View Full Code Here

Examples of org.eobjects.metamodel.UpdateScript

  }


  private synchronized final void flushBuffer() {
    if (!_buffer.isEmpty()) {
      logger.info("Flushing {} rows in write buffer", _buffer.size());
      _dataContext.executeUpdate(new UpdateScript() {
        @Override
        public void run(UpdateCallback callback) {
          for (Object[] rowData = _buffer.poll(); rowData != null; rowData = _buffer.poll()) {
            RowInsertionBuilder insertBuilder = callback.insertInto(getTable());
            for (int i = 0; i < _columns.length; i++) {

View Full Code Here

Examples of org.eobjects.metamodel.UpdateScript

          parentFile.mkdirs();
        }
        dataContext = new CsvDataContext(file, getConfiguration(separatorChar, quoteChar));


        final Schema schema = dataContext.getDefaultSchema();
        dataContext.executeUpdate(new UpdateScript() {
          @Override
          public void run(UpdateCallback callback) {
            TableCreationBuilder tableBuilder = callback.createTable(schema, "table");
            for (String header : headers) {
              tableBuilder.withColumn(header);

View Full Code Here

0 1 2 3 4 5

TOP

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.