aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb
Commit message (Collapse)AuthorAgeFilesLines
* MySQL: ensure that @config is set.Jeremy Kemper2005-12-091-3/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3264 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: more robust test for nullified result hashes. References #3124.Jeremy Kemper2005-12-081-8/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3246 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: work around ruby-mysql/mysql-ruby inconsistency with mysql.stat. ↵Jeremy Kemper2005-12-031-7/+9
| | | | | | Eliminate usage of mysql.ping because it doesn't guarantee reconnect. Explicitly close and reopen the connection instead. References #428. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3216 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: active? compatibility with the pure-Ruby driver. References #428.Jeremy Kemper2005-11-281-1/+5
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3194 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL, PostgreSQL: reconnect! also reconfigures the connection. Otherwise, ↵Jeremy Kemper2005-11-221-15/+19
| | | | | | the connection 'loses' its settings if it times out and is reconnected. Closes #2978. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3165 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: introduce :encoding option to specify the character set for client, ↵Jeremy Kemper2005-11-211-3/+23
| | | | | | connection, and results. Only available for MySQL 4.1 and later with the mysql-ruby driver. Do SHOW CHARACTER SET in mysql client to see available encodings. Closes #2975. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3152 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Simpler Mysql load test.Jeremy Kemper2005-11-211-2/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3148 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r3042@asus: jeremy | 2005-11-13 01:51:08 -0800Jeremy Kemper2005-11-131-15/+22
| | | | | | | | | | | MySQL active? and reconnect! References #428. r3043@asus: jeremy | 2005-11-13 01:58:28 -0800 SQLite active? and reconnect! References #428. r3044@asus: jeremy | 2005-11-13 02:02:27 -0800 Update CHANGELOG with admonishment regarding avoidance of the log method. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3001 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r3886@sedna: jeremy | 2005-11-07 03:09:59 -0800Jeremy Kemper2005-11-091-1/+0
| | | | | | | | r3944@sedna: jeremy | 2005-11-09 01:29:56 -0800 Upgrade bundled ruby-mysql 0.2.4 with mysql411 shim (see #440) to ruby-mysql0.2.6 with a patchset for 4.1 protocol support. Local change [301] is now apart of the main driver; reapplied local change [2182]. Removed GC.start fromResult.free. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2947 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Map Active Record time to SQL TIME. Closes #2576.Jeremy Kemper2005-10-231-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2713 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Optimization for Mysql selects using mysql-ruby extension greater than ↵Marcel Molina2005-10-111-3/+15
| | | | | | 2.6.3. Closes #2426. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2529 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Optimization refactoring for add_limit_offset!. In partial fullfilment of #1236.Marcel Molina2005-10-091-4/+4
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2509 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Add rename_table to mysql, sqlite and postgres adapters for use in migrationsTobias Lütke2005-10-061-0/+4
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2477 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Get rid of old symbolize_strings_in_hash.Jeremy Kemper2005-09-301-3/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2427 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Remove duplicate 'quote_column_name' definitionJamis Buck2005-09-251-5/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2340 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Refactored the AbstractAdapter to be a lot less scary. Cleaned up the docs ↵David Heinemeier Hansson2005-09-251-76/+95
| | | | | | and style for the OSS adapters git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2339 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Standardize the interpretation of boolean columns in the Mysql and Sqlite ↵Jamis Buck2005-09-251-1/+22
| | | | | | adapters. (Use MysqlAdapter.emulate_booleans = false to disable this behavior) git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2335 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Add ActiveRecord::SchemaDumper for dumping a DB schema to a pure-ruby file, ↵Jamis Buck2005-09-231-1/+22
| | | | | | making it easier to consolidate large migration lists and port database schemas between databases. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2312 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Made Oracle a first-class connection adapter by adhering closer to idiomatic ↵David Heinemeier Hansson2005-07-241-1/+1
| | | | | | Oracle style #1798 [The Gang of Oracles] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1912 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added better error message for "packets out of order" #1630 [courtenay]David Heinemeier Hansson2005-07-081-0/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1774 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Made default changes work in both postgresql and mysql #1612 [Tobias Luetke]David Heinemeier Hansson2005-07-051-1/+9
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1703 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Sugared up migrations with even more bling #1609 [Tobias Luekte]David Heinemeier Hansson2005-07-051-2/+13
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1697 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added new Migrations framework for describing schema transformations in a ↵David Heinemeier Hansson2005-07-041-1/+4
| | | | | | way that can be easily applied across multiple databases #1604 [Tobias Luetke] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1672 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r1617@asus: jeremy | 2005-07-03 08:23:31 -0700Jeremy Kemper2005-07-031-29/+27
| | | | | | | settle on the 'slow' MysqlAdapter#select since it means fewer comparisons later. strip trailing whitespace. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1635 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r1616@asus: jeremy | 2005-07-03 08:07:13 -0700Jeremy Kemper2005-07-031-1/+1
| | | | | | | remove duplicate conditional git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1634 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r1607@asus: jeremy | 2005-07-02 23:36:52 -0700Jeremy Kemper2005-07-031-7/+7
| | | | | | | Rollback MysqlAdapter#select speedup; fix add_limit_offset git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1625 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r1603@asus: jeremy | 2005-07-02 14:38:52 -0700Jeremy Kemper2005-07-031-38/+39
| | | | | | | Faster MysqlAdapter#select. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1622 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added support for ODBC connections to MS SQL Server so you can connect from ↵David Heinemeier Hansson2005-07-011-4/+10
| | | | | | a non-Windows machine #1569 [Mark Imbriaco/DeLynn Berry] Added support for limit/offset with the MS SQL Server driver so that pagination will now work #1569 [DeLynn Berry] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1583 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Made migrations create InnoDB tables per defaultDavid Heinemeier Hansson2005-04-161-0/+4
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1168 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added adapter independent limit clause as a two-element array with the first ↵David Heinemeier Hansson2005-03-201-1/+5
| | | | | | being the limit, the second being the offset #795 [Sam Stephenson] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@944 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* More incremental work on active schema for MySQLDavid Heinemeier Hansson2005-03-101-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@885 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* More incremental work on active schema for MySQLDavid Heinemeier Hansson2005-03-101-11/+11
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@884 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added preliminary support for an agile database migration technique ↵David Heinemeier Hansson2005-03-011-9/+30
| | | | | | (currently only for MySQL) git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@818 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added documentation for database adapters to visible RDocDavid Heinemeier Hansson2005-02-231-1/+16
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@771 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed the Broken pipe error on SHOW FIELDs queries tooDavid Heinemeier Hansson2005-02-221-5/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@746 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed that Active Record would throw Broken Pipe errors with FCGI when the ↵David Heinemeier Hansson2005-02-211-28/+51
| | | | | | MySQL connection timed out instead of reconnecting #428 [Nicholas Seckar] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@729 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added options to specify an SSL connection for MySQL. Define the following ↵David Heinemeier Hansson2005-02-201-4/+6
| | | | | | attributes in the connection config (config/database.yml in Rails) to use it: sslkey, sslcert, sslca, sslcapath, sslcipher. To use SSL with no client certs, just set :sslca = /dev/null. http://dev.mysql.com/doc/mysql/en/secure-connections.html #604 [daniel@nightrunner.com] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@720 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added automatic dropping/creating of test tables for running the unit tests ↵David Heinemeier Hansson2005-02-201-1/+5
| | | | | | on all databases #587 [adelle@bullet.net.au] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@719 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed the 4.11 changes to the mysql adapterDavid Heinemeier Hansson2005-01-111-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@391 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added support for the new protocol spoken by MySQL 4.1.1+ servers for the ↵David Heinemeier Hansson2005-01-101-0/+1
| | | | | | Ruby/MySQL adapter that ships with Rails #440 [Matt Mower] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@372 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Changed the interface on AbstractAdapter to require that adapters return the ↵David Heinemeier Hansson2004-12-191-2/+6
| | | | | | number of affected rows on delete and update operations. Added that Base.update_all and Base.delete_all return an integer of the number of affected rows #341 git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@228 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed value quoting in all generated SQL statements, so that integers are ↵David Heinemeier Hansson2004-12-071-0/+4
| | | | | | not surrounded in quotes and that all sanitation are happening through the database's own quoting routine. This should hopefully make it lots easier for new adapters that doesn't accept '1' for integer columns. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@70 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* InitialDavid Heinemeier Hansson2004-11-241-0/+131
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4 5ecf4fe2-1ee6-0310-87b1-e25e094e27de