Linden

i want to set up a tag based metasearch system for videofiles.

How would i do that? I am little experienced with coll and text but not at all with dict!

my wish would be: let's say you search for "black_and_white": then you get an umenu populated with all videos which are taged with "black_and_white".

i could arrange folders myself and put them in via drag and drop. but the advantage would be that you can reorder your files dynamicly and do not have to copy them to different folders.

any ideas how i could achieve this? i dont know which object would suite best for this purpose.

i want to set up a tag based metasearch system for videofiles.
How would i do that? I am little experienced with coll and text but not at all with dict!
my wish would be: let's say you search for "black_and_white": then you get an umenu populated with all videos which are taged with "black_and_white".
i could arrange folders myself and put them in via drag and drop. but the advantage would be that you can reorder your files dynamicly and do not have to copy them to different folders.
any ideas how i could achieve this? i dont know which object would suite best for this purpose.
any hints are very highly welocme.

how-to-do-a-metasearch

lookin in the forum the most useful thing i found is Andrew Benson Data Base article:

https://cycling74.com/tutorials/data-collection-building-databases-using-sqlite/

I am not familiar with sql at all. so i wonder if it would be hard to adapt this patch with following modifactions:

1. populate the umenu with only the videos which have a certain tag. At the monent it shows always the complete database and it choses the videos randomly.

2. combining tags - show videos which have been tagged for example with "color" and "action"

lookin in the forum the most useful thing i found is Andrew Benson Data Base article:
https://cycling74.com/tutorials/data-collection-building-databases-using-sqlite/

This comes very close to me wishes.
I am not familiar with sql at all. so i wonder if it would be hard to adapt this patch with following modifactions:
1. populate the umenu with only the videos which have a certain tag. At the monent it shows always the complete database and it choses the videos randomly.
2. combining tags - show videos which have been tagged for example with "color" and "action"

i managed to show only the wished tags in the cellblock object and select the movie from there.

how would i delete a single entry from the database or delete duplicates?

how would i update the databse correctly?

i have a folder which may always grow. so i import an allready imported folder to the databse which has fresh entris...

the problem is that the old ones are creating duplicates...

how should i set up my patch to achieve a dynamic database which i can edit in a fluent way?

how can i format this message #exec "SELECT * FROM dumpster WHERE style = 'action'"# to

#exec "SELECT * FROM dumpster WHERE style = '$1'"#

$1 is a placeholder for anything. but this way i could work with tabs and wouldnt have to make so much different message boxes.

sorry if this may redundant or allready asked a bunch of times.

ok i made step further:
i managed to show only the wished tags in the cellblock object and select the movie from there.
how would i delete a single entry from the database or delete duplicates?
how would i update the databse correctly?
i have a folder which may always grow. so i import an allready imported folder to the databse which has fresh entris...
the problem is that the old ones are creating duplicates...
how should i set up my patch to achieve a dynamic database which i can edit in a fluent way?
and partly off topic:
how can i format this message #exec "SELECT * FROM dumpster WHERE style = 'action'"# to
#exec "SELECT * FROM dumpster WHERE style = '$1'"#
$1 is a placeholder for anything. but this way i could work with tabs and wouldnt have to make so much different message boxes.
sorry if this may redundant or allready asked a bunch of times.
thx


how to do a metasearch?