Re: [pgAdmin][RM1802] ERD Tool (Beta)

Поиск
Список
Период
Сортировка
От Khushboo Vashi
Тема Re: [pgAdmin][RM1802] ERD Tool (Beta)
Дата
Msg-id CAFOhELdL0-M_itS4z-qNKUq6=RieWqc9UPos=oJTJFjyLrYQQw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [pgAdmin][RM1802] ERD Tool (Beta)  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
Ответы Re: [pgAdmin][RM1802] ERD Tool (Beta)  (Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>)
Список pgadmin-hackers
Hi Aditya,
The functionalities and the code looks good to me, however some of the comments as below:
  • Correct the comments at some places (3 occurrences found in /erd/__init__.py) which mention Schema diff instead of ERD.
Some comments in the JS/JSX file regarding components/functions (For example, IconButton (forwardRef), Bodywidget etc.) would
be great help as we all are new to React. 
  • Remove the unused imports (for ex bad_request) in /erd/__init__.py
  • Remove commented code
# req_args = request.args
# if ('recreate' in req_args and
#     req_args['recreate'] == '1'):
#     connect = False
  • TableNode.jsx, below two lines can be combined.
import { PortModelAlignment, DefaultNodeModel } from '@projectstorm/react-diagrams';
import { PortWidget } from '@projectstorm/react-diagrams';
  • onImageClick function in BodyWidget.jsx is no use I think, so it should be removed.
  • I got some console errors while adding/editing tables. Refer to the attached screenshot.
  • In the column Edit Mode, while deleting the primary key, it gives the error, which does not go away with any further modifications.
  • While generating the SQL, if the server is disconnected, a proper error message should be thrown, right now some server side error is coming.
  • Please remove ... from the menu title (New ERD Project(Beta)...) as it is not opening a dialog.
  • For large data sets, generate ERD hangs.
  • Opening the ERD panel in a new window is not working, it opens in the same tab even if you have set the Preference "Open in new browser tab" to True.
  • No shortcut is provided to open the ERD Tool.
  • SonarQube fixes required.
Suggestion:
While removal of the FK link, If any of the table is selected, it is being deleted with FK link.
Either we should warn the user OR make 2 different buttons for FK removal and table removal as the user may be confused if the selected table is also removed with the FK.
Observations:
Lodash has been used in this module in place of Underscore, though the dependency is already introduced by another module,
but we have mentioned it in the package.json file, which is somewhat not convincing to me.
Lodash is more advanced than Underscore but we should pick anyone as it will be easy to manage.


Table dialog code is duplicate of the table node, as it was difficult to extend it because it was attached to the tree.
So, we need to keep in mind that while implementing React in pgAdmin, the nodes should be properly detached from the tree itself, so we can reuse it.

Thanks,
Khushboo


On Mon, Dec 28, 2020 at 10:53 AM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:


On Fri, Dec 25, 2020 at 4:34 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Hi Khushboo,

Can you please review it?

On it. 
On Fri, Dec 25, 2020 at 3:31 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Hackers,

Attached patch introduces ERD Tool(Beta) to pgAdmin. Below are the details:
1) Create a diagram from scratch or generate for an existing DB.
2) Generate "Create" DDL from the diagram.
3) Save the diagram and resume it later.
4) Supports basic table fields, one-to-many relationships, many-to-many relationships, adding notes.
5) Test cases added with 75-80% test coverage.

Please review.

--
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"


--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Principal Software Architect
EDB Postgres
Mobile: +91 976-788-8246

Вложения

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: "Huang, Jun"
Дата:
Сообщение: The target connection was wrong in function check_version_compatibility()
Следующее
От: Dave Page
Дата:
Сообщение: Re: Somewhat excessive version checks