Skip to content

Instantly share code, notes, and snippets.

View domgiles's full-sized avatar

Dominic Giles domgiles

View GitHub Profile
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@domgiles
domgiles / OracleAltAir.ipynb
Created June 20, 2018 12:13
Jupyter notebook using Oracle_CX, Pandas and Altair
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@domgiles
domgiles / alertlogparser.py
Last active April 20, 2021 17:49
Simple parse for Oracle Alert Log Files
from __future__ import print_function
import argparse
import os
import time
import humanize
import psutil
from colorama import Fore, Back
from colorama import Style, init
import argparse
import datetime
import os
import socket
import cx_Oracle
import paramiko
from colorama import Fore
from colorama import Style
@domgiles
domgiles / projectile_calculation.py
Created January 1, 2018 19:16
Simple projectile calculations using numpy and matplotlib
import matplotlib.pyplot as plt
import numpy as np
# Simple projectile calculations using numpy and matplotlib
# Author : Dominic Giles
g = 9.8 # gravity
h = 0 # height where projectile is launched from
v = 10.0 # velocity of launch
@domgiles
domgiles / ChangeRedoSize.py
Last active August 26, 2018 07:28
Simple "Oracle Database" hack in python to change the size of the redo logs files. It assumes that Oracle Managed Files are being used.
import argparse
import time
import cx_Oracle
from prettytable import PrettyTable
class RedoLogManager():
def get_log_files_info(self, cursor):
from matplotlib import style
import pandas as pd
from matplotlib import dates
import matplotlib.pyplot as plt
timings = pd.Series(['2016-12-25 08:10:00', '2016-12-25 08:30:00', '2016-12-25 08:50:00', '2016-12-25 08:58:00',
'2016-12-25 09:08:00', '2016-12-25 09:14:00', '2016-12-25 09:20:00', '2016-12-25 09:26:00',
'2016-12-25 09:35:00', '2016-12-25 09:46:00', '2016-12-25 09:55:00', '2016-12-25 10:05:00',
'2016-12-25 10:15:00', '2016-12-25 10:30:00', '2016-12-25 10:55:00', '2016-12-25 11:10:00',
'2016-12-25 11:30:00', '2016-12-25 11:54:00', '2016-12-25 12:15:00'])
import json
import requests
url = 'http://tpc12server:8080/ords/soe/soda/latest/OrdersCollection'
# Delete Collection
response = requests.delete(url)
# Create Collection
response = requests.put(url)
// Author : Dominic Giles
// Date : 21/7/2016
// File : liketable.js
// Description : Javascript to enable rows to be liked in a given table
// Note : DataTable paging is excluded for brevity
// Javascript Libraries : JQuery, JQuery UI, BootStrap, DataTable
$(document).ready(function () {
var $userName = 'dominic.giles';
<!--Author : Dominic Giles-->
<!--Date : 21/7/2016-->
<!--File : products.html-->
<!--Description : HTML to display simple table-->
<!--Javascript Libraries : JQuery, JQuery UI, DataTable-->
<!--CSS Files : BootStrap, Font-Awesome-->
<!DOCTYPE html>
<html lang="en">
<head>