3x Magento Master
You can check any physical file is exist or not at a specific location in Magento directory by Magento\Framework\Filesystem\Driver\File class.
You can use Magento 2 native class to check file is exist or not instead of the core PHP method.
I have taken a Block file and create a function for check file is exist or not via constructor DI, Continue reading “How to Check file is exists or not at specific location programmatically in Magento 2?”
In Magento 2, You can create a new table using db_schema.xml file. After creating a table you want to rename a table name, You can rename a table using declarative schema.
New Table(mycustom_table) db_schema.xml file,
<?xml version="1.0"?>
<schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup/Declaration/Schema/etc/schema.xsd">
<table name="mycustom_table" onCreate="migrateDataFromAnotherTable(new_declarative_table)">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"
comment="Entity Id"/>
<column xsi:type="varchar" name="fullname" nullable="true" length="50" comment="Full name"/>
<column xsi:type="varchar" name="email" nullable="true" length="255" comment="Email"/>
<column xsi:type="smallint" name="store_id" padding="5" unsigned="true" nullable="true" identity="false"
default="0" comment="Store Id"/>
</table>
</schema>
Now you must have to run generate-whitelist command to generate db_schema_whitelist.json file, Continue reading “Rename a tablename using db_schema(Declarative schema) in Magento 2.”
In Magento 2, You can create a new table using the db_schema.xml file. The table contains many columns based on your requirements.
Check the blog for, How to creates a new database table.
In the future, if you want to remove or drop some column from an existing table you can drop a column using db_schema.xml file.
Let’s assume, You have created a table name, my_custom_table in the database with the email column and you want to remove the email column.
Table with a list of entries and some of the columns you don’t require, You can remove those columns using the attribute disabled=true in a db_schema.xml file. Continue reading “Drop a column from the table using db_schema.xml in Magento 2.”