ResourceModel\Helper

What it does

This class provides SQL generation utilities for creating database backups in Magento 2.

Developers use it to generate SQL statements for dropping/creating tables, inserting data, handling foreign keys, and managing triggers during backup operations.

It's primarily used by the Backup module to export database structure and data into SQL files.

Public Methods

• getTableDropSql()
• getTableForeignKeysSql()
• getTableCreateScript()
• getTableCreateSql()
• getHeader()
• getFooter()
• getTableDataBeforeSql()
• getTableDataAfterSql()
• getPartInsertSql()
• getInsertSql()
• prepareTransactionIsolationLevel()
• restoreTransactionIsolationLevel()
• getTableTriggersSql()