Nikos Gereoudakis stream7

## view_sql_in_rails_console
For Rails 2:

ActiveRecord::Base.connection.instance_variable_set :@logger, Logger.new(STDOUT)

For Rails 3:

ActiveRecord::Base.logger = Logger.new(STDOUT)


taken form http://stackoverflow.com/questions/1344232/how-can-i-see-the-sql-that-will-be-generated-by-a-given-activerecord-query-in-rub

## migration_integer_limit_option
 literally always have to look up the meaning of :limit in migrations when it comes to integer values. Here's an overview. Now let's memorise it (oh, this works for MySQL, other databases may work differently):

:limit	    Numeric Type	Column Size	Max value
1	     tinyint	         1 byte	          127
2	     smallint	         2 bytes	32767
3	     mediumint	         3 byte	        8388607
nil, 4, 11    int(11)	         4 byte	       2147483647
5..8	      bigint	         8 byte	     9223372036854775807

Note: by default MySQL uses signed integers and Rails has no way (that I know of) to change this behaviour. Subsequently, the max. values noted are for signed integers.

## README.markdown

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                stream7
                / README.markdown
            
            
              Created
              August 13, 2011 11:33
                — forked from ariera/README.markdown
            
              
                Nestable, sortable and dragable categories
              
          
    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

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


## mysqldump_single_table
Backuping a single table from a database
mysqldump -u -p database_one -h host table_name > /var/www/backups/table_name.sql

Backuping a single table from a database with query
mysqldump -u #{user} -p#{pass} -h #{server} -nt --databases #{database} --tables #{table}  --where="#{query}" > example.sql
mysqldump -u root -prootpass -h ssserver -nt --databases example_development --tables products  --where="id > 7970001" > products.sql
-n -t for --no-create-db --no-create-info
mysqldump -u root -pmagrathea -h ssserver  --no-create-db --no-create-info --databases marvin_real3 --tables products  --where="id > 7970001" > pr2.sql

Restoring the table into another database

## favorite_gems.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                stream7
                / favorite_gems.md
            
            
              Created
              August 29, 2011 18:07
                — forked from ryanb/favorite_gems.md
            
              
                A list of my favorite gems for various tasks.
              
          
    These are some of my (Ryan Bates) favorite gems to use for various tasks:

JavaScript: jQuery with jquery-rails
Pagination: Kaminari
Testing: RSpec, Cucumber and Capybara
Factories: Factory Girl
Authentication: Nifty Generators and Omniauth
Authorization: CanCan
File Attachments: Carrierwave
HTML/XML Parsing: Nokogiri


## Gemfile
group :assets do
  gem 'sass-rails', '~> 3.1.0'
  gem 'coffee-rails', '~> 3.1.0'
  gem 'uglifier'
  gem 'compass', '~> 0.12.alpha'
end

## index.html.slim
doctype html
/[if lt IE 7]
  | <html class="no-js ie6 oldie" lang="en">
/[if IE 7]
  | <html class="no-js ie7 oldie" lang="en">
/[if IE 8]
  | <html class="no-js ie8 oldie" lang="en">
/[if gte IE 8]
  | <html class="no-js" lang="en">
head

## paperclip.rb
Paperclip.interpolates(:s3_eu_url) { |attachment, style|
  "#{attachment.s3_protocol}://s3-eu-west-1.amazonaws.com/#{attachment.bucket_name}/#{attachment.path(style).gsub(%r{^/}, "")}"
}
require 'aws/s3'
AWS::S3::DEFAULT_HOST = "s3-eu-west-1.amazonaws.com"

## avatar_uploader.rb
# app/uploaders/avatar_uploader.rb

  process :fix_exif_rotation
  process :strip
  process :resize_to_fill => [1024, 768]
  process :quality => 90 # Percentage from 0 - 100

## paperclip_migration.rake
# First configure your models to use Amazon s3 as storage option and setup the associated S3 config.
# Then add the classes your want to migrate in the klasses array below.
# Then run rake paperclip_migration:migrate_to_s3
# Should work but this is untested and may need some tweaking - but it did the job for me.

namespace :paperclip_migration do
  desc "migrate files from filesystem to s3"
  task :migrate_to_s3 => :environment do
    klasses = [:model_1, :model_2] # Replace with your real model names. If anyone wants to this could be picked up from args or from configuration.
    klasses.each do |klass_key|
	For Rails 2:

	ActiveRecord::Base.connection.instance_variable_set :@logger, Logger.new(STDOUT)

	For Rails 3:

	ActiveRecord::Base.logger = Logger.new(STDOUT)


	taken form http://stackoverflow.com/questions/1344232/how-can-i-see-the-sql-that-will-be-generated-by-a-given-activerecord-query-in-rub
	literally always have to look up the meaning of :limit in migrations when it comes to integer values. Here's an overview. Now let's memorise it (oh, this works for MySQL, other databases may work differently):

	:limit Numeric Type Column Size Max value
	1 tinyint 1 byte 127
	2 smallint 2 bytes 32767
	3 mediumint 3 byte 8388607
	nil, 4, 11 int(11) 4 byte 2147483647
	5..8 bigint 8 byte 9223372036854775807

	Note: by default MySQL uses signed integers and Rails has no way (that I know of) to change this behaviour. Subsequently, the max. values noted are for signed integers.
	Backuping a single table from a database
	mysqldump -u -p database_one -h host table_name > /var/www/backups/table_name.sql

	Backuping a single table from a database with query
	mysqldump -u #{user} -p#{pass} -h #{server} -nt --databases #{database} --tables #{table} --where="#{query}" > example.sql
	mysqldump -u root -prootpass -h ssserver -nt --databases example_development --tables products --where="id > 7970001" > products.sql
	-n -t for --no-create-db --no-create-info
	mysqldump -u root -pmagrathea -h ssserver --no-create-db --no-create-info --databases marvin_real3 --tables products --where="id > 7970001" > pr2.sql

	Restoring the table into another database
	group :assets do
	gem 'sass-rails', '~> 3.1.0'
	gem 'coffee-rails', '~> 3.1.0'
	gem 'uglifier'
	gem 'compass', '~> 0.12.alpha'
	end
	doctype html
	/[if lt IE 7]
	\| <html class="no-js ie6 oldie" lang="en">
	/[if IE 7]
	\| <html class="no-js ie7 oldie" lang="en">
	/[if IE 8]
	\| <html class="no-js ie8 oldie" lang="en">
	/[if gte IE 8]
	\| <html class="no-js" lang="en">
	head
	Paperclip.interpolates(:s3_eu_url) { \|attachment, style\|
	"#{attachment.s3_protocol}://s3-eu-west-1.amazonaws.com/#{attachment.bucket_name}/#{attachment.path(style).gsub(%r{^/}, "")}"
	}
	require 'aws/s3'
	AWS::S3::DEFAULT_HOST = "s3-eu-west-1.amazonaws.com"
	# app/uploaders/avatar_uploader.rb

	process :fix_exif_rotation
	process :strip
	process :resize_to_fill => [1024, 768]
	process :quality => 90 # Percentage from 0 - 100
	# First configure your models to use Amazon s3 as storage option and setup the associated S3 config.
	# Then add the classes your want to migrate in the klasses array below.
	# Then run rake paperclip_migration:migrate_to_s3
	# Should work but this is untested and may need some tweaking - but it did the job for me.

	namespace :paperclip_migration do
	desc "migrate files from filesystem to s3"
	task :migrate_to_s3 => :environment do
	klasses = [:model_1, :model_2] # Replace with your real model names. If anyone wants to this could be picked up from args or from configuration.
	klasses.each do \|klass_key\|