When downloading a file attached to a task, it is named with it's md5 hash. Furthermore the extension is missing. Once I add the extension the file can be opened as expected.

When downloading a file attached to a task the downloaded file should be named as the original file including it's file extension.

I tested this in the current version using Chrome and Firefox.

On a side note: It would be nice to be able to upload a new revision of a file to an existing task.

Hi @thewhitetulip ,i saw you defined the Close funtion to close the databse connection, but i didnt see you use this function ,why not close the database connection?

Hi i tried to run the instruction but when I ran go get and tired to build it I got this:

Users/noby > go get github.com/thewhitetulip/Tasks github.com/thewhitetulip/Tasks/views Golang/src/github.com/thewhitetulip/Tasks/views/api.go:31: invalid operation: token.Claims["username"](type jwt.Claims does not support indexing) Golang/src/github.com/thewhitetulip/Tasks/views/api.go:32: invalid operation: token.Claims["exp"](type jwt.Claims does not support indexing) Golang/src/github.com/thewhitetulip/Tasks/views/api.go:54: invalid operation: token.Claims["username"](type jwt.Claims does not support indexing)

/Users/noby/Golang/src/github.com/thewhitetulip/Tasks > ls README.md config.json files public screenshots templates utils config db main.go schema.sql sessions types views

/Users/noby/Golang/src/github.com/thewhitetulip/Tasks > cat schema.sql | sqlite3 tasks.db /Users/noby/Golang/src/github.com/thewhitetulip/Tasks > ls

README.md config.json files public screenshots tasks.db types views config db main.go schema.sql sessions templates utils

/Users/noby/Golang/src/github.com/thewhitetulip/Tasks > go build github.com/thewhitetulip/Tasks/views views/api.go:31: invalid operation: token.Claims["username"](type jwt.Claims does not support indexing) views/api.go:32: invalid operation: token.Claims["exp"](type jwt.Claims does not support indexing) views/api.go:54: invalid operation: token.Claims["username"](type jwt.Claims does not support indexing)

The build instructions in README.md don't work:

How you install?
==================

1. `go get github.com/thewhitetulip/Tasks`
1. change dir to the respective folder and create the db file: `cat schema.sql | sqlite3 tasks.db`
1. run `go build`
1. ./Task
1. open [localhost:8080](http://localhost:8080)

go build gives an error

main.go:9:2: cannot find package "github.com/thewhitetulip/Tasks/views" in any of: /usr/local/go/src/github.com/thewhitetulip/Tasks/views (from $GOROOT) /home/ben/projects/golib/src/github.com/thewhitetulip/Tasks/views (from $GOPATH)

I found that this worked:

$ go get github.com/thewhitetulip/Tasks/views $ go build

i got these log.

2019/04/01 12:20:52 running server on  :8081
2019/04/01 12:20:59 error identifying session
2019/04/01 12:20:59 error identifying session
2019/04/01 12:21:25 taiga taiga [email protected]
2019/04/01 12:21:25 inside task query
2019/04/01 12:21:25 Commit successful
2019/04/01 12:21:25 error identifying session
2019/04/01 12:21:26 error identifying session
2019/04/01 12:21:30 error identifying session
2019/04/01 12:21:30 error identifying session
2019/04/01 12:21:38 error identifying session
2019/04/01 12:21:38 error identifying session
2019/04/01 12:21:53 error identifying session
2019/04/01 12:21:53 error identifying session

Hi after i tried to login with an new user i got an runtime error.

I'm not an SQL expert but it seems there is a column missing.

Here is the output:

016/08/30 15:08:22 getting tasks for pending 2016/08/30 15:08:22 no such column: t.hide 2016/08/30 15:08:22 http: panic serving 192.168.1.2:51734: runtime error: invalid memory address or nil pointer dereference goroutine 50 [running]:

It must be in this file: Tasks/db/tasks.go

And these are the columns of the table task in task.db

What I'm doing wrong and what does the column t.hide exactly do?

https://github.com/thewhitetulip/Tasks/issues/18 Extend the SQL storing the information to a file by username and creation date.

The SQL storing the information about an attached file was missing the values for the user_id and creation_date.

This pull request extends the SQL by these two values.

When I change html, js, css I need turn off server and reload server then new code appear. Why the server didn't auto receive new client code, sorry for my bad english

I get the following error when trying to attach a file to a task:

2016/05/15 21:53:27 inside task query
2016/05/15 21:53:27 table files has 4 columns but 2 values were supplied
2016/05/15 21:53:27 http: panic serving [::1]:60501: runtime error: invalid memory address or nil pointer dereference
goroutine 90 [running]:
net/http.(*conn).serve.func1(0xc820366e80)
    /usr/local/go/src/net/http/server.go:1389 +0xc1
panic(0x45e2ec0, 0xc82000a0d0)
    /usr/local/go/src/runtime/panic.go:426 +0x4e9
database/sql.(*Tx).Stmt(0xc820454ff0, 0x0, 0x1d)
    /usr/local/go/src/database/sql/sql.go:1341 +0x32
github.com/thewhitetulip/Tasks/db.taskQuery(0x46ef900, 0x1d, 0xc8204d3690, 0x2, 0x2, 0x0, 0x0)
    /Users/christian/Development/Go/src/github.com/thewhitetulip/Tasks/db/tasks.go:254 +0x172
github.com/thewhitetulip/Tasks/db.AddFile(0xc8204c8720, 0x26, 0xc820322fe0, 0x20, 0x0, 0x0)
    /Users/christian/Development/Go/src/github.com/thewhitetulip/Tasks/db/files.go:15 +0x187
github.com/thewhitetulip/Tasks/views.AddTaskFunc(0x5a5ce20, 0xc82045eea0, 0xc820508b60)
    /Users/christian/Development/Go/src/github.com/thewhitetulip/Tasks/views/addViews.go:98 +0xe9e
github.com/thewhitetulip/Tasks/views.RequiresLogin.func1(0x5a5ce20, 0xc82045eea0, 0xc820508b60)
    /Users/christian/Development/Go/src/github.com/thewhitetulip/Tasks/views/sessionViews.go:18 +0x95
net/http.HandlerFunc.ServeHTTP(0xc820210720, 0x5a5ce20, 0xc82045eea0, 0xc820508b60)
    /usr/local/go/src/net/http/server.go:1618 +0x3a
net/http.(*ServeMux).ServeHTTP(0xc820062a80, 0x5a5ce20, 0xc82045eea0, 0xc820508b60)
    /usr/local/go/src/net/http/server.go:1910 +0x17d
net/http.serverHandler.ServeHTTP(0xc820232400, 0x5a5ce20, 0xc82045eea0, 0xc820508b60)
    /usr/local/go/src/net/http/server.go:2081 +0x19e
net/http.(*conn).serve(0xc820366e80)
    /usr/local/go/src/net/http/server.go:1472 +0xf2e
created by net/http.(*Server).Serve
    /usr/local/go/src/net/http/server.go:2137 +0x44e

A copy of the file is placed in the files folder.

This line of code seem to build the SQL to write to the database: err := taskQuery("insert into files values(?,?)", fileName, token). The error reads table files has 4 columns but 2 values were supplied. Since the SQL provides only two values this seems to be the issue.

I created a pullrequest fixing this issue: https://github.com/thewhitetulip/Tasks/pull/19

These are edge cases. The basic flow will be a ted bit harder since they need a database mock, or an interface instead of the database to use as a Test database.

To check what areas are covered, run the following commands:

go test -coverprofile=cover.out
go tool cover -html=cover.out

This will give you a nice view of what functions are covered and what not.

Hello 👋

I run a security community that finds and fixes vulnerabilities in OSS. A researcher (@an5er) has found a potential issue, which I would be eager to share with you.

Could you add a SECURITY.md file with an e-mail address for me to send further details to? GitHub recommends a security policy to ensure issues are responsibly disclosed, and it would help direct researchers in the future.

Looking forward to hearing from you 👍

(cc @huntr-helper)

For some reason when I try and edit an added task it always displays the first task I have entered into the db. This displays the first ever entered regardless of the item being completed or deleted. not seeing any errors or anything that would indicate why this is happening.

if permissions are given or in a set group. I would like to say, show my boss what i am working on so that they can choose what is a priority for me. Also this would work great with my kids so i can see what they are working on and if i need to prioritize something they missed or i forgot about.