/**
* Create a new site entry with no faulty values. Site object will be created step by step by
* calling the appropriate methods.
*/
private static void runTest_Stepped() {
Number newSiteId = -1;
Testing.so("All legal site creation in single steps", Format.HEADER);
Testing.so("These tests should run without any errors.", Format.HEADERSUB);
Testing.so("Creating a new Site object", Format.STEP);
try {
SiteTest.site = new Site();
} catch (Exception e) {
Testing.err(e);
}
// run tests
SiteTest.testLanguage();
SiteTest.testCountryCode();
SiteTest.testURL();
SiteTest.testCategory();
SiteTest.testRootFile();
SiteTest.testTitle();
SiteTest.testTimestamp();
SiteTest.testStorage();
Testing.so("Writing data..", Format.STEPFINAL);
try {
newSiteId = SiteTest.site.write();
} catch (Exception e) {
Testing.err(e);
}
Testing.so("All legal site creation in single steps: final check", Format.HEADER);
SiteTest.checkTest(newSiteId);
}
private static void testRootFile() {
String file = SiteTest.getARootFileName();
Testing.so("Setting root-file: " + file, Format.STEP);
try {
SiteTest.site.setRootFile(file);
SiteTest.properties.put("rootfile", file);
} catch (Exception e) {
Testing.err(e);
}
}
private static void testTitle() {
String title = SiteTest.getATitle();
Testing.so("Setting title: " + title, Format.STEP);
try {
SiteTest.site.setTitle(title);
SiteTest.properties.put("title", title);
} catch (Exception e) {
Testing.err(e);
}
}
private static void testTimestamp() {
Timestamp ts = new Timestamp(Calendar.getInstance().getTime().getTime());
Testing.so("Setting timestamp: " + ts.toString(), Format.STEP);
try {
SiteTest.site.setTimestamp(ts);
SiteTest.properties.put("timestamp", ts.toString());
} catch (Exception e) {
Testing.err(e);
}
}
private static void testURL() {
try {
URL url = SiteTest.getAURL();
Testing.so("Setting URL: " + url.toString(), Format.STEP);
SiteTest.site.setURL(url);
SiteTest.properties.put("url", url.toString());
} catch (Exception e) {
Testing.err(e);
}
}
private static void testLanguage() {
Testing.so("Getting languages..", Format.STEP);
// get test data
List<String> languagesAll = null;
List<String> languagesUsed = null;
try {
Language lang = new Language(SiteTest.db);
languagesAll = lang.getAllEntries("name_de", false);
languagesAll.addAll(lang.getAllEntries("name_en", false));
languagesUsed = lang.getAllEntries("lang_code", true);
Testing.so(
String.format("%d of %d currently used", languagesUsed.size(), (languagesAll.size() / 2)),
Format.STEPSUB);
} catch (Exception e) {
Testing.err(e);
}
// test assignment
Testing.so("Assigning languages", Format.STEP);
Testing.so("This test only assigning the value. Site won't be saved.", Format.STEPINFO);
for (int i = 0; i < languagesAll.size(); i++) {
Testing.so("Try assigning language '" + languagesAll.get(i) + "'", Format.STEPSUB);
try {
SiteTest.site.setLanguageCodeByName(languagesAll.get(i));
} catch (Exception e) {
Testing.err(e);
}
}
// test setting
try {
String langCode = languagesAll.get(Testing.randomInt(languagesAll.size()));
Testing.so("Setting language for this site to (random): '" + langCode + "'", Format.STEP);
SiteTest.site.setLanguageCodeByName(langCode);
SiteTest.properties.put("languagecode", langCode);
} catch (Exception e) {
Testing.err(e);
}
}
private static void testCountryCode() {
Testing.so("Getting country-codes..", Format.STEP);
// get test data
List<String> ccodesAll = null;
List<String> ccodesUsed = null;
try {
Country country = new Country(SiteTest.db);
ccodesAll = country.getAllEntries("name_de", false);
ccodesAll.addAll(country.getAllEntries("name_en", false));
ccodesUsed = country.getAllEntries("country_code", true);
Testing.so(
String.format("%d of %d currently used", ccodesUsed.size(), ccodesAll.size()),
Format.STEPSUB);
} catch (Exception e) {
Testing.err(e);
}
// test assignment
Testing.so("Assigning country-codes", Format.STEP);
Testing.so("This test only assigning the value. Site won't be saved.", Format.STEPINFO);
for (int i = 0; i < ccodesAll.size(); i++) {
Testing.so("Try assigning country-code '" + ccodesAll.get(i) + "'", Format.STEPSUB);
try {
SiteTest.site.setCountryCodeByName(ccodesAll.get(i));
} catch (Exception e) {
Testing.err(e);
}
}
// test setting
try {
String cCode = ccodesAll.get(Testing.randomInt(ccodesAll.size()));
Testing.so("Setting country-code for this site to (random): '" + cCode + "'", Format.STEP);
SiteTest.site.setCountryCodeByName(cCode);
SiteTest.properties.put("countrycode", cCode);
} catch (Exception e) {
Testing.err(e);
}
}
private static void testCategory() {
MultilanguageContent mCategory = SiteTest.getACategoryMultiName();
MultilanguageContent mSubCategory = SiteTest.getACategoryMultiName();
MultilanguageContent mSubSubCategory = SiteTest.getACategoryMultiName();
Testing.so("Setting category: " + mCategory, Format.STEP);
try {
SiteTest.site.setCategory(mCategory, mSubCategory, mSubSubCategory);
SiteTest.properties.put("category", mCategory.toString());
SiteTest.properties.put("subcategory", mSubCategory.toString());
SiteTest.properties.put("subsubcategory", mSubSubCategory.toString());
} catch (Exception e) {
Testing.err(e);
}
}
/** @param args */
public static void main(String[] args) {
Testing.so("Initialize", Format.HEADER);
Testing.so("These tests should run without any errors.", Format.HEADERSUB);
Testing.so("Opening database", Format.STEP);
try {
SiteTest.db = gimmi.database.Database.getInstance();
} catch (Exception e) {
Testing.err(e);
}
// simple create test - multiple steps
SiteTest.runTest_Stepped();
// simple create test - one step
SiteTest.runTest_Single();
}
/**
* Create a new site entry with no faulty values. Site object will be created in one step with the
* appropriate constructor.
*
* @throws ConfigManagerException
* @throws SQLException
*/
private static void runTest_Single() {
Number newSiteId = -1;
// test one
Testing.so("All legal site creation in one step", Format.HEADER);
// gather data
try {
SiteTest.properties.put("url", SiteTest.getAURL());
SiteTest.properties.put("languagecode", SiteTest.getALanguageName());
SiteTest.properties.put("countrycode", SiteTest.getACountryName());
} catch (Exception e) {
Testing.err(e);
}
SiteTest.properties.put("rootfile", SiteTest.getARootFileName());
SiteTest.properties.put("title", SiteTest.getATitle());
SiteTest.properties.put("category", SiteTest.getACategoryName());
SiteTest.properties.put("subcategory", SiteTest.getACategoryName());
SiteTest.properties.put("subsubcategory", SiteTest.getACategoryName());
SiteTest.properties.put("storage", SiteTest.getAStoragePath());
// create site object
try {
Site site =
new Site( //
SiteTest.properties.get("url").toString(), //
SiteTest.properties.get("languagecode").toString(), //
SiteTest.properties.get("countrycode").toString(), //
SiteTest.properties.get("rootfile").toString(), //
// SiteTest.properties.get("title").toString(),//
SiteTest.properties.get("category").toString(), //
SiteTest.properties.get("subcategory").toString(), //
SiteTest.properties.get("subsubcategory").toString(), //
SiteTest.properties.get("storage").toString() //
);
newSiteId = site.getNewSiteId();
} catch (Exception e) {
Testing.err(e);
}
SiteTest.checkTest(newSiteId);
// test two
Testing.so("Bogous site creation in one step", Format.HEADER);
Testing.so(
"Country and Language shouldn't be resolvable and result in unknown or in an error, depending on the Site behaviour setting.",
Format.STEPINFO);
// just pass random junk
SiteTest.properties.put("countrycode", "scrambled");
SiteTest.properties.put("languagecode", "zizzlebizz");
// create site object
try {
Site site =
new Site( //
SiteTest.properties.get("url").toString(), //
SiteTest.properties.get("languagecode").toString(), //
SiteTest.properties.get("countrycode").toString(), //
SiteTest.properties.get("rootfile").toString(), //
// SiteTest.properties.get("title").toString(),//
SiteTest.properties.get("category").toString(), //
SiteTest.properties.get("subcategory").toString(), //
SiteTest.properties.get("subsubcategory").toString(), //
SiteTest.properties.get("storage").toString() //
);
newSiteId = site.getNewSiteId();
} catch (Exception e) {
Testing.err(e);
}
SiteTest.checkTest(newSiteId);
}
private static final boolean checkTest(Number siteId) {
final Map<String, Object> dbData = new HashMap<String, Object>();
System.out.println("Site id is " + siteId);
try {
gimmi.content.Site newSite = new gimmi.content.Site(SiteTest.db);
ResultSet newSiteRS = newSite.getTable().find("site_id", siteId.toString());
if (newSiteRS.next()) {
// simple types
dbData.put("timestamp", newSiteRS.getString("crawl_time"));
dbData.put("time", newSiteRS.getString("crawl_time"));
dbData.put("url", newSiteRS.getString("url_path"));
dbData.put("rootfile", newSiteRS.getString("root_file"));
dbData.put("title", newSiteRS.getString("title"));
dbData.put("storage", newSiteRS.getString("storage_path"));
// referenced types
Language language = new Language(SiteTest.db);
dbData.put(
"languagecode", language.getNameById("language_id", newSiteRS.getInt("language_id")));
Country country = new Country(SiteTest.db);
dbData.put(
"countrycode", country.getNameById("country_id", newSiteRS.getInt("country_id")));
// relation types
SiteHasCategory siteCategory = new SiteHasCategory(SiteTest.db);
ResultSet siteCategoryRS =
siteCategory
.getTable()
.joinWithCondition(
"category_id",
new Category(SiteTest.db).getTable(),
"category_id",
siteCategory.getTable().getName() + ".site_id='" + siteId + "'");
if (siteCategoryRS.next()) {
dbData.put("category", newSite.getCategoryNameById(siteId).toString());
}
}
} catch (Exception e) {
Testing.err(e);
}
for (String setting : SiteTest.properties.keySet()) {
String test = null;
if (setting == "url") {
try {
test =
(new URL(SiteTest.properties.get(setting).toString()).getPath())
.equals(dbData.get(setting))
? "ok"
: "fail?";
} catch (MalformedURLException e) {
Testing.err(e);
}
} else if (setting == "timestamp") {
// cut the hundreds - they aren't stored in the db
String ts1 = SiteTest.properties.get(setting).toString();
ts1 = ts1.substring(0, ts1.lastIndexOf("."));
String ts2 = SiteTest.properties.get(setting).toString();
ts2 = ts2.substring(0, ts2.lastIndexOf("."));
test = ts1.equals(ts2) ? "ok" : "fail?";
} else if (setting == "storage") {
String ts = SiteTest.properties.get(setting).toString();
// fix slashes like on add to db
if (!ts.startsWith("/")) {
ts = "/" + ts;
}
if (!ts.endsWith("/")) {
ts = ts + "/";
}
test = ts.equals(dbData.get(setting)) ? "ok" : "fail?";
} else {
test = SiteTest.properties.get(setting).equals(dbData.get(setting)) ? "ok" : "fail?";
}
System.out.printf(
"%-15s: set['%-45s'] get['%-45s'] = %s\n",
setting, SiteTest.properties.get(setting), dbData.get(setting), test);
}
return true;
}