seahrh

CREATE OR REPLACE PROCEDURE sp_update_ddl()
AS $$
	BEGIN
		alter table myschema.mytable add column newcolumn bigint;
	EXCEPTION
		WHEN OTHERS THEN
			raise 'exception in filename.sql';
	END
$$ LANGUAGE plpgsql
;

seahrh

definitions:
    steps:
      - step: &tests
          image: python:3.7.9
          script:
            - pip install ."[tests]"
            - mypy src
            - pytest -vv --cov=src
          caches:
            - pip

seahrh

import os
import numpy as np
from matplotlib import pyplot as plt
import IPython.display as ipd
import librosa
import pandas as pd
%matplotlib inline

def print_plot_play(x, Fs, text=''):
    """1. Prints information about an audio singal, 2. plots the waveform, and 3. Creates player

seahrh

import os
import numpy as np
from matplotlib import pyplot as plt
import IPython.display as ipd
import librosa
import pandas as pd
%matplotlib inline

def print_plot_play(x, Fs, text=''):
    """1. Prints information about an audio singal, 2. plots the waveform, and 3. Creates player

seahrh

def recall(y_true, y_pred):
    y_true = K.ones_like(y_true) 
    true_positives = K.sum(K.round(K.clip(y_true * y_pred, 0, 1)))
    all_positives = K.sum(K.round(K.clip(y_true, 0, 1)))
    
    recall = true_positives / (all_positives + K.epsilon())
    return recall

def precision(y_true, y_pred):
    y_true = K.ones_like(y_true) 

seahrh

feature_important = clf.get_booster().get_score(importance_type="weight")
keys = list(feature_important.keys())
values = list(feature_important.values())

data = pd.DataFrame(data=values, index=keys, columns=["score"]).sort_values(by = "score", ascending=False)

# Top 10 features
data.head(20)

seahrh

-- see https://docs.aws.amazon.com/redshift/latest/dg/r_PG_TABLE_DEF.html

select "column", type, encoding, distkey, sortkey
from pg_table_def where schemaname='public' and tablename='mytable' and sortkey!=0;

seahrh

from tensorflow import keras
from tensorflow.python.lib.io import file_io


class ModelCheckpointInGcs(keras.callbacks.ModelCheckpoint):
    def __init__(
        self,
        filepath,
        gcs_dir: str,
        monitor="val_loss",

seahrh

AWSTemplateFormatVersion: 2010-09-09
Transform: AWS::Serverless-2016-10-31

Parameters:
  BucketPrefix:
    Type: String
    Description: "The prefix used for all S3 buckets."
    AllowedPattern: "[a-z-]+"

Resources:

seahrh

import pandas as pd
import pandas.io.sql as sqlio
import psycopg2

conn = psycopg2.connect("host='{}' port={} dbname='{}' user={} password={}".format(host, port, dbname, username, pwd))
sql = "select count(*) from table;"
dat = sqlio.read_sql_query(sql, conn)
conn = None