Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/old/vendor/magento/magento-coding-standard/Magento2/Tests/SQL/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

class RawQueryTest
{
    /**
     * @var \Magento\Framework\App\ResourceConnection
     */
    private $connection;

    public function __construct(Magento\Framework\App\ResourceConnection $connection)
    {
        $this->connection = $connection;
    }

    private function insertOneRow($ccode, $county, $city, $tax_rate)
    {
        $query = '
            insert INTO `tax_zipcode` (
                `zipcode` ,
                `county` ,
                `city` ,
                `tax_rate`
            )
            VALUES (
            ' . '\'' . $ccode . '\', \'' . $county . '\', \'' . $city . '\', ' . $tax_rate . ')
            ON DUPLICATE KEY UPDATE `tax_rate` = ' . $tax_rate . ';';


        $this->connection->query($query);
    }

    public function delete()
    {
        $this->connection->query(
            '      DELETE FROM table_name'
        );
    }

    public function delete2()
    {

        $this->connection->query(
            "
            DROP table table_name"
        );
    }

    public function truncate()
    {
        $this->connection->query(
            '
            TRUNCATE table table_name'
        );
    }

    public function runQuery($countyInfo, $countyName)
    {
        $query = '
            UPDATE `table_name`
            SET `tax_rate` = \'' . $countyInfo['tax_percentage'] . '\',
                `auth_code` = \'' . $countyInfo['auth_code'] . '\'
            WHERE county = \'' . $countyName . '\'';
        $this->connection->query($query);

        $this->connection->query('CREATE TABLE Persons
                (
                PersonID int,
                LastName varchar(255),
                FirstName varchar(255),
                Address varchar(255),
                City varchar(255)
                );');
    }

    public function getQuery($period)
    {
        $this->_period = $period;

        $query = "
            select `report_data`
            FROM `trending_report`
            WHERE `created_at` <= CURDATE( )
            AND CURDATE( ) <= `expire_at`
            AND `last_for` = ' . $period . '
            ORDER BY `created_at` DESC
            LIMIT 1
		";

        return $query;
    }
}

$installer = $this;

$installer->run("
    ALTER TABLE `{$installer->getTable('enterprise_catalogpermissions/permission')}`
        CHANGE `website_id` `website_id` SMALLINT(5) UNSIGNED DEFAULT NULL,
        CHANGE `customer_group_id` `customer_group_id` SMALLINT(3) UNSIGNED DEFAULT NULL;
");

$q = <<<EOT
    select * from table_name1
EOT;

$q2 = <<<'EOT'
    select * from table_name2
EOT;

$q3 = 'select * from table_name3';
$q4 = 'Selects from database';
$q5 = '<select></select>';

$message = 'ERROR : UPDATE SINGLE CONTACT';
$message2 = 'ERROR : SELECT SINGLE CONTACT';