Skip to content

Instantly share code, notes, and snippets.

View bobby5892's full-sized avatar

Robert Moore bobby5892

  • Roseburg, OR
  • 22:29 (UTC -07:00)
View GitHub Profile
/* Clean the slate */
DROP TABLE PAYROLL_ITEM CASCADE CONSTRAINTS;
DROP TABLE PAYROLL_PAYMENT CASCADE CONSTRAINTS;
DROP TABLE PAYROLL CASCADE CONSTRAINTS;
DROP TABLE EMPLOYEE_SCHEDULE CASCADE CONSTRAINTS;
DROP TABLE EMPLOYEE_TYPE CASCADE CONSTRAINTS;
DROP TABLE EMPLOYEE CASCADE CONSTRAINTS;
DROP TABLE VENDOR CASCADE CONSTRAINTS;
DROP TABLE PURCHASE_ORDER CASCADE CONSTRAINTS;
/* NOTE TO FUTURE SELF
ADD CONSTRAINTS FOR TABLES THAT HAVE NULLABLE VALUES
CUSTOMER ORDER
ADJUST_STOCK
EXAMPLE*/
/* Clean the slate */
DROP TABLE PAYROLL_ITEM CASCADE CONSTRAINTS;
DROP TABLE PAYROLL_PAYMENT CASCADE CONSTRAINTS;
DROP TABLE PAYROLL CASCADE CONSTRAINTS;
DROP TABLE DINOSAUR CASCADE CONSTRAINTS;
DROP TABLE DISCOVERY CASCADE CONSTRAINTS;
DROP TABLE ARCHEOLOGIST CASCADE CONSTRAINTS;
DROP TABLE LOCATION CASCADE CONSTRAINTS;
CREATE TABLE DINOSAUR(
DINOSAUR_ID NUMBER(8) PRIMARY KEY,
DINOSAUR_NAME VARCHAR2(50) NOT NULL,
DIET_TYPE VARCHAR2(10) NOT NULL,
COST NUMBER(10,2)
DROP TABLE Resort CASCADE CONSTRAINTS;
DROP TABLE Resort_type CASCADE CONSTRAINTS;
DROP TABLE Accomodation CASCADE CONSTRAINTS;
CREATE TABLE Resort (
resort_id varchar2(2) PRIMARY KEY,
resort_name varchar(50) NOT NULL,
FK_resort_type_id varchar2(2) NOT NULL
);
CREATE TABLE Resort_type(
ProxyPass /p5001 http://localhost:5001/
ProxyPassReverse /p5001 http://localhost:5001/
ProxyPass /p5002 http://localhost:5002/
ProxyPassReverse /p5002 http://localhost:5002/
ProxyPass /p5003 http://localhost:5003/
ProxyPassReverse /p5003 http://localhost:5003/
ProxyPass /p5004 http://localhost:5004/
ProxyPassReverse /p5004 http://localhost:5004/
ProxyPass /p5005 http://localhost:5005/
ProxyPassReverse /p5005 http://localhost:5005/
@bobby5892
bobby5892 / gist:57b1fbc9bd2e7fc6d5daad9f58e1374b
Created January 31, 2019 20:26
creating apache forwader
let i = 0;
let port = 5000;
let body = document.getElementById("body");
body.innerHTML = "";
while (i < 100){
i++;
port++;
body.innerHTML += "<br>ProxyPass /p"+ port +" http://localhost:"+ port +"/";
body.innerHTML += "<br>ProxyPassReverse /p"+ port +" http://localhost:"+ port +"/";
}
@bobby5892
bobby5892 / gist:2d0d1b92db6de12dbd8d49325df2ca15
Last active January 23, 2019 02:19
CS275 - Wk 3 - Combined Lab 3
DROP TABLE STUDENT CASCADE CONSTRAINTS;
DROP TABLE DORM_ROOM CASCADE CONSTRAINTS;
CREATE TABLE STUDENT
(STUDENT_ID number(8) PRIMARY KEY,
STUDENT_FIRST_NAME varchar(25) NOT NULL,
STUDENT_LAST_NAME varchar(50) NOT NULL,
STUDENT_TYPE varchar(1) NOT NULL,
FK_DORM_ROOM_ID varchar(8));
@bobby5892
bobby5892 / mightwork
Created May 2, 2018 17:04
might work
std::string recPrint(std::string stringy,int index=-1){
if(index < 0){
index = stringy.length();
}
if(index > 0){
return recPrint(stringy.substr(index--,1));
}
}
@bobby5892
bobby5892 / auth.php
Last active May 1, 2018 20:43
CAS Login
<?php
/*
By Robert Moore
[email protected]
http://www.github.com/bobby5892
5/1/2018
Request Looks Like
POST /cas/v1/tickets HTTP/1.0
#include "Dequeue.h"
#include <string>
#include <sstream>
#include <iostream>
#include <ostream>
Dequeue::Dequeue()
{
// Create initial data
this->init(100);