eralchemy | Entity Relation Diagrams generation tool | SQL Database library

by Alexis-benoist Python Version: 1.2.10 License: Apache-2.0

X-Ray Key Features Code Snippets Community Discussions(3)Vulnerabilities Install Support

kandi X-RAY | eralchemy Summary

eralchemy is a Python library typically used in Database, SQL Database, PostgresSQL, Oracle applications. eralchemy has no vulnerabilities, it has build file available, it has a Permissive License and it has medium support. However eralchemy has 3 bugs. You can install using 'pip install eralchemy' or download it from GitHub, PyPI.

Entity Relation Diagrams generation tool

Support

Quality

Security

License

Reuse

Support

eralchemy has a medium active ecosystem.

It has 1018 star(s) with 118 fork(s). There are 25 watchers for this library.

It had no major release in the last 12 months.

There are 33 open issues and 17 have been closed. On average issues are closed in 78 days. There are 16 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of eralchemy is 1.2.10

Quality

eralchemy has 3 bugs (3 blocker, 0 critical, 0 major, 0 minor) and 10 code smells.

Security

eralchemy has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

eralchemy code analysis shows 0 unresolved vulnerabilities.

There are 1 security hotspots that need review.

License

eralchemy is licensed under the Apache-2.0 License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

eralchemy releases are available to install and integrate.

Deployable package is available in PyPI.

Build file is available. You can build the component from source.

Installation instructions, examples and code snippets are available.

eralchemy saves you 542 person hours of effort in developing the same functionality from scratch.

It has 1270 lines of code, 132 functions and 23 files.

It has medium code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi has reviewed eralchemy and discovered the below as its top functions. This is intended to give you an instant insight into eralchemy implemented functionality, and help decide if they suit your requirements.

Render an Erlang table
Convert a Markdown file to an intermediary representation
Converts a line iterator to an intermediary representation
Filter lines from comments
Renders the engine
Parse command line arguments
Check arguments
Checks if arguments are set
Build and uploads and uploads and uploads
Return a dot representation of the graph
Return node cardinalities
Return the next version
Convert intermediary to dot format
Return a string representation of the intermediary representation
Returns the current version
Read the latest version
Example example
Render a table
Convert intermediary representation to dot format
Convert the intermediary representation to markdown

Get all kandi verified functions for this library.

eralchemy Key Features

No Key Features are available at this moment for eralchemy.

eralchemy Examples and Code Snippets

No Code Snippets are available at this moment for eralchemy.

Community Discussions

Trending Discussions on eralchemy

Error when trying to install eralchemy in Jupyter from a Windows device

SQLAlchemy ER diagram in python 3

ERAlchemy cannot connect to database

QUESTION

Error when trying to install eralchemy in Jupyter from a Windows device

Asked 2021-Mar-03 at 07:32

Good day

When I run the command pip install eralchemy in a clear Jupyter notebook from a Windows device, I get the lengthy error message below. I have already installed Graphviz with Chocolate and Visual Studio with its BuildTools. Any help?

ERROR: Command errored out with exit status 1: command: 'C:\Users\stanj\anaconda3\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\Users\stanj\AppData\Local\Temp\pip-install-pw34pfvb\pygraphviz\setup.py'"'"'; file='"'"'C:\Users\stanj\AppData\Local\Temp\pip-install-pw34pfvb\pygraphviz\setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(file);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, file, '"'"'exec'"'"'))' bdist_wheel -d 'C:\Users\stanj\AppData\Local\Temp\pip-wheel-68acdv22' cwd: C:\Users\stanj\AppData\Local\Temp\pip-install-pw34pfvb\pygraphviz\
Complete output (46 lines): running bdist_wheel running build
running build_py creating build Collecting eralchemy Using cached ERAlchemy-1.2.10-py2.py3-none-any.whl (14 kB) Collecting pygraphviz
Using cached pygraphviz-1.7.zip (118 kB) Requirement already satisfied: SQLAlchemy in c:\users\stanj\anaconda3\lib\site-packages (from eralchemy) (1.3.18) Building wheels for collected packages: pygraphviz Building wheel for pygraphviz (setup.py): started
Building wheel for pygraphviz (setup.py): finished with status 'error' Running setup.py clean for pygraphviz Failed to build pygraphviz Installing collected packages: pygraphviz, eralchemy Running setup.py install for pygraphviz: started Running setup.py install for pygraphviz: finished with status 'error' creating build\lib.win-amd64-3.8 creating build\lib.win-amd64-3.8\pygraphviz copying pygraphviz\agraph.py -> build\lib.win-amd64-3.8\pygraphviz copying pygraphviz\graphviz.py -> build\lib.win-amd64-3.8\pygraphviz copying pygraphviz\scraper.py -> build\lib.win-amd64-3.8\pygraphviz copying pygraphviz\testing.py -> build\lib.win-amd64-3.8\pygraphviz copying pygraphviz_init_.py -> build\lib.win-amd64-3.8\pygraphviz creating build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_attribute_defaults.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_clear.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_close.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_drawing.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_edge_attributes.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_graph.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_html.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_layout.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_node_attributes.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_readwrite.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_scraper.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_string.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_subgraph.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_unicode.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests_init_.py -> build\lib.win-amd64-3.8\pygraphviz\tests running egg_info writing pygraphviz.egg-info\PKG-INFO writing dependency_links to pygraphviz.egg-info\dependency_links.txt writing top-level names to pygraphviz.egg-info\top_level.txt reading manifest file 'pygraphviz.egg-info\SOURCES.txt' reading manifest template 'MANIFEST.in' warning: no files found matching '.png' under directory 'doc' warning: no files found matching '.txt' under directory 'doc' warning: no files found matching '.css' under directory 'doc' warning: no previously-included files matching '~' found anywhere in distribution warning: no previously-included files matching '.pyc' found anywhere in distribution warning: no previously-included files matching '.svn' found anywhere in distribution no previously-included directories found matching 'doc\build' writing manifest file 'pygraphviz.egg-info\SOURCES.txt' copying pygraphviz\graphviz.i -> build\lib.win-amd64-3.8\pygraphviz
copying pygraphviz\graphviz_wrap.c -> build\lib.win-amd64-3.8\pygraphviz running build_ext building 'pygraphviz.graphviz' extension error: Microsoft Visual C++ 14.0 is required. Get it with "Build Tools for Visual Studio": https://visualstudio.microsoft.com/downloads/
---------------------------------------- ERROR: Failed building wheel for pygraphviz ERROR: Command errored out with exit status 1: command: 'C:\Users\stanj\anaconda3\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\Users\stanj\AppData\Local\Temp\pip-install-pw34pfvb\pygraphviz\setup.py'"'"'; file='"'"'C:\Users\stanj\AppData\Local\Temp\pip-install-pw34pfvb\pygraphviz\setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(file);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, file, '"'"'exec'"'"'))' install --record 'C:\Users\stanj\AppData\Local\Temp\pip-record-v7o_3mbj\install-record.txt' --single-version-externally-managed --compile --install-headers 'C:\Users\stanj\anaconda3\Include\pygraphviz' cwd: C:\Users\stanj\AppData\Local\Temp\pip-install-pw34pfvb\pygraphviz
Complete output (46 lines): running install running build running build_py creating build creating build\lib.win-amd64-3.8 creating build\lib.win-amd64-3.8\pygraphviz copying pygraphviz\agraph.py -> build\lib.win-amd64-3.8\pygraphviz copying pygraphviz\graphviz.py -> build\lib.win-amd64-3.8\pygraphviz copying pygraphviz\scraper.py -> build\lib.win-amd64-3.8\pygraphviz copying pygraphviz\testing.py -> build\lib.win-amd64-3.8\pygraphviz copying pygraphviz_init.py -> build\lib.win-amd64-3.8\pygraphviz creating build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_attribute_defaults.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_clear.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_close.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_drawing.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_edge_attributes.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_graph.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_html.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_layout.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_node_attributes.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_readwrite.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_scraper.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_string.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_subgraph.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests\test_unicode.py -> build\lib.win-amd64-3.8\pygraphviz\tests copying pygraphviz\tests_init_.py -> build\lib.win-amd64-3.8\pygraphviz\tests running egg_info writing pygraphviz.egg-info\PKG-INFO writing dependency_links to pygraphviz.egg-info\dependency_links.txt writing top-level names to pygraphviz.egg-info\top_level.txt reading manifest file 'pygraphviz.egg-info\SOURCES.txt' reading manifest template 'MANIFEST.in' warning: no files found matching '.png' under directory 'doc' warning: no files found matching '.txt' under directory 'doc' warning: no files found matching '.css' under directory 'doc' warning: no previously-included files matching '~' found anywhere in distribution warning: no previously-included files matching '.pyc' found anywhere in distribution warning: no previously-included files matching '.svn' found anywhere in distribution no previously-included directories found matching 'doc\build' writing manifest file 'pygraphviz.egg-info\SOURCES.txt' copying pygraphviz\graphviz.i -> build\lib.win-amd64-3.8\pygraphviz copying pygraphviz\graphviz_wrap.c -> build\lib.win-amd64-3.8\pygraphviz running build_ext building 'pygraphviz._graphviz' extension error: Microsoft Visual C++ 14.0 is required. Get it with "Build Tools for Visual Studio": https://visualstudio.microsoft.com/downloads/ ---------------------------------------- ERROR: Command errored out with exit status 1: 'C:\Users\stanj\anaconda3\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\Users\stanj\AppData\Local\Temp\pip-install-pw34pfvb\pygraphviz\setup.py'"'"'; file='"'"'C:\Users\stanj\AppData\Local\Temp\pip-install-pw34pfvb\pygraphviz\setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(file);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, file, '"'"'exec'"'"'))' install --record 'C:\Users\stanj\AppData\Local\Temp\pip-record-v7o_3mbj\install-record.txt' --single-version-externally-managed --compile --install-headers 'C:\Users\stanj\anaconda3\Include\pygraphviz' Check the logs for full command output.

...

ANSWER

Answered 2021-Feb-26 at 09:41

This should work :

pip install --upgrade --no-deps git+https://github.com/psychemedia/eralchemy.git

Source https://stackoverflow.com/questions/66381950

QUESTION

SQLAlchemy ER diagram in python 3

Asked 2020-Apr-01 at 18:59

Does anyone know a way to make an ER diagram from SQLAlchemy models in python 3. I found sqlalchemy_schemadisplay, which is python 2 because of pydot and ERAlchemy which is also python 2 only.

...

ANSWER

Answered 2017-Sep-03 at 06:34

You can try eralchemy.

Source https://stackoverflow.com/questions/44981986

QUESTION

ERAlchemy cannot connect to database

Asked 2019-Jan-28 at 15:25

I don't understand the syntax to call the render feature of ERAlchemy (https://pypi.org/project/ERAlchemy see "Usage for Python"). I am using Python 2.7, sqlite3, and PyCharm. I have ERAlchemy, GraphViz, and PyGraphViz installed.

I am trying the following, but it cannot connect to the database:

...

ANSWER

Answered 2019-Jan-28 at 04:07

Ah! Found the answer here

had to find the folder with "dot.exe" and add it to the environment variables -> system variables -> path

Source https://stackoverflow.com/questions/54395073

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install eralchemy

The simplest way to install eralchemy on OSX is by using Homebrew.
To install ERAlchemy, just do:. ERAlchemy requires GraphViz to generate the graphs and Python. Both are available for Windows, Mac and Linux.

Support

Every feedback is welcome on the GitHub issues. To run the tests, use : $ py.test. Some tests require a local postgres database with a schema named test in a database named test all owned by a user named postgres with a password of postgres. All tested PR are welcome.

Find more information at: