* @param args\r
*/\r
public static void main(String[] args) {\r
- System.out.println("Start import from BerlinModel ...");\r
- Source source = berlinModelSource;\r
+ System.out.println("Start import from BerlinModel ("+ berlinModelSource.getDatabase() + ") ...");\r
CdmApplicationController cdmApp;\r
\r
//make CdmApplication\r
// dataSourceName = "testSqlServer"; \r
\r
//make BerlinModel Source\r
- source = BerlinModelSources.euroMed();\r
+ Source source = berlinModelSource;\r
if (source == null){\r
logger.error("Connection to BerlinModel could not be established");\r
System.out.println("End import from BerlinModel ...");\r
BerlinModelImport bmImport = new BerlinModelImport();\r
bmImport.doImport(source, cdmApp);\r
}\r
- System.out.println("End import from BerlinModel ...");\r
+ System.out.println("End import from BerlinModel ("+ berlinModelSource.getDatabase() + ")...");\r
}\r
\r
\r
" FROM Reference AS InInReference " +\r
" RIGHT OUTER JOIN Reference AS InReference ON InInReference.RefId = InReference.InRefFk " + \r
" RIGHT OUTER JOIN Reference ON InReference.RefId = dbo.Reference.InRefFk " + \r
- " WHERE (1=1) AND Reference.refId = 7000000 " ;\r
+ " WHERE (1=1) "; \r
+ //strQueryBase += " AND Reference.refId = 7000000 " ;\r
String strQueryNoInRef = strQueryBase + \r
" AND (Reference.InRefFk is NULL) ";\r
\r
\r
//get data from database\r
String strQuery = \r
- "SELECT TOP 20002 Name.* , RefDetail.RefDetailId, RefDetail.RefFk, " +\r
+ "SELECT Name.* , RefDetail.RefDetailId, RefDetail.RefFk, " +\r
" RefDetail.FullRefCache, RefDetail.FullNomRefCache, RefDetail.PreliminaryFlag AS RefDetailPrelim, RefDetail.Details, " + \r
" RefDetail.SecondarySources, RefDetail.IdInSource " +\r
" FROM Name LEFT OUTER JOIN RefDetail ON Name.NomRefDetailFk = RefDetail.RefDetailId AND Name.NomRefDetailFk = RefDetail.RefDetailId AND " +\r
}\r
\r
public static Source editWP6(){\r
- // BerlinModel - Euro+Med\r
+ // BerlinModel - EditWp6\r
String dbms = "SQLServer";\r
String strServer = "BGBM111";\r
String strDB = "EditWP6";\r
return this;\r
}\r
\r
+ public String getDatabase(){\r
+ return mDb;\r
+ }\r
+ \r
+ public String getServer(){\r
+ return mServer;\r
+ }\r
+ \r
\r
}
\ No newline at end of file