You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@subversion.apache.org by "H.M. Aamir Yaseen" <aa...@gmail.com> on 2006/06/28 06:51:19 UTC
Re: Search properties
Hi,
I do have same requirement / problem, if someone may guide us in this
regard, this would be a great help.
Kind Regards
Aamir Yaseen
Re: Search properties
Posted by Ryan Schmidt <su...@ryandesign.com>.
On Jun 30, 2006, at 20:42, H.M. Aamir Yaseen wrote:
> From your last email I have understood the concept of using post-
> revprop-change hook and post-commit hooks to store and retrive
> required information (Metadata information) from RDBMS.
> In my last email I used SQL type syntax just to explain my
> requirments/problem. I was not asking for any feature related to
> RDBMS in SVN, My Question was like this:
>
> Can we search for files/folders in svn against a given property
> (metadata property) using any svn subcommand like svn propget & svn
> proplist or any other?
> In other words:
> Does svn provide any command to list down all files/folders which
> have been associated with the given property ?
>
> I am sorry for reiterating my question and I Hope this time i have
> made my question clear, and waiting for your quick response.
To the best of my knowledge:
No.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Re: Search properties
Posted by "H.M. Aamir Yaseen" <aa...@gmail.com>.
Dear Schmidt,
Re: Search properties
Posted by Ryan Schmidt <su...@ryandesign.com>.
On Jun 28, 2006, at 11:59, H.M. Aamir Yaseen wrote:
>>> I do have same requirement / problem, if someone may guide us in
>>> this regard, this would be a great help.
>>
>> There is currently no way to search properties in Subversion. If you
>> want to be able to search properties, you can write a post-commit
>> hook (and, if you're interested in revision properties, a post-
>> revprop-change hook) which stores the properties in a relational
>> database of your choice (for example MySQL) which you can then search
>> using any tools that work with that database.
>
> Can we search for files/folders in svn against a given property
> (metadata property) ??
I do not believe you can currently do that, no.
> i can rewrite my quetion can we search in svn (as we do in RDBMS)
> like following:
>
> SELECT FILENAME, FOLDERNAME
> FROM PROJECT/PATH/IN/REPOSITORY/PATH
> WHERE ATTRIBUTENAME = "ANY_GIVEN_VALUE";
No, Subversion is not a relational database management system, nor
can it make use of one.
> if we can not do that, can you guide me what can be the alternate,
> as i could not understand your point in last email.
What I meant to suggest is that you can write a script which would
update an RDBMS (any RDBMS of your choosing) with this data, after
every commit. You would write a post-commit hook. Hooks are described
in the book at http://svnbook.org . The post-commit hook runs after
every commit. In the script, you would get the list of properties for
all files that had just been committed, and write that into the
RDBMS. Then you could execute queries against the RDBMS as you wish.
That would take care of versioned properties (properties applied to
files). If you also want to keep track of unversioned properties
(properties applied to revisions) then you might also want a post-
revprop-change hook.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Re: Search properties
Posted by "H.M. Aamir Yaseen" <aa...@gmail.com>.
Hi Ryan,
Thanks for the reply.
Can we search for files/folders in svn against a given property (metadata
property) ??
i can rewrite my quetion can we search in svn (as we do in RDBMS) like
following:
SELECT FILENAME, FOLDERNAME
FROM PROJECT/PATH/IN/REPOSITORY/PATH
WHERE ATTRIBUTENAME = "ANY_GIVEN_VALUE";
if we can not do that, can you guide me what can be the alternate, as i
could not understand your point in last email.
Kind Regards ~~~~
H.M. Aamir Yaseen
On 6/28/06, Ryan Schmidt <su...@ryandesign.com> wrote:
>
> On Jun 28, 2006, at 08:51, H.M. Aamir Yaseen wrote:
>
> > I do have same requirement / problem, if someone may guide us in
> > this regard, this would be a great help.
>
> There is currently no way to search properties in Subversion. If you
> want to be able to search properties, you can write a post-commit
> hook (and, if you're interested in revision properties, a post-
> revprop-change hook) which stores the properties in a relational
> database of your choice (for example MySQL) which you can then search
> using any tools that work with that database.
>
>
>
Re: Search properties
Posted by Ryan Schmidt <su...@ryandesign.com>.
On Jun 28, 2006, at 08:51, H.M. Aamir Yaseen wrote:
> I do have same requirement / problem, if someone may guide us in
> this regard, this would be a great help.
There is currently no way to search properties in Subversion. If you
want to be able to search properties, you can write a post-commit
hook (and, if you're interested in revision properties, a post-
revprop-change hook) which stores the properties in a relational
database of your choice (for example MySQL) which you can then search
using any tools that work with that database.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org