Redaxscript\Db::countTablePrefix PHP Méthode

countTablePrefix() public static méthode

count table with prefix
Since: 2.4.0
public static countTablePrefix ( ) : Db
Résultat Db
    public static function countTablePrefix()
    {
        if (self::$_config->get('dbType') === 'mysql') {
            return self::rawInstance()->rawQuery('SHOW TABLES LIKE \'' . self::$_config->get('dbPrefix') . '%\'')->findMany()->count();
        }
        if (self::$_config->get('dbType') === 'pgsql') {
            return self::forTable('pg_catalog.pg_tables')->whereLike('tablename', '%' . self::$_config->get('dbPrefix') . '%')->whereNotLike('tablename', '%pg_%')->whereNotLike('tablename', '%sql_%')->count();
        }
        if (self::$_config->get('dbType') === 'sqlite') {
            return self::forTable('sqlite_master')->where('type', 'table')->whereLike('name', '%' . self::$_config->get('dbPrefix') . '%')->whereNotLike('name', '%sqlite_%')->count();
        }
    }

Usage Example

 /**
  * testUninstall
  *
  * @since 2.6.0
  */
 public function testUninstall()
 {
     /* setup */
     $module = new Module();
     $module->init(array('alias' => 'TestDummy'));
     $module->uninstall();
     /* actual */
     $actualModules = Db::forTablePrefix('modules')->findMany()->count();
     $actualTables = Db::countTablePrefix();
     /* compare */
     $this->assertEquals(1, $actualModules);
     $this->assertEquals(8, $actualTables);
 }
All Usage Examples Of Redaxscript\Db::countTablePrefix