質問編集履歴

3

追記

2018/01/13 15:04

投稿

komorigasa
komorigasa

スコア9

test CHANGED
File without changes
test CHANGED
@@ -82,119 +82,7 @@
82
82
 
83
83
  /Users/hikaru/Desktop/TS/vendor/bundle/gems/sqlite3-1.3.13/lib/sqlite3/statement.rb:108:in `step'
84
84
 
85
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/sqlite3-1.3.13/lib/sqlite3/statement.rb:108:in `block in each'
85
+
86
-
87
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/sqlite3-1.3.13/lib/sqlite3/statement.rb:107:in `loop'
88
-
89
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/sqlite3-1.3.13/lib/sqlite3/statement.rb:107:in `each'
90
-
91
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:152:in `map'
92
-
93
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:152:in `block in execute'
94
-
95
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:95:in `prepare'
96
-
97
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:137:in `execute'
98
-
99
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:251:in `block (2 levels) in execute'
100
-
101
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
102
-
103
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'
104
-
105
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'
106
-
107
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:250:in `block in execute'
108
-
109
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block (2 levels) in log'
110
-
111
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:611:in `block in log'
112
-
113
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
114
-
115
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:603:in `log'
116
-
117
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:249:in `execute'
118
-
119
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/schema_statements.rb:471:in `drop_table'
120
-
121
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:435:in `move_table'
122
-
123
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:427:in `block in alter_table'
124
-
125
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/database_statements.rb:233:in `transaction'
126
-
127
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:426:in `alter_table'
128
-
129
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:376:in `change_column'
130
-
131
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:849:in `block in method_missing'
132
-
133
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:818:in `block in say_with_time'
134
-
135
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:818:in `say_with_time'
136
-
137
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:838:in `method_missing'
138
-
139
- /Users/hikaru/Desktop/TS/db/migrate/20180112034439_change_datatype_travel_departure_of_listings.rb:3:in `change'
140
-
141
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:792:in `exec_migration'
142
-
143
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:776:in `block (2 levels) in migrate'
144
-
145
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:775:in `block in migrate'
146
-
147
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:408:in `with_connection'
148
-
149
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:774:in `migrate'
150
-
151
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:953:in `migrate'
152
-
153
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:1230:in `block in execute_migration_in_transaction'
154
-
155
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:1298:in `block in ddl_transaction'
156
-
157
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in `block in transaction'
158
-
159
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/transaction.rb:194:in `block in within_new_transaction'
160
-
161
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/transaction.rb:191:in `within_new_transaction'
162
-
163
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in `transaction'
164
-
165
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/transactions.rb:210:in `transaction'
166
-
167
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:1298:in `ddl_transaction'
168
-
169
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:1229:in `execute_migration_in_transaction'
170
-
171
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:1201:in `block in migrate_without_lock'
172
-
173
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:1200:in `each'
174
-
175
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:1200:in `migrate_without_lock'
176
-
177
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:1150:in `migrate'
178
-
179
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:1007:in `up'
180
-
181
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/migration.rb:985:in `migrate'
182
-
183
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:171:in `migrate'
184
-
185
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>'
186
-
187
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/railties-5.1.4/lib/rails/commands/rake/rake_command.rb:21:in `block in perform'
188
-
189
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/railties-5.1.4/lib/rails/commands/rake/rake_command.rb:18:in `perform'
190
-
191
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/railties-5.1.4/lib/rails/command.rb:46:in `invoke'
192
-
193
- /Users/hikaru/Desktop/TS/vendor/bundle/gems/railties-5.1.4/lib/rails/commands.rb:16:in `<top (required)>'
194
-
195
- bin/rails:4:in `require'
196
-
197
- bin/rails:4:in `<main>'
198
86
 
199
87
 
200
88
 
@@ -211,3 +99,177 @@
211
99
 
212
100
 
213
101
  ご教授のほど、よろしくお願いいたします。
102
+
103
+
104
+
105
+ ###(追記)db/schema.rb
106
+
107
+ ```
108
+
109
+ # This file is auto-generated from the current state of the database. Instead
110
+
111
+ # of editing this file, please use the migrations feature of Active Record to
112
+
113
+ # incrementally modify your database, and then regenerate this schema definition.
114
+
115
+ #
116
+
117
+ # Note that this schema.rb definition is the authoritative source for your
118
+
119
+ # database schema. If you need to create the application database on another
120
+
121
+ # system, you should be using db:schema:load, not running all the migrations
122
+
123
+ # from scratch. The latter is a flawed and unsustainable approach (the more migrations
124
+
125
+ # you'll amass, the slower it'll run and the greater likelihood for issues).
126
+
127
+ #
128
+
129
+ # It's strongly recommended that you check this file into your version control system.
130
+
131
+
132
+
133
+ ActiveRecord::Schema.define(version: 20180109075510) do
134
+
135
+
136
+
137
+ create_table "listings", force: :cascade do |t|
138
+
139
+ t.string "travel_type"
140
+
141
+ t.string "travel_country"
142
+
143
+ t.integer "travel_departure"
144
+
145
+ t.integer "travel_arrival"
146
+
147
+ t.string "address"
148
+
149
+ t.string "listing_title"
150
+
151
+ t.text "listing_content"
152
+
153
+ t.boolean "active"
154
+
155
+ t.integer "user_id"
156
+
157
+ t.datetime "created_at", null: false
158
+
159
+ t.datetime "updated_at", null: false
160
+
161
+ t.integer "price"
162
+
163
+ t.float "latitude"
164
+
165
+ t.float "longitude"
166
+
167
+ t.index ["user_id"], name: "index_listings_on_user_id"
168
+
169
+ end
170
+
171
+
172
+
173
+ create_table "photos", force: :cascade do |t|
174
+
175
+ t.integer "listing_id"
176
+
177
+ t.datetime "created_at", null: false
178
+
179
+ t.datetime "updated_at", null: false
180
+
181
+ t.string "image_file_name"
182
+
183
+ t.string "image_content_type"
184
+
185
+ t.integer "image_file_size"
186
+
187
+ t.datetime "image_updated_at"
188
+
189
+ t.index ["listing_id"], name: "index_photos_on_listing_id"
190
+
191
+ end
192
+
193
+
194
+
195
+ create_table "reservations", force: :cascade do |t|
196
+
197
+ t.integer "user_id"
198
+
199
+ t.integer "listing_id"
200
+
201
+ t.integer "number"
202
+
203
+ t.datetime "by_time"
204
+
205
+ t.integer "price"
206
+
207
+ t.integer "total_price"
208
+
209
+ t.datetime "created_at", null: false
210
+
211
+ t.datetime "updated_at", null: false
212
+
213
+ t.integer "commodity_prices"
214
+
215
+ t.index ["listing_id"], name: "index_reservations_on_listing_id"
216
+
217
+ t.index ["user_id"], name: "index_reservations_on_user_id"
218
+
219
+ end
220
+
221
+
222
+
223
+ create_table "users", force: :cascade do |t|
224
+
225
+ t.string "email", default: "", null: false
226
+
227
+ t.string "encrypted_password", default: "", null: false
228
+
229
+ t.string "reset_password_token"
230
+
231
+ t.datetime "reset_password_sent_at"
232
+
233
+ t.datetime "remember_created_at"
234
+
235
+ t.integer "sign_in_count", default: 0, null: false
236
+
237
+ t.datetime "current_sign_in_at"
238
+
239
+ t.datetime "last_sign_in_at"
240
+
241
+ t.string "current_sign_in_ip"
242
+
243
+ t.string "last_sign_in_ip"
244
+
245
+ t.datetime "created_at", null: false
246
+
247
+ t.datetime "updated_at", null: false
248
+
249
+ t.string "provider"
250
+
251
+ t.string "uid"
252
+
253
+ t.string "image"
254
+
255
+ t.string "name"
256
+
257
+ t.string "phone_number"
258
+
259
+ t.string "description"
260
+
261
+ t.integer "price"
262
+
263
+ t.index ["email"], name: "index_users_on_email", unique: true
264
+
265
+ t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
266
+
267
+ end
268
+
269
+
270
+
271
+ end
272
+
273
+
274
+
275
+ ```

2

2018/01/13 15:04

投稿

komorigasa
komorigasa

スコア9

test CHANGED
File without changes
test CHANGED
File without changes

1

2018/01/13 05:45

投稿

komorigasa
komorigasa

スコア9

test CHANGED
File without changes
test CHANGED
File without changes