Skip to content

Instantly share code, notes, and snippets.

View recursivecodes's full-sized avatar
😸

Todd Sharp recursivecodes

😸
117 followers · 1 following
View GitHub Profile
@recursivecodes
recursivecodes / func.js
Last active June 21, 2019 15:14
const fdk = require('@fnproject/fdk');
const oracledb = require('oracledb');
const dateFormat = require('dateformat');
oracledb.outFormat = oracledb.OBJECT;
oracledb.fetchAsString = [oracledb.CLOB];
let pool;
fdk.handle( async function(input){
@recursivecodes
recursivecodes / fn-invoke-node-insert.sh
Created June 11, 2019 21:32
echo '{"isDemo": true, "key": 5, "isAwesome": true, "isEasy": true}' | fn invoke fn-atp-node-json fn-atp-node-json-insert
@recursivecodes
recursivecodes / fn-invoke-read.sh
Created June 11, 2019 21:38
trsharp@MacBook-Pro-2 ~/Projects/fn/fn-atp-node-json/throwaway$ fn invoke fn-atp-node-json fn-atp-node-json-read
[{"id":66,"capturedAt":"2019-06-11T21:33:04.000Z","data":{"isDemo":true,"key":5,"isAwesome":true,"isEasy":true}}]
@recursivecodes
recursivecodes / fn-soda.js
Last active June 21, 2019 15:15
const fdk = require('@fnproject/fdk');
const oracledb = require('oracledb');
oracledb.outFormat = oracledb.OBJECT;
oracledb.fetchAsString = [oracledb.CLOB];
oracledb.autoCommit = true;
fdk.handle( async function(input){
let connection;
@recursivecodes
recursivecodes / fn-soda-invoke.js
Created June 12, 2019 14:10
$ echo '{"id": 1, "temp": 58}' | fn invoke fn-atp-node-json fn-atp-node-json-soda
$ echo '{"id": 2, "temp": 60}' | fn invoke fn-atp-node-json fn-atp-node-json-soda
@recursivecodes
recursivecodes / query-soda.sql
Last active June 12, 2019 14:17
select id, utl_raw.cast_to_varchar2(json_document) as doc
from soda_collection sc
where sc.json_document.temp < 60;
/*
ID DOC
----- -----
E05734C093684FBEBFDEC3404099F959 {"id":1,"temp":58}
*/
@recursivecodes
recursivecodes / soda-json-table.sql
Last active June 12, 2019 14:21
select id, jt.temp, jt.docId
from soda_collection sc,
json_table(json_document, '$' COLUMNS (temp number PATH '$.temp', docId varchar2(50) PATH '$.id')) as jt
/*
ID TEMP DOCID
----- ----- -----
E05734C093684FBEBFDEC3404099F959 58 1
B675F6056E374F9ABF76C6E35A280ED5 60 2
*/
@recursivecodes
recursivecodes / fn-inspect.sh
Created June 12, 2019 14:32
$ fn inspect function fn-atp-node-json fn-atp-node-json-read
@recursivecodes
recursivecodes / fn-inspect-result.json
Created June 12, 2019 14:35
{
"annotations": {
"fnproject.io/fn/invokeEndpoint": "https://xicciwch3fq.us-phoenix-1.functions.oci.oraclecloud.com/20181201/functions/ocid1.fnfunc..../actions/invoke",
"oracle.com/oci/compartmentId": "ocid1.compartment...."
},
"app_id": "ocid1.fnapp....",
"created_at": "2019-04-02T14:15:47.129Z",
"id": "ocid1.fnfunc....",
"idle_timeout": 30,
"image": "phx.ocir.io/toddrsharp/faas/fn-atp-node-json-read:0.0.91",
@recursivecodes
recursivecodes / invoke-vars.groovy
Last active June 12, 2019 14:56
String endpoint = "https://xicciwch3fq.us-phoenix-1.functions.oci.oraclecloud.com"
String insertId = "ocid1.fnfunc.oc1.us-phoenix-1..."
String readId = "ocid1.fnfunc.oc1.us-phoenix-1..."
String payload = JsonOutput.toJson([isCool: true, createdOn: new Date()])
AuthenticationDetailsProvider authProvider = new ConfigFileAuthenticationDetailsProvider('DEFAULT')