krisrice’s gists

krisrice / kill.js

Created October 19, 2022 13:18

	// SQLCL's Command Registry
	var CommandRegistry = Java.type("oracle.dbtools.raptor.newscriptrunner.CommandRegistry");

	// CommandListener for creating any new command
	var CommandListener = Java.type("oracle.dbtools.raptor.newscriptrunner.CommandListener")

	// Broke the .js out from the Java.extend to be easier to read
	var cmd = {};

	// Called to attempt to handle any command

krisrice / sql-replay.html

Created October 3, 2022 19:27

	<html>
	<head>
	<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/hack-font/3.3.0/web/hack.min.css" integrity="sha512-XgCw4Srl8lC1ECwcaHwAU0WnxQwHkqmInzg9wJLtGB7DRuMaXPuK2k9WJ2AwRDGdrgK9eJpZl2hUlLi2WQssmw==" crossorigin="anonymous" referrerpolicy="no-referrer" />
	<script
	src="https://code.jquery.com/jquery-2.2.4.min.js"
	integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44="
	crossorigin="anonymous"></script>
	<script src="https://mattboldt.com/demos/typed-js/js/typed.custom.js"></script>
	<script>$( document ).ready(function() {
	var data = [

krisrice / dbms_cloud_metric_sql_pkg.sql

Created May 20, 2022 15:26

	create or replace package oci_metrics as
	--
	-- ╔═╗┌─┐┌┬┐┬ ┬┌─┐ ╔═╗┌┬┐┌─┐┌─┐┌─┐
	-- ╚═╗├┤ │ │ │├─┘ ╚═╗ │ ├┤ ├─┘└─┐
	-- ╚═╝└─┘ ┴ └─┘┴ ╚═╝ ┴ └─┘┴ └─┘
	--
	-- Current PDB's OCID
	-- select json_value(cloud_identity , '$.DATABASE_OCID') from v$pdbs
	--
	-- Crate Dynamic Group "klrice-testing"

krisrice / sql_oci_metrics.sql

Last active May 18, 2022 20:08

	set serveroutput on
	DECLARE
	credential_name varchar2(200) := 'OCI$RESOURCE_PRINCIPAL';
	region varchar2(200) := 'us-phoenix-1';
	base_uri varchar2(200) := 'https://telemetry-ingestion.' \|\| region\|\| '.oraclecloud.com/20180401/metrics';
	resp dbms_cloud_types.RESP;
	BEGIN

	-- Current PDB's OCID
	-- select json_value(cloud_identity , '$.DATABASE_OCID') from v$pdbs

krisrice / load_strava.sql

Created March 2, 2022 15:08

	set load scan_rows 10000
	drop table strava_activities;
	drop table strava_applications;
	drop table strava_bikes;
	drop table strava_blocks;
	drop table strava_clubs;
	drop table strava_comments;
	drop table strava_components;
	drop table strava_connected_apps;
	drop table strava_contacts;

krisrice / addMyIpWhiteList.sh

Last active June 14, 2022 21:09

	#!/bin/bash
	OCIPROFILE="MYPROFILE"
	DBOCID="ocid1.autonomousdatabase.oc1.phx.anyhqljrcsc5xxqnxxxxxxxxxxxxxxxxxxxxxxxxkulv5ipmbqiq"
	REGION="us-phoenix-1"
	#
	# GET my IP Address
	#
	# Example : "1.2.3.4"
	CURRENT_IP=$(oci raw-request --profile $OCIPROFILE --target-uri https://database.${REGION}.oraclecloud.com/20160918/autonomousDatabases/capabilities --http-method GET \| jq ".data.clientIpAddress")

krisrice / node-select.js

Created December 6, 2021 19:09

	const common = require("oci-common");
	const databasetools = require("oci-databasetools");
	const secrets = require("oci-secrets");
	const core = require("oci-core");
	const fs = require("fs");
	const oracledb = require('oracledb');

	//
	// Configure Instant Client
	//

krisrice / DBToolsServiceRestSQLExamples.java

Last active November 17, 2021 17:33

DBTools Service sample for REST-SQL

	package io.krisice;

	import com.oracle.bmc.http.signing.RequestSigningFilter;

	import javax.ws.rs.client.*;
	import javax.ws.rs.core.MediaType;
	import java.io.BufferedReader;
	import java.io.IOException;
	import java.io.Reader;

krisrice / install-graaljs-sqlcl.sh

Last active July 24, 2023 09:40

	#!/bin/bash

	# MAVEN DEPS
	declare -a array=("https://repo1.maven.org/maven2/org/graalvm/truffle/truffle-api"
	"https://repo1.maven.org/maven2/org/graalvm/regex/regex"
	"https://repo1.maven.org/maven2/com/ibm/icu/icu4j"
	"https://repo1.maven.org/maven2/org/graalvm/sdk/graal-sdk"
	"https://repo1.maven.org/maven2/org/graalvm/js/js"
	"https://repo1.maven.org/maven2/org/graalvm/js/js-scriptengine")

krisrice / colors-all.sql

Created October 19, 2021 13:21

Kris Rice krisrice