/
db.go
66 lines (54 loc) · 1.33 KB
/
db.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
package db
import (
"database/sql"
"fmt"
"log"
"github.com/abhishekshree/iitk-coin/config"
)
type User struct {
Rollno string
Name string
Password string
Coins int
}
var DB *sql.DB
func Add(user User) bool {
status := false
checker, _ := DB.Query(`SELECT * FROM User WHERE rollno=$1`, user.Rollno)
defer checker.Close()
if checker.Next() {
fmt.Printf("%v with roll number %v already EXISTS.\n", user.Name, user.Rollno)
return status
}
statement, err := DB.Prepare("INSERT INTO User (rollno, name, password, coins) VALUES (?, ?, ?, ?)")
if err == nil {
statement.Exec(user.Rollno, user.Name, user.Password, config.INITIAL_COINS)
fmt.Printf("Added %v with roll number %v.\n", user.Name, user.Rollno)
status = true
} else {
panic(err)
}
return status
}
func FindPass(rollno string) (string, bool) {
var pass string
err := DB.QueryRow(`SELECT password FROM User WHERE rollno=$1`, rollno).Scan(&pass)
if err != nil {
return "User does not exists", false
}
return pass, true
}
func UserExists(rollno string) bool {
checker, _ := DB.Query(`SELECT * FROM User WHERE rollno=$1`, rollno)
defer checker.Close()
return checker.Next()
}
func Clean() bool {
stmt, _ := DB.Prepare("DROP TABLE IF EXISTS Transactions")
_, err := stmt.Exec()
if err != nil {
log.Println(err)
return false
}
return true
}