Embed_in doesn't work

[jcheng418]

Hi,

In this test, I'm trying embed lu_project and lu_owner into lu_object table with following translation.rb but it never succeeded. The process run fine without any error msg and I just couldn't get the embedded structure. Can you please advise what could be wrong in the translation.rb file.

Regards!

table "lu_object" do
column "object_id", :integer
column "object_guid", :string
column "object_name", :string
column "object_desc", :string
column "object_location", :string
column "creation_date", :date
column "modification_date", :date
column "creation_timestamp", :datetime
column "modification_timestamp", :datetime
column "project_id", :integer
column "owner_id", :integer
column "object_status_id", :integer
column "object_type_id", :integer
column "object_category_id", :integer
end

table "lu_project" ,:embed_in => :"lu_object", :on => :project_id do
column "project_id", :integer
column "project_guid", :string
column "project_name", :string
column "project_desc", :string
column "creation_timestamp", :datetime
column "modification_timestamp", :datetime
column "project_status", :string
column "metadata_id", :integer
end

table "lu_owner" ,:embed_in => :"lu_object", :on => :owner_id do
column "owner_id", :integer
column "owner_guid", :string
column "owner_name", :string
column "owner_login", :string
column "creation_timestamp", :datetime
column "modification_timestamp", :datetime
column "owner_status", :string
end

[anlek]

Hello @jcheng418, your key columns must be setup for Mongify to know which columns are primary keys. Please see the docs in regards to column types