Skip to content

Instantly share code, notes, and snippets.

@Alexis-benoist
Alexis-benoist / readme.rst
Created February 24, 2018 11:16
readme eralchemy

Entity relation diagrams generator

ERAlchemy generates Entity Relation (ER) diagram (like the one below) from databases or from SQLAlchemy models.

Example

body request: {"name":"Deploy","start_unix":1516359007,"end_unix":1516359187,"timezone":"utc"}
body response: {"success":false,"message":"The provided parameters are invalid. Check the errors output for detailed information.","errors":{"name":["Name is required"],"start_unix":["Start Unix is required","Start Unix must be numeric"],"end_unix":["End Unix is required","End Unix must be numeric"],"timezone":["Timezone is required"]},"data":[]}%
package main
import (
"fmt"
"sync"
)
type Fetcher interface {
// Fetch returns the body of URL and
// a slice of URLs found on that page.
@Alexis-benoist
Alexis-benoist / df_2.csv
Created July 29, 2015 12:46
DataFrame 2 to concat
index seismic seismoacoustic shift genergy gpuls gdenergy gdpuls ghazard nbumps nbumps2 nbumps3 nbumps4 nbumps5 nbumps6 nbumps7 nbumps89 energy maxenergy class (u'internal', u'__delete__') (u'seismic', u'a')
0 50 a b N 66510 215 93 50 b 1 1 0 0 0 0 0 0 300 300 0 False True
1 51 a b W 248900 739 -9 0 b 1 1 0 0 0 0 0 0 400 400 0 False True
2 52 a b N 51620 186 51 34 a 1 0 1 0 0 0 0 0 7000 7000 0 False True
3 53 a b N 45150 140 24 -4 a 0 0 0 0 0 0 0 0 0 0 0 False True
4 54 a b N 60460 191 56 29 a 0 0 0 0 0 0 0 0 0 0 0 False True
5 55 a a N 18330 91 -57 -43 a 1 0 1 0 0 0 0 0 4000 4000 0 False True
6 56 a a N 50580 134 15 -18 a 0 0 0 0 0 0 0 0 0 0 0 False True
7 57 a a W 269070 767 -1 4 a 2 2 0 0 0 0 0 0 800 400 0 False True
8 58 a a N 37360 171 -21 0 a 1 0 1 0 0 0 0 0 4000 4000 0 False True
@Alexis-benoist
Alexis-benoist / df_1.csv
Created July 29, 2015 12:46
DataFrame to concat
index seismic seismoacoustic shift genergy gpuls gdenergy gdpuls ghazard nbumps nbumps2 nbumps3 nbumps4 nbumps5 nbumps6 nbumps7 nbumps89 energy maxenergy class (u'seismic', u'a') (u'internal', u'__delete__')
0 0 a a N 15180 48 -72 -72 a 0 0 0 0 0 0 0 0 0 0 0 True False
1 1 a a N 14720 33 -70 -79 a 1 0 1 0 0 0 0 0 2000 2000 0 True False
2 2 a a N 8050 30 -81 -78 a 0 0 0 0 0 0 0 0 0 0 0 True False
3 3 a a N 28820 171 -23 40 a 1 0 1 0 0 0 0 0 3000 3000 0 True False
4 4 a a N 12640 57 -63 -52 a 0 0 0 0 0 0 0 0 0 0 0 True False
5 5 a a W 63760 195 -73 -65 a 0 0 0 0 0 0 0 0 0 0 0 True False
6 6 a a W 207930 614 -6 18 a 2 2 0 0 0 0 0 0 1000 700 0 True False
7 7 a a N 48990 194 -27 -3 a 1 0 1 0 0 0 0 0 4000 4000 0 True False
8 8 a a N 100190 303 54 52 a 0 0 0 0 0 0 0 0 0 0 0 True False
This file has been truncated, but you can view the full file.
(lp0
ccopy_reg
_reconstructor
p1
(cpandas.core.frame
DataFrame
p2
c__builtin__
object
p3
@Alexis-benoist
Alexis-benoist / log
Created May 22, 2015 10:08
Error when trying to install eralchemy
/Users/username/api_venv/bin/pip run on Fri May 22 12:05:29 2015
Downloading/unpacking eralchemy
Getting page https://pypi.python.org/simple/eralchemy/
URLs to search for versions for eralchemy:
* https://pypi.python.org/simple/eralchemy/
Analyzing links from page https://pypi.python.org/simple/eralchemy/
Skipping link https://pypi.python.org/packages/py2.py3/E/ERAlchemy/ERAlchemy-0.0.10-py2.py3-none-any.whl#md5=d4db1f4c52404b4a60f06b9d0288b4de (from https://pypi.python.org/simple/eralchemy/); unknown archive format: .whl
Skipping link https://pypi.python.org/packages/py2.py3/E/ERAlchemy/ERAlchemy-0.0.11-py2.py3-none-any.whl#md5=e96cc6f2c7cedb9d2f5fe203cf30a8e4 (from https://pypi.python.org/simple/eralchemy/); unknown archive format: .whl
Skipping link https://pypi.python.org/packages/py2.py3/E/ERAlchemy/ERAlchemy-0.0.12-py2.py3-none-any.whl#md5=4bbb38aab05a5b1f73b173ebfe3db7f4 (from https://pypi.python.org/simple/eralchemy/); unknown archive format: .whl