Fat Models

This is a blog about my findings with rails, ruby, and other misc. programming things. It's mostly for my personal use, to keep track of things I want to remember. Maybe it will be useful to you too.

[fatmodelsblog-blog]

Running specific migrations

rake db:migrate:redo VERSION=20140430171821

[fatmodelsblog-blog]

HABTM Class

If you ever need to work directly with a HABTM relation table, you can simply create a model which inherits from active record to interact with the data:

If your table is named agents_clients, create a class called AgentsClients:

class AgentsClients < ActiveRecord::Base end

Now you can do things like:

ac = AgentsClients.first

I used this when I was migrating an existing HABTM relation to a has_many :through model.  It was useful to be able to grab all the data and move it to my new :through model.

[fatmodelsblog-blog]

rake mongo:restore

rake mongo:restore LOCAL=/absolute/path/to/<backup-file.gz>

[fatmodelsblog-blog]

Drop Table via Active Record

ActiveRecord::Migration.drop_table :table_name

ActiveRecord::Migration.add_column :table_name, :length, :integer, default: 2

[fatmodelsblog-blog]

Track Branch

git branch --set-upstream mobile-new origin/mobile-new

[fatmodelsblog-blog]

Reset Auto Increment

def self.reset_auto_num

ActiveRecord::Base.connection.execute( "alter table [table] auto_increment 1 " )

end

[fatmodelsblog-blog]

Delete GIT Branch

git push REMOTENAME :BRANCHNAME

ex: git push origin :newcrops

[fatmodelsblog-blog]

Git Branch

[from master] git branch staging

git checkout staging

Switched to branch 'staging'

git push origin staging:refs/heads/staging

[fatmodelsblog-blog]

New Rails app with MySQL

rails new [project_name] -d mysql

[fatmodelsblog-blog]

Collect

User.find(:all, :conditions => "hitfix = 1").collect(&:id)

[fatmodelsblog-blog]

Helpers within Controllers

You can use @template.[helper] within a controller to use it! COOL!

@template.strip_tags(event.description),

[fatmodelsblog-blog]

Run a specific migration

rake db:migrate:up VERSION=20120113194623

[fatmodelsblog-blog]

Creating a migration in rails 2.1

ruby script/generate migration ‘name’

[fatmodelsblog-blog]

Installing a gem within my RVM environment

rvm 1.8.7@rails211 do gem install AjaxfulRating  --no-rdoc --no-ri

[fatmodelsblog-blog]

Console on EY SSH (from the current directory)

ey_bundler_binstubs/rails c

[fatmodelsblog-blog]

Load a SQL file to a table

msyql -u root  hitfix2 -p <  thefilename.sql