add endpoint.go

2 files changed, 1 insertions, 9 deletions

diff --git a/db/endpoint.go b/db/endpoint.go
index cb59de5..d880510 100644
--- a/db/endpoint.go
+++ b/db/endpoint.go
@@ -2,7 +2,7 @@ package db
 
 func (p *Phlox) CreateEndpoint(name, path, address string) (Endpoint, error) {
 	var id int
-	row := p.db.QueryRow("select max(endpointid) from endpoints;")
+	row := p.db.QueryRow("select coalesce(max(endpointid), 0) from endpoints;")
 	err := row.Scan(&id)
 	if err != nil {
 		return Endpoint{}, err
diff --git a/db/session.go b/db/session.go
index b8365ff..8590d2f 100644
--- a/db/session.go
+++ b/db/session.go
@@ -73,14 +73,6 @@ func extractSession(s Scanner) (Session, error) {
 }
 
 
-func (p *Phlox) TouchSession(session Session) error {
-	now := time.Now().UTC()
-	nowStr := now.Format(time.RFC3339)
-	_, err := p.db.Exec("update sessions set modified=? where sessionid=?;", nowStr, session.Id)
-	return err
-}
-
-
 func (p *Phlox) CheckSession(session Session) (bool, error) {
 	row := p.db.QueryRow("select * from sessions where sessionid = ?", session.Id)
 	session, err := extractSession(row)