Logo ROOT  
Reference Guide
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/files/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:2434
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:4019
void Draw(Option_t *option="") override
Draw this histogram with options.
Definition: TH1.cxx:3060
2D Histogram with Polygonal Bins
Definition: TH2Poly.h:66
Int_t Fill(Double_t x, Double_t y) override
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:5932
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....
Definition: TSQLServer.cxx:61
#define F(x, y, z)
Author
Alexandra-Maria Dobrescu 08/2018

Definition in file SQLiteIPLocation.C.