kdclaw3

-- add work layer group if not exists
INSERT INTO systemlookup
(id, org, [type], [name])
SELECT 
    id + 'work_layer_group' id,
    id as org,
    'MAP_LAYER_GROUP' [type],
    'Work' [name]
FROM org o
where id = '${orgId}'

kdclaw3

// icon
{
  "type": "symbol",
  "layout": {
    "icon-size": 0.5
  },
  "paint": {}
}

// point

kdclaw3

(async function () {

	const { layers } = await (await fetch('https://.../arcgis/rest/services/.../MapServer?f=pjson')).json();

	const layersById = layers.reduce((acc, item) => {
		acc[item.id] = item;
		return acc;
	}, {});

	let usedIcons = [];

kdclaw3

/*
----------------------------------------------------------------------------------------------------
Table: W1_DOCUMENT - Document
----------------------------------------------------------------------------------------------------
The data for CLOB/XML field BO_DATA_AREA should be enclosed by <endclob>.
Delimiter: ,
Enclosing Character: "
For not-nullable fields with no value, provide a single space enclosed in enclosing character
Fields:
The first 30 characters contain target table name W1_DOCUMENT padded with spaces

kdclaw3

declare @v_db			nvarchar(255) = 'sample';
declare @v_bkup_name	nvarchar(255) = (select @v_db + format(sysdatetime(),'_yyyyMMdd_HHmm') + '.bak');
declare @v_arn			nvarchar(510) = 'arn:aws:s3:::sample-databasebackups/' + @v_bkup_name;
print '=====backing up database====='
print 'database: ' + @v_db;
print 'filename: ' + @v_bkup_name;
print 'arn: '      + @v_arn;

exec msdb.dbo.rds_backup_database
	@source_db_name=		@v_db, --database name

kdclaw3

/* 
refresh sql server database views
*/
declare @name varchar(max) = ''
declare viewCursor cursor
for
select distinct [name]
from [sysobjects]
where [type] = 'V';

kdclaw3

kdclaw3

// Amazon Monitron Lamda Function
// Basic Example grabbing info from S3 Bicket

const aws = require('aws-sdk');
const s3 = new aws.S3({ apiVersion: '2006-03-01' });
var ses = new aws.SES({ region: "us-east-1" });

const prefix = '[LOGPREFIX] '

exports.handler = async (event, context) => {

kdclaw3

// Oracle OCI Object Storage Upload Example
// Using Upload Manager with Progress Bar Tracking

// imports
const fs = require('fs');
const { basename, join } = require('path');
const cliProgress = require('cli-progress');
const os = require('oci-objectstorage');
const common = require('oci-common');

kdclaw3

/* 
Load Files into Clob from Filesystem Using PL/SQL
Dee Clawson
20210814
MIT License
*/

res                 CLOB;
v_bfile             BFILE;
v_temp_blob         BLOB;