aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb
Commit message (Collapse)AuthorAgeFilesLines
* Make caller attribute in deprecation methods optionalAlexey Gaziev2012-10-301-4/+4
|
* Provide a call stack for deprecation warnings where needed.Nikita Afanasenko2012-10-291-3/+4
| | | | It's sometimes hard to quickly find where deprecated call was performed, especially in case of migrating between Rails versions. So this is an attempt to improve the call stack part of the warning message by providing caller explicitly.
* Support for specifying transaction isolation levelJon Leighton2012-09-211-0/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | If your database supports setting the isolation level for a transaction, you can set it like so: Post.transaction(isolation: :serializable) do # ... end Valid isolation levels are: * `:read_uncommitted` * `:read_committed` * `:repeatable_read` * `:serializable` You should consult the documentation for your database to understand the semantics of these different levels: * http://www.postgresql.org/docs/9.1/static/transaction-iso.html * https://dev.mysql.com/doc/refman/5.0/en/set-transaction.html An `ActiveRecord::TransactionIsolationError` will be raised if: * The adapter does not support setting the isolation level * You are joining an existing open transaction * You are creating a nested (savepoint) transaction The mysql, mysql2 and postgresql adapters support setting the transaction isolation level. However, support is disabled for mysql versions below 5, because they are affected by a bug (http://bugs.mysql.com/bug.php?id=39170) which means the isolation level gets persisted outside the transaction.
* Merge pull request #7547 from danmcclain/pg-arraysRafael Mendonça França2012-09-161-0/+2
|\ | | | | Adds migration and type casting support for PostgreSQL Array datatype
| * Moves column dump specific code to a module included in AbstractAdapterDan McClain2012-09-141-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Having column related schema dumper code in the AbstractAdapter. The code remains the same, but by placing it in the AbstractAdapter, we can then overwrite it with Adapter specific methods that will help with Adapter specific data types. The goal of moving this code here is to create a new migration key for PostgreSQL's array type. Since any datatype can be an array, the goal is to have ':array => true' as a migration option, turning the datatype into an array. I've implemented this in postgres_ext, the syntax is shown here: https://github.com/dockyard/postgres_ext#arrays Adds array migration support Adds array_test.rb outlining the test cases for array data type Adds pg_array_parser to Gemfile for testing Adds pg_array_parser to postgresql_adapter (unused in this commit) Adds schema dump support for arrays Adds postgres array type casting support Updates changelog, adds note for inet and cidr support, which I forgot to add before Removing debugger, Adds pg_array_parser to JRuby platform Removes pg_array_parser requirement, creates ArrayParser module used by PostgreSQLAdapter
* | Ensure disconnecting or reconnecting resets the transaction stateJon Leighton2012-09-151-5/+6
| |
* | Move transaction joinability into the transaction objectJon Leighton2012-09-151-3/+4
| |
* | Alter the naming structure a bitJon Leighton2012-09-151-1/+6
| |
* | Store the transaction number in the transaction objectJon Leighton2012-09-151-4/+6
| | | | | | | | This avoids us having to manually increment and decrement it.
* | Start to tease out transaction handling into a state machineJon Leighton2012-09-151-0/+1
| |
* | Revert "create a transaction object and point AR objects at that object ↵Jon Leighton2012-09-151-20/+3
|/ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | during a" This reverts commit c24c885209ac2334dc6f798c394a821ee270bec6. Here's the explanation I just sent to @tenderlove: Hey, I've been thinking about about the transaction memory leak thing that we were discussing. Example code: post = nil Post.transaction do N.times { post = Post.create } end Post.transaction is going to create a real transaction and there will also be a (savepoint) transaction inside each Post.create. In an idea world, we'd like all but the last Post instance to be GC'd, and for the last Post instance to receive its after_commit callback when Post.transaction returns. I can't see how this can work using your solution where the Post itself holds a reference to the transaction it is in; when Post.transaction returns, control does not switch to any of Post's instance methods, so it can't trigger the callbacks itself. What we really want is for the transaction itself to hold weak references to the objects within the transaction. So those objects can be GC'd, but if they are not GC'd then the transaction can iterate them and execute their callbacks. I've looked into WeakRef implementations that are available. On 1.9.3, the stdlib weakref library is broken and we shouldn't use it. There is a better implementation here: https://github.com/bdurand/ref/blob/master/lib/ref/weak_reference/pure_ruby.rb We could use that, either by pulling in the gem or just copying the code in, but it still suffers from the limitation that it uses ObjectSpace finalizers. In my testing, this finalizers make GC quite expensive: https://gist.github.com/3722432 Ruby 2.0 will have a native WeakRef implementation (via ObjectSpace::WeakMap), hence won't be reliant on finalizers: http://bugs.ruby-lang.org/issues/4168 So the ultimate solution will be for everyone to use Ruby 2.0, and for us to just use ObjectSpace::WeakMap. In the meantime, we have basically 3 options: The first is to leave it as it is. The second is to use a finalizer-based weakref implementation and take the GC perf hit. The final option is to store object ids rather than the actual objects. Then use ObjectSpace._id2ref to deference the objects at the end of the transaction, if they exist. This won't stop memory use growing within the transaction, but it'll grow more slowly. I benchmarked the performance of _id2ref this if the object does or does not exist: https://gist.github.com/3722550 If it does exist it seems decent, but it's hugely more expensive if it doesn't, probably because we have to do the rescue nil. Probably most of the time the objects will exist. However the point of doing this optimisation is to allow people to create a large number of objects inside a transaction and have them be GC'd. So for that use case, we'd be replacing one problem with another. I'm not sure which of the two problems is worse. My feeling is that we should just leave this for now and come back to it when Ruby 2.0 is out. I'm going to revert your commit because I can't see how it solves this. Hope you don't mind... if I've misunderstood then let me know! Jon
* create a transaction object and point AR objects at that object during aAaron Patterson2012-09-071-3/+20
| | | | transaction.
* load active_support/deprecation in active_support/railsXavier Noria2012-08-021-1/+0
|
* Avoid unnecessary catching of Exception instead of StandardError.Dylan Smith2012-06-171-1/+1
|
* Merge pull request #5976 from aderyabin/fix1Jeremy Kemper2012-04-251-5/+0
|\ | | | | Duplicate quote_table_name method
| * already defined in quotingAndrey Deryabin2012-04-251-5/+0
| |
* | cleanliness in method parametersAndrey Deryabin2012-04-251-1/+1
|/
* errors should probably be logged as errorsAaron Patterson2012-03-151-20/+19
|
* Merge pull request #5162 from kennyj/schema_cache_dumpAaron Patterson2012-03-071-0/+5
|\ | | | | [Proposal] Schema cache dump
| * Load db/schema_cache.dump duaring boot time.kennyj2012-03-011-0/+5
| |
* | only log an error if there is a logger. fixes #5226Aaron Patterson2012-03-021-1/+1
|/
* tag bind params with a bind param objectAaron Patterson2012-02-201-1/+1
|
* Autoload various constants effectively in abstract connection adapter.Waseem Ahmad2012-02-161-9/+12
|
* Added where option to add_index to support postgresql partial indicesMarcelo Silveira2012-02-091-0/+5
| | | | | | | | | | | The `add_index` method now supports a `where` option that receives a string with the partial index criteria. add_index(:accounts, :code, :where => "active") Generates CREATE INDEX index_accounts_on_code ON accounts(code) WHERE active
* Support establishing connection on ActiveRecord::Model.Jon Leighton2011-12-281-1/+1
| | | | | This is the 'top level' connection, inherited by any models that include ActiveRecord::Model or inherit from ActiveRecord::Base.
* implements automatic EXPLAIN logging for slow queriesXavier Noria2011-12-021-0/+6
|
* AbstractAdapter#close can be called to add the connection back to theAaron Patterson2011-11-291-11/+18
| | | | pool.
* expire will set in_use to falseAaron Patterson2011-11-291-0/+5
|
* Leased connections return false on second leaseAaron Patterson2011-11-291-2/+4
|
* Adapters keep in_use flag when leasedAaron Patterson2011-11-291-1/+14
|
* removing deprecated methodsAaron Patterson2011-11-191-18/+0
|
* pushing caching and visitors down to the connectionAaron Patterson2011-11-191-0/+3
|
* AR changes to support creating ordered (asc, desc) indexesVlad Jebelev2011-11-041-0/+5
|
* Only use LOWER for mysql case insensitive uniqueness check when column has a ↵Joseph Palermo2011-10-091-0/+4
| | | | case sensitive collation.
* Adding missing autoloadClaudio Poli2011-08-241-0/+1
|
* In 1efd88283ef68d912df215125951a87526768a51, ConnectionAdapters was put ↵Jon Leighton2011-08-161-12/+22
| | | | under eager_autoload. Due to the requires in that file, this caused ConnectionSpecification to be loaded, which references ActiveRecord::Base, which means the database connection is established. We do not want to connect to the database when Active Record is loaded, only when ActiveRecord::Base is first referenced by the user.
* Remove TODO comment I didn't mean to commitJon Leighton2011-08-091-2/+0
|
* Make it the responsibility of the connection to hold onto an ARel visitor ↵Jon Leighton2011-08-081-0/+24
| | | | for generating SQL. This improves the code architecture generally, and solves some problems with marshalling. Adapter authors please take note: you now need to define an Adapter.visitor_for method, but it degrades gracefully with a deprecation warning for now.
* initializing @open_transactions in the initialize methodAaron Patterson2011-08-031-4/+2
|
* Remove extra whitespacesSebastian Martinez2011-05-031-9/+9
|
* set the backtrace to prevent AR exceptions from lying to usAaron Patterson2011-04-221-1/+3
|
* use index based substitution for bind parametersAaron Patterson2011-04-131-1/+1
|
* adding a case_sensitive_modifier for forcing comparisons to be case sensitiveAaron Patterson2011-04-111-0/+4
|
* log method takes an option list of bind valuesAaron Patterson2011-02-091-5/+7
|
* moving AR::ConnectionAdapters::Column to its own fileAaron Patterson2011-02-011-0/+1
|
* Add :bulk => true option to change_tablePratik Naik2011-01-311-0/+4
|
* SQLite3 has supported savepoints since version 3.6.8, we should use this!Jon Leighton2011-01-111-2/+2
|
* Use params default.Emilio Tagua2010-11-241-2/+1
|
* Removed ids_in_list_limit in favor of in_clause_length defined in ↵Alex Rothenberg2010-11-231-5/+0
| | | | database_limits.rb
* Adapters can specify maximum number of ids they support in a list of expressionsAlex Rothenberg2010-11-181-0/+5
| | | | | (default is nil meaning unlimited but Oracle imposes a limit of 1000) Limit is used to make multiple queries when preloading associated has_many or habtm records