Modern Node.js backend for the Movietok movie platform with comprehensive review system, user groups, favorites management, and integration with Finnkino and TMDB APIs.
- User Management: Registration, authentication, profiles and JWT authentication
- Review System: Movie reviews, likes/dislikes, aura scoring system
- Group Features: User groups, member management, group favorites
- Favorites List: Personal favorites with three levels (1-3)
- API Integrations: Finnkino API and TMDB (The Movie Database) API
- Modern Features: JWT authentication, CORS support, health checks
- Database: PostgreSQL database with complete schema
backend/
├── src/
│ ├── config/ # Database and other configurations
│ │ ├── database.js
│ │ └── config.js
│ ├── controllers/ # API controllers (CRUD logic)
│ │ ├── UserController.js
│ │ ├── ReviewController.js
│ │ ├── GroupController.js
│ │ ├── FavoritesController.js
│ │ ├── FinnkinoController.js
│ │ ├── TMDBController.js
│ │ └── GenresController.js
│ ├── middleware/ # Express middlewares
│ │ └── auth.js
│ ├── models/ # Database models
│ │ ├── User.js
│ │ ├── Movie.js
│ │ ├── Reviews.js
│ │ ├── Group.js
│ │ └── Genre.js
│ ├── routes/ # API routes
│ │ ├── index.js
│ │ ├── userRoutes.js
│ │ ├── reviewRoutes.js
│ │ ├── groupRoutes.js
│ │ ├── favorites.js
│ │ ├── finnkinoRoutes.js
│ │ └── tmdbRoutes.js
│ ├── services/ # Business logic
│ │ ├── UserService.js
│ │ ├── ReviewService.js
│ │ └── FinnkinoService.js
│ └── utils/ # Utility functions
├── scripts/ # Helper scripts
│ └── switch-env.js
├── tests/ # Tests
│ ├── user.test.js
│ ├── auth.test.js
│ └── review.test.js
├── index.js # Application entry point
├── package.json # Dependencies & scripts
├── Database.sql # Database schema
├── Postman/ # Postman schemas for endpoint testing
├── FINNKINO_API.md # Finnkino API documentation
└── README.md # This documentation
- Node.js 18+
- PostgreSQL 14+
- npm or yarn
npm run dev - Start server in development mode with nodemon
npm run devStart - Start server in development mode with nodemon
npm start - Start server in production mode
npm test - Run tests
npm run start:dev - Development server
npm run test:server - Test server
npm run start:prod - Production server
npm run db:connect:dev - Test development database connection
npm run db:connect:test - Test test database connection
npm run db:connect:prod - Test production database connection
make sure to setup .env file before setting up database
npm run db:setup - Create development database
npm run db:setup:test - Create test database
- GET /api/health - Health check including database connection
- POST /api/users/register - User registration
- POST /api/users/login - User login
- GET /api/users/:id - Get user profile by ID
- GET /api/reviews/recent - Get recent reviews
- GET /api/reviews/users-by-review-count - Get users by review count
- GET /api/reviews/users-by-aura - Get users by aura points
- GET /api/reviews/:id - Get single review
- GET /api/reviews/movie/:movieId - Get movie reviews
- GET /api/reviews/user/:userId - Get user reviews
- GET /api/reviews/group/:groupId - Get group reviews
- GET /api/groups/popular - Get most popular groups by member count
- GET /api/groups/by-genres - Get groups by genres
- GET /api/groups/themes - Get all group themes
- GET /api/groups/:id - Get group details
- PUT /api/users/profile - Update own user profile
- DELETE /api/users/profile - Delete own account
- GET /api/users - Get all users
- PUT /api/users/:id - Update user by ID
- POST /api/reviews - Create new review
- PUT /api/reviews/:id - Update review
- DELETE /api/reviews/:id - Delete review
- POST /api/reviews/:id/interaction - like/dislike
- GET /api/groups/user/:userId/groups - Get user's groups
- POST /api/groups - Create new group
- PUT /api/groups/:id - Update group details
- POST /api/groups/:id/join - Join group
- POST /api/groups/:id/request-join - Request to join group
- PUT /api/groups/:id/members/:userId/approve - Approve membership request
- GET /api/groups/:id/pending-requests - Get pending membership requests
- DELETE /api/groups/:id/leave - Leave group
- DELETE /api/groups/:id/members/:userId - Remove member from group
- PUT /api/groups/:id/members/:userId/role - Update member role
- DELETE /api/groups/:id - Delete group
- GET /api/favorites - Get user's favorites
- POST /api/favorites - Add movie to favorites
- DELETE /api/favorites/:id - Remove favorite
- GET /api/favorites/user/:userId - Get user's favorites
- GET /api/favorites/group/:groupId - Get group favorites
Include JWT token in Authorization header:
Authorization: Bearer <your_jwt_token>
Token contains user information and expires after a defined time period.
Entity Relationship Diagram of the Movietok Database
The project uses PostgreSQL database with the following tables:
- users - User information (includes user_bio field)
- movies - Movie information (TMDB integration)
- reviews - User reviews (1-5 stars + comment)
- groups - User groups by themes
- favorites - User favorite movies (3 levels)
- group_members - Group memberships and roles
- group_themes - Group themes/topics
- tags - Group genre tags
- interactions - Review likes/dislikes
- Aura Points: Calculated based on review likes received
- Group Hierarchy: Owner, moderator, member roles
- Favorite Levels: 1 = watched, 2 = liked, 3 = group favorite
The project includes comprehensive tests with Mocha and Chai
npm test
Start development server:
npm run devStart
Server starts on the port defined in .env file (default: 3000).
The project follows MVC (Model-View-Controller) pattern:
- Models (src/models/): Database model definitions and CRUD operations
- Controllers (src/controllers/): HTTP request handling and response formatting
- Services (src/services/): Business logic and data processing
- Routes (src/routes/): API route definitions and authentication
- Middleware (src/middleware/): Authentication, validation and error handling
- Config (src/config/): Application configurations and database connection
The project supports API versioning:
- /api/v1/* - Versioned API
- /api/* - Legacy API (backward compatibility)
The project is designed to be easily extensible:
- New Models: Create new file in src/models/ folder
- New Controllers: Create new file in src/controllers/ folder
- New Services: Create new file in src/services/ folder
- New Routes: Create new file in src/routes/ folder and add it to src/routes/index.js
The backend provides comprehensive statistics:
- User Statistics: Review count, average rating, aura points
- Group Statistics: Member count, activity, most popular groups
- Review Statistics: Recent, most popular, user-specific