aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb
Commit message (Collapse)AuthorAgeFilesLines
* Preserve MySQL boolean column defaults when changing a column in a ↵Marcel Molina2006-05-141-1/+3
| | | | | | migration. Closes #5015. [pdcawley@bofh.org.uk] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4340 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Properly quote index names in migrations (closes #4764) [John Long]Rick Olson2006-04-201-1/+0
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4239 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Only string_to_binary if the column respondsDavid Heinemeier Hansson2006-03-261-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4040 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed that MySQL enums should always be returned as strings (closes #3501) [DHH]David Heinemeier Hansson2006-03-251-0/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4028 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added connection#current_database that'll return of the current database ↵David Heinemeier Hansson2006-03-181-0/+3
| | | | | | (only works in MySQL, SQL Server, and Oracle so far -- please help implement for the rest of the adapters) (closes #3663) [Tom ward] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3911 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Make all tinyint(1) variants act like boolean in mysql (tinyint(1) unsigned, ↵Jamis Buck2006-03-171-1/+1
| | | | | | etc.) git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3902 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Stop the MySQL adapter crashing when views are present. (closes #3782) ↵David Heinemeier Hansson2006-03-161-1/+16
| | | | | | [Jonathan Viney] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3886 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* ActiveRecord::Base.remove_connection explicitly closes database connections ↵Jeremy Kemper2006-02-261-1/+5
| | | | | | and doesn't corrupt the connection cache. Introducing the disconnect! instance method for the PostgreSQL, MySQL, and SQL Server adapters; implementations for the others are welcome. References #3591. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3674 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Escape database name in MySQL adapter when creating and dropping databases. ↵Marcel Molina2006-01-131-2/+2
| | | | | | Closes #3409. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3403 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: allow encoding option for mysql.rb driver.Jeremy Kemper2005-12-131-5/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3293 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* 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