Idea PhpStorm - Database - No databases and tables, all is empty

 Sometimes, when you add new project (site) and configure Database connection, the panel with tables is empty. Even if connection is green and all is OK. 

To fix this problem, you just need to add necessary schemes in Database configuration.

  1. Go to "Data Source Properties" window.


  2. In opened window choose Schemas tab and select "All schemas" checkbox, or another one what you need.
So, after saving changes, you see all tables in Database panel.

Comments

Post a Comment

Popular posts from this blog

Symfony - Twig - How to check on instanceof class object

In Twig exist "constant" function that returns constant value, but if you set "class" in first parameter and object in second parameter, then function returns the fully qualified class name of an object.  So we can use it in our case and compare it on class name that we want to check like "instanceof". Example: {% if constant('class', app.user) == 'User' %}{% endif %} Or with namespace: {% if constant('class', app.user) == 'EntityBundle\\Entity\\User' %}{% endif %}
Читать далее

Symfony - Doctrine - How to change old attributes in entity to new PHP 8 attributes

Old-Style Annotations: Written as comments, typically using PHPDoc syntax (/** ... */). Annotations are interpreted by external tools or libraries. Doctrine ORM interprets annotations to configure database mappings. Limited flexibility in terms of syntax and available metadata types. May lack type safety and validation. PHP 8 Attributes: Written using the #[...] syntax. Introduced as a language feature in PHP 8 for adding metadata directly to code. Provides a more structured and standardized way of associating metadata with classes, methods, or properties. Attributes are a built-in language feature, eliminating the need for external interpretation in many cases. Attributes are directly handled by the PHP runtime. Offers better type safety and validation compared to traditional annotations. Supports the use of PHP's native types and expressions within attribute values. Attributes support namespacing, allowing for better organization and...
Читать далее

Symfony - Doctrine - How to save SQL query to Session

If you have separated ajax table sheet with data and filters, sometimes, you need to keep this filtered data between requests. In my case, I needed to be able to download file in CSV format, after choosing all necessary filters in table. So, it is possible to store SQL query in client Session after applying all filters and receive data from DB via DQL. To store DQL in session: $query = $this->createQueryBuilder('i')->select('COUNT(i)'); $_SESSION['query'] = $query->getQuery()->getDQL(); $_SESSION['query_params'] = $query->getQuery()->getParameters(); To get data from DB: $data = $this->createQuery($_SESSION['query'])->setParameters($_SESSION['query_params'])->getResult();
Читать далее