How do I insert data into a table in a module's installation process?

cerebrumgit · January 28, 2016, 10:54pm

Hello good afternoon

All good my friend

I created a new extension

Where a table was set up in the database

I would like to offer this new module but with pre-existing data in this table

What is the correct way to do this process?

dmitry_fedyuk · January 28, 2016, 11:00pm

See examples from the core:

github.com

magento/magento2/blob/720667e/app/code/Magento/Catalog/Setup/InstallData.php#L47-L58


// Create Root Catalog Node
$categorySetup->createCategory()
    ->load(1)
    ->setId(1)
    ->setStoreId(0)
    ->setPath('1')
    ->setLevel(0)
    ->setPosition(0)
    ->setChildrenCount(0)
    ->setName('Root Catalog')
    ->setInitialSetupFlag(true)
    ->save();

github.com

magento/magento2/blob/720667e/app/code/Magento/Cms/Setup/InstallData.php#L98-L103


/**
 * Insert default and system pages
 */
foreach ($cmsPages as $data) {
    $this->createPage()->setData($data)->save();
}

github.com

magento/magento2/blob/720667e/app/code/Magento/Checkout/Setup/InstallData.php#L139-L148


$connection->insert(
    $setup->getTable('eav_form_type'),
    [
        'code' => 'checkout_onepage_register',
        'label' => 'checkout_onepage_register',
        'is_system' => 1,
        'theme' => '',
        'store_id' => 0
    ]
);