SIMPLE TSKR APP USING Next.js & DRIZZLE

MYTODOS:

• Initial Cleanup
• Initial Tailwind theme setup
• Initial Planning

Initial Commit

• Essential Packages installations
• Drizzle / DB setup
  • Schema
  • Migration Setup
  • Initial Migration
  • Run First Insert Query
  • Run First Select Query

Chore db schema setup and connection testing

Docs docs update Fix removed unwanted apis

• Initial UnAuth Layout development
• Initial HomePage page development
• /api/auth/sign-up api development
• Initial Sign Up page development
• /api/auth/sign-in api development
• Initial Sign In page development
• AuthContext development
• access-token refresh on reload/load of the web-app
• Working sign Out BTN
• Create an Protected page

Add added authentication

• FIX THE DYNAMIC SERVER USAGE PROBLEM

Fix fixed dynamic server usage error

• SideNav development
• Add new project
• Have single AuthContextProvider and have it in RootLayout & make all routes dynamic.
• Display project lists in side-nav
• View Project page
• add a add-task fn in project-page
• List out all tasks on project-page
• Solve default timestamp's timezone bug
• Delete tasks
• Edit tasks
• View/Edit Project Note
• View/Edit Task Note
• Edit projects
• Archive projects
• Today
• Delete archived projects
• Final code review
• Build locally and test for errors/warns
• Update schema info in readme

Add added projects/tasks management

Fix timezone problem in today-api

• User Info page

• Change User info page

• Change password page

• Delete User functionality

• some actions directing user to signIn page on Auth failure remove it just send Authentication failed error

• Add count in view-project/today pages > completed tasks

Add added user management

• Responsivess

  • HomePage
  • Sign In
  • Sign Up
  • Main-Nav
  • App-SideNav
  • User-SideNav
  • Project-Form
  • TodoBar
  • Todo-Form
  • Today
  • Due
  • View-Project
  • Note-Form
  • Archives
  • User Pages
    • User-Info
    • Edit User-Info
    • Change Password
    • Delete Account
  • Info-States
    • Error
    • Loading
    • Auths

• Robots

• Finale testing

Fix fixed responsiveness and added robots.txt

Notes:

Schema:

Users

Column	Type	Nullable	Extra
id	Int	NO	Primary Key
FirstName	String	No
LastName	String	No
Username	String	NO	Unique
Email	String	No	Unique
Password	String	No
refreshToken	String	Yes	No

Projects

Column	Type	Nullable	Extra
id	Int	No	Primary Key
Name	String	No
Description	String	YES
Note	Text	YES
ColorCode	String	No
Archived	Boolean	NO	Default = NO
createdAt	INT	No	Default=UNIX_TIMESTAMP
archivedAt	Datetime	Yes
userId	INT	NO	Foreign Key

Tasks

Column	Type	Nullable	Extra
id	Int	No	Primary Key
Name	String	No
Note	Text	Yes
Done	Boolean	NO	Default = False
createdAt	INT	No	Default=UNIX_TIMESTAMP
Due	Datetime	YES
projectId	int	No	Foreign Key

Pages

• Home - A simple landing page with only a hero section
• Auth pages (Sign In & Up)
• Protected Pages
  • Main Tasks Pages
    • Today
    • Project Pages
    • Archived Projects
  • User info view/update