List Projects and Tasks if no id is given to editproject/edittask

1 files changed, 32 insertions, 2 deletions

diff --git a/sqlite.go b/sqlite.go
index 6ce6c3c..6ab652e 100644
--- a/sqlite.go
+++ b/sqlite.go
@@ -102,8 +102,8 @@ func initDB(filename string) {
             times VARCHAR(240),
             hours VARCHAR(240),
             moneys VARCHAR(240),
-            paid TIMESTAMP DEFAULT '1791-09-30 19:07',
-            date TIMESTAMP DEFAULT '1791-09-30 19:07');
+            paid TIMESTAMP DEFAULT datetime('1791-09-30 19:07','utc'),
+            date TIMESTAMP DEFAULT datetime('1791-09-30 19:07','utc') );
         `
         _, err = db.Exec(sqlstmt)
         checkErr(err)
@@ -613,6 +613,36 @@ func getTaskList(in []int,showcust bool) ([]int, []string) {
     }
     return outids,outstr
 }
+func getProjectIds() ([]int) {
+    var ids []int
+    rows,err := db.Query("SELECT id FROM projects WHERE id != 0")// ORDER BY id DESC")
+    checkErr(err)
+    var id int
+
+    defer rows.Close()
+    for rows.Next() {
+        err = rows.Scan(&id)
+        checkErr(err)
+	ids = append(ids,id)
+    }
+    return ids
+}
+
+
+func getTaskIds() ([]int) {
+    var ids []int
+    rows,err := db.Query("SELECT id FROM timetable WHERE stop != '1791-09-30 19:07'")// ORDER BY id DESC")
+    checkErr(err)
+    var id int
+
+    defer rows.Close()
+    for rows.Next() {
+        err = rows.Scan(&id)
+        checkErr(err)
+	ids = append(ids,id)
+    }
+    return ids
+}
 
 func getOpenTask() {
     rows,err := db.Query("SELECT id, project, start, task, checkout FROM timetable WHERE stop = '1791-09-30 19:07'")