sqlite-nginx-module/nginx.conf at master · linjan2/sqlite-nginx-module · GitHub

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
worker_processes  1;
error_log /dev/stdout info;

events {
    worker_connections  1024;
}

http {
    default_type  application/octet-stream;

    log_format main '$remote_addr - $remote_user [$time_local] "$request" '
                     '$status $body_bytes_sent "$http_referer" '
                     '"$http_user_agent" "$http_x_forwarded_for"';
    access_log /dev/stdout main;

    sendfile        on;
    #keepalive_timeout  0;
    keepalive_timeout  65;

    sqlite_database 'example.db';

    server {
        listen       8888;
        server_name  localhost;

        location / {
            root html;
        }


        location = /sql/select {
            sqlite_query 'select * from table1 where name=?1';
        }
        location = /sql/update {
            sqlite_query 'update table1 set number=?1 where name=?2';
        }
        location = /sql/insert {
            sqlite_query 'insert into table1(name,number) values (?1,?2)';
        }
        location = /sql/delete {
            sqlite_query 'delete from table1 where name=?1';
        }
    }
}