Showing posts with label Rails. Show all posts
Showing posts with label Rails. Show all posts
0

你在用open-uri 么？

Posted on Tuesday, June 16, 2020 by 醉·醉·鱼 and labeled under
看完http://sakurity.com/blog/2015/02/28/openuri.html，赶紧看一下自己的项目。还好还好，只有内部项目在用。要不回头黑客上传一个文件，然后再调用命令执行一下，简直不能够再欢喜了。
0

Implement DatabaseCleaner in Rails 4

Posted on Tuesday, August 21, 2018 by 醉·醉·鱼 and labeled under , ,
DatabaseCleaner上面的example过时了。按照示例去做的话，会报错 unknown method 'before'。在github上找到了答案，还是比较简单的。


class ActiveSupport::TestCase
  include FactoryGirl::Syntax::Methods

  ActiveRecord::Migration.check_pending!
  DatabaseCleaner.strategy = :truncation
  DatabaseCleaner.logger = Rails.logger
  setup { DatabaseCleaner.start }
  teardown { DatabaseCleaner.clean }
end

配置完成以后，就可以在MYSQL去monitor query，看具体是如何操作数据库的。

mysql> SHOW VARIABLES LIKE "general_log%";

+------------------+----------------------------+
| Variable_name    | Value                      |
+------------------+----------------------------+
| general_log      | OFF                        |
| general_log_file | /var/run/mysqld/mysqld.log |
+------------------+----------------------------+

mysql> SET GLOBAL general_log = 'ON';

观察log

tail -f -n300 /var/run/mysqld/mysqld.log

最后，重置改动。

mysql> SET GLOBAL general_log = 'OFF';

  1. https://stackoverflow.com/questions/568564/how-can-i-view-live-mysql-queries
  2. https://github.com/metaskills/minitest-spec-rails/issues/44#issuecomment-244155657