# TrafficStatistics

**Repository Path**: lands/TrafficStatistics

## Basic Information

- **Project Name**: TrafficStatistics
- **Description**: router traffic statistics 
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2017-03-07
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# data source
bw_get -i bdist1-upload-minute-15 -h -m > traffic.txt &&  bw_get -i bdist1-download-minute-15 -h -m >> traffic.txt


# db: traffic.db3
table: minute_flow
CREATE TABLE minute_flow(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, owner TEXT NOT NULL, datetime TEXT NOT NULL, upload INTEGER, download INTEGER);
DROP TABLE minute_flow;

table: hour_flow
CREATE TABLE hour_flow(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, owner TEXT NOT NULL, datetime TEXT NOT NULL, upload INTEGER, download INTEGER);
DROP TABLE hour_flow;

table: day_flow
CREATE TABLE day_flow(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, owner TEXT NOT NULL, datetime TEXT NOT NULL, upload INTEGER, download INTEGER);
DROP TABLE day_flow;


CREATE TEMPORARY TABLE minute_flow(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, owner TEXT NOT NULL, datetime TEXT NOT NULL, upload INTEGER, download INTEGER);



select owner, sum(upload), sum(download) from minute_flow where datetime > '2017-03-06 16:38:00.000' and datetime < '2017-03-06 16:40:00.000' group by owner;