taybin

CREATE TABLE IF NOT EXISTS stopwords (
  word VARCHAR(20) NOT NULL;
);

CREATE OR REPLACE FUNCTION remove_stopwords(string TEXT, OUT tsv TSVECTOR) AS
$$
BEGIN
  SELECT string_agg(words.*, ' ')::tsvector FROM 
  -- split tsvector into row for each word 
    regexp_split_to_table( 

taybin

var https = require('https');
var util = require('util');

exports.handler = function(event, context) {
    console.log(JSON.stringify(event, null, 2));
    console.log('From SNS:', event.Records[0].Sns.Message);

    var postData = {
        "channel": "#aws-sns",
        "username": "AWS SNS via Lamda :: DevQa Cloud",

taybin

defmodule NodeTest do
  use ExUnit.Case

  test "can have childen and parents" do
    node1 = %Node{name: "parent"} |> Repo.insert
    node2 = %Node{name: "child2"} |> Repo.insert
    %NodeToNode{parent_id: node1.id, child_id: node.id} |> Repo.insert
    assert Node.get_children(node1) == [node2]
    assert Node.get_parents(node2) == [node1]
  end

taybin

defmodule Node do
  import Ecto.Query, only: [from: 2]

  def get_children(node) do
    from(n in Node,
         join: n2n in NodeToNode, on: n.id == n2n.parent_id,
         inner_join: n1 in Node, on: n1.id == n2n.child_id,
         select: n1,
         where: n.id == ^node.id)
    |> Repo.all

taybin

defmodule Node do
  use Ecto.Model

  schema "nodes" do
    has_many :children, NodeToNode, foreign_key: :parent_id
    has_many :parents, NodeToNode, foreign_key: :child_id
  end
end

defmodule NodeToNode do

taybin

defmodule Repo.Migrations.CreateNodes do
  use Ecto.Migration

  def up do
    [
      "CREATE TABLE IF NOT EXISTS nodes(id SERIAL PRIMARY KEY, name TEXT NOT NULL, script TEXT)",
      "CREATE TABLE IF NOT EXISTS node_to_node(parent_id INTEGER NOT NULL REFERENCES nodes(id) ON DELETE CASCADE, child_id INTEGER NOT NULL REFERENCES nodes(id) ON DELETE CASCADE)"
    ]
  end

taybin

defmodule Foo.Model.Job do
  alias Foo.Model.JobToJob, as: JobToJob
  use Ecto.Model

  schema "jobs" do
    field :name, :string
    has_many :children, JobToJob, foreign_key: :parent_id
    has_many :parents, JobToJob, foreign_key: :child_id
  end
end

taybin

#!/bin/bash

# from http://stackoverflow.com/questions/620650/can-i-easily-update-all-local-git-branches-from-remote-branches-simultaneously

main() {
  REMOTES="$@";
  if [ -z "$REMOTES" ]; then
    REMOTES=$(git remote);
  fi
  REMOTES=$(echo "$REMOTES" | xargs -n1 echo)

taybin

#
# css/js minification/compression makefile
#

#
#   JS_TARGETS -- js files to minify/gzip
#   CSS_TARGETS -- css files to minify/gzip
#   CLEANUP -- additional files to delete during "make clean"
# 

taybin

diff --git a/Makefile.in b/Makefile.in
index 7ab25ff..34f5f36 100644
--- a/Makefile.in
+++ b/Makefile.in
@@ -16,9 +16,9 @@ DYNAMIC_EXTENSION	:= .so
 DYNAMIC_FULL_VERSION	:= .2.1.0
 DYNAMIC_ABI_VERSION	:= .2
 DYNAMIC_LIBNAME		:= librubberband$(DYNAMIC_EXTENSION)
-DYNAMIC_LDFLAGS		:= -shared -Wl,-Bsymbolic -Wl,-soname=$(DYNAMIC_LIBNAME)$(DYNAMIC_ABI_VERSION)
-VAMP_LDFLAGS		:= -shared -Wl,-Bsymbolic -Wl,--version-script=vamp/vamp-plugin.map