Re: Program to dole out jpg's to subdirctories, card-dealing style.

In comp.os.linux.misc,
Fritz Wuehler  <fritz@spamexpire-202506.rodent.frell.theremailer.net> wrote:

Eli the Bearded <*@eli.users.panix.com> [EtB]:
EtB> What I would really like is compound searching.
Does your program add its photo tags/dates to a database (e.g. sqlite)?
Can you query its database with other (generic) tools?

My program uses mysql. But (a) I'm not great at writing sql and (b) one
of the largest pain points is loading data into it.

With great work I came up with a tool that builds queries, but not
all the ones I might want. Nor am I impressed with the speed I get.

Example:

$ find-image --debug --tag dog --tag monterey --after 2004:10 --before 2004:12

     SELECT a.* FROM `ark_images` a
           INNER JOIN `ark_images_tags` i ON i.`image_id` = a.`image_id`
           INNER JOIN `ark_tags` t        ON t.`tag_id`   = i.`tag_id`
         WHERE t.`tag_clean` = ?
         AND a.`image_id` IN (
           SELECT DISTINCT a.`image_id` FROM `ark_images` a
           INNER JOIN `ark_images_tags` i ON i.`image_id` = a.`image_id`
           INNER JOIN `ark_tags` t        ON t.`tag_id`   = i.`tag_id`
         WHERE t.`tag_clean` = ?
         )
         AND a.`image_date` > ?
         AND a.`image_date` < ?
   LIMIT 50;
Binding params: dog, monterey, 2004:10, 2004:12

$ find-image --help
find-image general options:
  --newer  / -N         sort newer first
  --older  / -O         sort older first
  --random / -R         random order results
  --limit  / -L         smaller sample size

Searching optins:
  --anywhere    TEXT / -A TEXT         description or title or tag
                                          or filename like %TEXT%
  --tag         TEXT / -t TEXT         and clean tag TEXT
  --ortag       TEXT / -o TEXT         or clean tag TEXT
  --taglike     TEXT / -l TEXT         and clean tag like %TEXT%
  --nottag      TEXT / -n TEXT         does not have tag TEXT
  --title       TEXT / -T TEXT         and with TEXT in title
  --description TEXT / -d TEXT         and with TEXT in description
  --filename    TEXT / -f TEXT         and with TEXT in filename
  --after       DATETIME / -a DATETIME after  'YYYY:MM:DD HH:MM:SS'
  --before      DATETIME / -b DATETIME before 'YYYY:MM:DD HH:MM:SS'

DATETIME can be shortened to YYYY, or YYYY:MM, etc
$

I've mapped camera name and location (using long-lat to name database)
to special "tags", but it's not as useful as I hoped, at least for
location: eg:

Title: IMG_3916
image_id: 30347   image_path: /flickr/95/06/3516049506.jpg
image_name: 3516049506   image_date: 2009-03-29 13:47:24

Tags: _county_ San Mateo; _locality_ Pescadero; _country_ United States;
_device_ Canon PowerShot SD870 IS; family; IMG_3916; dog; bo; beach;
bean hollow; 3916; _state_ California; california

"Pescadero" is a fine as that goes, but "bean hollow" beach is a much
smaller area.

There's a (password protected) web ui, too, but it needs even more polish.

Elijah
------
stopped working on it sometime in 2023