Displaying 5 results from an estimated 5 matches for "bookmark_id".
Did you mean:
bookmark_add
2006 Jun 22
2
id column for join table... kosher?
...ot;know"
about join tables implicitly from the associations, but if I do a
rake migrate the join tables won''t be built. I''ve been creating them
using SQL/by hand.
2. Is there anything wrong with having an ''id'' column on my join
table? Rails expects:
bookmark_id & tag_id
...but what if I want to reference individual joins? Can I do:
bookmark_id & tag_id & id
Does this mess anything up? The Agile book says don''t do it, articles
on the web say it''s OK. Who to believe?
Thanks for any/all advice!
-Jason
2006 Jan 23
2
del.icio.us-like output
...b0851ae24a1994f105&jump=no>
There are several things going on there that make it
hard/impossible/inefficient to do it one query. I''m soliciting tips on how
to do this most efficiently.
For me, the data is in 4 tables.
Bookmarks (id, bookmark)
Tags (id, tag)
Tags_Bookmarks (tag_id, bookmark_id, user_id)
Users (id, username)
I have a query that can get me most of the info I need, but not necessarily
in the format I need it in.
sql = "SELECT jt.tag_id, b.id bid, t.tag, b.bookmark, jt.created_on
FROM tags_bookmarks jt
LEFT JOIN tags t ON jt.tag_id = t.id...
2006 Jun 14
0
testing table associations
...quot;matchups". The first three tables are
simple, normalized lookup tables. Each row has an item and a unique
id, that''s it, like this:
bookmarks:"23 => www.cnn.com"
users:"7 => scott"
tags:"44 => news"
The matchups table has 4 columns, id, bookmark_id, user_id, & tag_id.
Example record from matchups:
id:1 bookmark_id:23 user_id:7 tag_id:44
The purpose of the matchups table is to find out things like who owns
which bookmarks and tags, and which tags have what bookmarks, and
other similar queries. What I''d like to do is get a...
2005 Sep 13
5
acts_as_taggable 1.0.4 now gemified!
Hi Folks,
The acts_as_taggable mixin is now available as a shiny gem.
More details here:
http://dema.ruby.com.br/articles/2005/09/13/acts-as-taggable-gemified
This release features some cool additions as well.
Cheers
Dema
--
http://dema.ruby.com.br - Rails from a .NET perspective
2006 Jan 15
1
Attributes of a relationship
Hi all,
I have two types of models which I''m not sure how to model (or if it''s even
feasible) with ActiveRecord. Let me know if you''ve got any good ideas.
1) For those of you who are familliar with del.icio.us, you probably know
that you can bookmark a site, and add your own tags to it. Each person has
their own tags for a site, even though multiple people can