spazm

Automated last updated columns -- postgresql

SYNOPSIS

Create an updated_at timestamp column that is automatically updated whenever row values are changed in a postgresql database.

ABOUT

• Modifying a column when a row is changed requires a BEFORE UPDATE TRIGGER on row updates.
• A trigger can call a procedure
• A function can create a trigger programatically.

spazm

#!/usr/bin/env python3

import re
from pprint import pprint

def main():
    begin = "cat"
    end = "bar"
    word_len = len(begin)
    graph = build_graph(get_words(word_len))

spazm

/**
Given an arbitrary ransom note string and another string containing letters from all the magazines, write a function that will return true if the ransom note can be constructed from the magazines ; otherwise, it will return false.
 
Each letter in the magazine string can only be used once in your ransom note.

Note:
You may assume that both strings contain only lowercase letters.

  canConstruct("a", "b") -> false
  canConstruct("aa", "ab") -> false

spazm

// Provided code
// Definition for a binary tree node.
#[derive(Debug, PartialEq, Eq)]
pub struct TreeNode {
    val: i32,
    left: Option<Rc<RefCell<TreeNode>>>,
    right: Option<Rc<RefCell<TreeNode>>>,
}

impl TreeNode {

spazm

pub fn brackets_are_balanced(string: &str) -> bool {
    // second attempt/idea:
    //  push opening brace onto array
    //  pop array on close and check for match
    //  pop on empty => false
    //  not empty at end => false
    // third attempt:
    //  make a hashmap of open/close remove code duplication in the
    //  close bracket logic
    //  Is this really the best way to make a fixed hashmap?  Also, we

spazm

use itertools::Itertools;
use std::collections::HashMap;

/// Split a string into substrings of length sub_size
/// Final element may be shorter than sub_size
fn sub_strings(source: &str, sub_size: usize) -> Vec<String> {
    source
        .chars()
        .chunks(sub_size)
        .into_iter()

spazm

MY_SSH_AUTH_SOCK=$HOME/.ssh/ssh_auth_sock

if [ -n "$SSH_AUTH_SOCK" ] ; then
    if [ -L $MY_SSH_AUTH_SOCK ] && [ -e $MY_SSH_AUTH_SOCK ]; then
        [ -n "$DEBUG" ] && echo "SSH_AUTH_SOCK is still valid"
    else
        [ -n "$DEBUG" ] && echo "linking SSH_AUTH_SOCK to $MY_SSH_AUTH_SOCK"
        ln -fs "$SSH_AUTH_SOCK" "$MY_SSH_AUTH_SOCK"
    fi
fi

spazm

" check ITERM_PROFILE for 'DARK' or 'LIGHT' substrings, set background to match.
if $ITERM_PROFILE =~? 'DARK\c'
  set background=dark
endif
if $ITERM_PROFILE =~? 'LIGHT\c'
  set background=light
endif  

spazm

curl -XPUT "https://localhost:9200/int_vs_str_test" -d '{"mappings": { "foo" : { "properties": { "label_id": { "type": "integer"}}}}}'

{"acknowledged":true}

spazm

#!/bin/sh
set -e

# Check if HEAD and REF can be related by a fast-forward merge.
# Requires that either HEAD or REF be the merge-base between the two branches
usage () {
    cat << EOM
    $0 -v -h REF
    Checks if HEAD and REF can be fast-forwared to each other.