ivanleoncz

### Create, Read, Update and Delete

# SHOW DATABASES
> show databases
> show dbs

# DEFINE DATABASE FOR OPERATIONS
> use database_name

# CREATE DATABASE AND COLLECTIONS 

ivanleoncz

#!/usr/bin/python3
"""  Demonstration of PyMongo usage. """

from bson.objectid import ObjectId
from datetime import datetime
from pymongo import MongoClient

__author__ = "@ivanleoncz"

ivanleoncz

#!/usr/bin/python3
""" Determining validation of a password, against its hash. """

import bcrypt
from getpass import getpass

# simulation of hashed password stored in a DBMS (MongoDB, MySQL, SQLite, etc.)
salt = bcrypt.gensalt()
db_password = "Guido*Py2017".encode('utf-8')
db_pass_hash = bcrypt.hashpw(db_password,salt)

ivanleoncz

""" Demonstrating SQLite3 query with data returned as JSON Array. """

from json import dumps                                                          

__author__ = "@ivanleoncz"

import sqlite3                                                                  
                                                                                
def data_as_json():                                                                 
    db = sqlite3.connect("app_db.sqlite3")                                       

ivanleoncz

#!/usr/bin/python3
#
# Requires: youtube_dl module
# Requires: ffmpeg
# Usage:
#
# python youtube2mp3.py <URL>, ...
# 
# Example:
# 

ivanleoncz

const Sequelize = require('sequelize');
var sequelize = new Sequelize({
        dialect:"sqlite",
        storage:"./db.sqlite",
});

// DB Connection
sequelize.authenticate().then(
    function (err) {console.log("Connection established!");},
    function (err) {console.log("Unable to connect!", err);}

ivanleoncz

import time

class Calc:
    """ Arithmetic Operations for two numbers, per function. """
    
    def add(self, n1, n2):
        """ Performs addition of two numbers. """
        time.sleep(5) # intentional sleep for measuring time consumed
        return n1 + n2
      

ivanleoncz

var express = require('express');
var port = 3000;

var app = express();

app.get('/', function(req, res) {
    res.send('<h1>Welcome! </h1>');
});

app.get('/username/:user_name', function(req, res) {

ivanleoncz

var express = require('express');
var path = require('path');
var port = 3000;

var app = express();
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'ejs');

app.get('/', function(req, res) {
    res.render('index', {username: 'ivanleoncz'});

ivanleoncz

const express = require('express');
const bodyParser = require('body-parser');

var app = express();
var router = express.Router();

app.use(bodyParser.json());
app.use(bodyParser.urlencoded({extended: true}));

var tasks = [