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
|
-- name: create-log-table
CREATE TABLE IF NOT EXISTS logs (
ip text,
remote_log text,
userid text,
date integer,
request_method text,
path text,
version text,
status integer,
length integer,
referrer text,
user_agent text)
-- name: create-agent-table
CREATE TABLE IF NOT EXISTS agent (
id integer PRIMARY KEY,
user_agent text UNIQUE)
-- name: create-ip-table
CREATE TABLE IF NOT EXISTS ip (
id integer PRIMARY KEY,
addr text UNIQUE)
-- name: insert-log
INSERT INTO logs (ip, remote_log, userid, date, request_method, path, version, status, length, referrer, user_agent)
VALUES (?ip, ?remote_log, ?userid, ?date, ?request_method, ?path, ?version, ?status, ?length, ?referrer, ?user_agent)
-- name: update-ip-location
UPDATE
ip
SET
city = ?city,
country = ?country
WHERE
id = ?id
|
