db_sync Why do you use table

Why do you use table_name.upcase

Open papilip opened this issue 12 years ago • 3 comments

Hello,

With my version of MySQL

$ mysql --version
mysql  Ver 14.14 Distrib 5.1.66, for debian-linux-gnu (x86_64) using readline 6.1

db_sync does not work :

rake aborted!
Mysql2::Error: Table 'my_database.MY_TABLE' doesn't exist: SELECT * FROM MY_TABLE

Do you want a PR ?

Jun 14 '13 12:06 papilip

Sorry about that, I didn't test it on mysql. If you can make a PR that would be great.

Jun 14 '13 14:06 scottillogical

Interestingly enough, I cannot duplicate this

Connecting to database specified by database.yml (0.2ms) SELECT * FROM PEOPLE

scott :: Dropbox/code/db_sync_test » bundle exec rake db_sync:dump_data wrote /code/db_sync_test/db/data/people.yml / Dump succeeded

This is on mysql 14.14

Jun 14 '13 14:06 scottillogical

Regardless, if you have time to give it a shot and see what changes are needed to make it work on your box, I'll hold off removing the upcase code.

Jun 14 '13 14:06 scottillogical