Skip to content
Newer
Older
100644 383 lines (254 sloc) 20.5 KB
c3df640 @binarylogic Update changelog
authored Jul 29, 2009
1 == 2.1.13 released 2009-07-29
64053d5 @binarylogic * Applied bug fix from http://github.com/skanev/searchlogic to make #…
authored Jul 28, 2009
2
3 * Applied bug fix from http://github.com/skanev/searchlogic to make #order work with association ordering.
c3df640 @binarylogic Update changelog
authored Jul 29, 2009
4 * Applied bug fix to allow for custom ordering conditions.
64053d5 @binarylogic * Applied bug fix from http://github.com/skanev/searchlogic to make #…
authored Jul 28, 2009
5
256dfa8 @binarylogic * Fixed bug when dealing with scopes that return nil.
authored Jul 28, 2009
6 == 2.1.12 released 2009-07-28
7
8 * Fixed bug when dealing with scopes that return nil.
9
572981a @binarylogic * Reworked how alias conditions are created on the fly, uses scope(:f…
authored Jul 28, 2009
10 == 2.1.11 released 2009-07-28
11
12 * Reworked how alias conditions are created on the fly, uses scope(:find) instead of proxy_options to create the scope. This allows using association alias named scopes.
13
9a2a3e5 @binarylogic * Ignore polymorphic associations when dynamically creating condition…
authored Jul 28, 2009
14 == 2.1.10 released 2009-07-28
15
16 * Ignore polymorphic associations when dynamically creating conditions on associations.
17
141a913 @binarylogic Update changelog
authored Jul 28, 2009
18 == 2.1.9 released 2009-07-28
a56ab14 @binarylogic * Allow the call of foreign pre-existing named scopes instead of thos…
authored Jul 28, 2009
19
20 * Fixed bug when cloning with no scope
141a913 @binarylogic Update changelog
authored Jul 28, 2009
21 * Allow the call of foreign pre-existing named scopes instead of those generated by searchlogic. Allows you to call named scopes on associations that you define yourself.
a56ab14 @binarylogic * Allow the call of foreign pre-existing named scopes instead of thos…
authored Jul 28, 2009
22
23 == 2.1.8 released 2009-07-15
452cd75 @binarylogic * Added support for not_like, not_begin_with, not_end_with, and not_null
authored Jul 16, 2009
24
25 * Added support for not_like, not_begin_with, not_end_with, and not_null
26
27 == 2.1.7 released 2009-07-14
3060eaa @binarylogic * Add support for time zones in the Search class when type casting to…
authored Jul 13, 2009
28
29 * Add support for time zones in the Search class when type casting to Time objects.
30
8a11bfa @binarylogic * Fix bug when trying to set conditions on conflicting column names w…
authored Jul 13, 2009
31 == 2.1.6 released 2009-07-13
616bbb0 @binarylogic * Check for the existence of id before undefining it.
authored Jul 12, 2009
32
8a11bfa @binarylogic * Fix bug when trying to set conditions on conflicting column names w…
authored Jul 13, 2009
33 * Fix bug when trying to set conditions on conflicting column names with associations. Ex: User.has_many :orders, User.order_count_gt(10) would raise an exception because it was trying to set conditions on the count column for the orders table.
34
35 == 2.1.5 released 2009-07-12
36
37 * Check for the existence of id before undefining it, fixes bug in ruby 1.9
38
39 == 2.1.4 released 2009-07-12
40
41 * Add ActiveRecordConsistency module to help AR remove duplicate joins easier.
616bbb0 @binarylogic * Check for the existence of id before undefining it.
authored Jul 13, 2009
42
43 == 2.1.3 released 2009-07-12
a60fc65 @binarylogic * Added a no conflic resolution for other libraries already using the…
authored Jul 6, 2009
44
45 * Added a no conflic resolution for other libraries already using the "search" method. If you have a conflict, use "searchlogic".
ffa174a @binarylogic * Put the hidden order field in a div, to be valid XHTML.
authored Jul 12, 2009
46 * Put the hidden order field in a div, to be valid XHTML.
a60fc65 @binarylogic * Added a no conflic resolution for other libraries already using the…
authored Jul 6, 2009
47
16438fe @binarylogic Small test changes
authored Jul 4, 2009
48 == 2.1.2 released 2009-07-04
101d488 @binarylogic * Undefine the id method for the Search class, so that it acts like a…
authored Jul 3, 2009
49
50 * Undefine the id method for the Search class, so that it acts like a condition.
51
a77b72d @binarylogic Added inner_join convenience method.
authored Jun 28, 2009
52 == 2.1.1 released 2009-06-28
53
54 * Added inner_join convenience method.
55
56 == 2.1.0 released 2009-06-28
47efaeb @binarylogic * Added a delete method to the Search class to allow the deleting of …
authored Jun 20, 2009
57
58 * Added a delete method to the Search class to allow the deleting of conditions off of the object.
8906208 @binarylogic * Add alias_scope feature, lets your create "named scopes" that repre…
authored Jun 21, 2009
59 * Add alias_scope feature, lets your create "named scopes" that represent a procedure of named scopes, while at the same time telling Searchlogic it is safe to use in the Search class.
b3bf6f2 @binarylogic * Use url_for as the default with form_for since rails does some magi…
authored Jun 24, 2009
60 * Use url_for as the default with form_for since rails does some magic to determine the url to use.
2878f5d @binarylogic Update changelog
authored Jun 28, 2009
61 * Switched to using inner joins instead of left outer joins.
47efaeb @binarylogic * Added a delete method to the Search class to allow the deleting of …
authored Jun 20, 2009
62
63 == 2.0.1 released 2009-06-20
1cb9ecb @binarylogic * Allow the chaining of conditions off of a search object. Ex: search…
authored Jun 16, 2009
64
65 * Allow the chaining of conditions off of a search object. Ex: search.username_like("bjohnson").age_gt(20).all
8563a4d @binarylogic * Split out left outer join creation into its own method, allowing yo…
authored Jun 16, 2009
66 * Split out left outer join creation into its own method, allowing you to use it in your own named scopes.
58e1326 @binarylogic * Make sure the search objects clone properly.
authored Jun 17, 2009
67 * Make sure the search objects clone properly.
e8a52ec @binarylogic * named_scope_options should return the proper options for existing n…
authored Jun 17, 2009
68 * named_scope_options should return the proper options for existing named scopes with an arity greater than 0
1cb9ecb @binarylogic * Allow the chaining of conditions off of a search object. Ex: search…
authored Jun 16, 2009
69
c2bea31 @binarylogic Update readme
authored Jun 15, 2009
70 == 2.0.0
71
72 * Everything, completely rewritten.
73
74 == 1.6.6
75
76 * Fixed time zone issues when searching.
77
78 == 1.6.5 released 2009-04-2
79
80 * Skip all associations defined with the :finder_sql option, since conditions can not be chained to them, etc.
81 * Fixed bug when using non string values for the keywords condition.
82 * Fixed undefined methods link_options error.
83 * Return blank conditions when trying to scope blank conditions. Fixes the issue with groups that return a blank SQL string.
84 * Fixed issue with blank condition comparing boolean values to non boolean columns.
85 * Add utf-8 magic comment for ruby 1.9
86
87 == 1.6.4 released 2009-01-22
88
89 * Fixed calling attribute_condition with newer versions of rails.
90
91 == 1.6.3 released 2008-12-13
92
93 * Added in avg, count, and sum modifiers for SQLite and Postgres.
94 * Added ne for not_equal condition.
95 * Ignore :include option for calculations since we don't need it and AR throws an error for polymorphic relationships.
96 * Removed sum and count since they can not be in the WHERE statement, but must be in the HAVING statement
97 * Added in auto joins for groups so that the joins don't have to be manually specified.
98 * Use first column in column_names as the default column for calculations, since a column is required when using DISTINCT and some tables can have more than one primary key.
99 * On associations see what the first conditions "any" status is to determine if to join with "ANY" or "AND"
100
101 == 1.6.2 released 2008-12-13
102
103 * Remove duplicate joins at a lower level for a cleaner and less brittle approach.
104
105 == 1.6.1 released 2008-12-8
106
107 * Group multi faceted conditions since we allow for the mix of "and" and "or"
108 * Blank arrays are not meaningful values for conditions
109 * Add in a unique identifier for the auto-generated hidden fields so that multiple forms do no present a problem.
110
111 == 1.6.0 released 2008-12-8
112
113 * Converted all tree conditions to nested set conditions for performance reasons. A nested set data structure is now required instead of a tree
114 * Added DISTINCT to select if you are not provided a select, searching, and have joins.
115 * Included :not_like in the list of conditions to be required upon initialization.
116
117 == 1.5.10 released 2008-12-8
118
119 * Create class level conditions upon instantiation to avoid conflicts.
120
121 == 1.5.9 released 2008-12-3
122
123 * Added metaclass object extension for older version of ActiveSupport.
124 * Added average, count, and sum modifiers.
125
126 == 1.5.8 released 2008-12-3
127
128 * Removed array support for groups, arrays will set conditions, not create multiple groups. If you need to create multiple groups you will have to pass an array with multiple {:group => my_groups} hashes.
129 * Fixed issues with using name spaced models.
130 * Added support for multiparameter conditions to support date_select helpers.
131
132 == 1.5.7 released 2008-11-30
133
134 * Fixed how grouping works, you can now specify "and_group" and "or_group", just like you can with conditions.
135 * Specifying a join type will take priority. So "and_name_like" will ALWAYS join with AND, even is any = true for the search.
136
137 == 1.5.6 released 2008-11-29
138
139 * The order conditions are set is now relevant and will be reflected in the SQL. Setting a condition first will make it first in the SQL, setting a condition last will make it last in the SQL.
140 * The above allows for prefixing any condition with and_ or or_. Thus letting you create somewhat more complex queries, since the order matters.
141 * Added ability to group conditions to mimic parenthesis in raw SQL.
142 * Major clean up in the Searchlogic::Conditions name space: faster, smaller, cleaner, and modular.
143
144 == 1.5.5 released 2008-11-17
145
146 * Cleaned up class_name configuration for helpers, so that setting them to nil disables the class name
147 * Added page_links_div_wrapper and page_links_div_wrapper_class_name configuration option to add an wrapping div around page_links
148 * Added page_links_act_like_will_paginate configuration option to help with the transition from will_paginate
149
150 == 1.5.4 released 2008-11-16
151
152 * Removed subclass requirement for adding conditions in Conditions::Base
153 * Removed DISTINCT in the select clause, instead called uniq! on the results. PostgreSQL complains about DISTINCT and AR uses uniq! when using :includes, so this is the best option.
154 * Converted the return for SQLite's strftime to integer from string. This way day of month, day of year, etc works as expected.
155
156 == 1.5.3 released 2008-10-30
157
158 * Removed ilike conditions and let the like condition determine if it should use like or ilike depending on the connection adapter.
159 * Fixed bug where the keywords condition was removing foreign characters.
160 * Added configuration option for specifying your javascript library, to cut down on the javascript Searchlogic adds into the form helpers
161 * Fixed bug with "not" conditions to use sanitize method, like it should, instead of to_conditions.
162 * Only pass :distinct option for the count calculation
163 * Fixed not_nil and not_blank conditions to use boolean values configuration option.
164
165 == 1.5.2 released 2008-10-21
166
167 * Added ilike conditions
168 * Removed configatron dependency (was accidentally added)
169
170 == 1.5.1 released 2008-10-20
171
172 * Fixed bug with per_page_links
173 * Added "ordering_by" class for per_page_links
174
175 == 1.5.0 released 2008-10-20
176
177 * Merge array of conditions with or or and where it makes sense. Begins with condition does not make sense to join with and, so instead join with or.
178 * Cleaned up html validity so it will pass W3C validators
179 * Restructure configuration to be more organized and allow for more configuration options.
180 * Added more configuration options, especially for class names.
181
182 == 1.4.1 released 2008-10-15
183
184 * Extracted english text into configuration to support alternate languages. I18n support.
185 * Improved method detection in add_joins to use respond_to? with the private method option set to true
186
187 == 1.4.0 released 2008-10-15
188
189 * Fixed bug when duping or cloning to copy over instance vars instead of method values
190 * Fixed bug with older versions of ActiveRecord and creating an alias method chain on find in AssociationCollection
191 * Added modifiers: upper, lower, trim, ltrim, rtrim
192 * Added not_nil and not_blank conditions
193 * Modified conditions so that table name is a variable, this allows table name to be switched on the fly.
194 * Modified auto joins to return symbols instead of SQL. This allows AR to properly merge the joins and ultimately result in proper SQL when performing multiple complex scopes.
195 * Fixed conflicts between includes and joins, duplicate joins are not added. Includes are prioritized. This also makes ActiveRecord much more flexible. Now you can cherry pick included associations. And not have to worry about conflicting with joins.
196 * Modified ActiveRecord's default behavior to use inner joins with the :joins option. Inner joins impose limitations. When providing this as a "convenience", inner joins do not make sense. The don't allow OR conditions to be across associations, nor does it properly order when an ordering by an association attribute when that association is optional.
197
198 == 1.3.5 released 2008-10-08
199
200 * Since joins are now strings, AR doesn't know how to merge them properly. So searchlogic now checks which joins to skip over to avoid conflicts.
201
202 == 1.3.4 released 2008-10-07
203
204 * Fixed method names creation for conditions with modifiers
205 * Create local column conditions, incase there are method conflicts. Such as "id".
206 * All joins are switched to left outer joins. When search with *any* conditions, inner joins return incorrect results. Also when ordering by an association that allows for blanks, inner joins exclude the records with blank values. Only option is left outer joins.
207 * If joins is manually set with a string, treat it as SQL, just like ActiveRecord
208
209 == 1.3.3 released 2008-10-03
210
211 * Fixed modifiers being double escaped on equals condition
212 * Fixed bug when merging conditions with array substitutions
213 * Updated blank condition to check if the values is false or not
214 * Fixed type for the year modifier in the mysql adapter
215
216 == 1.3.2 released 2008-10-03
217
218 * Fixed condition to type cast all values in an array
219 * Fixed bug to properly set the type for the type cast column
220 * Fixed bug to allow conditions on local columns
221 * Apparently ActiveRecord 2.2 doesnt remove duplicates on all joins, need to enforce this for ALL versions of ActiveRecord
222 * Fixed bug when passing a symbol as the SQL type for condition return types
223 * Moved duplicate removal to only apply when searching or calculating from a search object. Anything done in a normal ActiveRecord method should remain untouched and let ActiveRecord handle it. Just like in ActiveRecord if you do a User.all search and pass some :joins, you might get duplicate records. Searchlogic should not change that behavior, unless called from a searchlogic object.
224 * Discard meaningless array values when setting a condition.
225 * Delete blank strings from mass assignments on conditions.
226
227 == 1.3.1 released 2008-10-02
228
229 * Fixed bug when requiring a connection adapter that is not present
230 * Fixes bug in "not" conditions
231
232 == 1.3.0 released 2008-10-02
233
234 * Added modifiers into the mix: hour_of_created_at_less_than = 10, etc.
235 * Changed how the Searchlogic::Conditions::Base class works. Instead of predefining all methods for all conditions upon instantiation, they are defined as needed via method_missing. Similar to
236 ActiveRecord's dynamic finders: User.find_by_name_and_email(name, email). Once the are defined they never hit method_missing again, acts like a cache.
237 * Altered how values are handled for each condition, meaningless values are ignored completely.
238 * Added in more "not" conditions: not_like, not_begin_with, not_have_keywords, etc
239
240 == 1.2.2 released 2008-09-29
241
242 * Fixed bug when reverse engineering order to order_by, assumed ASC and DESC would always be present when they are not.
243 * False is a meaningful value for some conditions, and false.blank? == true. So instead of using value.blank? to ignore conditions we use meaningless?(value), which returns false if it is false.
244 * Fixed aliases for lt, lte, gt, and gte.
245 * Fixed bug when writing conditions on associations via a hash with string keys
246 * Added Config.remove_duplicates to turn off the "automatic" removing of duplicates if desired.
247 * Updated searchlogic_state helper to insert the entire state all at once.
248 * Added CSS class "ordering" to order_by_link if the search is being ordered by that.
249
250 == 1.2.1 released 2008-09-25
251
252 * Fixed problem when determining if an order_by_link is currently being ordered. Just "stringified" both comparable values.
253 * Removed default order_by and order_as. They will ONLY have values if you specify how to order, otherwise they are nil.
254 * Removed order_as requirement. order_as is optional.
255 * Added in deep_merge methods for hash, copied over from ActiveSupport 2.1
256 * Improved order by auto joins to be based off of what order_by returns instead of setting it when setting order_by.
257 * Added priority_order_by. Useful if you want to order featured products first and then order as usual. See documentation in Searchlogic::Search::Ordering for more info.
258 * Added in base64 support for order_by and priority_order_by so that it's value is safe in the URL
259 * Added priority_order_by_link
260
261 == 1.2.0 released 2008-09-24
262
263 * Added searchlogic_params and searchlogic_url helper to use outside of the control type helpers.
264 * Added dup and clone methods that work properly for searchlogic objects
265 * Fixed bug to remove nil scope values, HABTM likes to add :limit => nil
266 * Removed unnecessary build_search methods for associations
267 * Removed support for searching with conditions only. This just made things much more complicated when you can accomplish the same thing by starting a new search and only setting conditions.
268 * Fixed bug when searching with *any* conditions to use left outer joins instead of inner joins.
269
270 == 1.1.3 released 2008-09-23
271
272 * Setting a condition to nil removes it if the condition is set to ignore blanks
273 * Setting search.conditions = "some sql" will reset ALL conditions. Alternatively search.conditions => {:first_name_contains => "Ben"} will overwrite "some sql". The same goes with search.conditions.first_name_contains = "Ben".
274 * Fixed bug with inspect
275 * Other small performance enhancements with memoized attributes
276
277 == 1.1.2 released 2008-09-22
278
279 * Fixed bug with select control types not using :search_obj to determine its select values.
280 * Added is_nil and is_blank condition types.
281 * "memoized" various attributes for performance enhancements
282 * Removed the :order option from calculation options when :order is useless and just slows down query.
283 * Switched from using :include to :joins, big performance increase
284
285 == 1.1.1 released 2008-09-19
286
287 * Fixed typo in "next page" button.
288 * Updated valid options for searching and performing calculations, fixed some bugs when searching and performing calculations with advanced options.
289 * Fixed bug in ordering where table name was assumed by the hash. Now assumed by the reflection.
290 * Added default for per_page, so pagination comes implemented by default
291 * On mass assignments blank strings for *any* conditions are ignored. Sometimes blank strings are meaningful for "equals" and "does not equal", those only takes effect if you explicitly call these conditions: search.conditions.name = "". User.new_search(:conditions => {:name => ""}) will be ignored. Also, Searchlogic should never change how ActiveRecord behaves by default. So User.all(:conditions => {:name => ""}) will NOT be ignored.
292
293 == 1.1.0 released 2008-09-18
294
295 * Added the options :inner_spread and :outer_spread to the page_links helper. Also added various config options for setting page_links defaults.
296 * Updated calculation methods to ignore :limit and :offset. AR returns 0 or nil on calculations that provide an offset.
297 * Added support to allow for "any" of the conditions, instead of all of them. Joins conditions with "or" instead of "and". See Searchlogic::Conditions::Base or the readme
298
299 == 1.0.4 released 2008-09-18
300
301 * Fixed bugs when performing calculations and searches on has_many through relationships.
302 * Instead of merging the find_options myself, I delegated that to AR's with_scope function, which already does this. Much more solid, less intrusive.
303
304 == 1.0.3 released 2008-09-18
305
306 * Updated inspect to show the current options for your search. Plays nicer in the console.
307 * Made sure protection state is persistent among relationship conditions.
308 * Fixed bug with backwards compatibility of rails. concat requires a proc in older version.
309 * Defaulted remote control types to use GET requests instead of POST.
310 * Completely reengineered integration with ActiveRecord. Searchlogic is properly using scopes letting you do use serachgasm where scope are implemented. @current_users.orders.new_search, etc. If your search is scoped and you want a search object, that search object will represent a new search in the context of those scopes, meaning the scopes get merged into Searchlogic as options.
311 * Dropped support for Searchlogic functionality when defining relationships: has_many :order, :conditions => {:total_gt => 100}, will not work anymore. It's a chicken and the egg thing. Searchlogic needs AR constants, some models get loaded before others, therefore the Order model may not have been loaded yet, causing an unknown constant error.
312 * Clean up redundant code and moved it into the Searchlogic::Shared namespace.
313
314 == 1.0.2 released 2008-09-12
315
316 * Moved cached searchers out of the global namespace and into the Searchlogic::Cache namespce.
317 * Various changes to improve performance through profiling / benchmarking. http://pastie.org/271936
318 * Config.per_page works with new_search & new_search! only. Where as before it was only working if the search was protected.
319
320 == 1.0.1 released 2008-09-11
321
322 * Cached "searchers" so when a new search object is instantiated it doesn't go through all of the meta programming and method creation. Helps a lot with performance. You will see the speed benefits after the first instantiation.
323 * Added in new options for page_links.
324 * Fixed minor bugs when doing page_links.
325 * Updated documentation to be more detailed and inclusive.
326
327 == 1.0.0 released 2008-09-08
328
329 * Major changes in the helpers, they were completely re-engineered. Hence the new version. I established a pattern between all helpers giving you complete flexibility as to how they are used. All helpers are called differently now (see documentation).
330
331 == 0.9.10 released 2008-09-08
332
333 * Fixed bug with setting the per_page configuration to only take effect on protected searches, thus staying out of the way of normal searching.
334 * Hardened more tests
335
336 == 0.9.9 released 2008-09-07
337
338 * Fixed setting per_page to nil, false, or ''. This is done to "show all" results.
339
340 == 0.9.8 released 2008-09-06
341
342 * Fixed order_by helper bug when guessing the text with arrays. Should use the first value instead of last.
343 * Added in per_page config option.
344
345 == 0.9.7 released 2008-09-06
346
347 * Complete class restructure. Moved the 3 main components into their own base level class: Search, Conditions, Condition
348 * Split logic and functionality into their own modules, implemented via alias_chain_method
349 * Added in helpers for using in a rails app
350 * Added link to documentation and live example in README
351 * Various small bug fixes
352 * Hardened tests
353
354 == 0.9.6 released 2008-09-04
355
356 * Fixed bug when instantiating with nil options
357
358 == 0.9.5 released 2008-09-03
359
360 * Enhanced searching with conditions only, added in search methods and calculations
361 * Updated README to include examples
362
363 == 0.9.4 released 2008-09-03
364
365 * Cleaned up search methods
366 * Removed reset! method for both searching and searching by conditions
367
368 == 0.9.3 released 2008-09-02
369
370 * Changed structure of conditions to have their own class
371 * Added API for adding your own conditions.
372
373 == 0.9.2 released 2008-09-02
374
375 * Enhanced protection from SQL injections (made more efficient)
376
377 == 0.9.1 released 2008-09-02
378
379 * Added aliases for datetime, date, time, and timestamp attrs. You could call created_at_after, now you can also call created_after. Just removed the "at" requirement.
380
381 == 0.9.0 released 2008-09-01
382
383 * First release
Something went wrong with that request. Please try again.