Changeset 19163 for lang/ruby

Timestamp:

09/11/08 11:10:49 (5 years ago)

Author:

authorNari

Message:

impl polymorphic pattern. add spec test.

Location:

lang/ruby/ymldot

Files:

• README (modified) (3 diffs)
• lib/ymldot.rb (modified) (3 diffs)
• sample/sample.dot (modified) (1 diff)
• sample/sample.png (modified) (previous)
• sample/sample.yml (modified) (4 diffs)
• sample/sample_jp.png (modified) (previous)
• sample/sample_jp.yml (modified) (4 diffs)
• spec/test_polymorphic.yml (added)
• spec/ymldot_spec.rb (modified) (1 diff)

lang/ruby/ymldot/README

@@ -9 +9 @@
 == Installation
 (1) if not install graphviz, type following.
-  $ apt-get install graphviz
+    $ apt-get install graphviz
 (2) get ymldot.
-  $ gem install ymldot
+    $ gem install ymldot
 
 == Option
@@ -32 +32 @@
       same meaning the relation of ActiveRecord.
       enumerate ref table name.
+    * polymorphic
+      * name
+      * type
+      * tables
+        target table name.
+
 * category
    * label
@@ -39 +45 @@
 
 == Sample
-please see "sample/sample.yml"
+* in file. "sample/sample.yml"
+
+  tables:
+    - name: customer
+      columns:
+        - name
+        - phone_number
+      foreignkeys:
+        has_many:
+           - order
+    - name:  order
+      columns:
+        - order_num
+    - name:  product
+      columns:
+        - name
+        - amount
+        - tax
+        - product_div
+      foreignkeys:
+        has_many:
+           - order
+    - name:  category
+      columns:
+        - name
+      foreignkeys:
+        has_many:
+           - product
+
+* output dot file. "sample/sample.dot"
+
+  digraph sample {
+    graph[overlap=false, splines=true]
+  
+    "category" [shape=record, label="{category|name\l}"]
+    "customer" [shape=record, label="{customer|name\lphone_number\l}"]
+    "order" [shape=record, label="{order|customerID(FK)\lproductID(FK)\lorder_num\l}"]
+    "product" [shape=record, label="{product|categoryID(FK)\lname\lamount\ltax\lproduct_div\l}"]
+  
+    "category" -> "product" [arrowtail=none arrowhead=dot headlabel="n" taillabel="1"]
+    "customer" -> "order" [arrowtail=none arrowhead=dot headlabel="n" taillabel="1"]
+    "product" -> "order" [arrowtail=none arrowhead=dot headlabel="n" taillabel="1"]
+  
+  }
+
+* please type
+  $ dot -Tpng sample.dot -o sample.png
 
 == Copyright

lang/ruby/ymldot/lib/ymldot.rb

@@ -127 +127 @@
     @config = @node["config"]? @node["config"] : {}
     @category << Tables.new(@node["tables"]) if @node["tables"] and !@node["tables"].empty?
-    @node["category"].each{|c| @category << Tables.new(c["tables"], c["label"], true)} if @node["category"]
+    @node["category"].each{|c| @category << Tables.new(c["tables"], c["label"], true) } if @node["category"]
     @category.each{|c| c.entity_dict.each_pair{|k, v| @entity_dict[k] = v}}
     @category.each{|c| c.table_node.each{|e| eval_relation(e) } }
@@ -139 +139 @@
     eval_relation_has_one(foreignkeys["has_one"], tname) if foreignkeys["has_one"]
     eval_relation_hmabt(foreignkeys["has_many_and_belongs_to"], tname) if foreignkeys["has_many_and_belongs_to"]
+    eval_relation_polymorphic(foreignkeys["polymorphic"], tname) if foreignkeys["polymorphic"]
   end
 
@@ -174 +175 @@
     end
   end
+
+  def eval_relation_polymorphic(keys, tname)
+    keys.each do |rel|
+      @entity_dict[tname].foreignkeys << "#{rel["name"]}ID(FK)" if key = rel["name"]
+      @entity_dict[tname].columns << "#{rel["type"]}(type)" if key = rel["type"]
+      rel["tables"].each do |t|
+        @one_relations << {:self => @entity_dict[t], :have => @entity_dict[tname] }
+      end
+    end
+  end
 end

lang/ruby/ymldot/sample/sample.dot

@@ -3 +3 @@
 
   "category" [shape=record, label="{category|name\l}"]
-  "customer" [shape=Mrecord, label="{customer|name\lphone_number\l}"]
+  "customer" [shape=record, label="{customer|name\lphone_number\l}"]
   "order" [shape=record, label="{order|customerID(FK)\lproductID(FK)\lorder_num\l}"]
   "product" [shape=record, label="{product|categoryID(FK)\lname\lamount\ltax\lproduct_div\l}"]

lang/ruby/ymldot/sample/sample.yml

@@ -1 @@
-#
 # reference http://codezine.jp/article/detail/154?p=1
 tables:
@@ -9 +8 @@
       has_many:
         - order
-    dependent: true
 
   - name:  order
     columns:
       - order_num
-    foreignkeys:
-      belongs_to:
-         - customer
-         - product
-    dependent: false
 
   - name:  product
@@ -27 +20 @@
       - product_div
     foreignkeys:
-      belongs_to:
-         - category
       has_many:
          - order
-    dependent: false
 
   - name:  category
@@ -39 +29 @@
       has_many:
          - product
-    dependent: false

lang/ruby/ymldot/sample/sample_jp.yml

@@ -1 @@
-#
 # reference http://codezine.jp/article/detail/154?p=1
 config:
@@ -12 +11 @@
       has_many:
         - 注文
-    dependent: false
 
   - name:  注文
     columns:
       - 注文数
-    foreignkeys:
-      belongs_to:
-         - 顧客
-         - 商品
-    dependent: false
 
   - name:  商品
@@ -30 +23 @@
       - 商品区分
     foreignkeys:
-      belongs_to:
-         - 商品カテゴリ
       has_many:
          - 注文
-    dependent: false
 
   - name:  商品カテゴリ
@@ -42 +32 @@
       has_many:
          - 商品
-    dependent: false
 

lang/ruby/ymldot/spec/ymldot_spec.rb

@@ -227 +227 @@
   end
 end
+
+describe Ymldot, "で読み込んだ.ymlにてpolymorphicを使用した場合" do
+  before do
+    @ymldot = Ymldot.new("test_polymorphic.yml")
+  end
+
+  it "#entity_dict のリレーションが正しいこと" do
+  
+  end
+
+  it "#entity_dict['foo'] のforeginkeyは'entiityID(FK)'であること" do
+    @ymldot.entity_dict['foo'].foreignkeys.should be_include 'entityID(FK)'
+  end
+
+  it "#entity_dict['foo'] のcolumnsには'entity_tyep(type)'があること" do
+    @ymldot.entity_dict['foo'].columns.should be_include 'entity_type(type)'
+  end
+
+  it "出力されるdotが正しいこと" do
+    @ymldot.dot_generate.should == <<'EOS'
+digraph test_polymorphic {
+  graph[overlap=false, splines=true]
+
+  "baf" [shape=record, label="{baf|buge\l}"]
+  "bar" [shape=record, label="{bar|fuge\l}"]
+  "baz" [shape=record, label="{baz|gage\l}"]
+  "foo" [shape=record, label="{foo|entityID(FK)\lhoge\lentity_type(type)\l}"]
+
+  "baf" -> "foo" [arrowtail=none arrowhead=dot headlabel="1" taillabel="1"]
+  "bar" -> "foo" [arrowtail=none arrowhead=dot headlabel="1" taillabel="1"]
+  "baz" -> "foo" [arrowtail=none arrowhead=dot headlabel="1" taillabel="1"]
+
+}
+EOS
+  end
+end