How yssf132/sheet2db-internship works
Project type and purpose
• Full-stack web application (“Sheet2DB”) for importing Excel/CSV into MongoDB.
• Provides file upload, preview, validation, column selection, batch import, and JWT-based authentication.
File structure
• Top‐level dirs:
– “frontend”: React 18 + TypeScript + Vite + Tailwind CSS + Axios + context/hooks/services/pages/components.
– “backend”: Node.js + Express + TypeScript + Mongoose + Multer + JWT. Follows an MVC-style layout:
· config (DB connection)
· controllers (Auth, Upload, Import, Preview, Ping)
· middleware (auth, validation, upload)
· routes
· services (DatabaseService, ImportService)
· models (User, ImportTypes)
· utils (ParseUtils, JWT utils, constants).
• Config files: .env, tsconfig.json, package.json, Vite config.
Extract architecture notes from README
• HTTP/REST interface from React Client ↔ Express Server.
• MongoDB (via Mongoose) as primary datastore.
• JWT for authentication; Multer for file handling.
• Workflow: Upload → Preview/Validate → Column Selection → Import → DB insertion.
Architectural patterns & design principles
• Frontend: component‐based + context + hooks (state management)
• Backend: MVC or layered architecture (controllers → services → models)
• Stateless auth (JWT)
• File‐upload pipeline: Multer → parse utils → validation → DB insertion
• Separation of concerns: UI vs API vs DB