estysdesu

// vim: syntax=sql

CREATE OR REPLACE FUNCTION create_constraint_if_not_exists (t_name text, c_name text, constraint_sql text)
  RETURNS void
AS
$BODY$
  BEGIN
    -- Look for our constraint
    IF NOT EXISTS (SELECT constraint_name
                   FROM information_schema.constraint_column_usage

Werninator

<?php

/**
 * Detects the end-of-line character of a string.
 * modified version from https://stackoverflow.com/questions/11066857/detect-eol-type-using-php
 * @param string $str The string to check.
 * @param string $default Default EOL (if not detected).
 * @return string The detected EOL, or default one.
 */
function detectEol($str, $default = PHP_EOL) {

mohammedyunus009

#!/bin/bash
# Ubuntu Developer Script For pdf2htmlEx
# Created by Rajeev Kannav Sharma
# http://rajeevkannav.github.io/
#
#
# Downloads and configures the following:
#
#   CMake, pkg-config
#   GNU Getopt

quonic

#Requires -Module PSSQLite
param(
    [Alias('Name', '')]
    [string]
    $ProfileName
)
<#
Updated for 9/2 patch
Updated by request of Truth91
#>

spagu

#!/bin/sh

# SVN PRE-COMMIT HOOK
#
# Requirements:
# - PHP installed ( https://secure.php.net/manual/en/install.php ) 
# - PHPCS installed ( https://github.com/squizlabs/PHP_CodeSniffer + https://github.com/WordPress-Coding-Standards/WordPress-Coding-Standards )
# - csslint installed ( https://github.com/CSSLint/csslint/wiki/command-line-interface )
# - i18n0lint installed ( https://github.com/jwarby/i18n-lint )

sebnyberg

Parameters:
  InstanceImageIdParameter:
    Type: AWS::EC2::Image::Id 
    Default: 'ami-5055cd3f'
  InstanceTypeParameter:
    Type: String
    Default: t2.micro
  InstanceKeyNameParameter:
    Type: String
  InstanceNameParameter:

anvk

--- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md
--- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192

-- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB.

------------
-- Basics --
------------

-- Get indexes of tables

mikoim

Parameters

Container: MP4

Parameter	YouTube recommends setting
-movflags faststart	moov atom at the front of the file (Fast Start)

Video codec: H.264

SimonEast

<?php 
// Simply place the following two functions in _support/Helper/Acceptance.php
// Then you can call $I->verifyRedirect(...) inside your tests

namespace Helper;
class Acceptance extends \Codeception\Module
{
    
    /**
     * Ensure that a particular URL does NOT contain a 301/302

agarzon

#!/bin/bash

#To execute it directly: sudo bash <(curl -s https://gist.githubusercontent.com/agarzon/ecb0b92d4c8e1bbde126534c76721a58/raw/install-php-tools.sh)

BIN_PATH=/usr/local/bin/

#COMPOSER
sudo curl -LsS https://getcomposer.org/composer.phar -o ${BIN_PATH}composer
sudo chmod a+x ${BIN_PATH}composer