You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ignite.apache.org by an...@apache.org on 2016/03/04 10:31:14 UTC
[19/50] ignite git commit: IGNITE-2287 TEMPORARY do not generate
values with NULL.
IGNITE-2287 TEMPORARY do not generate values with NULL.
Project: http://git-wip-us.apache.org/repos/asf/ignite/repo
Commit: http://git-wip-us.apache.org/repos/asf/ignite/commit/daccaefa
Tree: http://git-wip-us.apache.org/repos/asf/ignite/tree/daccaefa
Diff: http://git-wip-us.apache.org/repos/asf/ignite/diff/daccaefa
Branch: refs/heads/ignite-843
Commit: daccaefad557777cf9deccceb78420384c5626a7
Parents: f01fc59
Author: Alexey Kuznetsov <ak...@apache.org>
Authored: Sat Feb 20 17:12:25 2016 +0700
Committer: Alexey Kuznetsov <ak...@apache.org>
Committed: Sat Feb 20 17:12:25 2016 +0700
----------------------------------------------------------------------
.../main/js/helpers/generator/generator-java.js | 44 ++++++++++----------
1 file changed, 22 insertions(+), 22 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/ignite/blob/daccaefa/modules/control-center-web/src/main/js/helpers/generator/generator-java.js
----------------------------------------------------------------------
diff --git a/modules/control-center-web/src/main/js/helpers/generator/generator-java.js b/modules/control-center-web/src/main/js/helpers/generator/generator-java.js
index 3d83605..32023b9 100644
--- a/modules/control-center-web/src/main/js/helpers/generator/generator-java.js
+++ b/modules/control-center-web/src/main/js/helpers/generator/generator-java.js
@@ -2653,27 +2653,27 @@ var PREDEFINED_QUERIES = [
{name: 'EXAMPLE_MAX_DEPARTMENT_CNT', val: 5, comment: 'How many departments to generate.'}
],
specialGeneration: function (res, conVar) {
- $generatorJava.declareVariableCustom(res, 'stmt', 'java.sql.PreparedStatement', conVar +
- '.prepareStatement("INSERT INTO EMPLOYEE(ID, DEPARTMENT_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB, SALARY) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)")');
-
- res.startBlock('for (int id = 0; id < EXAMPLE_MAX_DEPARTMENT_CNT; id ++) {');
- res.line('stmt.setInt(1, id);');
- res.line('stmt.setInt(2, id);');
- res.line('stmt.setString(3, "First name manager #" + (id + 1));');
- res.line('stmt.setString(4, "Last name manager#" + (id + 1));');
- res.line('stmt.setString(5, "Email manager#" + (id + 1));');
- res.line('stmt.setString(6, "Phone number manager#" + (id + 1));');
- res.line('stmt.setString(7, "2014-01-01");');
- res.line('stmt.setString(8, "Job manager #" + (id + 1));');
- res.line('stmt.setDouble(9, 1000.0 + rnd.nextInt(500));');
-
- res.needEmptyLine = true;
-
- res.line('stmt.executeUpdate();');
-
- res.endBlock('}');
-
- res.needEmptyLine = true;
+ //$generatorJava.declareVariableCustom(res, 'stmt', 'java.sql.PreparedStatement', conVar +
+ // '.prepareStatement("INSERT INTO EMPLOYEE(ID, DEPARTMENT_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB, SALARY) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)")');
+ //
+ //res.startBlock('for (int id = 0; id < EXAMPLE_MAX_DEPARTMENT_CNT; id ++) {');
+ //res.line('stmt.setInt(1, id);');
+ //res.line('stmt.setInt(2, id);');
+ //res.line('stmt.setString(3, "First name manager #" + (id + 1));');
+ //res.line('stmt.setString(4, "Last name manager#" + (id + 1));');
+ //res.line('stmt.setString(5, "Email manager#" + (id + 1));');
+ //res.line('stmt.setString(6, "Phone number manager#" + (id + 1));');
+ //res.line('stmt.setString(7, "2014-01-01");');
+ //res.line('stmt.setString(8, "Job manager #" + (id + 1));');
+ //res.line('stmt.setDouble(9, 1000.0 + rnd.nextInt(500));');
+ //
+ //res.needEmptyLine = true;
+ //
+ //res.line('stmt.executeUpdate();');
+ //
+ //res.endBlock('}');
+ //
+ //res.needEmptyLine = true;
$generatorJava.declareVariableCustom(res, 'stmt', 'java.sql.PreparedStatement', conVar +
'.prepareStatement("INSERT INTO EMPLOYEE(ID, DEPARTMENT_ID, MANAGER_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB, SALARY) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")');
@@ -2704,7 +2704,7 @@ var PREDEFINED_QUERIES = [
res.needEmptyLine = true;
},
selectQuery: [
- "SELECT * FROM EMPLOYEE WHERE MANAGERID IS NOT NULL"
+ "SELECT * FROM EMPLOYEE WHERE SALARY > 700"
]
}
];