Gsyfuy

Why doesn't "adolescent" take any articles in "listen to adolescent agonising"?

Should I use HTTPS on a domain that will only be used for redirection?

PTIJ: What dummy is the Gemara referring to?

Where is the fallacy here?

I can't die. Who am I?

What is the meaning of "notice to quit at once" and "Lotty points”

Can a Trickery Domain cleric cast a spell through the Invoke Duplicity clone while inside a Forcecage?

How to mitigate "bandwagon attacking" from players?

Plagiarism of code by other PhD student

Practical reasons to have both a large police force and bounty hunting network?

Make me a metasequence

How do you say “my friend is throwing a party, do you wanna come?” in german

Can I solder 12/2 Romex to extend wire 5 ft?

When was drinking water recognized as crucial in marathon running?

“I had a flat in the centre of town, but I didn’t like living there, so …”

Relationship between the symmetry number of a molecule as used in rotational spectroscopy and point group

Why would the IRS ask for birth certificates or even audit a small tax return?

Split a number into equal parts given the number of parts

How to fix my table, centering of columns

Quitting employee has privileged access to critical information

What is a term for a function that when called repeatedly, has the same effect as calling once?

How does signal strength relate to bandwidth?

What can I do if someone tampers with my SSH public key?

3.5% Interest Student Loan or use all of my savings on Tuition?

Magento 2.3 : Insert data into table using DB Schema

Magento 2.3 : How to implement declarative schema in custom moduleCould someone please explain Declarative Database SchemaMagento 2.3 : How to implement declarative schema in custom moduleMagento 2.3 Can't view module's front end page output?How to add a Customer Attribute in a custom module using declarative schema in Magento 2.3?How to drop a table in Declarative schema?Undefined index: sales_shipment in l/vendor/magento/framework/Setup/Declaration/Schema/Db/SchemaBuilder.phpHelp! upgrade 2.x to 2.3 get error magento/framework/Setup/Declaration/Schema/Db/SchemaBuilder.php on line 152Errors on Declarative Schema on custom module on 2.3

0

I have created upgrade data for insert the values for particular table

<?php



namespace XXXYYYSetup;



use MagentoFrameworkSetupModuleContextInterface;

use MagentoFrameworkSetupModuleDataSetupInterface;

use MagentoFrameworkSetupUpgradeDataInterface;



class UpgradeData implements UpgradeDataInterface

{

    /**

     * Upgrades DB for a module

     *

     * @param ModuleDataSetupInterface $setup

     * @param ModuleContextInterface $context

     * @return void

     */

    public function upgrade(ModuleDataSetupInterface $setup, ModuleContextInterface $context)

    {

        $setup->startSetup();



        /**

         * install product link attributes

         */

        $data = [

            [

                'link_type_id' => 'color',

                'product_link_attribute_code' => 'position',

                'data_type' => 'int',

            ]

        ];



        $setup->getConnection()

            ->insertMultiple($setup->getTable('catalog_product_link_attribute'), $data);



        $setup->endSetup();

    }

}

I need to insert value using db_schema concept in Magento 2.3

how to do that.

Thanks.

magento2.3 php-7.2

share|improve this question

edited 2 mins ago

Rohan Hapani

6,37331764

asked 10 mins ago

Mano MMano M

941219

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  what do you mean by magento db_schema concept?
  
  – magefms
  7 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  need to change this script suitable for magento2.3
  
  – Mano M
  6 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Did you use this answer? magento.stackexchange.com/a/251886/51810
  
  – Rohan Hapani
  6 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I know ... But i need to insert the values for table ?
  
  – Mano M
  5 mins ago
  

  
  
  
  

add a comment | 

0

I have created upgrade data for insert the values for particular table

<?php



namespace XXXYYYSetup;



use MagentoFrameworkSetupModuleContextInterface;

use MagentoFrameworkSetupModuleDataSetupInterface;

use MagentoFrameworkSetupUpgradeDataInterface;



class UpgradeData implements UpgradeDataInterface

{

    /**

     * Upgrades DB for a module

     *

     * @param ModuleDataSetupInterface $setup

     * @param ModuleContextInterface $context

     * @return void

     */

    public function upgrade(ModuleDataSetupInterface $setup, ModuleContextInterface $context)

    {

        $setup->startSetup();



        /**

         * install product link attributes

         */

        $data = [

            [

                'link_type_id' => 'color',

                'product_link_attribute_code' => 'position',

                'data_type' => 'int',

            ]

        ];



        $setup->getConnection()

            ->insertMultiple($setup->getTable('catalog_product_link_attribute'), $data);



        $setup->endSetup();

    }

}

I need to insert value using db_schema concept in Magento 2.3

how to do that.

Thanks.

magento2.3 php-7.2

share|improve this question

edited 2 mins ago

Rohan Hapani

6,37331764

asked 10 mins ago

Mano MMano M

941219

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  what do you mean by magento db_schema concept?
  
  – magefms
  7 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  need to change this script suitable for magento2.3
  
  – Mano M
  6 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Did you use this answer? magento.stackexchange.com/a/251886/51810
  
  – Rohan Hapani
  6 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I know ... But i need to insert the values for table ?
  
  – Mano M
  5 mins ago
  

  
  
  
  

add a comment | 

I have created upgrade data for insert the values for particular table

<?php



namespace XXXYYYSetup;



use MagentoFrameworkSetupModuleContextInterface;

use MagentoFrameworkSetupModuleDataSetupInterface;

use MagentoFrameworkSetupUpgradeDataInterface;



class UpgradeData implements UpgradeDataInterface

{

    /**

     * Upgrades DB for a module

     *

     * @param ModuleDataSetupInterface $setup

     * @param ModuleContextInterface $context

     * @return void

     */

    public function upgrade(ModuleDataSetupInterface $setup, ModuleContextInterface $context)

    {

        $setup->startSetup();



        /**

         * install product link attributes

         */

        $data = [

            [

                'link_type_id' => 'color',

                'product_link_attribute_code' => 'position',

                'data_type' => 'int',

            ]

        ];



        $setup->getConnection()

            ->insertMultiple($setup->getTable('catalog_product_link_attribute'), $data);



        $setup->endSetup();

    }

}

I need to insert value using db_schema concept in Magento 2.3

how to do that.

Thanks.

magento2.3 php-7.2

share|improve this question

edited 2 mins ago

Rohan Hapani

6,37331764

asked 10 mins ago

Mano MMano M

941219

<?php



namespace XXXYYYSetup;



use MagentoFrameworkSetupModuleContextInterface;

use MagentoFrameworkSetupModuleDataSetupInterface;

use MagentoFrameworkSetupUpgradeDataInterface;



class UpgradeData implements UpgradeDataInterface

{

    /**

     * Upgrades DB for a module

     *

     * @param ModuleDataSetupInterface $setup

     * @param ModuleContextInterface $context

     * @return void

     */

    public function upgrade(ModuleDataSetupInterface $setup, ModuleContextInterface $context)

    {

        $setup->startSetup();



        /**

         * install product link attributes

         */

        $data = [

            [

                'link_type_id' => 'color',

                'product_link_attribute_code' => 'position',

                'data_type' => 'int',

            ]

        ];



        $setup->getConnection()

            ->insertMultiple($setup->getTable('catalog_product_link_attribute'), $data);



        $setup->endSetup();

    }

}

share|improve this question

edited 2 mins ago

Rohan Hapani

6,37331764

asked 10 mins ago

Mano MMano M

941219

share|improve this question

edited 2 mins ago

Rohan Hapani

6,37331764

asked 10 mins ago

Mano MMano M

941219

edited 2 mins ago

Rohan Hapani

6,37331764

edited 2 mins ago

Rohan Hapani

6,37331764

asked 10 mins ago

Mano MMano M

941219

asked 10 mins ago

Mano MMano M

941219

1 Answer
1

active

oldest

votes

0

Try this:

<?php



namespace XXXYYYSetup;



use MagentoFrameworkSetupModuleContextInterface;

use MagentoFrameworkSetupModuleDataSetupInterface;

use MagentoFrameworkSetupUpgradeDataInterface;



class UpgradeData implements UpgradeDataInterface

{

    /**

     * Upgrades DB for a module

     *

     * @param ModuleDataSetupInterface $setup

     * @param ModuleContextInterface $context

     * @return void

     */

    public function upgrade(ModuleDataSetupInterface $setup, ModuleContextInterface $context)

    {

        $setup->startSetup();



        /**

         * install product link attributes

         */



         if (version_compare($context->getVersion(), '1.0.1', '<')) {

            $setup->getConnection()->insert(

                $setup->getTable('catalog_product_link_attribute'),

                [

                    'link_type_id' => 'color',

                    'product_link_attribute_code' => 'position',

                    'data_type' => 'int'

                ]



            );

        }



        $setup->endSetup();

    }

}

share

answered 35 secs ago

magefmsmagefms

1,148220

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f264788%2fmagento-2-3-insert-data-into-table-using-db-schema%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

Try this:

<?php



namespace XXXYYYSetup;



use MagentoFrameworkSetupModuleContextInterface;

use MagentoFrameworkSetupModuleDataSetupInterface;

use MagentoFrameworkSetupUpgradeDataInterface;



class UpgradeData implements UpgradeDataInterface

{

    /**

     * Upgrades DB for a module

     *

     * @param ModuleDataSetupInterface $setup

     * @param ModuleContextInterface $context

     * @return void

     */

    public function upgrade(ModuleDataSetupInterface $setup, ModuleContextInterface $context)

    {

        $setup->startSetup();



        /**

         * install product link attributes

         */



         if (version_compare($context->getVersion(), '1.0.1', '<')) {

            $setup->getConnection()->insert(

                $setup->getTable('catalog_product_link_attribute'),

                [

                    'link_type_id' => 'color',

                    'product_link_attribute_code' => 'position',

                    'data_type' => 'int'

                ]



            );

        }



        $setup->endSetup();

    }

}

share

answered 35 secs ago

magefmsmagefms

1,148220

add a comment | 

0

Try this:

<?php



namespace XXXYYYSetup;



use MagentoFrameworkSetupModuleContextInterface;

use MagentoFrameworkSetupModuleDataSetupInterface;

use MagentoFrameworkSetupUpgradeDataInterface;



class UpgradeData implements UpgradeDataInterface

{

    /**

     * Upgrades DB for a module

     *

     * @param ModuleDataSetupInterface $setup

     * @param ModuleContextInterface $context

     * @return void

     */

    public function upgrade(ModuleDataSetupInterface $setup, ModuleContextInterface $context)

    {

        $setup->startSetup();



        /**

         * install product link attributes

         */



         if (version_compare($context->getVersion(), '1.0.1', '<')) {

            $setup->getConnection()->insert(

                $setup->getTable('catalog_product_link_attribute'),

                [

                    'link_type_id' => 'color',

                    'product_link_attribute_code' => 'position',

                    'data_type' => 'int'

                ]



            );

        }



        $setup->endSetup();

    }

}

share

answered 35 secs ago

magefmsmagefms

1,148220

add a comment | 

Try this:

<?php



namespace XXXYYYSetup;



use MagentoFrameworkSetupModuleContextInterface;

use MagentoFrameworkSetupModuleDataSetupInterface;

use MagentoFrameworkSetupUpgradeDataInterface;



class UpgradeData implements UpgradeDataInterface

{

    /**

     * Upgrades DB for a module

     *

     * @param ModuleDataSetupInterface $setup

     * @param ModuleContextInterface $context

     * @return void

     */

    public function upgrade(ModuleDataSetupInterface $setup, ModuleContextInterface $context)

    {

        $setup->startSetup();



        /**

         * install product link attributes

         */



         if (version_compare($context->getVersion(), '1.0.1', '<')) {

            $setup->getConnection()->insert(

                $setup->getTable('catalog_product_link_attribute'),

                [

                    'link_type_id' => 'color',

                    'product_link_attribute_code' => 'position',

                    'data_type' => 'int'

                ]



            );

        }



        $setup->endSetup();

    }

}

share

answered 35 secs ago

magefmsmagefms

1,148220

<?php



namespace XXXYYYSetup;



use MagentoFrameworkSetupModuleContextInterface;

use MagentoFrameworkSetupModuleDataSetupInterface;

use MagentoFrameworkSetupUpgradeDataInterface;



class UpgradeData implements UpgradeDataInterface

{

    /**

     * Upgrades DB for a module

     *

     * @param ModuleDataSetupInterface $setup

     * @param ModuleContextInterface $context

     * @return void

     */

    public function upgrade(ModuleDataSetupInterface $setup, ModuleContextInterface $context)

    {

        $setup->startSetup();



        /**

         * install product link attributes

         */



         if (version_compare($context->getVersion(), '1.0.1', '<')) {

            $setup->getConnection()->insert(

                $setup->getTable('catalog_product_link_attribute'),

                [

                    'link_type_id' => 'color',

                    'product_link_attribute_code' => 'position',

                    'data_type' => 'int'

                ]



            );

        }



        $setup->endSetup();

    }

}

share

answered 35 secs ago

magefmsmagefms

1,148220

answered 35 secs ago

magefmsmagefms

1,148220

answered 35 secs ago

magefmsmagefms

1,148220