1 package info.globalcode.sql.dk; |
1 package info.globalcode.sql.dk; |
2 |
2 |
3 import info.globalcode.sql.dk.CLIParser.Tokens; |
3 import info.globalcode.sql.dk.CLIParser.Tokens; |
|
4 import java.sql.Types; |
4 import static org.testng.Assert.*; |
5 import static org.testng.Assert.*; |
5 import org.testng.annotations.BeforeMethod; |
6 import org.testng.annotations.BeforeMethod; |
6 import org.testng.annotations.Test; |
7 import org.testng.annotations.Test; |
7 |
8 |
8 /** |
9 /** |
40 assertEquals(options.getNumberedParameters().get(1).getType(), Parameter.DEFAULT_TYPE); |
41 assertEquals(options.getNumberedParameters().get(1).getType(), Parameter.DEFAULT_TYPE); |
41 assertEquals(options.getNumberedParameters().get(2).getType(), Parameter.DEFAULT_TYPE); |
42 assertEquals(options.getNumberedParameters().get(2).getType(), Parameter.DEFAULT_TYPE); |
42 } |
43 } |
43 |
44 |
44 @Test |
45 @Test |
|
46 public void testParseOptions_QueryNow_Numbered_withTypes() throws InvalidOptionsException, CLIParserException { |
|
47 String[] args = new String[]{ |
|
48 Tokens.DB, DATABASE_NAME_1, |
|
49 Tokens.SQL, SQL_1, |
|
50 Tokens.TYPES, " int,string, boolean", |
|
51 Tokens.DATA, DATA_1, DATA_2, DATA_3}; |
|
52 CLIOptions options = parser.parseOptions(args); |
|
53 options.validate(); |
|
54 |
|
55 assertEquals(options.getDatabaseName(), DATABASE_NAME_1); |
|
56 assertEquals(options.getSql(), SQL_1); |
|
57 assertEquals(options.getMode(), CLIOptions.MODE.QUERY_NOW); |
|
58 assertEquals(options.getNumberedParameters().size(), 3); |
|
59 assertEquals(options.getNumberedParameters().get(0).getValue(), DATA_1); |
|
60 assertEquals(options.getNumberedParameters().get(1).getValue(), DATA_2); |
|
61 assertEquals(options.getNumberedParameters().get(2).getValue(), DATA_3); |
|
62 assertEquals(options.getNumberedParameters().get(0).getType(), Types.INTEGER); |
|
63 assertEquals(options.getNumberedParameters().get(1).getType(), Types.VARCHAR); |
|
64 assertEquals(options.getNumberedParameters().get(2).getType(), Types.BOOLEAN); |
|
65 } |
|
66 |
|
67 @Test |
45 public void testParseOptions_QueryNow_Named() throws InvalidOptionsException, CLIParserException { |
68 public void testParseOptions_QueryNow_Named() throws InvalidOptionsException, CLIParserException { |
46 String[] args = new String[]{Tokens.DB, DATABASE_NAME_1, Tokens.SQL, SQL_1}; |
69 String[] args = new String[]{Tokens.DB, DATABASE_NAME_1, Tokens.SQL, SQL_1}; |
47 CLIOptions options = parser.parseOptions(args); |
70 CLIOptions options = parser.parseOptions(args); |
48 options.validate(); |
71 options.validate(); |
49 |
72 |