Lab Sql

I'm trying to manually execute SQL commands so I can access procedures in NuoDB. I'm using … Read more How Do You Manually Execute Sql Commands In Ruby On Rails Using Nuodb

I have a few massive SQL request involving join across various models in my rails application. A si… Read more How To Join On Subqueries Using Arel?

I have an ActiveRecord schema, PurchaseSummary, that I inherited and THAT I CAN NOT CHANGE that loo… Read more Difficulty With Activerecord Query That Does Percentage Calculation

I've been working on a small but somewhat complex Rails application with multiple has_and_belon… Read more Sqlexception On Db:test:load With Rails

I have a Rails app using sqlite3. Anytime I want to save anything in test environment I'm getti… Read more Rails/activerecord/sqlite3: Can't Save Records In Test Environment

How can I create active relation queries in Rails 3 that are aggregated by time slice? I'd li… Read more How To Get Aggregate Data By Time Slice (sum, Avg, Min, Max, Etc.) In Rails 3

I have the following model relationships: class Article :article_tags end class ArticleTag Solutio… Read more Rails3 Activerecord - Fetching All Records That Have A And B (through A Has_many Relationship)

What is the meaning of Binary data inserted forstringtype on column ...? When loggin remote ip add… Read more Binary Data Inserted For `string` Type On Column `remote_ip`?

I am trying to deploy my app to Heroku, but it keeps getting rejected with the following output. wa… Read more Heroku Installing Sqlite3 Even Though It Is Not A Dependecy

I think I will want to use combine a model level finder with a lambda. named_scope :recent_snaps, l… Read more Trying To Create A Rails Model Scope Query For Records Since Date X, Use A Lambda?

My last post was on the best way to write a SQL query with conditions on a LEFT OUTER JOIN: LEFT OU… Read more How To Convert Sql Query To Rails Active Record Query?

in Rails 3/AREL Model.group(:label).sum(:value) will do SELECT sum(value), label from model_table g… Read more How To Sum A Grouped Column In Arel

I have the following query method in my ActiveRecord model: def self.tagged_with( string ) arra… Read more Rails: Has Many Through Associations -- Find With And Condition, Not Or Condition

I have the old legacy table called 'DXFTACCTS', and I created Rails model 'Account'… Read more Rails 3 Model Mapping Certain Columns To Different Model Attributes

Im working on Rails 3.0.5 and PostgreSQL. I have a model Offer, that has many Products. class Off… Read more Rails: How To Query For All The Objects Whose Every Association Have An Attribute That Is Not Null

im using Rails 3.2.8 and SQLite 1.3.6 and im running into troubles changing boolian variables in th… Read more Rails 3 And Sqlite Communications Concerning Boolians

I have a table of questions: title Each question has answers, in another table: text, question_id … Read more Order Table By Grouping Values In Another Table