Skip to Content
เมนู
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
คำถามนี้ถูกตั้งค่าสถานะ
2 ตอบกลับ
8764 มุมมอง
Hi,
I am new to openerp , I have two table master and details , i want to use id of master as foreign key in detail table.
How can i achieve this?
my code is

from osv import osv,fields
class wlan_master(osv.osv):
    _name = 'wlan_master'
    _columns = {
        'AP_name'       :fields.char(),
        'description'   :fields.char(),
        'ip_address'    :fields.char(),
    }
class wlan_details(osv.osv):
    _name = 'wlan_details'
    _columns = {
        'wireless_workmode'     :fields.char(),
        'enable_wireless'       :fields.char(),
        'ssid'                  :fields.char(),
        'channel'               :fields.char(),
        'wireless_mode'         :fields.char(),
        'channel_bandwidth'     :fields.char(),
        'rate'                  :fields.char(),
        'broadcast_ssid'        :fields.char(),
        'client_isolation'      :fields.char(),
        'wmm_announcement'      :fields.char(),
        'fragement_threshold'   :fields.char(),
        'rts'                   :fields.char(),
        'dtim_gap'              :fields.char(),
        'beacon_gap'            :fields.char(),
        'preamble_type'         :fields.char(),
        'encryption_mode'       :fields.char(),
        'filter_mode'           :fields.char(),
    }
อวตาร
ละทิ้ง
คำตอบที่ดีที่สุด

Basically you have to do two things:

from osv import osv,fields
class wlan_master(osv.osv):
    _name = 'wlan.master'
    _columns = {
        'AP_name'       :fields.char(),
        'description'   :fields.char(),
        'ip_address'    :fields.char(),
        'defail_ids': fields.one2many('wlan.details','master_id', 'Details')
    }
class wlan_details(osv.osv):
    _name = 'wlan.details'
    _columns = {
        'master_id': fields.many2one('wlan.master', 'Master'),
        'wireless_workmode'     :fields.char(),
        'enable_wireless'       :fields.char(),
        'ssid'                  :fields.char(),
        'channel'               :fields.char(),
        'wireless_mode'         :fields.char(),
        'channel_bandwidth'     :fields.char(),
        'rate'                  :fields.char(),
        'broadcast_ssid'        :fields.char(),
        'client_isolation'      :fields.char(),
        'wmm_announcement'      :fields.char(),
        'fragement_threshold'   :fields.char(),
        'rts'                   :fields.char(),
        'dtim_gap'              :fields.char(),
        'beacon_gap'            :fields.char(),
        'preamble_type'         :fields.char(),
        'encryption_mode'       :fields.char(),
        'filter_mode'           :fields.char(),
    }

This adds a foreign key to details and this make a proper link to master.

อวตาร
ละทิ้ง
คำตอบที่ดีที่สุด

I think you haven't read documentation yet

class wlan_details(osv.osv):
    _name = 'wlan_details'
    _columns = {
       'master_id': fields.many2one('wlan_master',  'Master'),
       'wireless_workmode'     :fields.char(),
       etc...
อวตาร
ละทิ้ง
Related Posts ตอบกลับ มุมมอง กิจกรรม
0
ก.พ. 18
3426
Creating inner join in odoo แก้ไขแล้ว
1
ธ.ค. 18
9383
2
ส.ค. 24
1866
1
ม.ค. 25
1358
Adding relational fields แก้ไขแล้ว
1
เม.ย. 18
6172