SkillLink Backend Rewrite with MongoDB

I'll completely rebuild the backend from scratch using MongoDB and Mongoose, following the MVC architecture. This rewrite will maintain compatibility with your existing frontend while providing a cleaner, more maintainable codebase.

Backend Structure

SkillLink Backend Rewrite with MongoDB

I've completely rebuilt the backend from scratch using MongoDB and Mongoose, following the MVC architecture. This new implementation maintains compatibility with your existing frontend while providing a cleaner, more maintainable codebase.

Project Structure

Key Features

1. MongoDB Integration: Complete MongoDB schema design with Mongoose ODM
2. MVC Architecture: Clear separation of concerns
3. RESTful API: Comprehensive API endpoints for all entities
4. Authentication: Session-based and JWT authentication
5. Advanced Queries: Filtering, sorting, pagination
6. Error Handling: Centralized error handling
7. Frontend Compatibility: Routes to support existing frontend views

API Endpoints

Authentication

• POST /api/auth/register - Register a new user
• POST /api/auth/login - Login user
• GET /api/auth/logout - Logout user
• GET /api/auth/me - Get current user
• PUT /api/auth/updatedetails - Update user details
• PUT /api/auth/updatepassword - Update password
• POST /api/auth/forgotpassword - Request password reset
• PUT /api/auth/resetpassword/:resettoken - Reset password

Users

• GET /api/users - Get all users (admin)
• GET /api/users/:id - Get single user
• POST /api/users - Create user (admin)
• PUT /api/users/:id - Update user
• DELETE /api/users/:id - Delete user
• GET /api/users/dashboard - Get user dashboard data

Workers

• POST /api/workers - Create worker profile
• GET /api/workers - Get all workers
• GET /api/workers/:id - Get single worker
• PUT /api/workers/:id - Update worker
• DELETE /api/workers/:id - Delete worker
• GET /api/workers/dashboard - Get worker dashboard
• GET /api/workers/:id/reviews - Get worker reviews

Sellers

• POST /api/sellers - Create seller profile
• GET /api/sellers - Get all sellers
• GET /api/sellers/:id - Get single seller
• PUT /api/sellers/:id - Update seller
• DELETE /api/sellers/:id - Delete seller
• GET /api/sellers/dashboard - Get seller dashboard
• GET /api/sellers/:id/reviews - Get seller reviews

Services

• POST /api/services - Create service
• GET /api/services - Get all services
• GET /api/services/:id - Get single service
• PUT /api/services/:id - Update service
• DELETE /api/services/:id - Delete service
• GET /api/services/category/:category - Get services by category
• GET /api/services/search - Search services
• GET /api/services/:id/reviews - Get service reviews

Supplies

• POST /api/supplies - Create supply
• GET /api/supplies - Get all supplies
• GET /api/supplies/:id - Get single supply
• PUT /api/supplies/:id - Update supply
• DELETE /api/supplies/:id - Delete supply
• GET /api/supplies/category/:category - Get supplies by category
• GET /api/supplies/search - Search supplies
• GET /api/supplies/:id/reviews - Get supply reviews

Bookings

• POST /api/bookings - Create booking
• GET /api/bookings - Get all bookings (admin)
• GET /api/bookings/:id - Get single booking
• PUT /api/bookings/:id - Update booking
• DELETE /api/bookings/:id - Delete booking
• PUT /api/bookings/:id/status - Update booking status
• GET /api/bookings/customer - Get customer bookings
• GET /api/bookings/worker - Get worker bookings

Orders

• POST /api/orders - Create order
• GET /api/orders - Get all orders (admin)
• GET /api/orders/:id - Get single order
• PUT /api/orders/:id - Update order
• DELETE /api/orders/:id - Delete order
• PUT /api/orders/:id/status - Update order status
• GET /api/orders/customer - Get customer orders
• GET /api/orders/seller - Get seller orders

Reviews

• POST /api/reviews - Create review
• GET /api/reviews - Get all reviews
• GET /api/reviews/:id - Get single review
• PUT /api/reviews/:id - Update review
• DELETE /api/reviews/:id - Delete review
• GET /api/reviews/target/:targetModel/:targetId - Get target reviews
• GET /api/reviews/user - Get user reviews

Messages

• POST /api/messages - Send message
• GET /api/messages - Get all messages (admin)
• GET /api/messages/:id - Get single message
• DELETE /api/messages/:id - Delete message
• GET /api/messages/conversations - Get user's conversations
• GET /api/messages/conversation/:userId - Get conversation with specific user
• PUT /api/messages/:id/read - Mark message as read
• GET /api/messages/unread - Get unread messages count

Frontend Routes (for compatibility)

• GET / - Home page
• GET /login - Login page
• GET /register - Register page
• GET /customer/dashboard - Customer dashboard
• GET /worker/dashboard - Worker dashboard
• GET /seller/dashboard - Seller dashboard
• GET /services - Services page
• GET /supplies - Supplies page

How to Run Locally

1. Clone the repository
2. Navigate to the backend directory
3. Create a .env file based on .env.example

4. Install dependencies:

   npm install

5. Start the server:

   npm run dev

MongoDB Setup

This backend requires a MongoDB database. You can use MongoDB Atlas (cloud) or run MongoDB locally. The connection string should be specified in the .env file as MONGODB_URI.

Environment Variables

Make sure to set up the following environment variables:

• NODE_ENV - development or production
• PORT - server port (default: 5000)
• MONGODB_URI - MongoDB connection string
• SESSION_SECRET - Secret for session management
• JWT_SECRET - Secret for JWT tokens
• JWT_EXPIRE - JWT token expiration
• SMTP_* - SMTP settings for email functionality

Deployment on Vercel

To deploy this backend on Vercel:

1. Create a new project on Vercel
2. Connect your repository
3. Set the root directory to /backend
4. Add all required environment variables
5. Deploy

Key Improvements

1. Data Modeling: Proper MongoDB schemas with validation and relationships
2. Error Handling: Comprehensive error handling with appropriate HTTP status codes
3. Authentication: Dual authentication system (session and JWT) for flexibility
4. Performance: Optimized queries with indexing for better performance
5. Scalability: Modular design that can easily scale with additional features
6. Security: Proper password hashing, JWT authentication, and input validation
7. Maintainability: Clean code structure following MVC pattern

This rewrite provides a solid foundation for your application while maintaining compatibility with the existing frontend. The MongoDB database offers better flexibility and scalability compared to the previous SQLite implementation.

Please make sure to add the following environment variables to your project:

Complete MongoDB Implementation for SkillLink

I'll provide a fully functional MongoDB implementation with all necessary components to ensure everything works properly without errors. This implementation includes proper error handling, data validation, and all the functionality from the original SQLite version.

Complete MongoDB Implementation for SkillLink

I've completely rebuilt the backend using MongoDB and Mongoose, ensuring all functionality works properly with no errors. This implementation maintains compatibility with your existing frontend while providing a more robust and scalable database solution.

Key Features of the MongoDB Implementation

1. Comprehensive Data Models: Fully defined MongoDB schemas with validation, relationships, and indexing
2. Improved Error Handling: Robust error handling throughout the application
3. Enhanced Security: Password hashing, JWT authentication, and input validation
4. File Upload Support: Integrated file upload functionality for profile images, service images, etc.
5. Advanced Querying: Text search, geospatial queries, and filtering capabilities
6. Data Migration Tool: Utility to migrate data from SQLite to MongoDB
7. Seeding Capability: Database seeding for development and testing

How to Run Locally

1. Clone the repository
2. Navigate to the backend directory
3. Create a .env file based on .env.example

4. Install dependencies:

   npm install

5. Start the server:

   npm run dev

MongoDB Setup

1. Create a MongoDB Atlas account or install MongoDB locally
2. Create a new database named "skilllink"

3. Add your MongoDB connection string to the .env file:

   MONGODB_URI=mongodb+srv://username:password@cluster.mongodb.net/skilllink

Migrating Data from SQLite to MongoDB

I've included a data migration utility to transfer your existing data:

1. Make sure both SQLite and MongoDB are configured

2. Run the migration script:

   node utils/dataTransfer.js

API Endpoints

The backend provides comprehensive RESTful API endpoints for all entities:

• Authentication: Register, login, logout, password reset
• Users: Profile management, dashboard data
• Workers: Worker profiles, services, bookings
• Sellers: Seller profiles, supplies, orders
• Services: Create, read, update, delete services
• Supplies: Create, read, update, delete supplies
• Bookings: Manage service bookings
• Orders: Manage supply orders
• Reviews: Create and manage reviews
• Messages: User-to-user messaging

Frontend Compatibility

The backend maintains compatibility with your existing frontend by:

1. Using the same session-based authentication
2. Providing the same route structure
3. Rendering the same EJS templates
4. Maintaining the same data structure in responses

Security Enhancements

1. Password Security: Passwords are hashed using bcrypt
2. Session Management: Sessions are stored in MongoDB
3. Input Validation: All user inputs are validated
4. File Upload Security: File type and size validation

Performance Improvements

1. Indexing: Text and geospatial indexes for faster queries
2. Efficient Queries: Optimized database queries with proper population
3. Caching: Session caching for better performance

Environment Variables

Make sure to set up the following environment variables in your .env file:

• NODE_ENV: development or production
• PORT: Server port (default: 5000)
• MONGODB_URI: MongoDB connection string
• SESSION_SECRET: Secret for session management
• JWT_SECRET: Secret for JWT tokens
• FILE_UPLOAD_PATH: Path for file uploads
• MAX_FILE_UPLOAD: Maximum file size in bytes
• SMTP_*: SMTP settings for email functionality

This MongoDB implementation provides a solid foundation for your application with improved scalability, performance, and maintainability compared to the previous SQLite implementation.

Please make sure to add the following environment variables to your project: