-
Notifications
You must be signed in to change notification settings - Fork 0
/
define.rb
151 lines (138 loc) · 20.4 KB
/
define.rb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
require 'json'
load 'database.rb'
class Defines
attr_accessor :tables, :siteFile, :beaconDBTable, :options, :groupDir, :plotScripts, :plotDir, :resultsDB, :traceFile,
:adsDir, :beaconDB, :userDir, :dirs, :files, :dataDir, :tmln_path, :resourceFiles
def initialize(filename)
@beaconDBTable="beaconURLs"
@beaconDB="beaconsDB.db"
@column_Format={"2monthSorted_trace"=>1,"10k_trace"=>1 ,
"2m_trace"=>1,
"soun1k_trace"=>2,"souneilSorted_trace"=>2,"100k_trace"=>3,"month_201501_10days_filtered_ES_sorted_uniq"=>3,
"month_201501_20days_filtered_ES_sorted_uniq"=>3,"month_201501_30days_filtered_ES_sorted_uniq"=>3,"month_201502_10days_filtered_ES_sorted_uniq"=>3,
"month_201502_20days_filtered_ES_sorted_uniq"=>3,"month_201502_30days_filtered_ES_sorted_uniq"=>3,"month_201503_10days_filtered_ES_sorted_uniq"=>3,
"month_201503_20days_filtered_ES_sorted_uniq"=>3,"month_201503_30days_filtered_ES_sorted_uniq"=>3,"month_201504_10days_filtered_ES_sorted_uniq"=>3,
"month_201504_20days_filtered_ES_sorted_uniq"=>3,"month_201504_30days_filtered_ES_sorted_uniq"=>3,"month_201505_10days_filtered_ES_sorted_uniq"=>3,
"month_201505_20days_filtered_ES_sorted_uniq"=>3,"month_201505_30days_filtered_ES_sorted_uniq"=>3,"month_201506_10days_filtered_ES_sorted_uniq"=>3,
"month_201506_20days_filtered_ES_sorted_uniq"=>3,"month_201506_30days_filtered_ES_sorted_uniq"=>3,"month_201507_10days_filtered_ES_sorted_uniq"=>3,
"month_201507_20days_filtered_ES_sorted_uniq"=>3,"month_201507_30days_filtered_ES_sorted_uniq"=>3,"month_201508_10days_filtered_ES_sorted_uniq"=>3,
"month_201508_20days_filtered_ES_sorted_uniq"=>3,"month_201508_30days_filtered_ES_sorted_uniq"=>3,"month_201509_10days_filtered_ES_sorted_uniq"=>3,
"month_201509_20days_filtered_ES_sorted_uniq"=>3,"month_201509_30days_filtered_ES_sorted_uniq"=>3,"month_201510_10days_filtered_ES_sorted_uniq"=>3,
"month_201510_20days_filtered_ES_sorted_uniq"=>3,"month_201510_30days_filtered_ES_sorted_uniq"=>3,"month_201511_10days_filtered_ES_sorted_uniq"=>3,
"month_201511_20days_filtered_ES_sorted_uniq"=>3,"month_201511_30days_filtered_ES_sorted_uniq"=>3,"month_201512_10days_filtered_ES_sorted_uniq"=>3,
"month_201512_20days_filtered_ES_sorted_uniq"=>3,"month_201512_30days_filtered_ES_sorted_uniq"=>3}
filenames=["devices.csv","sizes3rd.csv","adParamsNum.csv","restParamsNum.csv","cmIDcount.csv","cmHosts.csv"]
@traceFile=filename
# system("rm -f BEACONS_"+@traceFile)
traceName=""
@siteFile="./sites.csv"
@resources="resources/"
@resourceFiles={"filterFile"=>@resources+"disconnect_merged.json","interestsFile"=>@resources+"interestBitmaps.json",
"geoCity"=>@resources+"GeoLite2-City.mmdb","geoCountry"=>@resources+"GeoLite2-Country.mmdb",
"adCompanies"=>@resources+"adCompanies.csv","uaMap"=>@resources+"useragents.csv"}
if @traceFile!=nil and File.exist?(@traceFile)
if @traceFile.include? "/"
[email protected]("/")
traceName=s[s.size-2]+"_"+s.last
else
traceName=@traceFile
end
puts "InputFile: "+traceName
# DATABASE
@resultsDB=traceName+"_analysis.db"
#DIRECTORIES
@dataDir="dataset/"
@adsDir="adRelated/"
@userDir="users/"
@plotDir="plots/"
@tmln_path="timelines/"
@dirs=Hash.new
@groupDir="grouppedRes/"
if @traceFile.include? "/"
Dir.mkdir groupDir unless File.exists?(groupDir)
@dirs["rootDir"]=groupDir+"results_"+traceName+"/"
else
@dirs["rootDir"]="results_"+traceName+"/"
end
@dirs["dataDir"]=@dirs["rootDir"]+@dataDir
@dirs["adsDir"]=@dirs["rootDir"]+@adsDir
@dirs["userDir"]=@dirs["rootDir"]+@userDir
@dirs["timelines"]=@dirs["userDir"]+@tmln_path
@dirs["plotDir"]=nil
#Utilities.error "Input file <"+filename.to_s+"> could not be found!"
#FILENAMES
@files={
"devices"=>@dirs["adsDir"]+filenames[0],
"size3rdFile"=>@dirs["adsDir"]+filenames[1],
"adParamsNum"=>@dirs["adsDir"]+filenames[2],
"restParamsNum"=>@dirs["adsDir"]+filenames[3],
"cmIDcount"=>@dirs["adsDir"]+filenames[4],
"cmHost"=>@dirs["adsDir"]+filenames[5]}
#GNUPLOT SCRIPTS
@plotScriptsDir="plotScripts/"
@plotScripts={
"cdf"=>@plotScriptsDir+"plotCDF.gn",
"bars"=>@plotScriptsDir+"plotBars.gn",
"zoomed"=>@plotScriptsDir+"plotZoomed.gn",
"linespoints"=>@plotScriptsDir+"plotLinesPoints.gn",
"stacked_area"=>@plotScriptsDir+"plotStacked_area.gn"}
else
Utilities.warning "Cannot find "+@traceFile if @traceFile!=nil
end
#DATABASES
@tables={"publishersTable"=>{"publishers"=>'timestamp BIGINT, IP_Port VARCHAR, url VARCHAR , Host VARCHAR, mobile VARCHAR, deviceBrand VARCHAR,deviceModel VARCHAR,osFamily VARCHAR,osName VARCHAR,uaType VARCHAR,uaFamily VARCHAR,uaName VARCHAR,uaCategory VARCHAR, browser INTEGER,id VARCHAR PRIMARY KEY'},
"impTable"=>{"impressions"=>'id VARCHAR PRIMARY KEY,timestamp BIGINT, IP_Port VARCHAR, UserIP VARCHAR, url VARCHAR, Host VARCHAR, userAgent VARCHAR, status INTEGER, length INTEGER, dataSize INTEGER, duration INTEGER'},
"bcnTable"=>{"beacons"=>'timestamp BIGINT, ip_port VARCHAR, url VARCHAR, beaconType VARCHAR, mob INTEGER,device VARCHAR,browser VARCHAR, id VARCHAR PRIMARY KEY'},
"advertiserTable"=>{"advertisers"=>'host VARCHAR PRIMARY KEY, numOfReqs BIGINT, numOfUsers BIGINT, avgReqPerUser INTEGER, avgDurOfReqs VARCHAR, totalDurOfReqs VARCHAR, avgSizeOfReqs VARCHAR,totalBytesDelivered BIGINT, type VARCHAR'},
"adsTable"=>{"advertisements"=>'timestamp BIGINT, receiverType VARCHAR,ip_Port VARCHAR, url VARCHAR, dataSize INTEGER, duration INTEGER,mob INTEGER,device VARCHAR,browser VARCHAR, id VARCHAR PRIMARY KEY'},
"userTable"=>{"userResults"=>'id VARCHAR PRIMARY KEY, totalRows BIGINT, advertising INTEGER, analytics INTEGER, social INTEGER, third_party_content INTEGER, other INTEGER, avgDurationPerCategory VARCHAR, totalSizePerCategory VARCHAR, totalBytes BIGINT, avgBytesPerReq VARCHAR, sumDuration BIGINT, avgDurationOfReq VARCHAR, hashedPrices INTEGER, numericPrices INTEGER, impressions INTEGER, publishersVisited INTEGER, beacons INTEGER, numOfCookieSyncs INTEGER, numOfLocations INTEGER, uniqLocations VARCHAR, sumDurationPerCat VARCHAR'},
"webUserTable"=>{"userResults_web"=>'id VARCHAR PRIMARY KEY, totalRows BIGINT, advertising INTEGER, analytics INTEGER, social INTEGER, third_party_content INTEGER, other INTEGER, avgDurationPerCategory VARCHAR, totalSizePerCategory VARCHAR, totalBytes BIGINT, avgBytesPerReq VARCHAR, sumDuration BIGINT, avgDurationOfReq VARCHAR, hashedPrices INTEGER, numericPrices INTEGER, impressions INTEGER, publishersVisited INTEGER, beacons INTEGER, numOfCookieSyncs INTEGER, numOfLocations INTEGER, uniqLocations VARCHAR, sumDurationPerCat VARCHAR'},
"appUserTable"=>{"userResults_app"=>'id VARCHAR PRIMARY KEY, totalRows BIGINT, advertising INTEGER, analytics INTEGER, social INTEGER, third_party_content INTEGER, other INTEGER, avgDurationPerCategory VARCHAR, totalSizePerCategory VARCHAR, totalBytes BIGINT, avgBytesPerReq VARCHAR, sumDuration BIGINT, avgDurationOfReq VARCHAR, hashedPrices INTEGER, numericPrices INTEGER, impressions INTEGER, publishersVisited INTEGER, beacons INTEGER, numOfCookieSyncs INTEGER, numOfLocations INTEGER, uniqLocations VARCHAR, sumDurationPerCat VARCHAR'},
"userFilesTable"=>{"userFiletypes"=>'id VARCHAR PRIMARY KEY, Reqs_Advertising_data INTEGER, Reqs_Advertising_gif INTEGER, Reqs_Advertising_html INTEGER, Reqs_Advertising_image INTEGER, Reqs_Advertising_other INTEGER, Reqs_Advertising_script INTEGER, Reqs_Advertising_styling INTEGER, Reqs_Advertising_text INTEGER, Reqs_Advertising_video INTEGER, Reqs_Analytics_data INTEGER, Reqs_Analytics_gif INTEGER, Reqs_Analytics_html INTEGER, Reqs_Analytics_image INTEGER, Reqs_Analytics_other INTEGER, Reqs_Analytics_script INTEGER, Reqs_Analytics_styling INTEGER, Reqs_Analytics_text INTEGER, Reqs_Analytics_video INTEGER, Reqs_Social_data INTEGER, Reqs_Social_gif INTEGER, Reqs_Social_html INTEGER, Reqs_Social_image INTEGER, Reqs_Social_other INTEGER, Reqs_Social_script INTEGER, Reqs_Social_styling INTEGER, Reqs_Social_text INTEGER, Reqs_Social_video INTEGER, Reqs3rd_party_Content_data INTEGER, Reqs3rd_party_Content_gif INTEGER, Reqs3rd_party_Content_html INTEGER, Reqs3rd_party_Content_image INTEGER, Reqs3rd_party_Content_other INTEGER, Reqs3rd_party_Content_script INTEGER, Reqs3rd_party_Content_styling INTEGER, Reqs3rd_party_Content_text INTEGER, Reqs3rd_party_Content_video INTEGER, ' +
#'Reqs_Beacons_data INTEGER, Reqs_Beacons_gif INTEGER, Reqs_Beacons_html INTEGER, Reqs_Beacons_image INTEGER, Reqs_Beacons_other INTEGER, Reqs_Beacons_script INTEGER, Reqs_Beacons_styling INTEGER, Reqs_Beacons_text INTEGER, Reqs_Beacons_video INTEGER,' +
'Reqs_Other_data INTEGER, Reqs_Other_gif INTEGER, Reqs_Other_html INTEGER, Reqs_Other_image INTEGER, Reqs_Other_other INTEGER, Reqs_Other_script INTEGER, Reqs_Other_styling INTEGER, Reqs_Other_text INTEGER, Reqs_Other_video INTEGER, TotalBytes_Advertising_data INTEGER, TotalBytes_Advertising_gif INTEGER, TotalBytes_Advertising_html INTEGER, TotalBytes_Advertising_image INTEGER, TotalBytes_Advertising_other INTEGER, TotalBytes_Advertising_script INTEGER, TotalBytes_Advertising_styling INTEGER, TotalBytes_Advertising_text INTEGER, TotalBytes_Advertising_video INTEGER, TotalBytes_Analytics_data INTEGER, TotalBytes_Analytics_gif INTEGER, TotalBytes_Analytics_html INTEGER, TotalBytes_Analytics_image INTEGER, TotalBytes_Analytics_other INTEGER, TotalBytes_Analytics_script INTEGER, TotalBytes_Analytics_styling INTEGER, TotalBytes_Analytics_text INTEGER, TotalBytes_Analytics_video INTEGER, TotalBytes_Social_data INTEGER, TotalBytes_Social_gif INTEGER, TotalBytes_Social_html INTEGER, TotalBytes_Social_image INTEGER, TotalBytes_Social_other INTEGER, TotalBytes_Social_script INTEGER, TotalBytes_Social_styling INTEGER, TotalBytes_Social_text INTEGER, TotalBytes_Social_video INTEGER, TotalBytes3rd_party_Content_data INTEGER, TotalBytes3rd_party_Content_gif INTEGER, TotalBytes3rd_party_Content_html INTEGER, TotalBytes3rd_party_Content_image INTEGER, TotalBytes3rd_party_Content_other INTEGER, TotalBytes3rd_party_Content_script INTEGER, TotalBytes3rd_party_Content_styling INTEGER, TotalBytes3rd_party_Content_text INTEGER, TotalBytes3rd_party_Content_video INTEGER, ' +
#'TotalBytes_Beacons_data INTEGER, TotalBytes_Beacons_gif INTEGER, TotalBytes_Beacons_html INTEGER, TotalBytes_Beacons_image INTEGER, TotalBytes_Beacons_other INTEGER, TotalBytes_Beacons_script INTEGER, TotalBytes_Beacons_styling INTEGER, TotalBytes_Beacons_text INTEGER, TotalBytes_Beacons_video INTEGER, ' +
'TotalBytes_Other_data INTEGER, TotalBytes_Other_gif INTEGER, TotalBytes_Other_html INTEGER, TotalBytes_Other_image INTEGER, TotalBytes_Other_other INTEGER, TotalBytes_Other_script INTEGER, TotalBytes_Other_styling INTEGER, TotalBytes_Other_text INTEGER, TotalBytes_Other_video INTEGER'},
"webUserFilesTable"=>{"userFiletypes_web"=>'id VARCHAR PRIMARY KEY, Reqs_Advertising_data INTEGER, Reqs_Advertising_gif INTEGER, Reqs_Advertising_html INTEGER, Reqs_Advertising_image INTEGER, Reqs_Advertising_other INTEGER, Reqs_Advertising_script INTEGER, Reqs_Advertising_styling INTEGER, Reqs_Advertising_text INTEGER, Reqs_Advertising_video INTEGER, Reqs_Analytics_data INTEGER, Reqs_Analytics_gif INTEGER, Reqs_Analytics_html INTEGER, Reqs_Analytics_image INTEGER, Reqs_Analytics_other INTEGER, Reqs_Analytics_script INTEGER, Reqs_Analytics_styling INTEGER, Reqs_Analytics_text INTEGER, Reqs_Analytics_video INTEGER, Reqs_Social_data INTEGER, Reqs_Social_gif INTEGER, Reqs_Social_html INTEGER, Reqs_Social_image INTEGER, Reqs_Social_other INTEGER, Reqs_Social_script INTEGER, Reqs_Social_styling INTEGER, Reqs_Social_text INTEGER, Reqs_Social_video INTEGER, Reqs3rd_party_Content_data INTEGER, Reqs3rd_party_Content_gif INTEGER, Reqs3rd_party_Content_html INTEGER, Reqs3rd_party_Content_image INTEGER, Reqs3rd_party_Content_other INTEGER, Reqs3rd_party_Content_script INTEGER, Reqs3rd_party_Content_styling INTEGER, Reqs3rd_party_Content_text INTEGER, Reqs3rd_party_Content_video INTEGER, ' +
#'Reqs_Beacons_data INTEGER, Reqs_Beacons_gif INTEGER, Reqs_Beacons_html INTEGER, Reqs_Beacons_image INTEGER, Reqs_Beacons_other INTEGER, Reqs_Beacons_script INTEGER, Reqs_Beacons_styling INTEGER, Reqs_Beacons_text INTEGER, Reqs_Beacons_video INTEGER,' +
'Reqs_Other_data INTEGER, Reqs_Other_gif INTEGER, Reqs_Other_html INTEGER, Reqs_Other_image INTEGER, Reqs_Other_other INTEGER, Reqs_Other_script INTEGER, Reqs_Other_styling INTEGER, Reqs_Other_text INTEGER, Reqs_Other_video INTEGER, TotalBytes_Advertising_data INTEGER, TotalBytes_Advertising_gif INTEGER, TotalBytes_Advertising_html INTEGER, TotalBytes_Advertising_image INTEGER, TotalBytes_Advertising_other INTEGER, TotalBytes_Advertising_script INTEGER, TotalBytes_Advertising_styling INTEGER, TotalBytes_Advertising_text INTEGER, TotalBytes_Advertising_video INTEGER, TotalBytes_Analytics_data INTEGER, TotalBytes_Analytics_gif INTEGER, TotalBytes_Analytics_html INTEGER, TotalBytes_Analytics_image INTEGER, TotalBytes_Analytics_other INTEGER, TotalBytes_Analytics_script INTEGER, TotalBytes_Analytics_styling INTEGER, TotalBytes_Analytics_text INTEGER, TotalBytes_Analytics_video INTEGER, TotalBytes_Social_data INTEGER, TotalBytes_Social_gif INTEGER, TotalBytes_Social_html INTEGER, TotalBytes_Social_image INTEGER, TotalBytes_Social_other INTEGER, TotalBytes_Social_script INTEGER, TotalBytes_Social_styling INTEGER, TotalBytes_Social_text INTEGER, TotalBytes_Social_video INTEGER, TotalBytes3rd_party_Content_data INTEGER, TotalBytes3rd_party_Content_gif INTEGER, TotalBytes3rd_party_Content_html INTEGER, TotalBytes3rd_party_Content_image INTEGER, TotalBytes3rd_party_Content_other INTEGER, TotalBytes3rd_party_Content_script INTEGER, TotalBytes3rd_party_Content_styling INTEGER, TotalBytes3rd_party_Content_text INTEGER, TotalBytes3rd_party_Content_video INTEGER, ' +
#'TotalBytes_Beacons_data INTEGER, TotalBytes_Beacons_gif INTEGER, TotalBytes_Beacons_html INTEGER, TotalBytes_Beacons_image INTEGER, TotalBytes_Beacons_other INTEGER, TotalBytes_Beacons_script INTEGER, TotalBytes_Beacons_styling INTEGER, TotalBytes_Beacons_text INTEGER, TotalBytes_Beacons_video INTEGER, ' +
'TotalBytes_Other_data INTEGER, TotalBytes_Other_gif INTEGER, TotalBytes_Other_html INTEGER, TotalBytes_Other_image INTEGER, TotalBytes_Other_other INTEGER, TotalBytes_Other_script INTEGER, TotalBytes_Other_styling INTEGER, TotalBytes_Other_text INTEGER, TotalBytes_Other_video INTEGER'},
"appUserFilesTable"=>{"userFiletypes_app"=>'id VARCHAR PRIMARY KEY, Reqs_Advertising_data INTEGER, Reqs_Advertising_gif INTEGER, Reqs_Advertising_html INTEGER, Reqs_Advertising_image INTEGER, Reqs_Advertising_other INTEGER, Reqs_Advertising_script INTEGER, Reqs_Advertising_styling INTEGER, Reqs_Advertising_text INTEGER, Reqs_Advertising_video INTEGER, Reqs_Analytics_data INTEGER, Reqs_Analytics_gif INTEGER, Reqs_Analytics_html INTEGER, Reqs_Analytics_image INTEGER, Reqs_Analytics_other INTEGER, Reqs_Analytics_script INTEGER, Reqs_Analytics_styling INTEGER, Reqs_Analytics_text INTEGER, Reqs_Analytics_video INTEGER, Reqs_Social_data INTEGER, Reqs_Social_gif INTEGER, Reqs_Social_html INTEGER, Reqs_Social_image INTEGER, Reqs_Social_other INTEGER, Reqs_Social_script INTEGER, Reqs_Social_styling INTEGER, Reqs_Social_text INTEGER, Reqs_Social_video INTEGER, Reqs3rd_party_Content_data INTEGER, Reqs3rd_party_Content_gif INTEGER, Reqs3rd_party_Content_html INTEGER, Reqs3rd_party_Content_image INTEGER, Reqs3rd_party_Content_other INTEGER, Reqs3rd_party_Content_script INTEGER, Reqs3rd_party_Content_styling INTEGER, Reqs3rd_party_Content_text INTEGER, Reqs3rd_party_Content_video INTEGER, ' +
#'Reqs_Beacons_data INTEGER, Reqs_Beacons_gif INTEGER, Reqs_Beacons_html INTEGER, Reqs_Beacons_image INTEGER, Reqs_Beacons_other INTEGER, Reqs_Beacons_script INTEGER, Reqs_Beacons_styling INTEGER, Reqs_Beacons_text INTEGER, Reqs_Beacons_video INTEGER,' +
'Reqs_Other_data INTEGER, Reqs_Other_gif INTEGER, Reqs_Other_html INTEGER, Reqs_Other_image INTEGER, Reqs_Other_other INTEGER, Reqs_Other_script INTEGER, Reqs_Other_styling INTEGER, Reqs_Other_text INTEGER, Reqs_Other_video INTEGER, TotalBytes_Advertising_data INTEGER, TotalBytes_Advertising_gif INTEGER, TotalBytes_Advertising_html INTEGER, TotalBytes_Advertising_image INTEGER, TotalBytes_Advertising_other INTEGER, TotalBytes_Advertising_script INTEGER, TotalBytes_Advertising_styling INTEGER, TotalBytes_Advertising_text INTEGER, TotalBytes_Advertising_video INTEGER, TotalBytes_Analytics_data INTEGER, TotalBytes_Analytics_gif INTEGER, TotalBytes_Analytics_html INTEGER, TotalBytes_Analytics_image INTEGER, TotalBytes_Analytics_other INTEGER, TotalBytes_Analytics_script INTEGER, TotalBytes_Analytics_styling INTEGER, TotalBytes_Analytics_text INTEGER, TotalBytes_Analytics_video INTEGER, TotalBytes_Social_data INTEGER, TotalBytes_Social_gif INTEGER, TotalBytes_Social_html INTEGER, TotalBytes_Social_image INTEGER, TotalBytes_Social_other INTEGER, TotalBytes_Social_script INTEGER, TotalBytes_Social_styling INTEGER, TotalBytes_Social_text INTEGER, TotalBytes_Social_video INTEGER, TotalBytes3rd_party_Content_data INTEGER, TotalBytes3rd_party_Content_gif INTEGER, TotalBytes3rd_party_Content_html INTEGER, TotalBytes3rd_party_Content_image INTEGER, TotalBytes3rd_party_Content_other INTEGER, TotalBytes3rd_party_Content_script INTEGER, TotalBytes3rd_party_Content_styling INTEGER, TotalBytes3rd_party_Content_text INTEGER, TotalBytes3rd_party_Content_video INTEGER, ' +
#'TotalBytes_Beacons_data INTEGER, TotalBytes_Beacons_gif INTEGER, TotalBytes_Beacons_html INTEGER, TotalBytes_Beacons_image INTEGER, TotalBytes_Beacons_other INTEGER, TotalBytes_Beacons_script INTEGER, TotalBytes_Beacons_styling INTEGER, TotalBytes_Beacons_text INTEGER, TotalBytes_Beacons_video INTEGER, ' +
'TotalBytes_Other_data INTEGER, TotalBytes_Other_gif INTEGER, TotalBytes_Other_html INTEGER, TotalBytes_Other_image INTEGER, TotalBytes_Other_other INTEGER, TotalBytes_Other_script INTEGER, TotalBytes_Other_styling INTEGER, TotalBytes_Other_text INTEGER, TotalBytes_Other_video INTEGER'},
"priceTable"=>{"prices"=> 'type VARCHAR, timestamp BIGINT, host VARCHAR, priceTag VARCHAR, priceValue VARCHAR, bytes INTEGER, upToKnowCM INTEGER, numOfParams INTEGER, adSize VARCHAR,carrier VARCHAR, adPosition VARCHAR, userLocation VARCHAR, TOD VARCHAR, day INTEGER, publisher VARCHAR, interest VARCHAR, pubPopularity INTEGER, userId VARCHAR, associatedSSP VARCHAR, associatedDSP VARCHAR,typeOfDSP VARCHAR, associatedADX VARCHAR, mob VARCHAR, device VARCHAR, browser VARCHAR, HTTPS VARCHAR,url VARCHAR, id VARCHAR PRIMARY KEY'},
"traceTable"=>{"traceResults"=>'totalRows BIGINT, users INTEGER, advertising INTEGER, analytics INTEGER, social INTEGER, third_party_content INTEGER, beacons INTEGER, other INTEGER, thirdPartySize_total INTEGER, totalMobileReqs INTEGER, browserReqs INTEGER, hashedPrices INTEGER, numericPrices INTEGER, numImpressions INTEGER,id VARCHAR PRIMARY KEY'},
"csyncTable"=>{"csyncResults"=>'user VARCHAR, hostPrev VARCHAR,prevCat VARCHAR, hostCur VARCHAR,curCat VARCHAR, paramNamePrev VARCHAR, syncedID VARCHAR, paramNameCur VARCHAR, possibleNumberOfIDs INTEGER, allParamsPrev VARCHAR, allParamsCur VARCHAR,urlPrev VARCHAR,urlCur VARCHAR, prevPiggybacked VARCHAR, curPiggybacked VARCHAR, prevStatus INTEGER, curStatus INTEGER, prevHttpRef VARCHAR, curHttpRef VARCHAR,dev VARCHAR, prevBrowser VARCHAR, curBrowser VARCHAR, prevUA VARCHAR, curUA VARCHAR,prevTimestamp BIGINT,curTimestamp BIGINT,id VARCHAR PRIMARY KEY'},
"visitsTable"=>{"userVisits"=> 'userID VARCHAR PRIMARY KEY, totalVisits INTEGER,visits VARCHAR, interests VARCHAR'},
"webTraceTable"=>{"traceResults_web"=>'totalRows BIGINT, users INTEGER, advertising INTEGER, analytics INTEGER, social INTEGER, third_party_content INTEGER, beacons INTEGER, other INTEGER, thirdPartySize_total INTEGER, totalMobileReqs INTEGER, browserReqs INTEGER, hashedPrices INTEGER, numericPrices INTEGER, numImpressions INTEGER,id VARCHAR PRIMARY KEY'},
"appTraceTable"=>{"traceResults_app"=>'totalRows BIGINT, users INTEGER, advertising INTEGER, analytics INTEGER, social INTEGER, third_party_content INTEGER, beacons INTEGER, other INTEGER, thirdPartySize_total INTEGER, totalMobileReqs INTEGER, browserReqs INTEGER, hashedPrices INTEGER, numericPrices INTEGER, numImpressions INTEGER,id VARCHAR PRIMARY KEY'},
}
#LOAD OPTIONS
configFile="config"
@options,str=Utilities.loadOptions(configFile,filenames,@tables)
#OUTPUT
if @options["printToSTDOUT?"]
@fw=STDOUT
else
@fw=nil
end
puts str
end
def puts(str)
print str+"\n"
end
def print (str)
if @fw!=nil
@fw.print str
end
end
def close
@fw.close
end
def column_Format()
return @column_Format[@traceFile]
end
end