todos.txt

Todos:
- stats on plots page: avg, last typing stats
- better looking avatar, plots page
- font sizes
- add icons
- code refactoring and use of classes
- multiplayer

https://api.github.com/search/repositories?q=language:python&sort=stars&order=desc
https://api.github.com/search/code?q=%20+language:python+repo:chubin/wttr.in
https://api.github.com/repos/chubin/wttr.in/contents/lib/globals.py
const decodeBase64Str = atob(response.content)

For theme toggle:
<div class="form-check form-switch">
	<input class="form-check-input" type="checkbox" role="switch" id="themeSwitch" checked>
	<label class="form-check-label" for="themeSwitch">Dark theme</label>
</div>
$("#themeSwitch").on('change', function(){ 
		console.log($(this).is(':checked'));
	}
);

to discard un commited changes:
git stash save --keep-index --include-untracked

<% if (error) { %>
      <div class="alert alert-danger"><%= error %></div>
    <% } %>

<% if (errorMessage) { %>
      <div class="alert alert-danger"><%= errorMessage %></div>
    <% } %>

CREATE TABLE users
(
    id serial primary key,
    email varchar(60) unique not null,
    password varchar(60) not null
);

CREATE TABLE avatar (
    avatar_id serial PRIMARY KEY,
    username VARCHAR(50) UNIQUE,
    avatar_character VARCHAR(50),
    xp INTEGER,
    level INTEGER,
	health INTEGER,
    user_id INTEGER UNIQUE,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

<% if (error) { %>
			<div class="alert alert-danger">
				<%= error %>
			</div>
		<% } %>
fix flash

to delete last n rows:
DELETE FROM users
WHERE id IN (
    SELECT id
    FROM users
    ORDER BY id DESC
    LIMIT 3
);

CREATE TABLE typing_session (
    session_id SERIAL PRIMARY KEY,
    session_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    wpm FLOAT NOT NULL,
    accuracy FLOAT NOT NULL,
	avatar_id INTEGER NOT NULL,
  	FOREIGN KEY (avatar_id) REFERENCES avatar(avatar_id)
);

npm i --save-dev nodemon

DELETE FROM typing_session WHERE accuracy = 'NaN';