-
Notifications
You must be signed in to change notification settings - Fork 0
/
main.go
94 lines (85 loc) · 2.33 KB
/
main.go
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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
// Copyright 2015 Yoshi Yamaguchi
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
package main
import (
"database/sql"
"encoding/json"
"log"
"net/http"
"time"
"github.com/ymotongpoo/gopt3rec/epg"
"github.com/mattn/go-sqlite3"
)
const (
EPGSelectStatement = `select id, channel, title, detail, start, end, duration from epg where start >= ? and end < ? limit 100`
SelectDefaultWindow = 2 * 24 * time.Hour // 1 week
ResultBufSize = 100
)
var (
db *sql.DB
)
func init() {
var err error
db, err = sql.Open("sqlite3", "./epg.db")
if err != nil {
log.Fatal(err)
}
}
func main() {
defer db.Close()
mux := http.NewServeMux()
mux.HandleFunc("/epg/v1/list", epgListHandler)
mux.Handle("/", http.FileServer(http.Dir("./static")))
if err := http.ListenAndServe(":8080", mux); err != nil {
log.Fatal(err)
}
}
func epgListHandler(w http.ResponseWriter, r *http.Request) {
now := time.Now()
weekLater := now.Add(SelectDefaultWindow)
nowStr := now.Format(sqlite3.SQLiteTimestampFormats[2])
weekLaterStr := weekLater.Format(sqlite3.SQLiteTimestampFormats[2])
rows, err := db.Query(EPGSelectStatement, nowStr, weekLaterStr)
if err != nil {
log.Println(err)
return
}
defer rows.Close()
programs := []epg.Program{}
for rows.Next() {
var p epg.Program
var duration int
var start, end string
err = rows.Scan(&p.EventID, &p.Channel, &p.Title, &p.Detail, &start, &end, &duration)
if err != nil {
log.Println(err)
continue
}
if p.Start, err = time.Parse(sqlite3.SQLiteTimestampFormats[2], start); err != nil {
log.Println(err)
continue
}
if p.End, err = time.Parse(sqlite3.SQLiteTimestampFormats[2], end); err != nil {
log.Println(err)
continue
}
p.Duration = time.Duration(duration)
programs = append(programs, p)
}
e := json.NewEncoder(w)
err = e.Encode(programs)
if err != nil {
log.Println(err)
}
}