my-todo-app/
│
├── public/                     ← Files deployed to Firebase Hosting
│   ├── index.html              ← Main app: HTML + CSS + JS (all-in-one)
│   └── 404.html                ← Custom 404 page (auto-created by Firebase)
│
├── .firebaserc                 ← Active Firebase project reference
├── firebase.json               ← Firebase hosting configuration
│
└── (future)
    ├── main.py                 ← Python Flask API for Cloud Run
    ├── Dockerfile              ← Docker container config
    └── requirements.txt        ← Python dependencies

{
  "projects": {
    "default": "my-todo-app-4dc76"
  }
}

{
  "hosting": {
    "public": "public",
    "ignore": [
      "firebase.json",
      "**/.*",
      "**/node_modules/**"
    ]
  }
}

# Install Node.js first from nodejs.org, then run:
npm install -g firebase-tools

# Verify installation
firebase --version    # Should print: 13.x.x

# Login to your Google account
firebase login        # Opens browser for Google auth

const firebaseConfig = {
  apiKey:            "AIzaSyDAQnYbn2ikrtC8YF7ABHRITkzFGhUeS9I",
  authDomain:        "my-todo-app-4dc76.firebaseapp.com",
  projectId:         "my-todo-app-4dc76",
  storageBucket:     "my-todo-app-4dc76.firebasestorage.app",
  messagingSenderId: "599715420588",
  appId:             "1:599715420588:web:4c79c01c6d149a8cf64209",
  databaseURL:       "https://my-todo-app-4dc76-default-rtdb.firebaseio.com"
};

const auth = firebase.auth();
const provider = new firebase.auth.GoogleAuthProvider();

// Sign in with Google popup
function signInWithGoogle() {
  auth.signInWithPopup(provider)
    .catch(err => console.error('Login failed:', err));
}

// Sign out
function signOut() {
  auth.signOut();
}

// Reactive state listener — fires on login/logout automatically
auth.onAuthStateChanged(user => {
  if (user) {
    // User logged in — user object contains:
    console.log(user.uid);          // Unique user ID
    console.log(user.displayName);  // "Rakesh Oza"
    console.log(user.email);        // "rakesh@gmail.com"
    console.log(user.photoURL);     // Profile picture URL
    loadTasks(user.email);
  } else {
    showLoginPage();
  }
});

CREATE TABLE todos (
  id          BIGSERIAL     PRIMARY KEY,            -- Auto-increment PK
  task        TEXT          NOT NULL,               -- Task description
  priority    TEXT          DEFAULT 'medium',       -- high / medium / low
  done        BOOLEAN       DEFAULT false,         -- Completion flag
  assigned_by TEXT,                                 -- Creator name
  assign_to   TEXT,                                 -- Assignee name
  assign_date DATE,                                 -- Assignment date
  due_date    DATE,                                 -- Deadline
  user_email  TEXT,                                 -- Owner (privacy scope)
  created_at  TIMESTAMPTZ   DEFAULT NOW()           -- Auto timestamp
);

-- Disable RLS (learning project — trusts all authenticated users)
ALTER TABLE todos DISABLE ROW LEVEL SECURITY;

-- Grant REST API access
GRANT ALL ON todos TO anon;
GRANT ALL ON todos TO authenticated;
GRANT USAGE, SELECT ON SEQUENCE todos_id_seq TO anon;
GRANT USAGE, SELECT ON SEQUENCE todos_id_seq TO authenticated;

-- READ: All tasks for a user, sorted by urgency
SELECT * FROM todos
WHERE user_email = 'rakesh@gmail.com'
ORDER BY done ASC, due_date ASC;

-- CREATE: Add a new task
INSERT INTO todos (task, priority, assigned_by, assign_to, assign_date, due_date, user_email)
VALUES ('Employee ID generation', 'high', 'Manager', 'Rakesh', '2026-03-18', '2026-03-20', 'rakesh@gmail.com');

-- UPDATE: Mark task as done
UPDATE todos SET done = true WHERE id = 1;

-- DELETE: Remove task
DELETE FROM todos WHERE id = 1;

-- REPORT: Overdue tasks
SELECT * FROM todos
WHERE due_date < CURRENT_DATE AND done = false;

-- REPORT: Dashboard summary counts
SELECT
  COUNT(*) AS total,
  COUNT(CASE WHEN done THEN 1 END) AS completed,
  COUNT(CASE WHEN NOT done THEN 1 END) AS pending,
  COUNT(CASE WHEN due_date < CURRENT_DATE AND NOT done THEN 1 END) AS overdue
FROM todos;

from flask import Flask, jsonify, request
from supabase import create_client
import os

app = Flask(__name__)
supabase = create_client(os.environ['SUPABASE_URL'], os.environ['SUPABASE_KEY'])

# GET — All tasks for a user
@app.route('/tasks', methods=['GET'])
def get_tasks():
    user_email = request.args.get('user_email')
    result = supabase.table('todos').select('*').eq('user_email', user_email).execute()
    return jsonify(result.data)

# POST — Add a new task
@app.route('/tasks', methods=['POST'])
def add_task():
    result = supabase.table('todos').insert(request.json).execute()
    return jsonify(result.data[0]), 201

# PATCH — Mark as done
@app.route('/tasks/<int:id>', methods=['PATCH'])
def update_task(id):
    result = supabase.table('todos').update({'done': True}).eq('id', id).execute()
    return jsonify(result.data[0])

# DELETE — Remove task
@app.route('/tasks/<int:id>', methods=['DELETE'])
def delete_task(id):
    supabase.table('todos').delete().eq('id', id).execute()
    return jsonify({'message': 'Deleted'}), 204

if __name__ == '__main__':
    app.run(host='0.0.0.0', port=8080)

gcloud run deploy my-todo-api \
  --source . \
  --region us-central1 \
  --allow-unauthenticated \
  --set-env-vars SUPABASE_URL=https://xxx.supabase.co,SUPABASE_KEY=your_key

DATABASE_URL = (
    "postgresql://postgres:PASSWORD@/postgres"
    "?host=/cloudsql/my-todo-app-4dc76:us-central1:INSTANCE_NAME"
)

{
  "id":          1,
  "task":        "Employee ID generation",
  "priority":    "high",
  "done":        false,
  "assigned_by": "Rakesh Oza",
  "assign_to":   "WNS-Onboarding",
  "assign_date": "2026-03-18",
  "due_date":    "2026-03-20",
  "user_email":  "ozarakesh533@gmail.com",
  "created_at":  "2026-03-18T10:30:00+00:00"
}

{
  "iss":     "https://securetoken.google.com/my-todo-app-4dc76",
  "aud":     "my-todo-app-4dc76",
  "uid":     "abc123xyz789",
  "email":   "rakesh@gmail.com",
  "name":    "Rakesh Oza",
  "picture": "https://lh3.googleusercontent.com/a/...",
  "iat":     1710000000,   // Issued At (Unix timestamp)
  "exp":     1710003600    // Expires At (iat + 3600 seconds = 1 hour)
}

const response = await fetch(
  SUPABASE_URL + '/rest/v1/todos?user_email=eq.rakesh@gmail.com&order=created_at.desc',
  { headers: { 'apikey': SUPABASE_KEY, 'Authorization': 'Bearer ' + SUPABASE_KEY } }
);
const tasks = await response.json();

await fetch(SUPABASE_URL + '/rest/v1/todos', {
  method: 'POST',
  headers: { 'apikey': SUPABASE_KEY, 'Content-Type': 'application/json', 'Prefer': 'return=representation' },
  body: JSON.stringify({ task: 'Design mockup', priority: 'high', due_date: '2026-03-25', user_email: 'rakesh@gmail.com', done: false })
});

await fetch(SUPABASE_URL + '/rest/v1/todos?id=eq.42', {
  method: 'PATCH',
  headers: { 'apikey': SUPABASE_KEY, 'Content-Type': 'application/json', 'Prefer': 'return=minimal' },
  body: JSON.stringify({ done: true })
});

await fetch(SUPABASE_URL + '/rest/v1/todos?id=eq.42', {
  method: 'DELETE',
  headers: { 'apikey': SUPABASE_KEY, 'Prefer': 'return=minimal' }
});

# Setup
npm install -g firebase-tools            # Install Firebase CLI
firebase --version                       # Verify installation
firebase login                           # Authenticate with Google
firebase logout                          # Sign out

# Project management
firebase projects:list                   # List all projects
firebase use my-todo-app-4dc76          # Switch active project
firebase hosting:sites:list             # List hosting sites

# Deployment
firebase init hosting --project my-todo-app-4dc76   # Initialize hosting
firebase deploy                          # Deploy all
firebase deploy --only hosting           # Deploy hosting only
firebase deploy --debug                  # Verbose output

# Authentication
gcloud auth login                        # Login to GCP
gcloud config set project my-todo-app-4dc76

# Cloud Run
gcloud run deploy my-todo-api \
  --source . \
  --region us-central1 \
  --allow-unauthenticated
gcloud run services list
gcloud run services delete my-todo-api --region us-central1

# Cloud SQL
gcloud sql instances list
gcloud sql connect INSTANCE --user=postgres