Database Statistics

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Database Statistics

Bugzilla from andi.clemens@gmx.net
Hi,

I guess these statistics are wrong, because they display all entries, even the
not-active ones.
For me it displays 580 GIFs for example, but they were removed months ago.
Also 58 AVIs are listed, although they are gone, too.

I would consider to only display the active ones (status==1 if I'm not wrong).

Andi


SVN commit 973908 by cgilles:

New Database statistic dialog to show count of items by type mime.
screenshot : http://farm4.static.flickr.com/3615/3572850378_535a270800_o.png
BUG: 191634


 M  +1 -0      CMakeLists.txt  
 M  +7 -0      digikam/componentsinfo.h  
 M  +12 -0     digikam/digikamapp.cpp  
 M  +1 -0      digikam/digikamapp.h  
 M  +2 -0      digikam/digikamapp_p.h  
 M  +2 -1      digikam/digikamui.rc  
 AM            libs/database/dbstatdlg.cpp   [License: GPL (v2+)]
 AM            libs/database/dbstatdlg.h   [License: GPL (v2+)]


--- trunk/extragear/graphics/digikam/CMakeLists.txt #973907:973908
@@ -762,6 +762,7 @@
         ${CMAKE_CURRENT_SOURCE_DIR}/libs/database/namefilter.cpp
         ${CMAKE_CURRENT_SOURCE_DIR}/libs/database/schemaupdater.cpp
         ${CMAKE_CURRENT_SOURCE_DIR}/libs/database/upgradedb_sqlite2tosqlite3.cpp
+        ${CMAKE_CURRENT_SOURCE_DIR}/libs/database/dbstatdlg.cpp
        )
 
     SET(libsqlite2_SRCS
--- trunk/extragear/graphics/digikam/digikam/componentsinfo.h #973907:973908
@@ -42,6 +42,7 @@
 
 #include "config-digikam.h"
 #include "libsinfodlg.h"
+#include "dbstatdlg.h"
 
 #ifdef ENABLE_GPHOTO2
 
@@ -73,6 +74,12 @@
     dlg->show();
 }
 
+static inline void showDigikamDatabaseStat()
+{
+    DBStatDlg *dlg = new DBStatDlg(kapp->activeWindow());
+    dlg->show();
+}
+
 }  // namespace Digikam
 
 #endif // COMPONENTS_INFO_H
--- trunk/extragear/graphics/digikam/digikam/digikamapp.cpp #973907:973908
@@ -1038,6 +1038,13 @@
 
     // -----------------------------------------------------------
 
+    d->dbStatAction = new KAction(KIcon("application-vnd.oasis.opendocument.database"),
+                                  i18n("Database Statistic"), this);
+    connect(d->dbStatAction, SIGNAL(triggered()), this, SLOT(slotDBStat()));
+    actionCollection()->addAction("help_dbstat", d->dbStatAction);
+
+    // -----------------------------------------------------------
+
     d->kipiHelpAction = new KAction(KIcon("kipi"), i18n("Kipi Plugins Handbook"), this);
     connect(d->kipiHelpAction, SIGNAL(triggered()), this, SLOT(slotShowKipiHelp()));
     actionCollection()->addAction("help_kipi", d->kipiHelpAction);
@@ -2180,6 +2187,11 @@
     showDigikamComponentsInfo();
 }
 
+void DigikamApp::slotDBStat()
+{
+    showDigikamDatabaseStat();
+}
+
 void DigikamApp::loadPlugins()
 {
     if(d->splashScreen)
--- trunk/extragear/graphics/digikam/digikam/digikamapp.h #973907:973908
@@ -144,6 +144,7 @@
     void slotContribute();
     void slotRawCameraList();
     void slotComponentsInfo();
+    void slotDBStat();
 
     void slotRecurseAlbums(bool);
     void slotRecurseTags(bool);
--- trunk/extragear/graphics/digikam/digikam/digikamapp_p.h #973907:973908
@@ -143,6 +143,7 @@
         tipAction                            = 0;
         rawCameraListAction                  = 0;
         libsInfoAction                       = 0;
+        dbStatAction                         = 0;
         kipiHelpAction                       = 0;
         donateMoneyAction                    = 0;
         addCameraSeparatorAction             = 0;
@@ -272,6 +273,7 @@
     // Application Actions
     KAction                            *rawCameraListAction;
     KAction                            *libsInfoAction;
+    KAction                            *dbStatAction;
     KAction                            *kipiHelpAction;
     KAction                            *donateMoneyAction;
     KAction                            *contributeAction;
--- trunk/extragear/graphics/digikam/digikam/digikamui.rc #973907:973908
@@ -1,5 +1,5 @@
 <!DOCTYPE kpartgui SYSTEM "kpartgui.dtd">
-<gui version="56" name="digikam" >
+<gui version="57" name="digikam" >
 
  <MenuBar>
 
@@ -126,6 +126,7 @@
   <Menu name="help"><Text>&amp;Help</Text>
     <Action name="help_rawcameralist"/>
     <Action name="help_librariesinfo"/>
+    <Action name="help_dbstat"/>
     <Action name="help_kipi"/>
     <Action name="help_tipofday"/>
     <Separator/>
** trunk/extragear/graphics/digikam/libs/database/dbstatdlg.cpp #property svn:eol-style
   + native
** trunk/extragear/graphics/digikam/libs/database/dbstatdlg.h #property svn:eol-style
   + native

_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

Re: Database Statistics

Bugzilla from andi.clemens@gmx.net
Look at this screenshot, the statistics are totally wrong here.
I have 23.786 totals at the moment, and no movies at all.

Andi

On Thursday 28 May 2009 09:56:58 Andi Clemens wrote:

> Hi,
>
> I guess these statistics are wrong, because they display all entries, even
> the not-active ones.
> For me it displays 580 GIFs for example, but they were removed months ago.
> Also 58 AVIs are listed, although they are gone, too.
>
> I would consider to only display the active ones (status==1 if I'm not
> wrong).
>
> Andi

_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

db.jpg (26K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Database Statistics

Gilles Caulier-4
Andi,

Well, try to adjust code to query database from
AlbumDB::getImageFormatStatistics() method.

Gilles

2009/5/28 Andi Clemens <[hidden email]>:

> Look at this screenshot, the statistics are totally wrong here.
> I have 23.786 totals at the moment, and no movies at all.
>
> Andi
>
> On Thursday 28 May 2009 09:56:58 Andi Clemens wrote:
>> Hi,
>>
>> I guess these statistics are wrong, because they display all entries, even
>> the not-active ones.
>> For me it displays 580 GIFs for example, but they were removed months ago.
>> Also 58 AVIs are listed, although they are gone, too.
>>
>> I would consider to only display the active ones (status==1 if I'm not
>> wrong).
>>
>> Andi
>
>
> _______________________________________________
> Digikam-devel mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-devel
>
>
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

Re: Database Statistics

Bugzilla from andi.clemens@gmx.net
Ok, will take a look.

Andi

On Thursday 28 May 2009 10:06:45 Gilles Caulier wrote:

> Andi,
>
> Well, try to adjust code to query database from
> AlbumDB::getImageFormatStatistics() method.
>
> Gilles
>
> 2009/5/28 Andi Clemens <[hidden email]>:
> > Look at this screenshot, the statistics are totally wrong here.
> > I have 23.786 totals at the moment, and no movies at all.
> >
> > Andi
> >
> > On Thursday 28 May 2009 09:56:58 Andi Clemens wrote:
> >> Hi,
> >>
> >> I guess these statistics are wrong, because they display all entries,
> >> even the not-active ones.
> >> For me it displays 580 GIFs for example, but they were removed months
> >> ago. Also 58 AVIs are listed, although they are gone, too.
> >>
> >> I would consider to only display the active ones (status==1 if I'm not
> >> wrong).
> >>
> >> Andi
> >
> > _______________________________________________
> > Digikam-devel mailing list
> > [hidden email]
> > https://mail.kde.org/mailman/listinfo/digikam-devel
>
> _______________________________________________
> Digikam-devel mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-devel

_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel