gist:527117

desc "creates database & database user"

task :create_database do
  set :root_password, Capistrano::CLI.password_prompt("MySQL root password: ")
  set :db_user, Capistrano::CLI.ui.ask("Application database user: ")
  set :db_pass, Capistrano::CLI.password_prompt("Password: ")
  set :db_name, Capistrano::CLI.ui.ask("Database name: ")
    
  run "mysql --user=root --password=#{root_password} -e \"CREATE DATABASE IF NOT EXISTS #{db_name}\""
  run "mysql --user=root --password=#{root_password} -e \"GRANT ALL PRIVILEGES ON #{db_name}.* TO '#{db_user}'@'localhost' IDENTIFIED BY '#{db_pass}' WITH GRANT OPTION\""

mtigas

Client-side SSL

For excessively paranoid client authentication.

---

Updated Apr 5 2019:

because this is a gist from 2011 that people stumble into and maybe you should AES instead of 3DES in the year of our lord 2019.

some other notes:

juggy

# create the template
template = PageOfflineTemplate.new
template.quote = quote
template.pages = quote.build_pages
        
# Here I render a template with layout to a string then a PDF
pdf = PDFKit.new template.render_to_string(:template=>"quotes/review.html.haml")
        

priithaamer

task :ask_production_confirmation do
  set(:confirmed) do
    puts <<-WARN

    ========================================================================

      WARNING: You're about to perform actions on production server(s)
      Please confirm that all your intentions are kind and friendly

    ========================================================================

tenderlove

diff --git a/Makefile.in b/Makefile.in
index a01faae..ff05dae 100644
--- a/Makefile.in
+++ b/Makefile.in
@@ -297,6 +297,10 @@ enc/unicode/name2ctype.h: enc/unicode/name2ctype.kwd
 	@$(ECHO) preprocessing $<
 	$(Q) $(CPP) $(XCFLAGS) $(CPPFLAGS) $(COUTFLAG)$@ -E $< > $@
 
+probes.h:
+	@$(ECHO) translating probes $<

ariera

Nestable, sortable and dragable categories:

In the project I'm working on we wanted to have a Category model which we wanted to be nestable. But we also liked the user to have a draggable interface to manage and rearrange the order of his categories. So we chose awesome_nested_set for the model and jQuery.nestedSortable for the UI.

It took me some time to arrange things to work properly so I wanted to share my work in case it helps anybody.

Before beginning

you might want to take a look at a demo app

1. go to: http://awesomenestedsortable.heroku.com/groups/
2. click in show of any group

piscisaureus

Locate the section for your github remote in the .git/config file. It looks like this:

[remote "origin"]
	fetch = +refs/heads/*:refs/remotes/origin/*
	url = git@github.com:joyent/node.git

Now add the line fetch = +refs/pull/*/head:refs/remotes/origin/pr/* to this section. Obviously, change the github url to match your project's URL. It ends up looking like this:

Mithrandir0x

// Source: https://groups.google.com/forum/#!topic/angular/hVrkvaHGOfc
// jsFiddle: http://jsfiddle.net/pkozlowski_opensource/PxdSP/14/
// author: Pawel Kozlowski

var myApp = angular.module('myApp', []);

//service style, probably the simplest one
myApp.service('helloWorldFromService', function() {
    this.sayHello = function() {
        return "Hello, World!"

jnicklas

require "timeout"

module WaitSteps
  extend RSpec::Matchers::DSL

  matcher :become_true do
    match do |block|
      begin
        Timeout.timeout(Capybara.default_wait_time) do
          sleep(0.1) until value = block.call

mfilej

# http://stackoverflow.com/questions/5108876/kill-a-postgresql-session-connection
namespace :db do 
  desc "Fix 'database is being accessed by other users'"
  task :terminate => :environment do
    ActiveRecord::Base.connection.execute <<-SQL
      SELECT 
        pg_terminate_backend(pid) 
      FROM 
        pg_stat_activity 
      WHERE