Read challenge description.

Technologies used: JavaScript, Node.js, Express.js, HTML/CSS/Bootsrap, Google-vision API, MySQL, file-storage, heroku

Screenshots

• Upload Pictures

  • Maximum 10 pictures can be uploaded at once
  • Maximum file size 15Mb.
  • .jpg .png .gif are accepted types
  • Name and description of the file can be entered during upload
  • User can upload a picture publicly or privatey
  • Guest cannot upload pictures

• Search filters

  • Labels (like: Night, Beauty, Happy, Street, Dog, Ice-cream etc)
  • Text present in a picture (OCR)
    • Label and Text recognition will take some time to complete as the API is in free-trial mode.
  • Name of the file entered during upload or the original filename
  • Extension of the picture
  • Pictures uploaded before and after a certain date
  • Maximum and minimum size of the picture in Bytes
  • Words present in description entered during upload.

• Delete Pictures

  • A user can delete only pictures uploaded by him/her/they

• View/Download Pictures

  • User can view or download public as well as pictures uploaded by him/her/they
  • Guest can only view or download public pictures

Install node, npm and MySQL

https://nodejs.org/en/download/
https://www.mysql.com/downloads/

Run the following mysql queries

create database shopifyWinter2022InternChallenge;
use shopifyWinter2022InternChallenge;

create table users(username VARCHAR(50) primary key, password VARCHAR(50) not null);
create table images(id INT primary key, name VARCHAR(50) not null, filepath VARCHAR(50) not null, extension VARCHAR(10) default 'jpg', size INT default 0, owner VARCHAR(50) default 'GUEST', visibility VARCHAR(8) default 'private', uploadDate DATE DEFAULT (curdate()), description VARCHAR(200));
create table imageLabels(imageId INT, label VARCHAR(50), PRIMARY KEY (imageId,label), FOREIGN KEY (imageId) REFERENCES images(id) ON DELETE CASCADE);
create table imageOCRs(imageId INT, text VARCHAR(200), PRIMARY KEY (imageId,text), FOREIGN KEY (imageId) REFERENCES images(id) ON DELETE CASCADE);

Clone the project

git clone https://github.com/smitdesai1010/Shopify-Winter2022-Challenge.git

Add the following environment variables in a .env file located in the root directory of the project

    MYSQL_USERNAME
    MYSQL_PASSWORD
    MYSQL_HOST
    MYSQL_DATABASE

    GOOGLE_APPLICATION_CREDENTIALS

Note: Contact me if you are having trouble setting up GOOGLE_APPLICATION_CREDENTIALS, I will provide you my key for a temporary basis.

Go to the project directory

npm install     
npm start   

Note: If you face error code 1175 in mysql, please execute the following mysql queries. Replace root, localhost and password with your credentials.

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;

Run tests

npm test

• Writing unit tests
• Handling files uploads using multer (node.js package)
• Using postman for testing APIs
• Using token authorization