Saturday, 7 November 2020

go web app 18 - election for year 3000, part 2

 
index page shows current vote count, press on the search button

redirected to record page, sample random vote data was inserted in mongodb

register as 123 and vote for human, human count increase by 1

123's vote is recorded

//tutorial.go
package main

import (
"bytes"
"context"
"fmt"
"html/template"
"log"
"net/http"
"time"

"github.com/gorilla/mux"
"github.com/gorilla/sessions"
"golang.org/x/crypto/bcrypt"

"go.mongodb.org/mongo-driver/bson"
"go.mongodb.org/mongo-driver/bson/primitive"
"go.mongodb.org/mongo-driver/mongo"
"go.mongodb.org/mongo-driver/mongo/options"
)

type auth struct {
Username string
Password []byte
Ballot   string
Status   string
Count1   int
Count2   int
}

var templates *template.Template
var store = sessions.NewCookieStore([]byte("secret"))

func indexGetHandler(w http.ResponseWriter, r *http.Request) {

session, _ := store.Get(r, "session")
registeredUser, _ := session.Values["username"]
registeredHashedPassword, _ := session.Values["password"]
ballot, _ := session.Values["ballot"]
status, _ := session.Values["status"]

count1 := countBallot("human")
count2 := countBallot("humanoid")

if registeredUser == nil || registeredHashedPassword == nil || status == nil {
templates.ExecuteTemplate(w, "index.html", auth{Count1: count1, Count2: count2})
return
}

if ballot == nil {
ballot = ""
}

templates.ExecuteTemplate(w, "index.html",
auth{Username: registeredUser.(string), Ballot: ballot.(string),
Password: registeredHashedPassword.([]byte), Status: status.(string),
Count1: count1, Count2: count2})
}

func indexPostHandler(w http.ResponseWriter, r *http.Request) {
r.ParseForm()
ballot := r.PostForm.Get("ballot")

session, _ := store.Get(r, "session")
username, _ := session.Values["username"]
password, _ := session.Values["password"]

if username == nil || password == nil {
http.Redirect(w, r, "/login", 302)
return
}

var updateStatus = updateUser(username.(string), password.([]byte), ballot)

session.Values["status"] = updateStatus
if updateStatus == "update successful" {
session.Values["ballot"] = ballot
}
session.Save(r, w)

http.Redirect(w, r, "/", 302)
}

func ballotGetHandler(w http.ResponseWriter, r *http.Request) {
ballot := queryAll()
templates.ExecuteTemplate(w, "ballot.html", ballot)
}

func loginGetHandler(w http.ResponseWriter, r *http.Request) {
session, _ := store.Get(r, "session")
registeredUser, _ := session.Values["username"]
userBallot, _ := session.Values["ballot"]
//registeredHashedPassword, _ := session.Values["password"]
status, _ := session.Values["status"]

if userBallot == nil {
userBallot = ""
}

if registeredUser == nil || status == nil {
templates.ExecuteTemplate(w, "login.html", nil)
return
}

templates.ExecuteTemplate(w, "login.html",
auth{Username: registeredUser.(string), Ballot: userBallot.(string),
Status: status.(string)})

}

func loginPostHandler(w http.ResponseWriter, r *http.Request) {
r.ParseForm()
username := r.PostForm.Get("username")
password := r.PostForm.Get("password")

var userAuth auth
userAuth = findUser(username)
if userAuth.Status != "voter found" {
templates.ExecuteTemplate(w, "login.html",
auth{Status: "voter not exist"})
return
}

err := bcrypt.CompareHashAndPassword(userAuth.Password, []byte(password))

if err != nil || username != userAuth.Username {
templates.ExecuteTemplate(w, "login.html",
auth{Status: "username password mismatch"})
return
}

session, _ := store.Get(r, "session")
session.Values["username"] = username
session.Values["ballot"] = userAuth.Ballot
session.Values["password"] = userAuth.Password
session.Values["status"] = "logged in as " + username
session.Save(r, w)

http.Redirect(w, r, "/", 302)

}

func logoutGetHandler(w http.ResponseWriter, r *http.Request) {
session, _ := store.Get(r, "session")
session.Values["username"] = nil
session.Values["password"] = nil
session.Values["status"] = nil
session.Values["ballot"] = nil
session.Save(r, w)

templates.ExecuteTemplate(w, "logout.html", nil)
}

func registerGetHandler(w http.ResponseWriter, r *http.Request) {
templates.ExecuteTemplate(w, "register.html", nil)
}

func registerPostHandler(w http.ResponseWriter, r *http.Request) {
r.ParseForm()
username := r.PostForm.Get("username")
password := r.PostForm.Get("password")

cost := bcrypt.DefaultCost
hashedPassword, err := bcrypt.GenerateFromPassword([]byte(password), cost)
if err != nil {
templates.ExecuteTemplate(w, "register.html", auth{Status: "password not accepted"})
return
}

status := addUser(username, hashedPassword)

session, _ := store.Get(r, "session")
session.Values["username"] = username
session.Values["status"] = status
session.Save(r, w)

http.Redirect(w, r, "/login", 302)
}

func addUser(user string, password []byte) string {
client, err := mongo.NewClient(options.Client().ApplyURI("mongodb+srv://bob:password@cluster0.yvyo2.mongodb.net/test?retryWrites=true&w=majority"))
if err != nil {
log.Fatal(err)
}
ctx, _ := context.WithTimeout(context.Background(), 100*time.Second)
err = client.Connect(ctx)
if err != nil {
return "error connecting to database"
}
defer client.Disconnect(ctx)

electionDatabase := client.Database("sample_election")
votersCollection := electionDatabase.Collection("voters")

//check if voter exist
var userAuth auth
userAuth = findUser(user)
if userAuth.Status == "voter found" {
return "You are registered already, please log in."
}

address, err := votersCollection.InsertOne(ctx, bson.D{
{"user", user},
{"password", password},
{"ballot", ""},
})
if err != nil {
return "error adding new voter"
}

fmt.Println("inserted", user, "@ ", address)
return "new volter profile created"
}

func findUser(user string) auth {
client, err := mongo.NewClient(options.Client().ApplyURI("mongodb+srv://bob:password@cluster0.yvyo2.mongodb.net/test?retryWrites=true&w=majority"))
if err != nil {
log.Fatal(err)
}
ctx, _ := context.WithTimeout(context.Background(), 100*time.Second)
err = client.Connect(ctx)
if err != nil {
return auth{Status: "error connecting to database"}
}
defer client.Disconnect(ctx)

electionDatabase := client.Database("sample_election")
votersCollection := electionDatabase.Collection("voters")

filterCursor, err := votersCollection.Find(ctx, bson.M{"user": user})
defer filterCursor.Close(ctx)
if err != nil {
return auth{Status: "voter not found"}
}

var userAuth bson.M
var userLiscense string
var userPassword []byte
var userBallot string

filterCursor.Next(ctx)
if err = filterCursor.Decode(&userAuth); err != nil {
return auth{Status: "error connecting to database 2"}
}

for k, v := range userAuth {
if k == "user" {
userLiscense = v.(string)
}
if k == "ballot" {
userBallot = v.(string)
}
if k == "password" {
userPassword = v.(primitive.Binary).Data
//fmt.Println(reflect.TypeOf(v))
}
}

return auth{Username: userLiscense, Password: userPassword, Ballot: userBallot, Status: "voter found"}
}

func updateUser(registeredUser string, registeredHashedPassword []byte, ballot string) string {

var userAuth auth
userAuth = findUser(registeredUser)
if userAuth.Status != "voter found" {
return "not registered"
}

if bytes.Compare(userAuth.Password, registeredHashedPassword) != 0 || registeredUser != userAuth.Username {
return "wrong credential"
}

client, err := mongo.NewClient(options.Client().ApplyURI("mongodb+srv://bob:password@cluster0.yvyo2.mongodb.net/test?retryWrites=true&w=majority"))
if err != nil {
return "database not exist"
}
ctx, _ := context.WithTimeout(context.Background(), 100*time.Second)
err = client.Connect(ctx)
if err != nil {
return "error connecting to database"
}
defer client.Disconnect(ctx)

electionDatabase := client.Database("sample_election")
votersCollection := electionDatabase.Collection("voters")

userUpdate, err := votersCollection.UpdateOne(
ctx,
bson.M{"user": userAuth.Username},
bson.M{"$set": bson.M{"ballot": ballot}})

if err != nil {
return "update failed"
}
fmt.Println(userUpdate.ModifiedCount, " updated")

return "update successful"
}

func countBallot(ballot string) int {
client, err := mongo.NewClient(options.Client().ApplyURI("mongodb+srv://bob:password@cluster0.yvyo2.mongodb.net/test?retryWrites=true&w=majority"))
if err != nil {
log.Fatal(err)
}
ctx, _ := context.WithTimeout(context.Background(), 100*time.Second)
err = client.Connect(ctx)
if err != nil {
log.Fatal(err)
}
defer client.Disconnect(ctx)

electionDatabase := client.Database("sample_election")
votersCollection := electionDatabase.Collection("voters")

filterCursor, err := votersCollection.Find(ctx, bson.M{"ballot": ballot})
defer filterCursor.Close(ctx)
if err != nil {
log.Fatal(err)
}
var countFiltered []bson.M
if err = filterCursor.All(ctx, &countFiltered); err != nil {
log.Fatal(err)
}

return len(countFiltered)
}

func queryAll() map[string]string {
client, err := mongo.NewClient(options.Client().ApplyURI("mongodb+srv://bob:password@cluster0.yvyo2.mongodb.net/test?retryWrites=true&w=majority"))
if err != nil {
log.Fatal(err)
}
ctx, _ := context.WithTimeout(context.Background(), 100*time.Second)
err = client.Connect(ctx)
if err != nil {
log.Fatal(err)
}
defer client.Disconnect(ctx)

electionDatabase := client.Database("sample_election")
votersCollection := electionDatabase.Collection("voters")
cursor, err := votersCollection.Find(ctx, bson.M{})
if err != nil {
log.Fatal(err)
}
defer cursor.Close(ctx)

profileArray := make(map[string]string)
for cursor.Next(ctx) {
var profile bson.M
if err = cursor.Decode(&profile); err != nil {
log.Fatal(err)
}
profileArray[profile["user"].(string)] = profile["ballot"].(string)
}

return profileArray
}

func main() {
templates = template.Must(template.ParseGlob("templates/*.html"))
r := mux.NewRouter()
r.HandleFunc("/", indexGetHandler).Methods("GET")
r.HandleFunc("/", indexPostHandler).Methods("POST")
r.HandleFunc("/ballot", ballotGetHandler).Methods("GET")
r.HandleFunc("/login", loginGetHandler).Methods("GET")
r.HandleFunc("/login", loginPostHandler).Methods("POST")
r.HandleFunc("/logout", logoutGetHandler).Methods("GET")
r.HandleFunc("/register", registerGetHandler).Methods("GET")
r.HandleFunc("/register", registerPostHandler).Methods("POST")
fs := http.FileServer(http.Dir("./static/"))
r.PathPrefix("/static/").Handler(http.StripPrefix("/static/", fs))
http.Handle("/", r)
http.ListenAndServe(":8000", nil)
}

------------------------------------
//simulator.go
package main

import (
"context"
"fmt"
"log"
"math/rand"
"strconv"
"time"

"golang.org/x/crypto/bcrypt"

"go.mongodb.org/mongo-driver/bson"
"go.mongodb.org/mongo-driver/mongo"
"go.mongodb.org/mongo-driver/mongo/options"
)

func main() {
client, err := mongo.NewClient(options.Client().ApplyURI("mongodb+srv://bob:password@cluster0.yvyo2.mongodb.net/test?retryWrites=true&w=majority"))
if err != nil {
log.Fatal(err)
}
ctx, _ := context.WithTimeout(context.Background(), 100*time.Second)
err = client.Connect(ctx)
if err != nil {
log.Fatal(err)
}
defer client.Disconnect(ctx)

electionDatabase := client.Database("sample_election")
votersCollection := electionDatabase.Collection("voters")

cost := bcrypt.DefaultCost
hashedPassword, err := bcrypt.GenerateFromPassword([]byte("abc"), cost)

for i := 0; i < 100; i++ {
var ballot = ""
randomN := rand.Intn(100)
if randomN > 50 {
ballot = "humanoid"
} else {
ballot = "human"
}

address, err := votersCollection.InsertOne(ctx, bson.D{
{"user", strconv.Itoa(i)},
{"password", hashedPassword},
{"ballot", ballot},
})
if err != nil {
log.Fatal(err)
}

fmt.Println("inserted", strconv.Itoa(i), "@ ", address)
}
}

--------------------------------
//index.html
<html>

<head>
    <title> Ballot</title>
    <link rel="stylesheet" type="text/css" href="/static/index.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
</head>

<body>
    <div style="text-align: center;">
        <h1>World Election of Year 3000 </h1>
    </div>

    {{if .Username}}
    <div>
        <h3>I ({{.Username}}) vote for <i>{{.Ballot}}</i>
            <span style="float: right;"><a href="/logout">sign out</a></span></h3>
    </div>

    {{else}}
    <div>
        <h3>Please <a href="/login">log in</a></h3>
    </div>
    {{end}}

    <div>
        <h3>Current Counts: human ({{.Count1}}) vs humanoid ({{.Count2}})
            <a href="/ballot" style="border: 1px solid black; background-color: beige;">
                <i class="fa fa-search"></i></a>
        </h3>
    </div>

    <form method="POST">
        <input type="hidden" value="" id="input1" name="ballot">
        <div class="row">
            <div class="column">
                <h2>Human</h2>
                <img src="/static/human.jpg" alt="Human" style="width:90%;" onclick="humanClick()">
            </div>
            <div class="column">
                <h2>Humanoid</h2>
                <img src="/static/humanoid.jpg" alt="Humanoid" style="width:90%;" onclick="humanoidClick()">
            </div>
        </div>
        <button type="submit" style="display: none;" id="button1"></button>

    </form>

    <div>
        <h3>status: {{.Status}}</h3>
    </div><br />
</body>
<script>
    function humanClick() {
        document.getElementById("input1").value = "human"
        document.getElementById("button1").click()
    }

    function humanoidClick() {
        document.getElementById("input1").value = "humanoid"
        document.getElementById("button1").click()
    }
</script>

</html>

----------------------------------
//ballot.html
<html>

<head>
    <title>Ballot Record</title>
    <link rel="stylesheet" type="text/css" href="/static/index.css">
</head>

<body>
    <h1>Ballot Record</h1>
    <h3><a href="/">back</a></h3>
    <table>
        <tr>
            <th>Driver's license</th>
            <th>Ballot</th>
        </tr>
        {{range $key, $val := .}}
        <tr>
            <td>{{$key}}</td>
            <td>{{$val}}</td>
        </tr>
        {{end}}
    </table>
</body>

</html>

reference:

mangodb query

go template

go map

Friday, 6 November 2020

go web app 17 - election for year 3000, part 1

 
open election webpage

register a new account with driver's license (123)

press on human image to vote

mongodb ballot is updated to human for 123

press on humanoid to switch vote

mongodb ballot is updated to humanoid for 123

log out

log in as 123 again, data from mongodb shows 123 currently votes for humanoid

//tutorial.go
package main

import (
"bytes"
"context"
"fmt"
"html/template"
"log"
"net/http"
"time"

"github.com/gorilla/mux"
"github.com/gorilla/sessions"
"golang.org/x/crypto/bcrypt"

"go.mongodb.org/mongo-driver/bson"
"go.mongodb.org/mongo-driver/bson/primitive"
"go.mongodb.org/mongo-driver/mongo"
"go.mongodb.org/mongo-driver/mongo/options"
)

type auth struct {
Username string
Password []byte
Ballot   string
Status   string
}

var templates *template.Template
var store = sessions.NewCookieStore([]byte("secret"))

func indexGetHandler(w http.ResponseWriter, r *http.Request) {

session, _ := store.Get(r, "session")
registeredUser, _ := session.Values["username"]
registeredHashedPassword, _ := session.Values["password"]
ballot, _ := session.Values["ballot"]
status, _ := session.Values["status"]

if registeredUser == nil || registeredHashedPassword == nil || status == nil {
templates.ExecuteTemplate(w, "index.html", nil)
return
}

if ballot == nil {
ballot = ""
}

templates.ExecuteTemplate(w, "index.html",
auth{Username: registeredUser.(string), Ballot: ballot.(string),
Password: registeredHashedPassword.([]byte), Status: status.(string)})
}

func indexPostHandler(w http.ResponseWriter, r *http.Request) {
r.ParseForm()
ballot := r.PostForm.Get("ballot")

session, _ := store.Get(r, "session")
username, _ := session.Values["username"]
password, _ := session.Values["password"]

if username == nil || password == nil {
http.Redirect(w, r, "/login", 302)
return
}

var updateStatus = updateUser(username.(string), password.([]byte), ballot)

session.Values["status"] = updateStatus
if updateStatus == "update successful" {
session.Values["ballot"] = ballot
}
session.Save(r, w)

http.Redirect(w, r, "/", 302)
}

func loginGetHandler(w http.ResponseWriter, r *http.Request) {
session, _ := store.Get(r, "session")
registeredUser, _ := session.Values["username"]
userBallot, _ := session.Values["ballot"]
//registeredHashedPassword, _ := session.Values["password"]
status, _ := session.Values["status"]

if userBallot == nil {
userBallot = ""
}

if registeredUser == nil || status == nil {
templates.ExecuteTemplate(w, "login.html", nil)
return
}

templates.ExecuteTemplate(w, "login.html",
auth{Username: registeredUser.(string), Ballot: userBallot.(string),
Status: status.(string)})

}

func loginPostHandler(w http.ResponseWriter, r *http.Request) {
r.ParseForm()
username := r.PostForm.Get("username")
password := r.PostForm.Get("password")

var userAuth auth
userAuth = findUser(username)
if userAuth.Status != "voter found" {
templates.ExecuteTemplate(w, "login.html",
auth{Status: "voter not exist"})
return
}

err := bcrypt.CompareHashAndPassword(userAuth.Password, []byte(password))

if err != nil || username != userAuth.Username {
templates.ExecuteTemplate(w, "login.html",
auth{Status: "username password mismatch"})
return
}

session, _ := store.Get(r, "session")
session.Values["username"] = username
session.Values["ballot"] = userAuth.Ballot
session.Values["password"] = userAuth.Password
session.Values["status"] = "logged in as " + username
session.Save(r, w)

http.Redirect(w, r, "/", 302)

}

func logoutGetHandler(w http.ResponseWriter, r *http.Request) {
session, _ := store.Get(r, "session")
session.Values["username"] = nil
session.Values["password"] = nil
session.Values["status"] = nil
session.Values["ballot"] = nil
session.Save(r, w)

templates.ExecuteTemplate(w, "logout.html", nil)
}

func registerGetHandler(w http.ResponseWriter, r *http.Request) {
templates.ExecuteTemplate(w, "register.html", nil)
}

func registerPostHandler(w http.ResponseWriter, r *http.Request) {
r.ParseForm()
username := r.PostForm.Get("username")
password := r.PostForm.Get("password")

cost := bcrypt.DefaultCost
hashedPassword, err := bcrypt.GenerateFromPassword([]byte(password), cost)
if err != nil {
templates.ExecuteTemplate(w, "register.html", auth{Status: "password not accepted"})
return
}

status := addUser(username, hashedPassword)

session, _ := store.Get(r, "session")
session.Values["username"] = username
session.Values["status"] = status
session.Save(r, w)

http.Redirect(w, r, "/login", 302)
}

func addUser(user string, password []byte) string {
client, err := mongo.NewClient(options.Client().ApplyURI("mongodb+srv://bob:password@cluster0.yvyo2.mongodb.net/test?retryWrites=true&w=majority"))
if err != nil {
log.Fatal(err)
}
ctx, _ := context.WithTimeout(context.Background(), 100*time.Second)
err = client.Connect(ctx)
if err != nil {
return "error connecting to database"
}
defer client.Disconnect(ctx)

electionDatabase := client.Database("sample_election")
votersCollection := electionDatabase.Collection("voters")

//check if voter exist
var userAuth auth
userAuth = findUser(user)
if userAuth.Status == "voter found" {
return "You are registered already, please log in."
}

address, err := votersCollection.InsertOne(ctx, bson.D{
{"user", user},
{"password", password},
{"ballot", ""},
})
if err != nil {
return "error adding new voter"
}

fmt.Println("inserted", user, "@ ", address)
return "new volter profile created"
}

func findUser(user string) auth {
client, err := mongo.NewClient(options.Client().ApplyURI("mongodb+srv://bob:password@cluster0.yvyo2.mongodb.net/test?retryWrites=true&w=majority"))
if err != nil {
log.Fatal(err)
}
ctx, _ := context.WithTimeout(context.Background(), 100*time.Second)
err = client.Connect(ctx)
if err != nil {
return auth{Status: "error connecting to database"}
}
defer client.Disconnect(ctx)

electionDatabase := client.Database("sample_election")
votersCollection := electionDatabase.Collection("voters")

filterCursor, err := votersCollection.Find(ctx, bson.M{"user": user})
defer filterCursor.Close(ctx)
if err != nil {
return auth{Status: "voter not found"}
}

var userAuth bson.M
var userLiscense string
var userPassword []byte
var userBallot string

filterCursor.Next(ctx)
if err = filterCursor.Decode(&userAuth); err != nil {
return auth{Status: "error connecting to database 2"}
}

for k, v := range userAuth {
if k == "user" {
userLiscense = v.(string)
}
if k == "ballot" {
userBallot = v.(string)
}
if k == "password" {
userPassword = v.(primitive.Binary).Data
//fmt.Println(reflect.TypeOf(v))
}
}

return auth{Username: userLiscense, Password: userPassword, Ballot: userBallot, Status: "voter found"}
}

func updateUser(registeredUser string, registeredHashedPassword []byte, ballot string) string {

var userAuth auth
userAuth = findUser(registeredUser)
if userAuth.Status != "voter found" {
return "not registered"
}

if bytes.Compare(userAuth.Password, registeredHashedPassword) != 0 || registeredUser != userAuth.Username {
return "wrong credential"
}

client, err := mongo.NewClient(options.Client().ApplyURI("mongodb+srv://bob:password@cluster0.yvyo2.mongodb.net/test?retryWrites=true&w=majority"))
if err != nil {
return "database not exist"
}
ctx, _ := context.WithTimeout(context.Background(), 100*time.Second)
err = client.Connect(ctx)
if err != nil {
return "error connecting to database"
}
defer client.Disconnect(ctx)

electionDatabase := client.Database("sample_election")
votersCollection := electionDatabase.Collection("voters")

userUpdate, err := votersCollection.UpdateOne(
ctx,
bson.M{"user": userAuth.Username},
bson.M{"$set": bson.M{"ballot": ballot}})

if err != nil {
return "update failed"
}
fmt.Println(userUpdate.ModifiedCount, " updated")

return "update successful"
}

func main() {
templates = template.Must(template.ParseGlob("templates/*.html"))
r := mux.NewRouter()
r.HandleFunc("/", indexGetHandler).Methods("GET")
r.HandleFunc("/", indexPostHandler).Methods("POST")
r.HandleFunc("/login", loginGetHandler).Methods("GET")
r.HandleFunc("/login", loginPostHandler).Methods("POST")
r.HandleFunc("/logout", logoutGetHandler).Methods("GET")
r.HandleFunc("/register", registerGetHandler).Methods("GET")
r.HandleFunc("/register", registerPostHandler).Methods("POST")
fs := http.FileServer(http.Dir("./static/"))
r.PathPrefix("/static/").Handler(http.StripPrefix("/static/", fs))
http.Handle("/", r)
http.ListenAndServe(":8000", nil)
}

-------------------------------
//index.html
<html>

<head>
    <title> Ballot</title>
    <link rel="stylesheet" type="text/css" href="/static/index.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
</head>

<body>
    <div style="text-align: center;">
        <h1>World Election of Year 3000 </h1>
    </div>

    {{if .Username}}
    <div>
        <h3>I ({{.Username}}) vote for <i>{{.Ballot}}</i>
            <span style="float: right;"><a href="/logout">sign out</a></span></h3>
    </div>

    {{else}}
    <div>
        <h3>Please <a href="/login">log in</a></h3>
    </div>
    {{end}}

    <form method="POST">
        <input type="hidden" value="" id="input1" name="ballot">
        <div class="row">
            <div class="column">
                <h2>Human</h2>
                <img src="/static/human.jpg" alt="Human" style="width:90%;" onclick="humanClick()">
            </div>
            <div class="column">
                <h2>Humanoid</h2>
                <img src="/static/humanoid.jpg" alt="Humanoid" style="width:90%;" onclick="humanoidClick()">
            </div>
        </div>
        <button type="submit" style="display: none;" id="button1"></button>

    </form>

    <div>
        <h3>status: {{.Status}}</h3>
    </div><br />
</body>
<script>
    function humanClick() {
        document.getElementById("input1").value = "human"
        document.getElementById("button1").click()
    }

    function humanoidClick() {
        document.getElementById("input1").value = "humanoid"
        document.getElementById("button1").click()
    }
</script>

</html>

-------------------------------
//index.css
.column {
    flex: 50%;
    padding: 10px;
    text-align: center;
  }

.row {
    display: flex;
  }

  img {
    display: block;
    margin-left: auto;
    margin-right: auto;
    cursor: pointer;
  }

  img:hover { 
    border: 3px solid red; 
  } 

reference:

mongodb update

Wednesday, 4 November 2020

go web app 16 authentication mongodb

 
index page, not logged in

try logging in, but user not exist

create a new account

new account created, redirect to log in

register duplicate driver license will be rejected.
server search mongodb first, only add new user

user added to mongodb

logged in, sign out

sign out page, view ballots redirect to index page

logged out

//tutorial.go

package main

import (
"context"
"fmt"
"html/template"
"log"
"net/http"
"time"

"github.com/gorilla/mux"
"github.com/gorilla/sessions"
"golang.org/x/crypto/bcrypt"

"go.mongodb.org/mongo-driver/bson"
"go.mongodb.org/mongo-driver/bson/primitive"
"go.mongodb.org/mongo-driver/mongo"
"go.mongodb.org/mongo-driver/mongo/options"
)

type auth struct {
Username string
Password []byte
Status   string
}

var templates *template.Template
var store = sessions.NewCookieStore([]byte("secret"))

func indexGetHandler(w http.ResponseWriter, r *http.Request) {

session, _ := store.Get(r, "session")
registeredUser, _ := session.Values["username"]
registeredHashedPassword, _ := session.Values["password"]
status, _ := session.Values["status"]

if registeredUser == nil || registeredHashedPassword == nil || status == nil {
templates.ExecuteTemplate(w, "index.html", nil)
return
}

templates.ExecuteTemplate(w, "index.html",
auth{Username: registeredUser.(string),
Password: registeredHashedPassword.([]byte), Status: status.(string)})
}

func loginGetHandler(w http.ResponseWriter, r *http.Request) {
session, _ := store.Get(r, "session")
registeredUser, _ := session.Values["username"]
//registeredHashedPassword, _ := session.Values["password"]
status, _ := session.Values["status"]

if registeredUser == nil || status == nil {
templates.ExecuteTemplate(w, "login.html", nil)
return
}

templates.ExecuteTemplate(w, "login.html",
auth{Username: registeredUser.(string),
Status: status.(string)})

}

func loginPostHandler(w http.ResponseWriter, r *http.Request) {
r.ParseForm()
username := r.PostForm.Get("username")
password := r.PostForm.Get("password")

var userAuth auth
userAuth = findUser(username)
if userAuth.Status != "voter found" {
templates.ExecuteTemplate(w, "login.html",
auth{Status: "voter not exist"})
return
}

err := bcrypt.CompareHashAndPassword(userAuth.Password, []byte(password))

if err != nil || username != userAuth.Username {
templates.ExecuteTemplate(w, "login.html",
auth{Status: "username password mismatch"})
return
}

session, _ := store.Get(r, "session")
session.Values["username"] = username
session.Values["password"] = userAuth.Password
session.Values["status"] = "logged in as " + username
session.Save(r, w)

http.Redirect(w, r, "/", 302)

}

func logoutGetHandler(w http.ResponseWriter, r *http.Request) {
session, _ := store.Get(r, "session")
session.Values["username"] = nil
session.Values["password"] = nil
session.Values["status"] = nil
session.Save(r, w)

templates.ExecuteTemplate(w, "logout.html", nil)
}

func registerGetHandler(w http.ResponseWriter, r *http.Request) {
templates.ExecuteTemplate(w, "register.html", nil)
}

func registerPostHandler(w http.ResponseWriter, r *http.Request) {
r.ParseForm()
username := r.PostForm.Get("username")
password := r.PostForm.Get("password")

cost := bcrypt.DefaultCost
hashedPassword, err := bcrypt.GenerateFromPassword([]byte(password), cost)
if err != nil {
templates.ExecuteTemplate(w, "register.html", auth{Status: "password not accepted"})
return
}

status := addUser(username, hashedPassword)

session, _ := store.Get(r, "session")
        session.Values["username"] = username
session.Values["status"] = status
session.Save(r, w)

http.Redirect(w, r, "/login", 302)
}

func addUser(user string, password []byte) string {
client, err := mongo.NewClient(options.Client().ApplyURI("mongodb+srv://bob:password@cluster0.yvyo2.mongodb.net/test?retryWrites=true&w=majority"))
if err != nil {
log.Fatal(err)
}
ctx, _ := context.WithTimeout(context.Background(), 100*time.Second)
err = client.Connect(ctx)
if err != nil {
return "error connecting to database"
}
defer client.Disconnect(ctx)

electionDatabase := client.Database("sample_election")
votersCollection := electionDatabase.Collection("voters")

//check if voter exist
var userAuth auth
userAuth = findUser(user)
if userAuth.Status == "voter found" {
return "You are registered already, please log in."
}

address, err := votersCollection.InsertOne(ctx, bson.D{
{"user", user},
{"password", password},
})
if err != nil {
return "error adding new voter"
}

fmt.Println("inserted", user, "@ ", address)
return "new volter profile created"
}

func findUser(user string) auth {
client, err := mongo.NewClient(options.Client().ApplyURI("mongodb+srv://bob:password@cluster0.yvyo2.mongodb.net/test?retryWrites=true&w=majority"))
if err != nil {
log.Fatal(err)
}
ctx, _ := context.WithTimeout(context.Background(), 100*time.Second)
err = client.Connect(ctx)
if err != nil {
return auth{Status: "error connecting to database"}
}
defer client.Disconnect(ctx)

electionDatabase := client.Database("sample_election")
votersCollection := electionDatabase.Collection("voters")

filterCursor, err := votersCollection.Find(ctx, bson.M{"user": user})
defer filterCursor.Close(ctx)
if err != nil {
return auth{Status: "voter not found"}
}

var userAuth bson.M
var userLiscense string
var userPassword []byte

filterCursor.Next(ctx)
if err = filterCursor.Decode(&userAuth); err != nil {
return auth{Status: "error connecting to database 2"}
}

for k, v := range userAuth {
if k == "user" {
userLiscense = v.(string)
}
if k == "password" {
userPassword = v.(primitive.Binary).Data
//fmt.Println(reflect.TypeOf(v))
}
}

return auth{Username: userLiscense, Password: userPassword, Status: "voter found"}
}

func main() {
templates = template.Must(template.ParseGlob("templates/*.html"))
r := mux.NewRouter()
r.HandleFunc("/", indexGetHandler).Methods("GET")
//r.HandleFunc("/", indexPostHandler).Methods("POST")
r.HandleFunc("/login", loginGetHandler).Methods("GET")
r.HandleFunc("/login", loginPostHandler).Methods("POST")
r.HandleFunc("/logout", logoutGetHandler).Methods("GET")
r.HandleFunc("/register", registerGetHandler).Methods("GET")
r.HandleFunc("/register", registerPostHandler).Methods("POST")
fs := http.FileServer(http.Dir("./static/"))
r.PathPrefix("/static/").Handler(http.StripPrefix("/static/", fs))
http.Handle("/", r)
http.ListenAndServe(":8000", nil)
}

------------------------------------
//index.html
<html>

<head>
    <title> Templates</title>
    <link rel="stylesheet" type="text/css" href="/static/index.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
</head>

<body>
    <div style="text-align: center;">
        <h1>World Election of Year 3000 </h1>
    </div>

    {{if .Username}}
    <div>I ({{.Username}}) vote for</div>
    <div><a href="/logout">sign out</a></div>
    {{else}}
    <div>Please <a href="/login">log in</a></div>
    {{end}}
    <!--
    <form method="POST">
        <textarea name="textarea1"></textarea>
        <div>
            <button type="submit">Post Comment</button>
        </div>
    </form>
    -->
    <div>status: {{.Status}}</div><br />
</body>

</html>

-------------------------------
//login.html
<html>

<head>
    <title>Login</title>
</head>

<body>
    <h1>Log In</h1>
    <form method="POST">
        <div> Driver's Liscense: <input name="username"></div><br />
        <div></div>Password: <input name="password"></div><br />
        <div> <a href="/register">create new account</a></div><br /><br />
        <div> <button type="submit">Login</button></div>
    </form>
    <div>status: {{.Status}}</div><br />
</body>

</html>

---------------------------------
//register.html
<html>

<head>
    <title>Register</title>
</head>

<body>
    <h1>Registration</h1>
    <form method="POST">
        <div> Driver's Liscense: <input name="username"></div><br />
        <div><input type="button" onclick="inputClick(); this.value=' &#10004'" value='voter validation'></input>
        </div><br />
        <div></div>Password: <input name="password"></div><br /><br />
        <div> <button type="submit" id="button1" disabled>Register</button></div><br />
    </form>
    <div>status: {{.Status}}</div><br />
</body>

<script>
    function inputClick() {
        document.getElementById('button1').disabled = false;
    }
</script>

</html>

reference:

mongodb insert

mongodb query

ArriveCAN

 2020 年 11 月 2 日,加拿大公共卫生署在首都渥太华颁布了对前往加拿大的旅行者拟定的新的强制要求!

具体内容如下:

作为加拿大减缓 COVID-19 疫情传播努力的一部分,所有旅行者在进入加拿大之时和之 后都要求必须提供一些具体信息。包括要求提供隔离计划以及联系和旅行信息。加拿大联 邦政府于 2020 年 4 月推出了 ArriveCAN(抵达加拿大),创建一种安全且对用户友好的 方式来帮助旅行者遵守这些边境措施。ArriveCAN 可以作为一种手机应用程序、也可通 过在线登陆来使用。

11 月 2 日,加拿大政府宣布了对前往加拿大旅行者的新的强制性要求。

抵达加拿大之前:

自 2020 年 11 月 21 日起,最终目的地为加拿大的航空旅行者将被要求在登机之前通过 ArriveCAN 电子提交信息。这包括旅行和联系信息、隔离计划(除非依照《强制隔离令》 中规定的条件下获得豁免)以及 COVID-19 症状自我评估。寻求入境加拿大的旅行者必 须准备出示 ArriveCAN 收据;边境服务官员将核实他们已经以数字方式所提交的信息。在登机前没有以数字方式提交所需信息的旅客可能会受到执法行动的处罚,从口头警告到 罚款 1,000 元不等。对于那些由于个人情况(例如残疾或基础设施不足)而无法以电子方 式提交文件的人将作例外处理。

 从 2020 年 11 月 4 日开始,航空承运商将会提醒航空旅客在登机飞往加拿大之前需要通 过 ArriveCAN 以数字方式提交与 COVID 相关的信息。

从即刻开始,强烈建议通过陆路或海路方式进入加拿大的旅客继续使用 ArriveCAN,他 们可以下载手机应用程序或在线登录,在到达之前提供必要的信息,以避免因必须接受公共卫生问询而延误行程,并避免在边境与他人过多接触。旅行者在寻求入境加拿大时,可 向边境服务官员出示 ArriveCAN 收据。

抵达加拿大之后:

自 2020 年 11 月 21 日起,通过空中、陆路或海路方式进入加拿大的旅行者,除非依照 《强制隔离令》规定的条件获得豁免,还要求他们在免疫隔离或自我隔离期间通过 ArriveCAN 或致电免费电话 1-833-641- 0343 申报。入境加拿大后的 48 小时内,旅行者 必须确认他们已到达检疫或自我隔离地点,而被检疫隔离的人士必须在检疫隔离期内完成 每日的 COVID-19 症状自我评估。

在进入加拿大前未使用 ArriveCAN 提交信息的旅行者将被要求在整个检疫隔离或自我隔 离期间每天拨打免费电话 1-833-641-0343,提供他们入境之后的信息。他们不可转换到 使用 ArriveCAN 状态。

入境后未提交必须提交信息的旅行者,将被执法部门视为高度优先的跟进事项。

这是遏止 COVID-19 疫情传播的重要一步,因为旅行者的信息可以快速而安全地分享给 当地省和地区,以便与旅行者联系进行公共卫生跟进,并可分享给执法部门以核实是否符 合《强制隔离令》。

在所有入境旅行途径中以数字形式提交信息,还将帮助旅行者减少在边境口岸的处理时间, 并限制旅行者与边境服务官员和加拿大公共卫生局官员之间的身体接触。这样可以保护旅 行者和官员的健康和安全。

ArriveCAN 应用程序可以在安卓平台的 Google Play 或 iOS 平台的 App Store 中下载。旅 行者还可以通过在线登录来提交其信息。

事实简要

最终目的地不是加拿大的过境乘客无需通过 ArriveCAN 提交信息。

如果旅行者在通过 ArriveCAN 提交信息时可能遇到困难,可以从 Canada.ca/ArriveCAN 获得更多信息或发送电子邮件至 phac.arrivecan.aspc@canada.ca。

如因个人情况(例如残疾或基础设施不足)而无法以电子方式提交文件的人,将可 作例外处理。

一些主要的国际机场将为 ArriveCAN 用户提供更快处理的专设通道,包括:温哥华国际机场、卡尔加里国际机场、多伦多皮尔逊国际机场和蒙特利尔皮埃尔·埃利 奥特·特鲁多国际机场。

ArriveCAN 不使用任何技术或数据(例如 GPS)来监视或跟踪旅行者的行动。您 的隐私受到保护。

加拿大政府在边境上采取多种措施,以减少 COVID-19 疫情在加拿大的扩散。现 行的各种旅行限制仍然存在。加拿大政府继续建议加拿大人避免任何非必要的加拿 大境外旅行。加拿大的官方全球旅行建议、游轮建议和 COVID-19 疫情大流行旅 行卫生通告仍在生效。

Monday, 2 November 2020

新冠免疫恐怕希望渺茫

 一名俄罗斯的科学家为了验证群体免疫的可能性,铤而走险让自己第二次染上新冠病毒,然而结果却让他感到失望!

今年69岁的亚历山大·切普尔诺夫(Alexander Chepurnov)博士曾在制造俄罗斯新冠疫苗EpiVacCorona的国家病毒学和生物技术研究媒介中心(State Research Vector Centre of Virology and Biotechnology )工作。

今年2月他从法国滑雪归来,飞往新西伯利亚时中途停留在莫斯科,结果首次感染了新冠病毒。

切普尔诺夫此次是轻度感染无需住院,在自家休养后就逐渐康复。此后他和他研究所的团队就展开了有关新冠病毒抗体的研究,竟发现抗体在他的体内迅速下降,直至消失!

切普尔诺夫博士的团队研究了新冠病毒抗体的行为方式、强度和在人体内能停留多久。他表示:“从我感到生病的那一刻起,到第三个月末,我们就不再能检测到抗体了。”

很多人寄希望于感染新冠病毒后能就此免疫,但既然病毒抗体几个月就消失了,那人们是不是会再次感染呢?切普尔诺夫决心拿自己当实验的小白鼠,来衡量群体免疫的可能性。

在首次感染后6个月,他故意毫无防护措施地身处在新冠患者周围,把自己暴露在可能充满病毒的环境中,直到再次确诊阳性!

第二次感染来势汹汹,已经年近70岁的切普尔诺夫博士这次直接病倒住院了。他感到嗓子痛,连续5天一直高烧39度以上,嗅觉和味觉也出现了问题,情况似乎越来越糟。

在切普尔诺夫患新冠的第6天,CT扫描还显示他的肺部是清楚无阴影的;等到3天后再照X光,已经显示出左右肺部双肺炎!

幸运的是,切普尔诺夫再次从新冠肺炎的侵害中挺了过来。在大约两周后,他的鼻咽道和其他样本中都不再能检测到该病毒。但切普尔诺夫博士也就此得出了遗憾的实验结果:指望群体免疫来对抗新冠病毒恐怕希望渺茫!

切普尔诺夫博士表示,新冠病毒将继续存在,而疫苗虽然可以产生免疫力,但可能只是暂时的效果。

切普尔诺夫博士也强调:“我们需要可以多次使用的疫苗,重组腺病毒载体并不适合。这种疫苗无法注射后重复使用,因为针对腺病毒载体的免疫力将继续干扰疫苗的效果。”

目前全球在研究的新冠疫苗有多种不同原理,比如有灭活病毒疫苗、重组蛋白疫苗、核酸疫苗、腺病毒载体疫苗等等。

此前俄罗斯已给重要工作者使用、包括普京女儿也已注射的疫苗“卫星V”(Sputnik V)就是腺病毒载体疫苗;而已通过审批的第二种疫苗EpiVacCorona,也需要重复注射以保持免疫力。

有关群体免疫的结论,也与英国研究人员的最新报告不谋而合。英国伦敦帝国理工学院(The Imperial College London)在27日发表一项最新研究,表示英国民众感染新冠病毒后获得的抗体保持率从6月底的6%下降至9月份的4.4%,对新冠的免疫能力在夏季“迅速消失”!

换句话说,即便人们已经感染过新冠病毒,并痊愈获得抗体,免疫作用也不能维持很长时间,很可能需要每年接种疫苗2次!

虽然仍有很多科学家认为新冠病毒出现的时间不长,它对人体的影响力还需要更多观察和试验,现在就做出判断太过片面。不过如此看来,人类与新冠病毒之间还有很长的战役要打,并不是简单地等到疫苗出现、有了抗体就万事大吉了。无论如何,还是希望大家多加防范!

Sunday, 1 November 2020

go webapp 15 bcrypt password

 
register new user, user is saved on server memory, and browser cookie for testing

//cmd - print hashed password
C:\Users\bob\golang1>go run tutorial.go
current registration
username:  bob
hashed password:  [36 50 97 36 49 48 36 78 105 122 75 74 87 69 73 114 84 86 119 86 73 48 55 52 51 117 114 121 79 55 102 76 77 111 77 65 69 101 84 88 115 52 89 103 49 47 89 97 65 115 83 98 75 98 72 121 48 86 46 67]

                                           
redirected to login page, retrieve user from cookie, password is hashed by bcrypt

login -> server compare user entry with user on server memory with bcrypt
if they are different, login fail

                                          
if match is found, login successful

//tutorial.go

package main

import (
//"fmt"
"fmt"
"html/template"
"net/http"

"github.com/gorilla/mux"
"github.com/gorilla/sessions"
"golang.org/x/crypto/bcrypt"
)

type car struct {
Color   string
Mileage int
Model   string
}

type auth struct {
Username string
Password []byte
Status   string
}

var templates *template.Template
var store = sessions.NewCookieStore([]byte("secret"))
var testUsername = ""
var testPassword = []byte("")


var truck = car{
Color:   "black",
Mileage: 12345,
Model:   "F-150",
}

var sedan = car{
Color:   "white",
Mileage: 321,
Model:   "Corolla",
}

func indexGetHandler(w http.ResponseWriter, r *http.Request) {
templates.ExecuteTemplate(w, "index.html", []car{truck, sedan})
}


func loginGetHandler(w http.ResponseWriter, r *http.Request) {
session, _ := store.Get(r, "session")
registeredUser, _ := session.Values["username"]
registeredHashedPassword, _ := session.Values["hashedPassword"]

templates.ExecuteTemplate(w, "login.html",
auth{Password: registeredHashedPassword.([]byte), Username: registeredUser.(string)})
}

func loginPostHandler(w http.ResponseWriter, r *http.Request) {
r.ParseForm()
username := r.PostForm.Get("username")
password := r.PostForm.Get("password")
err := bcrypt.CompareHashAndPassword(testPassword, []byte(password))

if err != nil || username != testUsername {
templates.ExecuteTemplate(w, "login.html",
auth{Password: testPassword, Username: testUsername, Status: "failed"})
} else {
templates.ExecuteTemplate(w, "login.html",
auth{Password: testPassword, Username: testUsername, Status: "succcess"})
}
}

func registerGetHandler(w http.ResponseWriter, r *http.Request) {
templates.ExecuteTemplate(w, "register.html", nil)
}

func registerPostHandler(w http.ResponseWriter, r *http.Request) {
r.ParseForm()
username := r.PostForm.Get("username")
password := r.PostForm.Get("password")

cost := bcrypt.DefaultCost
hashedPassword, err := bcrypt.GenerateFromPassword([]byte(password), cost)
if err != nil {
return
}
testUsername = username
testPassword = hashedPassword
fmt.Println("current registration")
fmt.Println("username: ", username)
fmt.Println("hashed password: ", hashedPassword)

session, _ := store.Get(r, "session")
session.Values["username"] = username
session.Values["hashedPassword"] = hashedPassword
session.Save(r, w)

http.Redirect(w, r, "/login", 302)
}

func main() {
templates = template.Must(template.ParseGlob("templates/*.html"))
r := mux.NewRouter()
r.HandleFunc("/", indexGetHandler).Methods("GET")
//r.HandleFunc("/", indexPostHandler).Methods("POST")
r.HandleFunc("/login", loginGetHandler).Methods("GET")
r.HandleFunc("/login", loginPostHandler).Methods("POST")
r.HandleFunc("/register", registerGetHandler).Methods("GET")
r.HandleFunc("/register", registerPostHandler).Methods("POST")
fs := http.FileServer(http.Dir("./static/"))
r.PathPrefix("/static/").Handler(http.StripPrefix("/static/", fs))
http.Handle("/", r)
http.ListenAndServe(":8000", nil)
}

-----------------------------------------
//login.html
<html>

<head>
    <title>Login</title>
</head>

<body>
    <form method="POST">
        <div> Username: <input name="username"></div><br />
        <div></div>Password: <input name="password"></div><br />
        <div> <a href="/register">create new account</a></div><br /><br />
        <div> <button type="submit">Login</button></div>
    </form>
    <div>authentication status: {{.Status}}</div><br />
    <div>current registered user</div>
    <div>username: {{.Username}}</div>
    <div>password: {{.Password}}</div>
</body>

</html>

--------------------------------------------
//register.html
<html>

<head>
    <title>Register</title>
</head>

<body>
    <form method="POST">
        <div> Username: <input name="username"></div><br />
        <div></div>Password: <input name="password"></div><br /><br />
        <div> <button type="submit">Register</button></div><br />
    </form>
</body>

</html>

reference:

go session

go template

Stellaris: Galaxy Command (iOS/Android)