aboutsummaryrefslogtreecommitdiffstats
path: root/guides/source/active_record_querying.md
Commit message (Collapse)AuthorAgeFilesLines
* Revert change on ActiveRecord::Relation#order method that prepends newRafael Mendonça França2013-07-291-2/+2
| | | | | | | | | | | | | | | order on the old ones The previous behavior added a major backward incompatibility since it impossible to have a upgrade path without major changes on the application code. We are taking the most conservative path to be consistent with the idea of having a smoother upgrade on Rails 4. We are reverting the behavior for what was in Rails 3.x and, if needed, we will implement a new API to prepend the order clauses in Rails 4.1.
* Add a SQL example for `not` [ci skip]Robin Dupret2013-07-261-1/+7
| | | | To share a certain logic across other examples, let's add a sample SQL code generated by the given Ruby code
* Revert "Fix SyntaxError in guides sample code"Erich Kist2013-07-181-1/+1
| | | | | | | | This reverts commit f573df32d43c413a5098721ba6151ff190c23c6c. The original idea of this documentation was to showcase the feature where you can remove some only queries attributes with a single key-value pair.
* Fix SyntaxError in guides sample codeAkira Matsuda2013-07-081-1/+1
| | | | [ci skip]
* 1.9 Hash SyntaxAkira Matsuda2013-07-081-1/+1
|
* removed markdown code markers which were rendering in the generated AR ↵Brian Foshee2013-07-041-2/+0
| | | | querying guide
* Merge branch 'master' of github.com:lifo/docrailsVijay Dev2013-06-261-1/+1
|\ | | | | | | | | Conflicts: guides/source/layout.html.erb
| * reorder finder methods list alphabeticallyMikhail Dieterle2013-06-161-1/+1
| |
* | Added an example of the query without except before the example with exceptPrathamesh Sonpatki2013-06-141-0/+8
|/
* Merge branch 'master' of github.com:lifo/docrailsVijay Dev2013-06-141-2/+2
|\ | | | | | | | | Conflicts: guides/source/upgrading_ruby_on_rails.md
| * Remove double spaces in code examplesSunny Ripert2013-05-281-1/+1
| |
| * In rails 4 there are much more ways to retrieve a single objectMikhail Dieterle2013-05-221-1/+1
| |
* | Missing ending ``` at 14.2 Merging of scopesLeo Gallucci2013-05-191-0/+1
|/ | | http://edgeguides.rubyonrails.org/active_record_querying.html#merging-of-scopes
* Rails 4 has deprecated :order in has_many to use a lambda instead, update ↵Nick Quaranto2013-05-011-1/+1
| | | | the guide accordingly
* it's Active Record not ActiveRecordYves Senn2013-04-301-1/+4
| | | | /cc @fxn
* Mention that Dynamic finders have been deprecated in Rails 4Jonathan Roes2013-04-231-0/+2
|
* more Ruby 1.9 Hash syntax in our guidesYves Senn2013-04-151-1/+1
|
* Merge branch 'master' of github.com:lifo/docrailsVijay Dev2013-03-301-9/+5
|\ | | | | | | | | | | | | | | | | Conflicts: activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb activerecord/test/cases/adapter_test.rb guides/source/testing.md [ci skip]
| * Update documentation for Where chained modifiers.Ryan Sandridge2013-03-191-7/+3
| | | | | | | | | | where.like and where.not_like were removed in 8d02afeaee, but the guide was not updated.
| * do some typo fixingVipul A M2013-03-141-1/+1
| |
| * I think "uniq" is more Rails-y than select("distinct(categories.id)")capps2013-03-111-1/+1
| |
* | rename `Relation#uniq` to `Relation#distinct`. `#uniq` still works.Yves Senn2013-03-151-5/+6
|/ | | | | | | | The similarity of `Relation#uniq` to `Array#uniq` is confusing. Since our Relation API is close to SQL terms I renamed `#uniq` to `#distinct`. There is no deprecation. `#uniq` and `#uniq!` are aliases and will continue to work. I also updated the documentation to promote the use of `#distinct`.
* copy edits [ci skip]Vijay Dev2013-03-101-1/+1
|
* fixing typo in the merging scopes sectionNeeraj Singh2013-03-081-4/+3
|
* Explained how merging of scope worksNeeraj Singh2013-03-081-0/+56
|
* fixes active_record_querying #pluck exampleawilliams2013-03-071-1/+1
|
* Created an unscope method for removing relations from a chain ofwangjohn2013-03-031-0/+21
| | | | | relations. Specific where values can be unscoped, and the unscope method still works when relations are merged or combined.
* Merge branch 'master' of github.com:lifo/docrailsVijay Dev2013-02-261-2/+2
|\
| * Update guides/source/active_record_querying.mdHanfei Shen2013-02-191-2/+2
| | | | | | | | Fix missing `ORDER BY id ASC` for Client.first(2); Uppercase the little y in the SQL equivalent of the Client.last(2).
* | remove AR auto-explain (config.auto_explain_threshold_in_seconds)Yves Senn2013-02-241-39/+0
|/ | | | | | | | | | We discussed that the auto explain feature is rarely used. This PR removes only the automatic explain. You can still display the explain output for any given relation using `ActiveRecord::Relation#explain`. As a side-effect this should also fix the connection problem during asset compilation (#9385). The auto explain initializer in the `ActiveRecord::Railtie` forced a connection.
* find_last_by is deprecated in AR 4Akira Matsuda2013-01-021-2/+0
|
* find_all_by is deprecated in AR 4Akira Matsuda2013-01-021-1/+1
|
* Merge branch 'master' of github.com:lifo/docrailsVijay Dev2012-12-081-11/+9
|\
| * Remove references to Rails versions.Steve Klabnik2012-12-071-2/+0
| | | | | | | | | | | | | | | | There's no reason for guides to reference old behaviors. They should be current as of the versions of Rails that they ship with, and including older information just clutters thing. I discussed this change with @fxn and he agrees.
| * Punctuation, capitalization, grammar fixes in rails guidesKatie Oldaker2012-12-071-2/+2
| |
| * Fixed grammar in a lot of guide prologues.Katie Oldaker2012-12-071-7/+7
| |
| * changing tense, since Rails 3.2 has been releasedDrew Dara-Abrams2012-12-061-1/+1
| |
* | Merge pull request #8332 from amatsuda/ar_where_chainCarlos Antonio da Silva2012-12-071-0/+14
|\ \ | |/ |/| | | | | | | | | | | Relation.where with no args can be chained with not, like, and not_like Conflicts: activerecord/CHANGELOG.md activerecord/lib/active_record/relation/query_methods.rb
| * Relation.where with no args can be chained with not, like, and not_likeAkira Matsuda2012-11-301-0/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | examples: Model.where.not field: nil #=> "SELECT * FROM models WHERE field IS NOT NULL Model.where.like name: 'Jeremy%' #=> "SELECT * FROM models WHERE name LIKE 'Jeremy%' this feature was originally suggested by Jeremy Kemper https://github.com/rails/rails/pull/5950#issuecomment-5591330 Closes #5950
* | Normalize on 'After reading this guide, you will know:'Steve Klabnik2012-11-291-1/+3
| | | | | | | | | | We have three or four different introduction sentences to the guides. After this commit, we use the same one everywhere.
* | Add periods to the bullet points in guides.Steve Klabnik2012-11-291-7/+7
| | | | | | | | Talked with @fxn about this. Bullet points should have periods at the ends.
* | ActiveRecord -> Active RecordSteve Klabnik2012-11-291-1/+1
|/ | | | | The proper name, as per the documentation guides, is 'Active Record.' I've updated several references to it as 'ActiveRecord'.
* Fix broken link in Active Record Query Interface guideJaime Iniesta2012-11-181-1/+1
|
* Revert "add AR deep dive video links to guides"Vijay Dev2012-11-171-15/+0
| | | | This reverts commit 25648ce35b9d8df9fac81c1d53c45aaeef08fde9.
* Switch to 1.9 hash syntaxAgis Anastasopoulos2012-11-151-28/+28
|
* add AR deep dive video links to guidesschneems2012-11-141-0/+15
|
* make syntax of select.map(&:field) same as pluckGaurish Sharma2012-11-081-0/+2
| | | The shortcut ampersand syntax of `select.map(&:field)` is same thing as `.plunk(:field)`. document that
* Fix a pair of typos on Active Record Querying guideJaime Iniesta2012-10-261-2/+2
|
* nodoc the first_or_create methods and document alternativesJon Leighton2012-10-191-28/+11
|
* Add Relation#find_or_create_by and friendsJon Leighton2012-10-191-20/+51
| | | | | | | This is similar to #first_or_create, but slightly different and a nicer API. See the CHANGELOG/docs in the commit. Fixes #7853