Schema has escaped quotation marks in Ruby on Rails

Asked Sep 25 '22 at 19:36

Active Sep 25 '22 at 22:03

Viewed 38 times

First part of my schema.rb

ActiveRecord::Schema[7.0].define(version: 2022_09_25_175429) do
  create_table "book", force: :cascade do |t|
    t.text "name"
    t.text "description"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.string "genre"
    t.index "\"tags\"", name: "index_formulas_on_tags"
  end

As you can see, tags has escaped quotes in it. How do I fix this, and how did this happen in the first place? Actually, I'm now considering that this could be intentional, but I could of doubt it?

edited Sep 25 '22 at 22:03

Eyeslandic

14,553
13
41
54

asked Sep 25 '22 at 19:36

kevinlinxc

What kind of RDBMS is it? – Bret Weinraub Sep 25 '22 at 20:50
SQLite3? I think? – kevinlinxc Sep 25 '22 at 20:51
try and dump the schema straight from the RDBMS, you have some entity in there with actual double-quotes in the naming..... – Bret Weinraub Sep 25 '22 at 20:57
For example I can do this ' create table "X" (....) ' – Bret Weinraub Sep 25 '22 at 20:57
That creates a table with name DOUBLE QUOTE X DOUBLE QUOTE.... – Bret Weinraub Sep 25 '22 at 20:58
Related? https://stackoverflow.com/questions/2901453/sql-standard-to-escape-column-names – Bret Weinraub Sep 25 '22 at 21:00
There should be a rails way of doing what I want – kevinlinxc Sep 25 '22 at 21:11

Schema has escaped quotation marks in Ruby on Rails

0 Answers0