Review Board 1.7.22


Review request for SQOOP-1035 "Add MS Sqoop Connecter tests to repo"

Review Request #10987 - Created May 8, 2013 and updated

Shuaishuai Nie
trunk
SQOOP-1035
Reviewers
Sqoop
sqoop-trunk
Add the MS Sqoop connector tests that test integration scenarios with SQL Server to the repo.
All tests passing after applying the patch

Diff revision 5

This is not the most recent revision of the diff. The latest diff is revision 7. See what's changed.

1 2 3 4 5 6 7
1 2 3 4 5 6 7

  1. conf/MSTest.properties: Loading...
  2. src/test/com/cloudera/sqoop/hive/TestHiveImport.java: Loading...
  3. src/test/com/cloudera/sqoop/manager/SQLServerManagerImportManualTest.java: Loading...
  4. src/test/org/apache/sqoop/manager/MSSQLTestData.java: Loading...
  5. src/test/org/apache/sqoop/manager/MSSQLTestDataFileParser.java: Loading...
  6. src/test/org/apache/sqoop/manager/MSSQLTestUtils.java: Loading...
  7. src/test/org/apache/sqoop/manager/ManagerCompatExport.java: Loading...
  8. src/test/org/apache/sqoop/manager/SQLServerDatatypeExportDelimitedFileManualTest.java: Loading...
  9. src/test/org/apache/sqoop/manager/SQLServerDatatypeExportSequenceFileManualTest.java: Loading...
  10. src/test/org/apache/sqoop/manager/SQLServerDatatypeImportDelimitedFileManualTest.java: Loading...
  11. src/test/org/apache/sqoop/manager/SQLServerDatatypeImportSequenceFileManualTest.java: Loading...
  12. src/test/org/apache/sqoop/manager/SQLServerHiveImportManualTest.java: Loading...
  13. src/test/org/apache/sqoop/manager/SQLServerManagerManualTest.java: Loading...
  14. src/test/org/apache/sqoop/manager/SQLServerMultiColsManualTest.java: Loading...
  15. src/test/org/apache/sqoop/manager/SQLServerMultiMapsManualTest.java: Loading...
  16. src/test/org/apache/sqoop/manager/SQLServerParseMethodsManualTest.java: Loading...
  17. src/test/org/apache/sqoop/manager/SQLServerQueryManualTest.java: Loading...
  18. src/test/org/apache/sqoop/manager/SQLServerSplitByManualTest.java: Loading...
  19. src/test/org/apache/sqoop/manager/SQLServerWhereManualTest.java: Loading...
  20. testdata/DatatypeTestData-export-lite.txt: Loading...
  21. testdata/DatatypeTestData-import-lite.txt: Loading...
conf/MSTest.properties
New File

    
   
1
# DEV NOTES:

    
   
2
# YOU NEED TO REPLACE ALL THE VALUES  FOR PATHS ON YOUR MACHINE.  THESE VALUES ARE TEMPLATE ONLY!!!!!!!!!!

    
   
3
# You also need to download the jdbc jar for the flavor of RDBMS you are testing and place in the lib folder

    
   
4
#IP Address of SQL server

    
   
5
MS_DB_SERVER_NAME=0.0.0.0:59975

    
   
6

   

    
   
7
#Name of database needs to be created at the time of test

    
   
8
MS_DATABASE_NAME=SQOOPTEST

    
   
9

   

    
   
10
#SQL server Username

    
   
11
MS_DB_USER_NAME=sqoopuser

    
   
12

   

    
   
13
#SQL server Password

    
   
14
MS_DB_PASSWORD=PASSWORD

    
   
15

   

    
   
16
#LZ Domain

    
   
17
LZ_DOMAIN=VDWPU-LZ01

    
   
18

   

    
   
19
#LZ Domain

    
   
20
LZ_IP=10.192.63.182

    
   
21

   

    
   
22
#LZ Username

    
   
23
LZ_USER_NAME=Administrator

    
   
24

   

    
   
25
#LZ Password

    
   
26
LZ_PASSWORD=dogmat1C

    
   
27

   

    
   
28
#The source file to export during export tests

    
   
29
MS_DATATYPE_TEST_DATA_FILE_EXPORT=D:\\hw\\project\\sqoop-monarch\\testdata\\DatatypeTestData-export-lite.txt

    
   
30

   

    
   
31
#The source file to import during import tests

    
   
32
MS_DATATYPE_TEST_DATA_FILE_IMPORT=D:\\hw\\project\\sqoop-monarch\\testdata\\DatatypeTestData-import-lite.txt

    
   
33

   

    
   
34
#Path of file containing test data samples for datatype testing.

    
   
35
MS_DATATYPE_TEST_DATA_FILE=E:/Test/testdata.txt

    
   
36

   

    
   
37
#Delimiter used in test data files.

    
   
38
MS_DATATYPE_TEST_DATA_FILE_DELIM=,

    
   
39

   

    
   
40
#Path of file containing test list file for data type testing

    
   
41
MS_DATATYPE_TEST_CASES_FILE_NAME=E:/Test/testlist.txt

    
   
42

   

    
   
43
#Path of directory which contains .test files.

    
   
44
MS_FUNCTIONAL_TEST_CASES_DIR=E:/sqoop-1.2.0-update/Testdata/testdata

    
   
45

   

    
   
46
#Path of list.txt file which contains list of test cases needs to be executed

    
   
47
MS_FUNCTIONAL_TEST_CASES_LIST=E:/sqoop-1.2.0-update/Testdata/testdata/list.txt

    
   
48

   

    
   
49
#Directory name on HDFS to store data files being used for import / export

    
   
50
MS_FUNCTIONAL_TEST_HDFS_TEST_HOME=mssqltesthomeNewTusharHive

    
   
51

   

    
   
52
#Directory path containing inputfiles for some testcases

    
   
53
MS_FUNCTIONAL_TEST_NATIVE_TEST_HOME=E:/sqoop-1.2.0-update/Testdata/Inputfiles

    
   
54

   

    
   
55
#Path of directory on HDFS containing Hive data.

    
   
56
MS_FUNCTIONAL_TEST_HIVE_HDFS_HOME=/hive/warehouse

    
   
57

   

    
   
58
#HDFS Path (used as a prefix to HDFS test home directory)

    
   
59
MS_DATATYPE_TEST_HDFSPREFIX=file:///

    
   
60

   

    
   
61
#Test Suite Platform OS ( Windows or Linux)

    
   
62
OS=Windows

    
   
63

   

    
   
64
#To test bcp set this option to 'yes', else 'no'

    
   
65
TEST_BCP=yes

    
   
66

   

    
   
67
#Path to conf file required to test bcp.

    
   
68
BCP_CONF_PATH=conf\\sqlserver-conf.xml

    
   
69

   

    
   
70
#Path to dll file required to test bcp.

    
   
71
BCP_DLL_PATH=lib/sqlserverbcp.dll
src/test/com/cloudera/sqoop/hive/TestHiveImport.java
Revision 462ccf1 New Change
 
src/test/com/cloudera/sqoop/manager/SQLServerManagerImportManualTest.java
Revision 27860c2 New Change
 
src/test/org/apache/sqoop/manager/MSSQLTestData.java
New File
 
src/test/org/apache/sqoop/manager/MSSQLTestDataFileParser.java
New File
 
src/test/org/apache/sqoop/manager/MSSQLTestUtils.java
New File
 
src/test/org/apache/sqoop/manager/ManagerCompatExport.java
New File
 
src/test/org/apache/sqoop/manager/SQLServerDatatypeExportDelimitedFileManualTest.java
New File
 
src/test/org/apache/sqoop/manager/SQLServerDatatypeExportSequenceFileManualTest.java
New File
 
src/test/org/apache/sqoop/manager/SQLServerDatatypeImportDelimitedFileManualTest.java
New File
 
src/test/org/apache/sqoop/manager/SQLServerDatatypeImportSequenceFileManualTest.java
New File
 
src/test/org/apache/sqoop/manager/SQLServerHiveImportManualTest.java
New File
 
src/test/org/apache/sqoop/manager/SQLServerManagerManualTest.java
New File
 
src/test/org/apache/sqoop/manager/SQLServerMultiColsManualTest.java
New File
 
src/test/org/apache/sqoop/manager/SQLServerMultiMapsManualTest.java
New File
 
src/test/org/apache/sqoop/manager/SQLServerParseMethodsManualTest.java
New File
 
src/test/org/apache/sqoop/manager/SQLServerQueryManualTest.java
New File
 
src/test/org/apache/sqoop/manager/SQLServerSplitByManualTest.java
New File
 
src/test/org/apache/sqoop/manager/SQLServerWhereManualTest.java
New File
 
testdata/DatatypeTestData-export-lite.txt
New File
 
testdata/DatatypeTestData-import-lite.txt
New File
 
  1. conf/MSTest.properties: Loading...
  2. src/test/com/cloudera/sqoop/hive/TestHiveImport.java: Loading...
  3. src/test/com/cloudera/sqoop/manager/SQLServerManagerImportManualTest.java: Loading...
  4. src/test/org/apache/sqoop/manager/MSSQLTestData.java: Loading...
  5. src/test/org/apache/sqoop/manager/MSSQLTestDataFileParser.java: Loading...
  6. src/test/org/apache/sqoop/manager/MSSQLTestUtils.java: Loading...
  7. src/test/org/apache/sqoop/manager/ManagerCompatExport.java: Loading...
  8. src/test/org/apache/sqoop/manager/SQLServerDatatypeExportDelimitedFileManualTest.java: Loading...
  9. src/test/org/apache/sqoop/manager/SQLServerDatatypeExportSequenceFileManualTest.java: Loading...
  10. src/test/org/apache/sqoop/manager/SQLServerDatatypeImportDelimitedFileManualTest.java: Loading...
  11. src/test/org/apache/sqoop/manager/SQLServerDatatypeImportSequenceFileManualTest.java: Loading...
  12. src/test/org/apache/sqoop/manager/SQLServerHiveImportManualTest.java: Loading...
  13. src/test/org/apache/sqoop/manager/SQLServerManagerManualTest.java: Loading...
  14. src/test/org/apache/sqoop/manager/SQLServerMultiColsManualTest.java: Loading...
  15. src/test/org/apache/sqoop/manager/SQLServerMultiMapsManualTest.java: Loading...
  16. src/test/org/apache/sqoop/manager/SQLServerParseMethodsManualTest.java: Loading...
  17. src/test/org/apache/sqoop/manager/SQLServerQueryManualTest.java: Loading...
  18. src/test/org/apache/sqoop/manager/SQLServerSplitByManualTest.java: Loading...
  19. src/test/org/apache/sqoop/manager/SQLServerWhereManualTest.java: Loading...
  20. testdata/DatatypeTestData-export-lite.txt: Loading...
  21. testdata/DatatypeTestData-import-lite.txt: Loading...