Edit File by line

<?php namespace la\core\db;

[0] Fix | Delete

[1] Fix | Delete

[2] Fix | Delete

/**

[3] Fix | Delete

[4] Fix | Delete

* @author navdeykin <navdeykin@gmail.com>

[5] Fix | Delete

[6] Fix | Delete

[7] Fix | Delete

class LADDLUtils {

[8] Fix | Delete

/**

[9] Fix | Delete

* @param LASafeMySQL $conn

[10] Fix | Delete

* @param string $table_name

[11] Fix | Delete

* @return bool

[12] Fix | Delete

[13] Fix | Delete

public static function existTable($conn, $table_name){

[14] Fix | Delete

return $conn->getOne('SHOW TABLES LIKE ?s', $table_name) !== false;

[15] Fix | Delete

}

[16] Fix | Delete

[17] Fix | Delete

/**

[18] Fix | Delete

* @param LASafeMySQL $conn

[19] Fix | Delete

* @param string $table_name

[20] Fix | Delete

[21] Fix | Delete

public static function dropTable($conn, $table_name){

[22] Fix | Delete

$conn->query('DROP TABLE ' . $table_name);

[23] Fix | Delete

}

[24] Fix | Delete

[25] Fix | Delete

/**

[26] Fix | Delete

* @param LASafeMySQL $conn

[27] Fix | Delete

* @param string $table_name

[28] Fix | Delete

* @param $column_name

[29] Fix | Delete

[30] Fix | Delete

public static function dropColumn($conn, $table_name, $column_name){

[31] Fix | Delete

$conn->query('ALTER TABLE ?n DROP ?s' . $table_name, $column_name);

[32] Fix | Delete

}

[33] Fix | Delete

[34] Fix | Delete

/**

[35] Fix | Delete

* @param LASafeMySQL $conn

[36] Fix | Delete

* @param string $table_name

[37] Fix | Delete

* @param $column_name

[38] Fix | Delete

[39] Fix | Delete

* @return bool

[40] Fix | Delete

[41] Fix | Delete

public static function existColumn($conn, $table_name, $column_name){

[42] Fix | Delete

return $conn->getOne('SHOW COLUMNS FROM ?n LIKE ?s', $table_name, $column_name) !== false;

[43] Fix | Delete

}

[44] Fix | Delete

[45] Fix | Delete

/**

[46] Fix | Delete

* @param LASafeMySQL $conn

[47] Fix | Delete

* @param string $table_name

[48] Fix | Delete

* @param string $column_name

[49] Fix | Delete

* @param string $type

[50] Fix | Delete

[51] Fix | Delete

* @return bool

[52] Fix | Delete

[53] Fix | Delete

public static function addColumn( $conn, $table_name, $column_name, $type ) {

[54] Fix | Delete

$sql = 'ALTER TABLE ?n ADD COLUMN ?n ' . $type;

[55] Fix | Delete

return $conn->query($sql, $table_name, $column_name);

[56] Fix | Delete

}

[57] Fix | Delete

[58] Fix | Delete

/**

[59] Fix | Delete

* @param LASafeMySQL $conn

[60] Fix | Delete

* @param string $table_name

[61] Fix | Delete

* @param string $column_name

[62] Fix | Delete

* @param string $type

[63] Fix | Delete

[64] Fix | Delete

* @return bool

[65] Fix | Delete

[66] Fix | Delete

public static function addColumnIfNotExist( $conn, $table_name, $column_name, $type ) {

[67] Fix | Delete

if (!self::existColumn($conn, $table_name, $column_name)){

[68] Fix | Delete

self::addColumn($conn, $table_name, $column_name, $type);

[69] Fix | Delete

}

[70] Fix | Delete

}

[71] Fix | Delete

[72] Fix | Delete

/** @return string */

[73] Fix | Delete

public static function charset(){

[74] Fix | Delete

if (FF_USE_WP){

[75] Fix | Delete

/** @var object $wpdb */

[76] Fix | Delete

$wpdb = $GLOBALS['wpdb'];

[77] Fix | Delete

return $wpdb->charset;

[78] Fix | Delete

}

[79] Fix | Delete

return DB_CHARSET; // @codeCoverageIgnore

[80] Fix | Delete

}

[81] Fix | Delete

[82] Fix | Delete

/** @return string */

[83] Fix | Delete

public static function collate() {

[84] Fix | Delete

if (FF_USE_WP){

[85] Fix | Delete

/** @var object $wpdb */

[86] Fix | Delete

$wpdb = $GLOBALS['wpdb'];

[87] Fix | Delete

return $wpdb->collate;

[88] Fix | Delete

}

[89] Fix | Delete

return DB_COLLATE; // @codeCoverageIgnore

[90] Fix | Delete

}

[91] Fix | Delete

}

[92] Fix | Delete