Logo ROOT  
Reference Guide
 
Loading...
Searching...
No Matches
SQLiteIPLocation.C File Reference

Detailed Description

View in nbviewer Open in SWAN

This tutorial demonstrates how TSQLServer can be used to create a connection with a SQlite3 database. It accesses the Sqlite data base. Download from https://root.cern/download/root_download_stats.sqlite The world map is hold by a TH2Poly histogram which, after filling, will show the world wide dispersion of ROOT's users. To histogram filling, is done having as input parameters the two columns of the database: "IPLongitude' - for the longitude, and the "IPLatitude" - for the latitude. The data related to the latitude and the longitude has been provided from the log files storing the users IP. This product includes GeoLite2 data created by MaxMind, available from <a href="http://www.maxmind.com">http://www.maxmind.com.

#include <TSQLiteServer.h>
#include <TSQLiteResult.h>
#include <TSQLRow.h>
#include <TString.h>
#include <TH2F.h>
void SQLiteIPLocation() {
TSQLServer *db = TSQLServer::Connect("sqlite://root_download_stats.sqlite", "", "");
TFile *F = TFile::Open("http://root.cern.ch/files/WM.root");
TH2Poly *WM;
WM = (TH2Poly*) F->Get("WM");
const char *location = "SELECT IPLatitude, IPLongitude FROM accesslog;";
TSQLResult *locationRes = db->Query(location);
while (TSQLRow *row = locationRes->Next()) {
if (!row->GetField(0)[0])
continue;
std::string sLatitude(row->GetField(0));
std::string sLongitude(row->GetField(1));
float latitude = std::stof(sLatitude);
float longitude = std::stof(sLongitude);
WM->Fill(longitude, latitude);
delete row;
}
TCanvas *locationHistogram = new TCanvas();
locationHistogram->SetLogz(1);
locationHistogram->ToggleEventStatus();
WM->Draw("colz");
}
The Canvas class.
Definition TCanvas.h:23
virtual void ToggleEventStatus()
Toggle event statusbar.
Definition TCanvas.cxx:2446
A ROOT file is a suite of consecutive data records (TKey instances) with a well defined format.
Definition TFile.h:54
static TFile * Open(const char *name, Option_t *option="", const char *ftitle="", Int_t compress=ROOT::RCompressionSetting::EDefaults::kUseCompiledDefault, Int_t netopt=0)
Create / open a file.
Definition TFile.cxx:3997
virtual void Draw(Option_t *option="")
Draw this histogram with options.
Definition TH1.cxx:3073
2D Histogram with Polygonal Bins
Definition TH2Poly.h:66
virtual Int_t Fill(Double_t x, Double_t y)
Increment the bin containing (x,y) by 1.
Definition TH2Poly.cxx:589
void SetLogz(Int_t value=1) override
Set Lin/Log scale for Z.
Definition TPad.cxx:5958
virtual TSQLRow * Next()=0
virtual TSQLResult * Query(const char *sql)=0
static TSQLServer * Connect(const char *db, const char *uid, const char *pw)
The db should be of the form: <dbms>://<host>[:<port>][/<database>], e.g.: mysql://pcroot....
#define F(x, y, z)
Author
Alexandra-Maria Dobrescu 08/2018

Definition in file SQLiteIPLocation.C.