File DB.php has 472 lines of code (exceeds 250 allowed). Consider refactoring.

Open

<?php
/*
Copyright 2014-2020 Guillaume Boudreau

This file is part of Greyhole.

DB has 36 functions (exceeds 20 allowed). Consider refactoring.

Open

final class DB {

    /** @var stdClass */
    protected static $options; // connection options
    /** @var PDO */

Method migrate_10_utf8 has 59 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    private static function migrate_10_utf8() {
        $q = "SHOW INDEX FROM du_stats WHERE key_name = 'uniqness' AND column_name = 'full_path'";
        $index_def = DB::getFirst($q);
        if ($index_def->Sub_part > 269) {
            $q = "ALTER TABLE du_stats DROP INDEX uniqness";

Function migrate_10_utf8 has a Cognitive Complexity of 15 (exceeds 5 allowed). Consider refactoring.

Open

    private static function migrate_10_utf8() {
        $q = "SHOW INDEX FROM du_stats WHERE key_name = 'uniqness' AND column_name = 'full_path'";
        $index_def = DB::getFirst($q);
        if ($index_def->Sub_part > 269) {
            $q = "ALTER TABLE du_stats DROP INDEX uniqness";

• Read up
  Read up

Function connect has a Cognitive Complexity of 14 (exceeds 5 allowed). Consider refactoring.

Open

    public static function connect($retry_until_successful=FALSE, $throw_exception_on_error=FALSE, $timeout = 10) {
        $connect_string = 'mysql:host=' . self::$options->host . ';dbname=' . self::$options->name . ';charset=utf8mb4';

        try {
            self::$handle = @new PDO($connect_string, self::$options->user, self::$options->pass, array(PDO::ATTR_TIMEOUT => $timeout, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));

• Read up
  Read up

Method migrate has 42 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    private static function migrate() {
        $db_version = (int) Settings::get('db_version');
        if ($db_version < 11) {
            DB::migrate_1_frozen_thaw();
            DB::migrate_2_idle();

Method connect has 38 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public static function connect($retry_until_successful=FALSE, $throw_exception_on_error=FALSE, $timeout = 10) {
        $connect_string = 'mysql:host=' . self::$options->host . ';dbname=' . self::$options->name . ';charset=utf8mb4';

        try {
            self::$handle = @new PDO($connect_string, self::$options->user, self::$options->pass, array(PDO::ATTR_TIMEOUT => $timeout, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));

Method migrate_18_full_path_utf8mb4 has 27 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    private static function migrate_18_full_path_utf8mb4() {
        $q = "ALTER TABLE `checksums` CHANGE `full_path` `full_path` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL";
        DB::execute($q);

        $query = "DESCRIBE tasks";

Function migrate_6_md5_worker_indexes has a Cognitive Complexity of 9 (exceeds 5 allowed). Consider refactoring.

Open

    private static function migrate_6_md5_worker_indexes() {
        $query = "SHOW INDEX FROM tasks WHERE Key_name = 'md5_worker'";
        $row = DB::getFirst($query);
        if ($row === FALSE) {
            // migrate

• Read up
  Read up

Function execute has a Cognitive Complexity of 9 (exceeds 5 allowed). Consider refactoring.

Open

    public static function execute($q, $args = array(), $attempt_repair=TRUE) {
        $stmt = self::$handle->prepare($q);
        foreach ($args as $key => $value) {
            $stmt->bindValue(":$key", $value);
        }

• Read up
  Read up

Function migrate has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

    private static function migrate() {
        $db_version = (int) Settings::get('db_version');
        if ($db_version < 11) {
            DB::migrate_1_frozen_thaw();
            DB::migrate_2_idle();

• Read up
  Read up

Function migrate_18_full_path_utf8mb4 has a Cognitive Complexity of 7 (exceeds 5 allowed). Consider refactoring.

Open

    private static function migrate_18_full_path_utf8mb4() {
        $q = "ALTER TABLE `checksums` CHANGE `full_path` `full_path` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL";
        DB::execute($q);

        $query = "DESCRIBE tasks";

• Read up
  Read up

Function migrate_9_complete_writen has a Cognitive Complexity of 7 (exceeds 5 allowed). Consider refactoring.

Open

    private static function migrate_9_complete_writen() {
        $query = "DESCRIBE tasks";
        $rows = DB::getAll($query);
        foreach ($rows as $row) {
            if ($row->Field == 'complete') {

• Read up
  Read up

Function migrate_3_larger_settings has a Cognitive Complexity of 7 (exceeds 5 allowed). Consider refactoring.

Open

    private static function migrate_3_larger_settings() {
        $query = "DESCRIBE settings";
        $rows = DB::getAll($query);
        foreach ($rows as $row) {
            if ($row->Field == 'value') {

• Read up
  Read up