Remove user from new schema. Fix #247
only get user from consent table
also remove from consent table
do delete in one transction block
BUG/ENH: Fix template rendering logic

Some templates had an inconsistent logic going on, specifically the FAQ
website, would show the login text boxes even if you were logged in,
giving the impression that you had been logged out. A similar thing
happened in the home page i. e. every time you went to the home page you
would be prompted to enter your kit id and password, eventhough your
credentials were still alive. The new behaviour will redirect you to
/authed/portal/ if you have credentials and will show you the loggin
site otherwise.

Fixes #248
Merge pull request #265 from squirrelo/delete-participant

Remove user from new schema. Fix #247
Merge pull request #271 from ElDeveloper/issue-248

BUG/ENH: Fix template rendering logic
add is_old_participant function
fix index issue
chage to explicit survey_id
add missing brackets
Merge pull request #267 from squirrelo/get-humans-from-consent

Only get user from consent table