109 public void testParseOptions_QueryNow_Named_withTypes() throws InvalidOptionsException, CLIParserException { |
109 public void testParseOptions_QueryNow_Named_withTypes() throws InvalidOptionsException, CLIParserException { |
110 String[] args = new String[]{ |
110 String[] args = new String[]{ |
111 Tokens.DB, DATABASE_NAME_1, |
111 Tokens.DB, DATABASE_NAME_1, |
112 Tokens.SQL, SQL_1, |
112 Tokens.SQL, SQL_1, |
113 Tokens.NAME_PREFIX, "$", |
113 Tokens.NAME_PREFIX, "$", |
114 Tokens.TYPES, " " + NAME_1 + TYPE_NAME_SEPARATOR + "int" + "," + NAME_2 + TYPE_NAME_SEPARATOR + "string" + "," + NAME_3 + TYPE_NAME_SEPARATOR + "boolean", |
114 Tokens.TYPES, " " + NAME_1 + TYPE_NAME_SEPARATOR + "int" + "," + NAME_3 + TYPE_NAME_SEPARATOR + "boolean", |
115 Tokens.DATA, "$" + NAME_1, DATA_1, "$" + NAME_2, DATA_2, "$" + NAME_3, DATA_3}; |
115 Tokens.DATA, "$" + NAME_1, DATA_1, "$" + NAME_2, DATA_2, "$" + NAME_3, DATA_3}; |
116 CLIOptions options = parser.parseOptions(args); |
116 CLIOptions options = parser.parseOptions(args); |
117 options.validate(); |
117 options.validate(); |
118 |
118 |
119 assertEquals(options.getDatabaseName(), DATABASE_NAME_1); |
119 assertEquals(options.getDatabaseName(), DATABASE_NAME_1); |
120 assertEquals(options.getSql(), SQL_1); |
120 assertEquals(options.getSql(), SQL_1); |
121 assertEquals(options.getMode(), CLIOptions.MODE.QUERY_NOW); |
121 assertEquals(options.getMode(), CLIOptions.MODE.QUERY_NOW); |
122 assertEquals(options.getNamedParameters().size(), 3); |
122 assertEquals(options.getNamedParameters().size(), 3); |
123 assertNamedParameter(options.getNamedParameters(), NAME_1, DATA_1, Types.INTEGER); |
123 assertNamedParameter(options.getNamedParameters(), NAME_1, DATA_1, Types.INTEGER); |
124 assertNamedParameter(options.getNamedParameters(), NAME_2, DATA_2, Types.VARCHAR); |
124 assertNamedParameter(options.getNamedParameters(), NAME_2, DATA_2, Parameter.DEFAULT_TYPE); |
125 assertNamedParameter(options.getNamedParameters(), NAME_3, DATA_3, Types.BOOLEAN); |
125 assertNamedParameter(options.getNamedParameters(), NAME_3, DATA_3, Types.BOOLEAN); |
126 } |
126 } |
127 |
127 |
128 private void assertNamedParameter(Collection<NamedParameter> params, String name, Object value, int type) { |
128 private void assertNamedParameter(Collection<NamedParameter> params, String name, Object value, int type) { |
129 for (NamedParameter p : params) { |
129 for (NamedParameter p : params) { |