Skip to content

README.md

Latest commit

 

History

History
67 lines (48 loc) · 1.58 KB

README.md

File metadata and controls

67 lines (48 loc) · 1.58 KB

📸 mypic — Backend API

Client → Router → Middleware → Controller → Service → Repository → Database → Response

A Go-based backend service built with Gin, GORM, and MySQL providing user authentication, profile management, and JWT-based authorization.

Tech Stack

  • Go (1.21+ recommended)
  • Gin (HTTP framework)
  • GORM (ORM)
  • MySQL
  • JWT (authentication)
  • bcrypt (password hashing)
  • godotenv (env loading) For Front end we are using angular

Mysql Queries Need to Run

CREATE DATABASE mypic_db; USE mypic_db;

CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, user_name VARCHAR(100) NOT NULL UNIQUE, name VARCHAR(150) NOT NULL, email VARCHAR(150) NOT NULL UNIQUE, user_password LONGTEXT NOT NULL, user_logo_url LONGTEXT, time_stamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_time_stamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP );

CREATE TABLE files ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, original_name VARCHAR(255) NOT NULL, stored_name VARCHAR(255) NOT NULL, extension VARCHAR(50), mime_type VARCHAR(100), size BIGINT, url TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );

Required Libraries

Install these before running:

go get github.com/gin-gonic/gin          # HTTP server
go get gorm.io/gorm                     # ORM
go get gorm.io/driver/mysql             # MySQL driver
go get golang.org/x/crypto/bcrypt       # Password hashing
go get github.com/golang-jwt/jwt/v5     # JWT auth
go get github.com/joho/godotenv          # Load env file