-
Notifications
You must be signed in to change notification settings - Fork 0
/
database.go
106 lines (94 loc) · 3.04 KB
/
database.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
95
96
97
98
99
100
101
102
103
// Copyright (c) 2014 by f4lk0r_
// Licensed under the GPLv3, see the License.txt file for details
package main
import (
sql "database/sql"
// "fmt"
//Go-sqlite3 library. Documentation here: http://godoc.org/github.com/mattn/go-sqlite3
_ "github.com/mattn/go-sqlite3"
"log"
"os"
"bytes"
"time"
)
var db *sql.DB
//func main() {
// db = setupDatabase()
//// insertMessage("+12345678910",[]byte("asdfasfasdfasdfasfasasdf"),nil)
// rows := getConversation("You")
// defer rows.Close()
// var msg string
// var src string
// var t time.Time
// for rows.Next() {
// rows.Scan(&msg,&src,&t)
// //log.Println(msg)
// //log.Println(src)
// //log.Println(time.Local())
// //log.Println(time.Clock())
// if (time.Now()).AddDate(0,0,-6).Before(t) {
// log.Println(string([]byte(t.Weekday().String())[0:3]))
// } else {
// log.Println(t.Local())
// }
// }
//}
// setupDatabase runs at start time to make sure the database exists and is ready to go
func setupDatabase() *sql.DB {
var doesExist bool = true
file, err := os.Open(".storage/textsecure.db")
if err != nil {
if os.IsNotExist(err) {
doesExist = false
} else {
log.Fatal("Problem opening database file",err)
}
}
file.Close()
db, err := sql.Open("sqlite3", ".storage/textsecure.db")
if err != nil {
log.Fatal("Problem accessing the sqlite database:",err)
}
if doesExist == false {
sqlStmt := `
create table textsecure (id integer not null primary key, source blob, dest blob, timeRecieved timestamp, message blob, whichGroup blob);
`
_, err = db.Exec(sqlStmt)
if err != nil {
log.Fatal("Failed to intialize database", err, sqlStmt)
}
}
return db
}
// Inserts a message object into the database
// INSERT INTO `textsecure`(`id`,`source`,`timeRecieved`,`message`,`whichGroup`) VALUES (1,NULL,NULL,NULL,NULL,NULL);
func insertMessage( source string, dest string, msg []byte, group []byte ) {
tx, err := db.Begin()
if err != nil {
log.Fatal(err)
}
stmt, err := tx.Prepare("insert into textsecure(id, source, dest, timeRecieved, message, whichGroup) values(?, ?, ?, ?, ?, ?)")
if err != nil {
log.Fatal(err)
}
defer stmt.Close()
_, err = stmt.Exec(nil,source, dest, time.Now(),msg,group)
if err != nil {
log.Fatal(err)
}
tx.Commit()
}
// getConversation gets the messages associated with a contact so they can be displayed in the message window
func getConversation(source string) *sql.Rows {
var b bytes.Buffer
b.WriteString("select message,source,timeRecieved from textsecure where source = '")
b.WriteString(source)
b.WriteString("' or dest = '")
b.WriteString(source)
b.WriteString("'order by timeRecieved asc;")
rows, err := db.Query(b.String())
if err != nil {
log.Fatal("Error retrieving messages from Sqlite database:", err)
}
return rows
}