webtry: Improve error handling/message when creating sqlite tables.

experimental/webtry/webtry.go

 package main
 
 import (
         "bytes"
         "crypto/md5"
         "database/sql"
         "encoding/base64"
         "encoding/binary"
         "encoding/json"
         "flag"
@@ skipping 217 matching lines @@
                 sql := `CREATE TABLE IF NOT EXISTS source_images (
              id        INTEGER     PRIMARY KEY                NOT NULL,
              image     MEDIUMBLOB  DEFAULT ''                 NOT NULL, -- formatted as a PNG.
              width     INTEGER     DEFAULT 0                  NOT NULL,
              height    INTEGER     DEFAULT 0                  NOT NULL,
              create_ts TIMESTAMP   DEFAULT CURRENT_TIMESTAMP  NOT NULL,
              hidden    INTEGER     DEFAULT 0                  NOT NULL
              )`
                 _, err = db.Exec(sql)
                 if err != nil {
-                        glog.Infof("status creating sqlite table for sources: %q\n", err)
+                        glog.Errorf("Creating source_images table failed: %s", err)
                 }
 
                 sql = `CREATE TABLE IF NOT EXISTS webtry (
              code               TEXT      DEFAULT ''                 NOT NULL,
              create_ts          TIMESTAMP DEFAULT CURRENT_TIMESTAMP  NOT NULL,
              hash               CHAR(64)  DEFAULT ''                 NOT NULL,
              width              INTEGER   DEFAULT 256                NOT NULL,
              height             INTEGER   DEFAULT 256                NOT NULL,
              gpu                BOOL      DEFAULT 0                  NOT NULL,
              source_image_id    INTEGER   DEFAULT 0                  NOT NULL,
 
              PRIMARY KEY(hash)
             )`
                 _, err = db.Exec(sql)
                 if err != nil {
-                        glog.Infof("status creating sqlite table for webtry: %q\n", err)
+                        glog.Errorf("Creating webtry table failed: %s", err)
                 }
 
                 sql = `CREATE TABLE IF NOT EXISTS workspace (
           name      CHAR(64)  DEFAULT ''                 NOT NULL,
           create_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP  NOT NULL,
           PRIMARY KEY(name)
         )`
                 _, err = db.Exec(sql)
                 if err != nil {
-                        glog.Infof("status creating sqlite table for workspace: %q\n", err)
+                        glog.Errorf("Creating workspace table failed: %s", err)
                 }
 
                 sql = `CREATE TABLE IF NOT EXISTS workspacetry (
           name               CHAR(64)  DEFAULT ''                 NOT NULL,
           create_ts          TIMESTAMP DEFAULT CURRENT_TIMESTAMP  NOT NULL,
           hash               CHAR(64)  DEFAULT ''                 NOT NULL,
           width              INTEGER   DEFAULT 256                NOT NULL,
           height             INTEGER   DEFAULT 256                NOT NULL,
           gpu                BOOL      DEFAULT 0                  NOT NULL,
           hidden             INTEGER   DEFAULT 0                  NOT NULL,
           source_image_id    INTEGER   DEFAULT 0                  NOT NULL,
 
           FOREIGN KEY (name)   REFERENCES workspace(name)
         )`
                 _, err = db.Exec(sql)
                 if err != nil {
-                        glog.Infof("status creating sqlite table for workspace try: %q\n", err)
+                        glog.Errorf("Creating workspacetry table failed: %s", err)
                 }
         }
 
         // Ping the database to keep the connection fresh.
         go func() {
                 c := time.Tick(1 * time.Minute)
                 for _ = range c {
                         if err := db.Ping(); err != nil {
                                 glog.Errorf("Database failed to respond: %q\n", err)
                         }
@@ skipping 669 matching lines @@
         http.HandleFunc("/sources/", autogzip.HandleFunc(sourcesHandler))
 
         // Resources are served directly
         // TODO add support for caching/etags/gzip
         http.Handle("/res/", autogzip.Handle(http.FileServer(http.Dir("./"))))
 
         // TODO Break out /c/ as it's own handler.
         http.HandleFunc("/", autogzip.HandleFunc(mainHandler))
         glog.Fatal(http.ListenAndServe(*port, nil))
 }