vendor\project-biz\database-bundle\src\Database\TableHelper.php line 47

Open in your IDE?
  1. <?php
  3. namespace ProjectBiz\DatabaseBundle\Database;
  5. use ProjectBiz\DatabaseBundle\Service\RepositoryConfigurationManager;
  6. use ProjectBiz\UserBundle\Service\SecurityContextWrapper;
  7. use Symfony\Contracts\Translation\TranslatorInterface;
  9. class TableHelper implements TableHelperInterface
  10. {
  11.     public $securityContext;
  13.     protected $configManager;
  14.     protected $databaseSchemaCache;
  15.     protected $translator;
  16.     protected $tableAndViewList;
  17.     protected $cachedViewList;
  18.     protected $cachedTableLists = [];
  19.     protected $cachedInfo       = [];
  21.     public function __construct(
  22.         SecurityContextWrapper $securityContext,
  23.         RepositoryConfigurationManager $configManager,
  24.         DatabaseSchemaCache $databaseSchemaCache,
  25.         TranslatorInterface $translator
  26.     ) {
  27.         $this->securityContext     = $securityContext;
  28.         $this->configManager       = $configManager;
  29.         $this->databaseSchemaCache = $databaseSchemaCache;
  30.         $this->translator          = $translator;
  31.     }
  33.     /**
  34.      * @inheritdoc
  35.      */
  36.     public function getTableInfo($tablename)
  37.     {
  38.         if (!isset($this->cachedInfo[$tablename])) {
  39.             if ($this->isView($tablename)) {
  40.                 $this->cachedInfo[$tablename] = new ViewInfo(
  41.                     $tablename,
  42.                     $this->databaseSchemaCache,
  43.                     $this,
  44.                     $this->translator
  45.                 );
  46.             } else {
  47.                 $this->cachedInfo[$tablename] = new TableInfo(
  48.                     $this->getTableDescriptor($tablename),
  49.                     $this->databaseSchemaCache,
  50.                     $this,
  51.                     $this->translator
  52.                 );
  53.             }
  54.         }
  56.         return $this->cachedInfo[$tablename];
  57.     }
  59.     /**
  60.      * @inheritdoc
  61.      */
  62.     public function isView($tablename)
  63.     {
  64.         return in_array($tablename, $this->getViews());
  65.     }
  67.     /**
  68.      * @return array List of views in database
  69.      */
  70.     protected function getViews()
  71.     {   
  72.         return $this->databaseSchemaCache->getViews();
  73.     }
  75.     /**
  76.      * @param $tablename
  77.      *
  78.      * @return TableDescriptor
  79.      */
  80.     protected function getTableDescriptor($tablename)
  81.     {
  82.         $tableDesciptor = $this->configManager->lookupDescriptor($tablename);
  83.         if (!$tableDesciptor) {
  84.             $tableDesciptor = new TableDescriptor($tablename, $tablename);
  85.         }
  86.         return $tableDesciptor;
  87.     }
  89.     /**
  90.      * @inheritdoc
  91.      */
  92.     public function getTables($withViews = true, $withSynTables = true)
  93.     {
  94.         // Determine index for cached list:
  95.         // 0 = only tables
  96.         // 1 = tables and syn tables
  97.         // 2 = tables and views
  98.         // 3 = tables, syn tables and views
  99.         $index = 0 | ($withSynTables?1:0) | ($withViews?2:0);
  101.         if (!isset($this->cachedTableLists[$index])) {
  103.             // 1. Collect Database-Tables starting with prefix
  104.             $tableList = $this->databaseSchemaCache->getTables();
  106.             // 2. merge the synthetic tables found in RepositoryConfigurationManager
  107.             if ($withSynTables) {
  108.                 $tableList = array_merge($tableList, $this->configManager->getTables());
  109.             }
  111.             // 3. Merge the views
  112.             if ($withViews) {
  113.                 $tableList = array_merge($tableList, $this->getViews());
  114.             }
  116.             $this->cachedTableLists[$index] = $tableList;
  117.         }
  120.         return $this->cachedTableLists[$index];
  121.     }
  123.     /**
  124.      * @inheritdoc
  125.      */
  126.     public function getColumnNameSubString($column)
  127.     {
  128.         return substr($column, strpos($column, '_') + 1);
  129.     }
  131. }