anlek / mongify

Mongify allows you to map your data from a sql database and into a mongodb document database.
http://github.com/anlek/mongify
MIT License
317 stars 82 forks source link

Doesn't mongify support unique string for embed_in? #114

Closed sungjunyoung closed 7 years ago

sungjunyoung commented 7 years ago

Doesn't mongify support unique string for embed_in?

I'm trying to migrate my company's mysql database to mongoDB. So I founded this wonderful library..

but, Differently from the examples, My data not embed in..

this is my simple test ruby code, included in my company's database

table "story_base" do
    column "idx", :key
    column "story_code", :string
    column "thread", :integer
    column "memb_code", :string
    column "memb_name", :string
    column "memb_nick", :string
    column "story_category_code", :string
    column "story_category_name", :string
    column "story_score", :integer
    column "story_title", :string
    column "story_content", :text
    column "story_img_cnt", :integer
    column "comment_cnt", :integer
    column "story_list_cnt", :integer
    column "story_view_cnt", :integer
    column "story_sympathy_cnt", :integer
    column "fat_code", :string
    column "fat_name", :string
    column "story_status", :string
    column "report_code", :string
    column "regtime", :integer
    column "kor_regtime", :date
    column "chgtime", :integer
    column "kor_chgtime", :date
    column "modifytime", :integer
    column "kor_modifytime", :date
    column "story_etc_1", :string
    column "story_etc_2", :string
    column "story_etc_3", :string
    column "story_etc_4", :string
    column "story_etc_5", :string
end

table "story_comment", :embed_in => 'story_base', :on => 'story_code' do
    column "idx", :key
    column "story_code", :string
    column "thread", :integer
    column "writer_code", :string
    column "writer_name", :string
    column "writer_nick", :string
    column "comment_text", :text
    column "delete_chk", :string
    column "regtime", :integer
    column "kor_regtime", :date
    column "modifytime", :integer
    column "kor_modifytime", :date
    column "comm_etc_1", :string
    column "comm_etc_2", :string
    column "comm_etc_3", :string
end

story_code in table story_base is unique primary,

I got a successful message from console terminal, but I cannot get result of mongodb collection from this code.. (exactly just story_base collection not embed story_comment)

By any chance, Doesn't mongify support unique string for embed_in?

sungjunyoung commented 7 years ago

I found solution .. I apologize for the lack of knowledge

anlek commented 7 years ago

Awesome! Glad to hear! :)