ruby on rails - How to connect two tables by using ActiveRecord? -

-

this question has answer here:

(sorry issue duplicated. now, deleted issue.) i'm trying ror active records association. , trying connect 2 tables, restaurants , restaurant_translations. these split multi-language support.

here's definition of 2 tables.

create_table "restaurant_translations", id: false, force: :cascade |t| t.integer  "id",             limit: 4,     default: 0,  null: false t.integer  "restaurant_id",  limit: 4 t.string   "restaurantname", limit: 255  t.string   "address",        limit: 255  t.string   "tel",            limit: 255  t.text     "description",    limit: 65535 t.string   "lang",           limit: 255,   default: "", null: false t.datetime "created_at",                                null: false t.datetime "updated_at",                                null: false end  create_table "restaurants", force: :cascade |t| t.string   "restaurant_type", limit: 255  t.string   "genre",           limit: 255  t.string   "url",             limit: 255  t.string   "fb",              limit: 255  t.string   "mailaddr",        limit: 255  t.datetime "created_at",                  null: false t.datetime "updated_at",                  null: false end

and models.

class restaurant < activerecord::base         has_many :restaurant_translations end   class restauranttranslation < activerecord::base         self.table_name = 'restaurant_translations'         belongs_to :restaurant end

and here's controller creates headache.

class restaurantcontroller < applicationcontroller         def list                 @restaurants = restaurant.all                 @restaurants = @restaurants.restaurant_translation.find_by(lang: "en")         end end

so error shows this. tell me how write?

enter image description here

@pavan 's advice causes errors this.

enter image description here

btw, view this. it's .slim file.

h1 = t :restraunt_list_title  table   thead     tr       th = t :restraunt_list_type       th = t :restraunt_list_name       th = t :restraunt_list_url       th = t :restraunt_list_genre       th = t :restraunt_list_addr    tbody     - @restaurants.each |restaurant|       tr         td = restaurant.restaurant_type         td = restaurant.restaurant_translations.first.restaurantname         td = link_to 'here', restaurant.url         td = restaurant.genre         td = restaurant.restaurant_translations.first.address   br

undefined method `restaurant_translation' restaurant::activerecord_relation:0x007f83832cb498

there 2 problems in code

first, calling .restaurant_translation should .restaurant_translations per associations.

and second, calling on activerecord_relation collection of records(i.e, @restaurants) not single instance.

i below instead achieve wanted.

class restaurantcontroller < applicationcontroller   def list     @restaurants = restaurant.includes(:restaurant_translations).where('restaurant_translations.lang = ?', "en").references(:restaurant_translations)   end end

note:

your restaurants table shouldn't contain restaurant_id convention.


Comments

Post a Comment

Popular posts from this blog

wordpress - (T_ENDFOREACH) php error -

-
creating wordpress website , i'm getting following php error: parse error: syntax error, unexpected 'endforeach' (t_endforeach) in /home/soralmedia/public_html/wp-content/themes/soral media/woocommerce/myaccount/my-orders.php on line 98 here's code file: <?php /** * orders * * shows recent orders on account page. * * template can overridden copying yourtheme/woocommerce/myaccount/my-orders.php. * * however, on occasion woocommerce need update template files , (the theme developer). * need copy new files theme maintain compatibility. try this. * little possible, happen. when occurs version of template file will. * bumped , readme list important changes. * * @see http://docs.woothemes.com/document/template-structure/ * @author woothemes * @package woocommerce/templates * @version 2.5.0 */ if ( ! defined( 'abspath' ) ) { exit; } $my_orders_columns = apply_filters( 'woocommerce_my_account_my_orders_columns', array( ...
Read more

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

-
i new vba have developed code use in excel move text/numbers txt file. issue have 3 functions need go same txt file. when run first function has set fs = createobject("scripting.filesystemobject") set = fs.createtextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the other 2 functions had save. set fs = createobject("scripting.filesystemobject") set = fs.savetextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the first function go txt file, other 2 error object doesn't support property or method. when changed 3 create last function goes txt file. can not figure out word use in order make other 2 functions follow txt file in order keyed. the entire code follows private sub addrecord_click() on error goto errhandler module1.nys45uploadfilename = application.getsaveasfilename(filefilter:="textfiles (*.txt), *.txt") if module1.nys45uploadfilename = "false" exit sub ...
Read more

Using django-mptt to get only the categories that have items -

-
sample structure: all uppercase: category mixed case: item root ├── books │   ├── fiction │   │   └── classics │   └── non-fiction ├── clothing └── electronics ├── laptops ├── phones │   ├── apple │   │   ├── iphone 6 │   │   ├── iphone 6 plus │   │   ├── iphone 6s │   │   └── iphone 6s plus │   ├── motorola │   │   ├── moto g4 │   │   ├── moto g4 play │   │   ├── moto g4 plus │   │   └── moto x │   └── samsung └── tablets └── apple i'm trying have index page show "electronics" category. "clothing" category shouldn't show since it's empty , "books" category shouldn't show either since, although has child categories, child categories don't have items. similarly, "electronics" page should show "phones" category. "laptops" category shouldn't show since it's empty , "tablets" category shouldn't show either since...
Read more