{"id":9759,"date":"2013-03-07T17:12:40","date_gmt":"2013-03-07T11:42:40","guid":{"rendered":"http:\/\/www.tothenew.com\/blog\/?p=9759"},"modified":"2016-11-30T12:38:09","modified_gmt":"2016-11-30T07:08:09","slug":"multiple-db-tables-in-single-custom-module-in-magento","status":"publish","type":"post","link":"https:\/\/www.tothenew.com\/blog\/multiple-db-tables-in-single-custom-module-in-magento\/","title":{"rendered":"Multiple db tables in single custom module in Magento"},"content":{"rendered":"

Creating a module which interact with a database table is quite simple. Most of the developers use magento<\/a> module creator to create such a module. However, what if you want a module with multiple database tables. Following is the example of module with two database tables.<\/p>\n

Step 1. Create setup file of your custom module with following queries.<\/p>\n

[php]
\nCREATE TABLE `test` (
\n`test_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
\n`name` VARCHAR( 25 ) NOT NULL
\n) ENGINE = MYISAM <\/p>\n

CREATE TABLE `test2` (
\n`test2_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
\n`name` VARCHAR( 25 ) NOT NULL
\n) ENGINE = MYISAM
\n[\/php]<\/p>\n

Step 2. Create pool file to register your module under app\/etc\/modules\/Mypackage_Mymodule.xml<\/p>\n

[php]
\n<?xml version="1.0"?>
\n<config>
\n <modules>
\n <Mypackage_Mymodule>
\n <active>true<\/active>
\n <codePool>local<\/codePool>
\n <\/Mypackage_Mymodule>
\n <\/modules>
\n<\/config>
\n[\/php]<\/p>\n

Step 3. Your module configuration file should looks like following<\/p>\n

app\/code\/local\/ Mypackage\/Mymodule\/etc\/config.xml<\/p>\n

[php]
\n<?xml version="1.0"?>
\n<config>
\n <modules>
\n <Mypackage_Mymodule>
\n <version>0.1.0<\/version>
\n <\/Mypackage_Mymodule>
\n <\/modules>
\n <global>
\n <models>
\n\t\t\t<Mymodule>
\n\t\t\t\t<class>Mypackage_Mymodule_Model<\/class>
\n\t\t\t\t<resourceModel>mymodule_mysql4<\/resourceModel>
\n\t\t\t<\/mymodule><\/p>\n

\t\t\t<!– model vs db table relation –>
\n <mymodule_mysql4>
\n <class>Mypackage_Mymodule_Model_Mysql4<\/class>
\n\t\t\t\t<!– db table with name test –>
\n <entities>
\n <test>
\n <table>test<\/table>
\n <\/test>
\n\t\t <test2>
\n <table>test2<\/table>
\n <\/test2><\/p>\n

<\/entities>
\n <\/mymodule_mysql4>
\n <\/models>
\n\t\t<resources>
\n\t\t\t<mymodule_write>
\n\t\t\t\t<connection>
\n\t\t\t\t\t<use>core_write<\/use>
\n\t\t\t\t<\/connection>
\n\t\t\t<\/mymodule_write>
\n\t\t\t<mymodule_read>
\n\t\t\t\t<connection>
\n\t\t\t\t\t<use>core_read<\/use>
\n\t\t\t\t<\/connection>
\n\t\t\t<\/mymodule_read>
\n\t\t<\/resources>
\n <\/global>
\n<\/config>
\n[\/php]<\/p>\n

Step 4. Now create models Test.php and Test2.php. Here we configure these model with the handler of table test and test2.<\/p>\n

\/app\/code\/local\/Mypackage\/Mymodule\/Model\/Test.php<\/p>\n

[php]
\n<?php<\/p>\n

class Mypackage_ Mymodule_Model_Test extends Mage_Core_Model_Abstract
\n{<\/p>\n

\tpublic function _construct()
\n {
\n parent::_construct();
\n $this->_init(‘mymodule\/test’);
\n }
\n}
\n[\/php]<\/p>\n

\/app\/code\/local\/Mypackage\/Mymodule\/Model\/Test2.php<\/p>\n

[php]
\n<?php<\/p>\n

class Mypackage_Mymodule_Model_Test2 extends Mage_Core_Model_Abstract
\n{<\/p>\n

\tpublic function _construct()
\n {
\n parent::_construct();
\n $this->_init(‘mymodule\/test2’);
\n }
\n}
\n[\/php]<\/p>\n

Step 5. Now create the resource models for model test and test2. In these files we also set the primary key of both the tables test and test2.<\/p>\n

\/app\/code\/local\/Mypackage\/Mmodule\/Model\/Mysql4\/Test.php.<\/p>\n

[php]
\n<?php<\/p>\n

class Mypackage_Mymodule_Model_Mysql4_Test extends Mage_Core_Model_Mysql4_Abstract
\n{
\n public function _construct()
\n {
\n $this->_init(‘mymodule\/test’, ‘test_id’);
\n }
\n}
\n[\/php]<\/p>\n

\/app\/code\/local\/Mypackage\/Mmodule\/Model\/Mysql4\/Test2.php.<\/p>\n

[php]
\n<?php<\/p>\n

class Mypackage_Mymodule_Model_Mysql4_Test2 extends Mage_Core_Model_Mysql4_Abstract
\n{
\n public function _construct()
\n {
\n $this->_init(‘mymodule\/test2’, ‘test2_id’);
\n }
\n}
\n[\/php]<\/p>\n

Step 6. Create a collection classes so that we can retrieve data from table test and test2.<\/p>\n

\/local\/Mypackage\/Mymodule\/Model\/Mysql4\/Test\/Collection.php<\/p>\n

[php]
\n<?php<\/p>\n

class Mypackage_Mymodule_Model_Mysql4_Test_Collection extends Mage_Core_Model_Mysql4_Collection_Abstract
\n{
\n public function _construct()
\n {
\n parent::_construct();
\n $this->_init(‘mymodule\/test’);
\n }
\n}
\n[\/php]<\/p>\n

\/local\/Mypackage\/Mymodule\/Model\/Mysql4\/Test2\/Collection.php<\/p>\n

[php]
\n<?php<\/p>\n

class Mypackage_Mymodule_Model_Mysql4_Test2_Collection extends Mage_Core_Model_Mysql4_Collection_Abstract
\n{
\n public function _construct()
\n {
\n parent::_construct();
\n $this->_init(‘mymodule\/test2’);
\n }
\n}
\n[\/php]<\/p>\n

So, now you have a custom module with two tables. Your module can interact with these tables with their models and respective collections as follows :<\/p>\n

[php]
\n$testModel = Mage::getModel(‘mymodule\/test’)
\n\t->setName("abcd")
\n\t->save();<\/p>\n

$test2Model = Mage::getModel(‘mymodule\/test2’)
\n\t->setName("abcd")
\n\t->save();
\n[\/php]<\/p>\n

That’s it. Hope this will help you.<\/p>\n","protected":false},"excerpt":{"rendered":"

Creating a module which interact with a database table is quite simple. Most of the developers use magento module creator to create such a module. However, what if you want a module with multiple database tables. Following is the example of module with two database tables. Step 1. Create setup file of your custom module […]<\/p>\n","protected":false},"author":62,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":4},"categories":[1],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/9759"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/62"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=9759"}],"version-history":[{"count":0,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/9759\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=9759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=9759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=9759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}