CREATE OR REPLACE FUNCTION public.sp_user_ins_status(status smallint)
RETURNS integer
LANGUAGE plpgsql
AS $function$
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/nodejs | |
// Easily copy and sync media from downloads area to target location | |
// | |
// Daniel Gillespie | |
// 2016 | |
// | |
// Install required packages where you're placing script | |
// npm install --save prompt-sync chalk exec-sync rsync | |
// |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
vagrant ssh -- -L 5858:127.0.0.1:5858 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// showRSS scheduler rss feed parse and download magent link files for your personal showRSS RSS URL | |
// HOW TO USE // | |
// 1. Setup showRss Feed and get a personal URL | |
// 2. Setup a torrent downloader (I like Deluge) and have it watch a folder to auto-add torrent_files | |
// 3. Cron to setup | |
// * 23 * * * nodejs /usr/bin/showrss_downloader.js >> /var/log/showrss_downloader.log 2>&1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/sh | |
# AUTHOR | |
# DANIEL E. GILLESPIE (2016) | |
# https://github.com/dantheman213 | |
# DESCRIPTION | |
# Export your app's table schemas and stored functions from a PostgreSQL | |
# database into individual *.sql files for easy management and source control. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/sh | |
# AUTHOR | |
# DANIEL E. GILLESPIE (2016) | |
# https://github.com/dantheman213 | |
# DESCRIPTION | |
# Import all *.sql files in a folder recuresively into your PostgreSQL database | |
# Batch export all table schemas and stored functions with this script located here: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!upstart | |
# NodeJS 'Upstart' Start-up script. | |
# Works on Ubuntu 14.04. Systemd is being used for Ubuntu 16.04 though. | |
description "your node js web app" | |
start on started mountall | |
stop on shutdown |