public FlushCacheQuery(final DataSource ds) { moveCacheToTableQuery = new SqlUpdate(ds, "INSERT INTO so_deviation(tenantId, item1Id, item2Id, item1TypeId, item2TypeId, numerator, denominator, deviation)\n" + " SELECT tenantId, item1Id, item2Id, item1TypeId, item2TypeId, numerator, denominator, (numerator/denominator)\n" + " FROM so_deviation_cache\n" + " WHERE written=b'0'\n" + "ON DUPLICATE KEY UPDATE\n" + " so_deviation.numerator = so_deviation.numerator + VALUES(so_deviation.numerator),\n" + " so_deviation.denominator = so_deviation.denominator + VALUES(so_deviation.denominator),\n" + " so_deviation.deviation = (so_deviation.numerator+VALUES(so_deviation.numerator))/(so_deviation.denominator + VALUES(so_deviation.denominator))", NO_TYPES); moveCacheToTableQuery.compile(); updateCacheWrittenQuery = new SqlUpdate(ds, "UPDATE so_deviation_cache SET numerator = 0, denominator = 0, written = b'1' WHERE written = b'0'", NO_TYPES); updateCacheWrittenQuery.compile(); reduceCacheQuery = new SqlUpdate(ds, "DELETE FROM so_deviation_cache WHERE written=b'1' LIMIT ?", new int[]{Types.INTEGER}); reduceCacheQuery.compile(); disableKeysQuery = new SqlUpdate(ds, "ALTER TABLE so_deviation DISABLE KEYS", NO_TYPES); disableKeysQuery.compile(); enableKeysQuery = new SqlUpdate(ds, "ALTER TABLE so_deviation ENABLE KEYS", NO_TYPES); enableKeysQuery.compile(); }
SqlUpdate insert = new SqlUpdate(ds, "INSERT INTO company (name) VALUES (?)"); insert.declareParameter(new SqlParameter(Types.VARCHAR)); insert.setReturnGeneratedKeys(true); // assuming auto-generated col is named 'id' insert.setGeneratedKeysColumnNames(new String[] {"id"}); insert.compile(); .... GeneratedKeyHolder keyHolder = new GeneratedKeyHolder(); insert.update(new Object[]{"test"}, keyHolder); System.out.println(keyHolder.getKey().longValue());
new int[]{Types.INTEGER, Types.INTEGER, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.BLOB, Types.BIT}, 1); createConfiguration.compile(); new int[]{Types.VARCHAR, Types.BLOB, Types.INTEGER, Types.INTEGER, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR}, 1); updateConfigurationActive.compile(); new int[]{Types.VARCHAR, Types.BLOB, Types.INTEGER, Types.INTEGER, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR}, 1); updateConfigurationInactive.compile(); "pluginVersion = ? AND name = ? AND active = b'0'", new int[]{Types.INTEGER, Types.INTEGER, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR}, 1); deleteConfiguration.compile();
"configuration) VALUES (?, ?, ?, ?, ?, ?)", new int[]{Types.INTEGER, Types.VARCHAR, Types.VARCHAR, Types.TIMESTAMP, Types.VARCHAR, Types.BLOB}); startEntry.compile(); new int[]{Types.INTEGER, Types.VARCHAR, Types.VARCHAR, Types.TIMESTAMP, Types.VARCHAR, Types.BLOB, Types.TIMESTAMP, Types.BLOB, Types.TIMESTAMP, Types.BLOB}); endEntry.compile(); "UPDATE plugin_log SET endDate = ?, statistics = ? WHERE endDate IS NULL", new int[]{Types.TIMESTAMP, Types.BLOB}); endAllEntries.compile(); deleteLogEntries.compile(); deleteLogEntryStatement.declareParameter(new SqlParameter("startDate", Types.TIMESTAMP)); deleteLogEntryStatement.declareParameter(new SqlParameter("assocTypeId", Types.VARCHAR)); deleteLogEntryStatement.compile();
new int[]{Types.INTEGER, Types.INTEGER, Types.INTEGER, Types.INTEGER, Types.INTEGER, Types.DOUBLE, Types.BIGINT}); QUERY_INSERT_CACHED_DEVIATION.compile();