Mryntu

My boss doesn't want me to have a side project

Do I need to write [sic] when including a quotation with a number less than 10 that isn't written out?

Small nick on power cord from an electric alarm clock, and copper wiring exposed but intact

Could a dragon use hot air to help it take off?

Does the Idaho Potato Commission associate potato skins with healthy eating?

Is it "common practice in Fourier transform spectroscopy to multiply the measured interferogram by an apodizing function"? If so, why?

My ex-girlfriend uses my Apple ID to login to her iPad, do I have to give her my Apple ID password to reset it?

Identify and count spells (Distinctive events within each group)

Can a PhD from a non-TU9 German university become a professor in a TU9 university?

Incomplete cube

How can the PCs determine if an item is a phylactery?

How to find if SQL server backup is encrypted with TDE without restoring the backup

Planeswalker Ability and Death Timing

Finitely generated matrix groups whose eigenvalues are all algebraic

Why doesn't Shulchan Aruch include the laws of destroying fruit trees?

Why did early computer designers eschew integers?

Calculating discount not working

Free fall ellipse or parabola?

Can you teleport closer to a creature you are Frightened of?

Can I hook these wires up to find the connection to a dead outlet?

Man transported from Alternate World into ours by a Neutrino Detector

Direct Implications Between USA and UK in Event of No-Deal Brexit

Was the Stack Exchange "Happy April Fools" page fitting with the 90s code?

How to coordinate airplane tickets?

Insert multiple records to multiple custom tables through install script in magento2

0

I have created multiple table schema using setup script like below.

Setup/InstallSchema.php

 namespace VendorModuleSetup;
 use MagentoFrameworkSetupInstallSchemaInterface;
 use MagentoFrameworkSetupModuleContextInterface;
 use MagentoFrameworkSetupSchemaSetupInterface;

 class InstallSchema implements InstallSchemaInterface
{

 public function install(SchemaSetupInterface $setup, 
 ModuleContextInterface $context)
 {
 /**
 * Create table 'tbl_test1'
 */
 $table = $setup->getConnection()
 ->newTable($setup->getTable('tbl_test1'))
 ->addColumn(
 'id',
 MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 null,
 ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],
 'Pod ID'
 )
 ->addColumn(
 'name',
 MagentoFrameworkDBDdlTable::TYPE_TEXT,
 255,
 ['nullable' => false, 'default' => ''],
 'name'
 );
 $setup->getConnection()->createTable($table);

 /**
 * Create table 'tbl_test_2'
 */
 $table = $setup->getConnection()
 ->newTable($setup->getTable('tbl_test_2'))
 ->addColumn(
 'id',
 MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 null,
 ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],
 ''
 )
 ->addColumn(
 'mage_order_id',
 MagentoFrameworkDBDdlTable::TYPE_TEXT,
 255,
 ['nullable' => false, 'default' => ''],
 'magento orderid'
 );
 $setup->getConnection()->createTable($table);

I need to insert multiple records for each table.

How this can be achieved using installer. Can anyone look into this and update me your answer please.

magento2 setup-script installdata

share

asked 4 mins ago

jafar pinjarjafar pinjar

745414

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You wanna to insert records into your table ??
  
  – Prathap Gunasekaran
  3 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @PrathapGunasekaran, yes I have created 2 tables, need to insert multiple records for each table
  
  – jafar pinjar
  2 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  For adding data to the tables you required installData or UpgradeData please follow this
  
  – ABHISHEK TRIPATHI
  23 secs ago
  
  

  
  
  
  

add a comment | 

0

I have created multiple table schema using setup script like below.

Setup/InstallSchema.php

 namespace VendorModuleSetup;
 use MagentoFrameworkSetupInstallSchemaInterface;
 use MagentoFrameworkSetupModuleContextInterface;
 use MagentoFrameworkSetupSchemaSetupInterface;

 class InstallSchema implements InstallSchemaInterface
{

 public function install(SchemaSetupInterface $setup, 
 ModuleContextInterface $context)
 {
 /**
 * Create table 'tbl_test1'
 */
 $table = $setup->getConnection()
 ->newTable($setup->getTable('tbl_test1'))
 ->addColumn(
 'id',
 MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 null,
 ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],
 'Pod ID'
 )
 ->addColumn(
 'name',
 MagentoFrameworkDBDdlTable::TYPE_TEXT,
 255,
 ['nullable' => false, 'default' => ''],
 'name'
 );
 $setup->getConnection()->createTable($table);

 /**
 * Create table 'tbl_test_2'
 */
 $table = $setup->getConnection()
 ->newTable($setup->getTable('tbl_test_2'))
 ->addColumn(
 'id',
 MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 null,
 ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],
 ''
 )
 ->addColumn(
 'mage_order_id',
 MagentoFrameworkDBDdlTable::TYPE_TEXT,
 255,
 ['nullable' => false, 'default' => ''],
 'magento orderid'
 );
 $setup->getConnection()->createTable($table);

I need to insert multiple records for each table.

How this can be achieved using installer. Can anyone look into this and update me your answer please.

magento2 setup-script installdata

share

asked 4 mins ago

jafar pinjarjafar pinjar

745414

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You wanna to insert records into your table ??
  
  – Prathap Gunasekaran
  3 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @PrathapGunasekaran, yes I have created 2 tables, need to insert multiple records for each table
  
  – jafar pinjar
  2 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  For adding data to the tables you required installData or UpgradeData please follow this
  
  – ABHISHEK TRIPATHI
  23 secs ago
  
  

  
  
  
  

add a comment | 

I have created multiple table schema using setup script like below.

Setup/InstallSchema.php

 namespace VendorModuleSetup;
 use MagentoFrameworkSetupInstallSchemaInterface;
 use MagentoFrameworkSetupModuleContextInterface;
 use MagentoFrameworkSetupSchemaSetupInterface;

 class InstallSchema implements InstallSchemaInterface
{

 public function install(SchemaSetupInterface $setup, 
 ModuleContextInterface $context)
 {
 /**
 * Create table 'tbl_test1'
 */
 $table = $setup->getConnection()
 ->newTable($setup->getTable('tbl_test1'))
 ->addColumn(
 'id',
 MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 null,
 ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],
 'Pod ID'
 )
 ->addColumn(
 'name',
 MagentoFrameworkDBDdlTable::TYPE_TEXT,
 255,
 ['nullable' => false, 'default' => ''],
 'name'
 );
 $setup->getConnection()->createTable($table);

 /**
 * Create table 'tbl_test_2'
 */
 $table = $setup->getConnection()
 ->newTable($setup->getTable('tbl_test_2'))
 ->addColumn(
 'id',
 MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 null,
 ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],
 ''
 )
 ->addColumn(
 'mage_order_id',
 MagentoFrameworkDBDdlTable::TYPE_TEXT,
 255,
 ['nullable' => false, 'default' => ''],
 'magento orderid'
 );
 $setup->getConnection()->createTable($table);

I need to insert multiple records for each table.

How this can be achieved using installer. Can anyone look into this and update me your answer please.

magento2 setup-script installdata

share

asked 4 mins ago

jafar pinjarjafar pinjar

745414

 namespace VendorModuleSetup;
 use MagentoFrameworkSetupInstallSchemaInterface;
 use MagentoFrameworkSetupModuleContextInterface;
 use MagentoFrameworkSetupSchemaSetupInterface;

 class InstallSchema implements InstallSchemaInterface
{

 public function install(SchemaSetupInterface $setup, 
 ModuleContextInterface $context)
 {
 /**
 * Create table 'tbl_test1'
 */
 $table = $setup->getConnection()
 ->newTable($setup->getTable('tbl_test1'))
 ->addColumn(
 'id',
 MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 null,
 ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],
 'Pod ID'
 )
 ->addColumn(
 'name',
 MagentoFrameworkDBDdlTable::TYPE_TEXT,
 255,
 ['nullable' => false, 'default' => ''],
 'name'
 );
 $setup->getConnection()->createTable($table);

 /**
 * Create table 'tbl_test_2'
 */
 $table = $setup->getConnection()
 ->newTable($setup->getTable('tbl_test_2'))
 ->addColumn(
 'id',
 MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 null,
 ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],
 ''
 )
 ->addColumn(
 'mage_order_id',
 MagentoFrameworkDBDdlTable::TYPE_TEXT,
 255,
 ['nullable' => false, 'default' => ''],
 'magento orderid'
 );
 $setup->getConnection()->createTable($table);

share

asked 4 mins ago

jafar pinjarjafar pinjar

745414

share

asked 4 mins ago

jafar pinjarjafar pinjar

745414

asked 4 mins ago

jafar pinjarjafar pinjar

745414

asked 4 mins ago

jafar pinjarjafar pinjar

745414