发表于   |   分类于   |  

在migration 里生成的文件写下如下要批量执行的sql:

1
2
3
4
execute <<-SQL
    ALTER TABLE distributors ADD CONSTRAINT zipchk CHECK (char_length(zipcode) = 5) NO INHERIT;
    ALTER TABLE zipchk ADD COLUMN board_time int(10) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '时间';      
   SQL

执行一直报sql错误，下面是Google Group 社区给出的解决方案：

1
2
3
4
5
6
7
8
9
sql = <<-SQL 
 <statement_1>; 
 <statement_2>; 
 <statement_3>; 
SQL 
sql.strip.split(';').each do |s| 
  ActiveRecord::Base.connection.execute(s) 
end

发表于   |   分类于   |  

##Gemfile加入相关测试驱动：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
   #测试组
group :test do
    gem "minitest"
    gem 'minitest-spec-rails'
    gem 'minitest-reporters'
    gem 'spring'
    gem 'guard'
    gem 'guard-minitest'
    # 添加调用跟踪静默程序
    # gem 'mini_backtrace'
    gem 'ruby-prof'
    gem 'minitest-rails-capybara'
    gem 'autotest-standalone' # The file '.autotest' makes sure the tests are run via test server (spork).
    gem 'autotest-rails-pure' # -pure gives us autotest without ZenTest gem.
    gem 'autotest-growl'      # growl notifications, complains a little bit if growl isn't installed
    gem 'autotest-fsevent'    # react to filesystem events, save your CPU
    gem 'spork-minitest'
end

##初始化guard:

guard init minitest

##配置guard:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
# A sample Guardfile
# More info at https://github.com/guard/guard#readme
## Uncomment and set this to only include directories you want to watch
# directories %w(app lib config test spec features) \
#  .select{|d| Dir.exists?(d) ? d : UI.warning("Directory #{d} does not exist")}
## Note: if you are using the `directories` clause above and you are not
## watching the project directory ('.'), then you will want to move
## the Guardfile to a watched dir and symlink it back, e.g.
#
#  $ mkdir config
#  $ mv Guardfile config/
#  $ ln -s config/Guardfile .
#
# and, you'll have to watch "config/Guardfile" instead of "Guardfile"
guard :minitest, spring: true, all_on_start: false do
  # with Minitest::Unit
  watch(%r{^test/(.*)\/?test_(.*)\.rb$})
  watch(%r{^lib/(.*/)?([^/]+)\.rb$})     { |m| "test/#{m[1]}test_#{m[2]}.rb" }
  watch(%r{^test/test_helper\.rb$})      { 'test' }
  # with Minitest::Spec
  # watch(%r{^spec/(.*)_spec\.rb$})
  # watch(%r{^lib/(.+)\.rb$})         { |m| "spec/#{m[1]}_spec.rb" }
  # watch(%r{^spec/spec_helper\.rb$}) { 'spec' }
  # Rails 4
  watch(%r{^app/(.+)\.rb$})                               { |m| "test/#{m[1]}_test.rb" }
  watch(%r{^app/controllers/application_controller\.rb$}) { 'test/controllers' }
  watch(%r{^app/controllers/(.+)_controller\.rb$})        { |m| "test/integration/#{m[1]}_test.rb" }
  watch(%r{^app/views/(.+)_mailer/.+})                   { |m| "test/mailers/#{m[1]}_mailer_test.rb" }
  watch(%r{^lib/(.+)\.rb$})                               { |m| "test/lib/#{m[1]}_test.rb" }
  watch(%r{^test/.+_test\.rb$})
  watch(%r{^test/test_helper\.rb$}) { 'test' }
  # Rails < 4
  # watch(%r{^app/controllers/(.*)\.rb$}) { |m| "test/functional/#{m[1]}_test.rb" }
  # watch(%r{^app/helpers/(.*)\.rb$})     { |m| "test/helpers/#{m[1]}_test.rb" }
  # watch(%r{^app/models/(.*)\.rb$})      { |m| "test/unit/#{m[1]}_test.rb" }
end

##运行Guard:

输入 guard 命令运行测试

##例外

如果database不用默认的数据库迁移，测试时可以在db下放入structure.sql, 该配置为数据库结构，然后更改配置文件 application.rb:

1
config.active_record.schema_format = :sql

运行：rake db:test:prepare

##生成集成化测试文件

rails g test_unit:integration testName

##生成model测试文件
rails g test_unit:model

发表于   |   分类于   |  

项目中要替换ionic 默认的icon 图标，Google 一下，大多是让图标生成svg的格式，下面有一种比较容易的方式去实现：

e.g. 在浏览器的调试模式，选中需要替换的图标，找到如下代码：

1
2
3
.ion-ios-home-outline:before {
    content: "\f447";
   }

在/img/找出要替换的icon图，如car.png
在样式表里写入如下代码：

1
2
3
4
.ion-ios-home-outline:before {
    /*content: "\f447";*/
    content: url('../img/car.png') !important;
}

效果图

发表于   |   分类于   |  

##在Centos上部署时遇到如下错误：

puma nginx connect() Permission denied

解决方法：在nginx.conf 配置文件中加入了puma 用户：
user deploy

puma 启动时的用户，如此启动正常。