Cyril Farré jarod022

PostgreSQL 9.x Sequence Fixing Script

This script is intended to automatically fix the sequence numbers for all tables in the current database.

This is accomplished through the use of the setval() command, which we provide with the next ID value we wish to make use of. We use the setval(sequence, number, is_called) overload and set is_called = false in conjunction with COALESCE(MAX + 1, 1) to ensure that, with an empty table, the next sequence value is 1 as expected.

Docker Resources All In One

A collection of docker online resources. Source

	#!/bin/bash

	# https://www.digitalocean.com/community/tutorials/how-to-secure-apache-with-let-s-encrypt-on-ubuntu-14-04

	# Download the Let’s Encrypt Client
	cd /usr/local/sbin
	sudo wget https://dl.eff.org/certbot-auto
	sudo chmod a+x /usr/local/sbin/certbot-auto

	# Set Up the SSL Certificate

	#Steps to install RVM + Ruby 1.9.3 + Rails + nginx + Passenger on CentOS (tested on v5.5)

	# Todo get up to date repo's

	# Install git and curl, if not already installed
	sudo yum install git
	sudo yum install curl-devel

	# Create the rvm group and add any users who will be using rvm to the group
	sudo su -

	set :domain, "licensing.lichfield-001.vm.brightbox.net"
	set :application, "licensing"
	set :deploy_to, "/home/rails/#{application}"

	set :user, "rails"
	set :use_sudo, false

	ssh_options[:forward_agent] = true

	set :scm, :git

	set :application, "multio"
	set :scm, :git
	set :repository, "[email protected]:cearls/multio.git"
	set :domain, "web310.webfaction.com"

	set :user, "cearls"
	set :scm_username, "cearls"
	set :use_sudo, false
	default_run_options[:pty] = true
	set :ssh_options, {:forward_agent => true}

	load 'deploy/assets'

	namespace :deploy do
	namespace :assets do
	desc 'Run the precompile task locally and rsync with shared'
	task :precompile, :roles => :web, :except => { :no_release => true } do
	%x{bundle exec rake assets:precompile}
	%x{rsync --recursive --times --rsh=ssh --compress --human-readable --progress public/assets #{user}@#{host}:#{shared_path}}
	%x{bundle exec rake assets:clean}
	end

	/**********************************************/
	/*
	/* IR_Black Skin by Ben Truyman - 2011
	/*
	/* Based on Todd Werth's IR_Black:
	/* http://blog.toddwerth.com/entries/2
	/*
	/* Inspired by Darcy Clarke's blog post:
	/* http://darcyclarke.me/design/skin-your-chrome-inspector/
	/*

	/**
	* Add this script to the end of your document that use <input autofocus type="text" />
	* or <input type="text" placeholder="username" /> and it'll plug support for browser
	* without these attributes
	* Minified version at the bottom
	*/
	(function () {

	function each(list, fn) {
	var l = list.length;

Cyril Farré jarod022

PostgreSQL 9.x Sequence Fixing Script

Docker Resources All In One

Menu