sgoley

Keybase proof

I hereby claim:

• I am sgoley on github.
• I am sgoley (https://keybase.io/sgoley) on keybase.
• I have a public key whose fingerprint is 01C6 62A2 DB83 7A9C 390F 1A3C E7B7 AE58 C442 0F83

To claim this, I am signing this object:

sgoley

library(shinydashboard)
library(dplyr)
library(dbplyr)
library(purrr)
library(shiny)
library(highcharter)
library(DT)
library(htmltools)

# Use the `config` package to get the credentials

sgoley

#export all packages from old installation:
ip <- as.data.frame(installed.packages())
dump("ip","ip.Rdmpd")

#install all packages into new installation:

setwd("/path/to/dumpfile")
source("ip.Rdmpd")
install.packages(ip$Package)

sgoley

$deviceName = 'myDeviceName'   # configure device name
$newOwner = 'user@example.com' # login name of the new user
 
Connect-AzureAD
 
# Get-AzureADDevice # if you want to list all devices
# Get-AzureADUser   # if you want to list all users
 
$device = Get-AzureADDevice | where { $_.DisplayName -eq $deviceName }
$aduser = Get-AzureADUser | where { $_.UserPrincipalName -eq $newOwner }

sgoley

//Make a list of ID's of addresses on Suppliers : List 1
List< Supplier__c > supList = [ SELECT Id,Address__c FROM Supplier__c ];
List<Id> supids = new List<Id>(new Map<Address__c,Supplier__c>(supList).keySet());

//Make a list of all address IDs : List 2
List< Address__c > AdrList = [ SELECT Id FROM Address__c ];
List<Id> adrids = new List<Id>(new Map<Id,Address__c>(AdrList).keySet());

//Make a list of ID's in List 2 which are not in List 1 : List 3
list< Id > List3 =[ SELECT Id FROM Address__c where Id not in:adrids Limit 1];

sgoley

1. Export existing app’s variables to config.txt
heroku config -s -a existing-heroku-app > config.txt

2. Review and push to another app
cat config.txt | tr '\n' ' ' | xargs heroku config:set -a new-heroku-app


Credit: https://emirkarsiyakali.com/@EmirKarsiyakali

sgoley

# For Windows users# Note: <> denotes changes to be made

#Create a conda environment
conda create --name <environment-name> python=<version:2.7/3.5>

#To create a requirements.txt file:
conda list #Gives you list of packages used for the environment

conda list -e > requirements.txt #Save all the info about packages to your folder

sgoley

{% macro grant_select_on_schemas(schemas, user) %}
  {% for schema in schemas %}
    grant usage on schema {{ schema }} to "{{ user }}";
    grant select on all tables in schema {{ schema }} to "{{ user }}";
    alter default privileges in schema {{ schema }}
        grant select on tables to "{{ user }}";
  {% endfor %}
{% endmacro %}

sgoley

-- author: Derek Sivers (https://github.com/sivers)
-- description: simple ideas / concepts / tagging table layout for PostgreSQL

CREATE TABLE concepts (
id integer primary key,
created_at date not null default CURRENT_DATE,
title varchar(127) not null unique CONSTRAINT title_not_empty CHECK (length(concepts."title") > 0),
concept text not null unique CONSTRAINT concept_not_empty CHECK (length(concepts."concept") > 0)
);
CREATE TABLE urls (

sgoley

-- in schema as procedure:

create function manage_magic_timestamp_columns() returns trigger
    strict
    cost 1
    language plpgsql
as
$$
BEGIN
    -- is a new record?