Rails 4.2 engine reference column migration fails PG::UndefinedTable: ERROR: in postgresql -


in engine have built, have 3 classes: books, categories , authors. migrations each of classes below. there 1 many relationship between authors , books , between categories , books. engine namespaces each of classes book_store. when using same migrations on postgresql (instead of sqlite) error 1 of classes not exist pg::undefinedtable: error: relation "authors" not exist

i'm not sure why error occurring. should namespace in reference well? e.g, this:

  t.references :author, index: true, foreign_key: true   t.references :category, index: true, foreign_key: true

to this:

  t.references :book_store_author, index: true, foreign_key: true   t.references :book_store_category, index: true, foreign_key: true

this seems not work because there attribute in bookstore::books named book_store_author , book_store_category resulting in bookstore::books.book_store_author not scoped engine properly.

is possible need change migration code reflect namespace of engine on separate line?

original code

authors

# migration comes book_store (originally 20150814153615) class createbookstoreauthors < activerecord::migration   def change     create_table :book_store_authors |t|       t.string :name       t.text :description       t.string :slug        t.timestamps null: false     end     add_index :book_store_authors, :slug, unique: true   end end

categories

# migration comes book_store (originally 20150814153710) class createbookstorecategories < activerecord::migration   def change     create_table :book_store_categories |t|       t.string :title       t.text :description       t.string :slug        t.timestamps null: false     end     add_index :book_store_categories, :slug, unique: true   end end

books

# migration comes book_store (originally 20150814153733) class createbookstorebooks < activerecord::migration   def change     create_table :book_store_books |t|       t.string :title       t.string :lead       t.text :excerpt       t.text :description       t.decimal :price       t.integer :cover_type       t.integer :num_pages       t.string :isbn       t.integer :year       t.string :buy_link       t.string :size       t.string :cover_image       t.string :slug       t.references :author, index: true, foreign_key: true       t.references :category, index: true, foreign_key: true        t.timestamps null: false     end     add_index :book_store_books, :slug, unique: true   end end

error:

/home/deploy/apps/saturnalia_books/shared/bundle/ruby/2.2.0/gems/activerecord-4.2.3/lib/active_record/migration.rb:797:in `migrate' /home/deploy/apps/saturnalia_books/shared/bundle/ruby/2.2.0/gems/activerecord-4.2.3/lib/active_record/tasks/database_tasks.rb:137:in `migrate' /home/deploy/apps/saturnalia_books/shared/bundle/ruby/2.2.0/gems/activerecord-4.2.3/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>' activerecord::statementinvalid: pg::undefinedtable: error:  relation "authors" not exist : alter table "book_store_books" add constraint "fk_rails_52f80cb3c5" foreign key ("author_id")   references "authors" ("id") /home/deploy/apps/saturnalia_books/shared/bundle/ruby/2.2.0/gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:in `async_exec' /home/deploy/apps/saturnalia_books/shared/bundle/ruby/2.2.0/gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:in `block in execute'      ...    pg::undefinedtable: error:  relation "authors" not exist

edit

here full stack trace

you getting pg::undefinedtable, table author trying reference can't found psql. , couldn't found because table named book_store_authors here create_table :book_store_authors. i'm not sure why working on sqlite, need pass full , valid table name creating model (i mean in singular form if user or in plural if in reason creating users model) t.belongs_to , t.references


-

Comments

Post a Comment

Popular posts from this blog

c# - Binding a comma separated list to a List<int> in asp.net web api -

the default binder in web api expecst http://url.com/webapi/report/?pageids=3243&pageids=2365 to bind public ihttpactionresult report(list<int> pageids){ // exciting webapi code} i wish bind http://url.com/webapi/report/?pageids=3243,2365 as running out of space in url get . i have created class public class commaseparatedmodelbinder : system.web.http.modelbinding.imodelbinder { public bool bindmodel(httpactioncontext actioncontext, modelbindingcontext bindingcontext) { //binding in here } } and registered in webapiconfig.cs var provider = new simplemodelbinderprovider( typeof(list<int>), new commaseparatedmodelbinder()); config.services.insert(typeof(modelbinderprovider), 0, provider); i have altered method signature use model binder so public ihttpactionresult report( [modelbinder] list<int> pageids){ // exciting webapi code} however break point in binder not being ...
Read more

how to prompt save As Box in Excel Interlop c# MVC 4 -

i want export excel sheet using excel interloop... i have datatable convert excel sheet... now there way save file using save dialogue box in mvc 4 here code public string datatabletoexcel(datatable dt, string htmlheading, string key) { try { microsoft.office.interop.excel.application excel; microsoft.office.interop.excel.workbook excelworkbook; microsoft.office.interop.excel.worksheet excelsheet; microsoft.office.interop.excel.range excelcellrange; excel = new microsoft.office.interop.excel.application(); excel.visible = false; excel.displayalerts = false; excelworkbook = excel.workbooks.add(type.missing); excelsheet = (microsoft.office.interop.excel.worksheet)excelworkbook.activesheet; excelsheet.name = "sheet1"; dataset ...
Read more

xslt 1.0 - How to access or retrieve mets content of an item from another item? -

my use case have item has link in item. example, item 123456789/152 has metadata field dc.relation.hasversion=123456789/717 . within item view of 123456789/152 , how can retrieve values of metadata of 123456789/717 ? example, want retrieve dc.language.iso value of 123456789/717 123456789/152 . i looked @ related items feature in dspace don't know how metadata displayed in related items list pulled items in list. i using dspace version 5.3 mirage 2 theme . edit based on schweerelos answer, below actual code. using custom metadata field dc.relation.languageversion . basically, want link other version instead of displaying value, display dc.language.iso of other version in item-view.xsl . i've incorporated answer of schweerelos question in code just displaying value of dc.relation.languageversion . sample values of dc.relation.languageversion 10665.1/9843 ; 10665.1/9844 ie not complete uri handle. thanks in advance! actual code <xsl:template name=...
Read more