Sourcecode in Global/objectFunctions.js:
1: function writeAccessLog() {
2: if (app.data.accessLog.size() == 0)
3: return;
4: // first of all swap app.data.accessLog
5: var size = app.data.accessLog.size();
6: var log = app.data.accessLog;
7: app.data.accessLog = new java.util.Vector(size);
8: // open database-connection
9: var c = getDBConnection("antville");
10: var dbError = c.getLastError();
11: if (dbError) {
12: app.log("Error establishing DB connection: " + dbError);
13: return;
14: }
15: // loop over log-vector
16: var query;
17: for (var i=0;i<log.size();i++) {
18: var logObj = log.get(i);
19: query = "insert into AV_ACCESSLOG (ACCESSLOG_F_SITE,ACCESSLOG_F_TEXT," +
20: "ACCESSLOG_REFERRER,ACCESSLOG_IP,ACCESSLOG_BROWSER) values (" +
21: logObj.siteID + "," + logObj.storyID + ",'" + logObj.referrer + "','" + logObj.remoteHost +
22: "','" + logObj.browser + "')";
23: c.executeCommand(query);
24: if (dbError) {
25: app.log("Error executing SQL query: " + dbError);
26: return;
27: }
28: }
29: app.log("wrote " + i + " referrers into database");
30: return;
31: }
|