photo-stats

commit 75928a150ea967ca7c2cea776e4a519e09da1c9e
parent 9f54e3c4809f1859df929b930f1889552eb3ec13
Author: René Wagner <rwagner@rw-net.de>
Date:   Wed, 29 Jul 2020 17:21:56 +0200

rename field and add a view

Diffstat:
M
phosta.pl
 | 
3
++-
M
photo_stats.db
 | 
0

2 files changed, 2 insertions(+), 1 deletion(-)
diff --git a/phosta.pl b/phosta.pl
@@ -65,8 +65,9 @@ sub get_stats
         if ($model eq '-') { $emptycount++; next; }
         $lens = ($lens ne '-') ? $lens : $lensmodel;
         $exposuretime = (looks_like_number($exposuretime) && $exposuretime < 1) ? "1/". POSIX::lround(1/$exposuretime) : $exposuretime;
+        if ($datetimeoriginal eq '0000:00:00 00:00:00') { $datetimeoriginal = '-'; }
 
-        my $stmt = "INSERT INTO photos (file, maker, model, lens, focallength, focallength35mm, aperture, shutterspeed, iso, flash, datetimeoriginal)
+        my $stmt = "INSERT INTO photos (file, maker, model, lens, focallength, focallength35mm, aperture, exposuretime, iso, flash, datetimeoriginal)
                VALUES ('$file', '$maker', '$model', '$lens', '$fl', '$fl35', '$apert', '$exposuretime', '$iso', '$flash', '$datetimeoriginal')";
         my $rv = $dbh->do($stmt) or $errorcount++; 
     }
diff --git a/photo_stats.db b/photo_stats.db
Binary files differ.