dbtutor’s gists

dbtutor / InstrumentAssignments.onExecute

Created November 16, 2021 05:31 — forked from vinodronold/InstrumentAssignments.onExecute

Sample REST API Implementation using PeopleCode

	import Z_REST_UTIL:Request;

	class InstrumentAssignments
	method InstrumentAssignments(&nVendorId As number, &nPaymentPartyId As number, &nPaymentInstrumentId As number);
	property number VendorId readonly;
	property number PaymentPartyId readonly;
	property number PaymentInstrumentId readonly;
	property string PaymentFlow readonly;
	property string PaymentInstrumentType readonly;
	property string PrimaryIndicator readonly;

dbtutor / APPLICATION_PACKAGE.Z_REST_UTIL.Request.OnExecute

Created November 16, 2021 05:31 — forked from vinodronold/APPLICATION_PACKAGE.Z_REST_UTIL.Request.OnExecute

PeopleCode to Call REST APIs

	/ APPLICATION_PACKAGE.Z_REST_UTIL.Request.OnExecute /
	import EOEW_ETLAPI:COMMON:HashTable;

	class Request
	method Request(&sURL As string);
	method get() Returns JsonObject;
	method post(&jsonRequest As JsonObject) Returns JsonObject;
	method generateRequest(&MethodName As string, &Request As string) Returns JsonObject;
	method buildGenericMessage(&MethodName As string, &Request As string) Returns Message;
	method base64ToString(&sBase64 As string) Returns string;

dbtutor / GenerateCSVFile

Created November 16, 2021 05:30 — forked from vinodronold/GenerateCSVFile

	import PACKAGE:Utils:StringHashtable;

	class Header
	method Header();
	method init();
	method insert();
	method createFile();

	property string fileName get;
	property string fullFilePathName get;

dbtutor / event-mapped-components.sql

Created June 12, 2020 13:02 — forked from jsmpros/event-mapped-components.sql

Find project components that use Event Mapping

	SELECT PORTAL.PORTAL_NAME
	, PORTAL.PORTAL_OBJNAME
	, PROJ.OBJECTVALUE1 PNLGRPNAME
	, PROJ.OBJECTVALUE2 MARKET
	, EVT.PTCS_SERVICEID
	, ISCOMP_LABEL.XLATLONGNAME /EVT.PTCS_ISCOMPSERVICE/
	, PROCSEC_LABEL.XLATLONGNAME PROC_SEQ
	, ( /* nested instead of join since this field might be empty */
	SELECT XLAT.XLATLONGNAME
	FROM PSXLATITEM XLAT

dbtutor / Add an Azure Resource Manager service connection.md

Created April 1, 2020 10:35 — forked from jackawatts/Add an Azure Resource Manager service connection.md

Adding an Azure Resource Manager Service Connection in AzureDevOps

Taken from: https://blogs.msdn.microsoft.com/mihansen/2018/03/31/granular-vststfs-deployment-privileges-using-service-principals/

AzureDevOpsAR is simply the name of the app registration AzureDevOps will be associated with, don't like the name? Simply change the references below.

Create an App Registration to act as a Service Principal:
1. Log in to portal.azure.com
2. Azure Active Directory => App Registrations => New Application Registration
3. Name: AzureDevOpsAR, Type: Web app/API, Url: http://azuredevopsar (Url isn't important as it won't be used)
4. Copy the Application ID as this will be the Service principal client ID
Settings => Keys => Add

dbtutor / apache_ssh.sh

Last active January 17, 2020 19:19

Apache HTTP Server SSL Installation with Demo Certificate

	#!/bin/bash
	sudo yum -y install httpd24-mod_ssl
	sudo openssl req -x509 -nodes -days 365 -subj /C=IN/ST=WB/L=Kolkata/CN=OracleCertificateAuthority -newkey rsa:1024 -keyout privatekey.pem -out cert.pem
	sudo openssl x509 -in cert.pem -out rootcert.crt

	sudo mkdir /etc/httpd/conf/ssl
	sudo cp cert.pem /etc/httpd/conf/ssl/cert.pem
	sudo cp privatekey.pem /etc/httpd/conf/ssl/privatekey.pem
	sudo cp cert.pem /etc/httpd/conf/ssl/root_cert.pem
	sudo restorecon -RvF /etc/httpd/conf/ssl

dbtutor / phpinfo.php

Last active January 16, 2020 07:46

	<?php
	// Show all information, defaults to INFO_ALL
	phpinfo();
	?>

dbtutor / generate-ssh-key.sh

Last active August 28, 2024 17:41 — forked from grenade/01-generate-ed25519-ssh-key.sh

Correct file permissions for ssh keys and config.

	# With Out Passphrase
	ssh-keygen -t rsa -b 4096 -N '' -C "[email protected]" -f ~/.ssh/oci_keys
	ssh-keygen -t rsa -b 2048 -N '' -C "[email protected]" -f ~/.ssh/oci_keys

	# With Passphrase
	ssh-keygen -t rsa -b 4096 -C "[email protected]" -f ~/.ssh/oci_keys_rsa
	ssh-keygen -t rsa -b 2048 -C "[email protected]" -f ~/.ssh/oci_keys_rsa

dbtutor / gist:0fce0d69ad72f9930aa4

Created February 29, 2016 05:11

	Collect Passport & Visa with stamp
	Ask for flight ticket and boading date & cash card
	Any necessary documents
	Visa and Passport Attested Copy Xerox.
	Visa and Passport Attested scan Copy Xerox.
	Scan Woolworths Employee form
	Misclenious medical submit
	Medi Assist Submit

dbtutor / 0_reuse_code.js

Created February 29, 2016 04:53

Here are some things you can do with Gists in GistBox.

	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console

Nayan dbtutor