Key to The SQL Murder Mystery
The crime was a murder that occurred sometime on Jan.15, 2018 and that it took place in SQL City
select * from crime_scene_report
where date=20180115 and type = 'murder' and city = 'SQL City';
>Description-
Key to The SQL Murder Mystery
The crime was a murder that occurred sometime on Jan.15, 2018 and that it took place in SQL City
select * from crime_scene_report
where date=20180115 and type = 'murder' and city = 'SQL City';
>Description-
Go to the course and have any video up. The following code relies on the right sidebar to be visible to uncheck all your progress.
You can do this with ctrl+shift+j
and making sure the console
tab is selected for chrome/brave
import apiProvider from './provider'; | |
export class ApiCore { | |
constructor(options) { | |
if (options.getAll) { | |
this.getAll = () => { | |
return apiProvider.getAll(options.url); | |
}; | |
} |
const express = require('express'); | |
const app = express(); | |
const path = require('path'); | |
const multer = require('multer'); | |
const port = 3000; | |
app.use('/uploads', express.static(path.join(__dirname, '/uploads'))); | |
const express = require('express'); | |
const mongoose = require('mongoose'); | |
const bodyParser = require('body-parser'); | |
const app = express(); | |
const PORT = 3000; | |
mongoose.connect('DB_URL', { dbName: 'todo' }, (err) => { | |
if (!err) { | |
console.log('Connected to database'); |
var mysql = require("mysql"); | |
// Configure your logger here | |
var logger = require("../utils/logger"); | |
// Add a properties file here with the configurations | |
// For properties file format visit https://github.com/steveukx/properties | |
var properties = require('properties-reader')('properties.properties'); | |
function getConnection() { | |
var connection = mysql.createConnection({ | |
host: properties.get('mysql.host'), |