Prasundas99

Node.js Deployment

Steps to deploy a Node.js app to DigitalOcean using PM2, NGINX as a reverse proxy and an SSL from LetsEncrypt

1. Sign up for Digital Ocean

If you use the referal link below, you get $10 free (1 or 2 months) https://m.do.co/c/5424d440c63a

2. Create a droplet and log in via ssh

I will be using the root user, but would suggest creating a new user

Prasundas99

using CollegeScoreApp.DTN;
using CollegeScoreApp.Entities;

namespace CollegeScoreApp.Utility.Profile
{
    public class ApplicationProfile: AutoMapper.Profile
    {
        public ApplicationProfile()
        {
            CreateMap<Colleges, CollegeList>().ReverseMap();

Prasundas99

    /**
     ** updating the ticket by using aggregation querry explained
     ** "$set": replaces the value of a field with the specified value.
     ** "$eq": Compares two values and returns true or false on weather the values are equivallent or not
     ** "$status" : performs taks equvalent to  n xor 1
     ** Intution: if false == current value $status change the value otherwise $eq changes
     */
    const toggleBoolean = await Model.findByIdAndUpdate(
      id,
      [{ $set: { status: { $eq: [false, '$status'] } } }],

Prasundas99

//next referes to middleware
Schema.post('save', function (error, doc, next) {
  if (error.code === 11000 && error.keyPattern.item === 1) 
      next(new Error('This Item already exists, please try again'));
  else next(error);
});

Prasundas99

import { useEffect } from "react";
import { useLocation } from "react-router-dom";

export default function ScrollToTop() {
  const { pathname } = useLocation();

  useEffect(() => {
    window.scrollTo(0, 0);
  }, [pathname]);

Prasundas99

    import { parseString, Builder } from "xml2js";

    // Convert string/XML to JSON
    function toJson(xml: string) {

        parseString(xml, { explicitArray: false }, function(error, result) {
            console.log(result);
        });
    }

Prasundas99

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database using XAMPP

MySQL Locations

• Xampp /xampp/mysql/bin

Add mysql to your PATH