Following the ERD: How to Map Your Software

Slide 1

Slide 1 text

[TITLE PENDING] Double-click to edit @kerrizor CodeDaze 2018

Slide 2

Slide 2 text

[TITLE PENDING] Double-click to edit @kerrizor CodeDaze 2018

Slide 3

Slide 3 text

@kerrizor CodeDaze 2018

Slide 4

Slide 4 text

@kerrizor CodeDaze 2018

Slide 5

Slide 5 text

@kerrizor CodeDaze 2018

Slide 6

Slide 6 text

@kerrizor CodeDaze 2018 @kerrizor CodeDaze 2018

Slide 7

Slide 7 text

@kerrizor CodeDaze 2018

Slide 8

Slide 8 text

@kerrizor CodeDaze 2018

Slide 9

Slide 9 text

@kerrizor CodeDaze 2018 42/50 Stamps, 20/25 States

Slide 10

Slide 10 text

@kerrizor CodeDaze 2018

Slide 11

Slide 11 text

@kerrizor CodeDaze 2018

Slide 12

Slide 12 text

@kerrizor CodeDaze 2018

Slide 13

Slide 13 text

@kerrizor CodeDaze 2018

Slide 14

Slide 14 text

@kerrizor CodeDaze 2018

Slide 15

Slide 15 text

@kerrizor CodeDaze 2018 graph graphname { a -- b -- c; b -- d; }

Slide 16

Slide 16 text

@kerrizor CodeDaze 2018

Slide 17

Slide 17 text

@kerrizor CodeDaze 2018 digraph graphname { a -> b -> c; b -> d; }

Slide 18

Slide 18 text

@kerrizor CodeDaze 2018

Slide 19

Slide 19 text

digraph G { subgraph cluster_0 { style=filled; color=lightgrey; node [style=filled,color=white]; a0 -> a1 -> a2 -> a3; label = "process #1"; } subgraph cluster_1 { node [style=filled]; b0 -> b1 -> b2 -> b3; label = "process #2"; color=blue } start -> a0; start -> b0; a1 -> b3; b2 -> a3; a3 -> a0; a3 -> end; b3 -> end; start [shape=Mdiamond]; end [shape=Msquare]; } @kerrizor CodeDaze 2018

Slide 20

Slide 20 text

@kerrizor CodeDaze 2018

Slide 21

Slide 21 text

@kerrizor CodeDaze 2018

Slide 22

Slide 22 text

@kerrizor CodeDaze 2018

Slide 23

Slide 23 text

@kerrizor CodeDaze 2018

Slide 24

Slide 24 text

@kerrizor CodeDaze 2018

Slide 25

Slide 25 text

@kerrizor CodeDaze 2018 E X T R A C T I N G M O D E L R E L AT I O N S H I P S • Ask the DB/Parse the schema • Parse model deﬁnitions in the framework

Slide 26

Slide 26 text

@kerrizor CodeDaze 2018 E X T R A C T I N G M O D E L R E L AT I O N S H I P S • Ask the DB/Parse the schema • Parse model deﬁnitions in the framework

Slide 27

Slide 27 text

@kerrizor CodeDaze 2018 E X T R A C T I N G M O D E L R E L AT I O N S H I P S • Ask the DB/Parse the schema • Parse model deﬁnitions in the framework • Have the framework introspect for you

Slide 28

Slide 28 text

@kerrizor CodeDaze 2018 g = GraphViz.new(:G, type: :digraph) models = ActiveRecord::Base.descendants assoc = models.first.reflect_on_all_associations.collect{|r| r.klass.to_s.downcase}.uniq # Raise your left hand if you’re reading this # user = g.add_nodes("User") assoc.each do |a| g.add_edges(user, g.add_nodes(a)) end g.output(png: "example.png")

Slide 29

Slide 29 text

@kerrizor CodeDaze 2018

Slide 30

Slide 30 text

@kerrizor CodeDaze 2018 digraph G { graph [bb="0,0,362.83,108"]; node [label="\N"]; user [height=0.5, label=user, pos="177.66,90", width=0.75]; Article [height=0.5, label=Article, pos="34.66,18", width=0.96276]; user -> Article [pos="e,59.965,30.741 155.94,79.065 132.88,67.452 96.092,48.931 69.076,35.328"]; Favorite [height=0.5, label=Favorite, pos="126.66,18", width=1.0994]; user -> Favorite [pos="e,138.9,35.277 166.09,73.662 159.81,64.805 151.92,53.658 144.84,43.67"]; […]

Slide 31

Slide 31 text

@kerrizor CodeDaze 2018 g = GraphViz.new(:G, type: :digraph) models = ActiveRecord::Base.descendants assoc = models.first.reflect_on_all_associations.collect{|r| r.klass.to_s.downcase}.uniq user = g.add_nodes("User") assoc.each do |a| attrs = a.classify.constantize.attribute_names label = "#{a}\n#{attrs.join("\n")}" g.add_edges(user, g.add_nodes(label)) end g.output(png: "example_with_labels.png")

Slide 32

Slide 32 text

@kerrizor CodeDaze 2018

Slide 33

Slide 33 text

@kerrizor CodeDaze 2018

Slide 34

Slide 34 text

@kerrizor CodeDaze 2018 https://github.com/voormedia/rails-erd

Slide 35

Slide 35 text

@kerrizor CodeDaze 2018 $ bundle viz

Slide 36

Slide 36 text

@kerrizor CodeDaze 2018

Slide 37

Slide 37 text

@kerrizor CodeDaze 2018

Slide 38

Slide 38 text

@kerrizor CodeDaze 2018

Slide 39

Slide 39 text

@kerrizor CodeDaze 2018

Slide 40

Slide 40 text

@kerrizor CodeDaze 2018

Slide 41

Slide 41 text

@kerrizor CodeDaze 2018

Slide 42

Slide 42 text

@kerrizor CodeDaze 2018

Slide 43

Slide 43 text

@kerrizor CodeDaze 2018

Slide 44

Slide 44 text

@kerrizor CodeDaze 2018

Slide 45

Slide 45 text

@kerrizor CodeDaze 2018

Slide 46

Slide 46 text

@kerrizor CodeDaze 2018 “ ” THE MAP IS NOT THE TERRITORY… THE WORD IS NOT THE THING… - ALFRED KORZYBSKI M A P - T E R R I T O RY R E L AT I O N

Slide 47

Slide 47 text

@kerrizor CodeDaze 2018

Slide 48

Slide 48 text

@kerrizor CodeDaze 2018

Slide 49

Slide 49 text

@kerrizor CodeDaze 2018

Slide 50

Slide 50 text

@kerrizor CodeDaze 2018

Slide 51

Slide 51 text

@kerrizor CodeDaze 2018

Slide 52

Slide 52 text

@kerrizor CodeDaze 2018 A N D I F Y O U A C T N O W… • Visual documentation for GraphQL • Shortcut for loading context • “Living Documentation”

Slide 53

Slide 53 text

@kerrizor CodeDaze 2018 “ ” WHEN YOU CHANGE THE WAY YOU LOOK AT THINGS, THE THINGS YOU LOOK AT CHANGE. - DR WAYNE W DYER M A P - T E R R I T O RY R E L AT I O N