diff options
Diffstat (limited to 'user')
-rw-r--r-- | user/adduser.go | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/user/adduser.go b/user/adduser.go new file mode 100644 index 0000000..873454b --- /dev/null +++ b/user/adduser.go @@ -0,0 +1,42 @@ +package user + +import ( + "log" + "time" + + "tildegit.org/andinus/perseus/storage/sqlite3" +) + +// AddUser adds the user to record. +func (u *User) AddUser(db *sqlite3.DB) error { + // Acquire write lock on the database. + db.Mu.Lock() + defer db.Mu.Unlock() + + // Start the transaction + tx, err := db.Conn.Begin() + if err != nil { + log.Printf("user/adduser.go: %s\n", + "failed to begin transaction") + return err + } + + usrStmt, err := db.Conn.Prepare(` +INSERT INTO users(id, username, password, regTime) values(?, ?, ?, ?)`) + if err != nil { + log.Printf("user/adduser.go: %s\n", + "failed to prepare statement") + return err + } + defer usrStmt.Close() + + _, err = usrStmt.Exec(u.id, u.username, u.password, time.Now().UTC()) + if err != nil { + log.Printf("user/adduser.go: %s\n", + "failed to execute statement") + return err + } + + tx.Commit() + return err +} |