thr3ads.net - Rails - dbmodel errors [Oct 2005]

If this information is useful, please help other people find it:
Share via:

Ron DiFrango

2005-Oct-17 14:35 UTC

dbmodel errors

All,
 
I figured out how to run dbmodel, but when I did, I got the error below.  Any
thoughts?
 
Ron
 
Reading the datamodel XML (tim_model.xml) from DBDesigner...
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'
error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
'has_and_belongs_to_many :x'

_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
http://lists.rubyonrails.org/mailman/listinfo/rails

Rodrigo Alvarez Fernández

2005-Oct-17 16:12 UTC

head link

Re: dbmodel errors

On 10/17/05, Ron DiFrango
<rdifrango-wfttzDtloRfhmZgEOWDAxUEOCMrvLtNR@public.gmane.org>
wrote:> All,
>
> I figured out how to run dbmodel, but when I did, I got the error below. 
Any thoughts?
>
> Ron
>
> Reading the datamodel XML (tim_model.xml) from DBDesigner...
> error: relationships must be labeled ''has_one :x'',
''has_many :x'', ''habtm :x'' or
> ''has_and_belongs_to_many :x''[snip]

Your error is clearly saying that you must give names to your
relations. This is explained in the dbmodel documentation.

Bill Katz

2005-Oct-17 16:27 UTC

head link

Re: dbmodel errors

dbmodel is a dumb proof-of-concept generator, and it''s telling you it
can''t
parse the relations between your tables. If you open up the XML file
generated by DBDesigner, you''ll see some RelationName attributes.
It''s
expecting those to be one of "has_one :x", "has_many :x",
"habtm :x" (or
"has_and_belongs_to_many :x") where ":x" is the associated
table.

For example, if there are tables for users, articles, and users_articles
(the join table), in DBDesigner you''d create a relation between users
and
users_articles named "habtm :articles" and another relation between
articles
and users_articles named "habtm :users". It''s simplistic, but
you are more
than welcome to hack the ruby code in dbmodel.rb. No "belongs_to"
should be
used since "has_one" or "has_many" will unambiguously
establish the other
end of the relationship.

FWIW, I haven''t improved dbmodel beyond 0.1 because (1) MySQL
Workbench, the
much awaited follow-up to DBDesigner, is in alpha and is radically different
under the hood, and (2) a better design system should incorporate
migrations. Ideally, you''d open up MySQL Workbench, modify your
database,
push a button, and auto-generate a migration.

Regards, Bill

On 10/17/05, Ron DiFrango
<rdifrango-wfttzDtloRfhmZgEOWDAxUEOCMrvLtNR@public.gmane.org>
wrote:>
> All,
>
> I figured out how to run dbmodel, but when I did, I got the error below.
> Any thoughts?
>
> Ron
>
> Reading the datamodel XML (tim_model.xml) from DBDesigner...
> error: relationships must be labeled ''has_one :x'',
''has_many :x'', ''habtm
> :x'' or
> ''has_and_belongs_to_many :x''
> [... very long redundant error log]
>

_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
http://lists.rubyonrails.org/mailman/listinfo/rails

Ron DiFrango

2005-Oct-18 19:07 UTC

head link

RE: dbmodel errors

Bill,
 
Thanks for the hint.  Since I am reverse engineering an existing DB, the
relationship names were the names of hte FK's in the DB.  Given what you say
below, I have to changes those before running DBDesigner?  Or is there a way to
export from it in a RoR compliant manner?
 
Ron

	-----Original Message----- 
	From: Bill Katz [mailto:billkatz@gmail.com] 
	Sent: Mon 10/17/2005 12:27 PM 
	To: rails@lists.rubyonrails.org 
	Cc: 
	Subject: Re: [Rails] dbmodel errors
	
	
	dbmodel is a dumb proof-of-concept generator, and it's telling you it
can't parse the relations between your tables. If you open up the XML file
generated by DBDesigner, you'll see some RelationName attributes. It's
expecting those to be one of "has_one :x", "has_many :x",
"habtm :x" (or "has_and_belongs_to_many :x") where
":x" is the associated table.
	
	For example, if there are tables for users, articles, and users_articles (the
join table), in DBDesigner you'd create a relation between users and
users_articles named "habtm :articles" and another relation between
articles and users_articles named "habtm :users". It's simplistic,
but you are more than welcome to hack the ruby code in dbmodel.rb. No
"belongs_to" should be used since "has_one" or
"has_many" will unambiguously establish the other end of the
relationship.
	
	FWIW, I haven't improved dbmodel beyond 0.1 because (1) MySQL Workbench,
the much awaited follow-up to DBDesigner, is in alpha and is radically different
under the hood, and (2) a better design system should incorporate migrations.
Ideally, you'd open up MySQL Workbench, modify your database, push a button,
and auto-generate a migration.
	
	Regards, Bill
	
	
	On 10/17/05, Ron DiFrango <rdifrango@captechventures.com> wrote: 

		All,
		
		I figured out how to run dbmodel, but when I did, I got the error below.  Any
thoughts?
		
		Ron
		
		Reading the datamodel XML (tim_model.xml) from DBDesigner...
		error: relationships must be labeled 'has_one :x', 'has_many
:x', 'habtm :x' or
		'has_and_belongs_to_many :x'
		[... very long redundant error log]
		



_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
http://lists.rubyonrails.org/mailman/listinfo/rails

Rails - Oct 2005 - dbmodel errors

dbmodel errors

Re: dbmodel errors

Re: dbmodel errors

RE: dbmodel errors