NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
OTHER DEALINGS IN THE SOFTWARE.
*/
require_once 'classes/piaApp.php';
$piaApp = new piaApp();
$piaApp->startPage('PiArchive Statistics');
$piaApp->addTableSorter();
$piaApp->showHeader('PiArchive Statistics');
$piaApp->addMenu('stats.php');
#
# ----- database version
#
$version = piaDB::getScalarString('SELECT * FROM pia_version()', array());
echo 'Database version: ', $version, '<p />';
#
# ----- total number of items
#
$num_sources = piaDB::getScalarInteger('SELECT count(rowid) FROM pia.source', array());
echo $num_sources, ' source(s)<p />';
$num_indexed_items = piaDB::getScalarInteger('SELECT count(rowid) FROM pia.index', array());
echo piaApp::getFormattedNumber($num_indexed_items, 0, -9), ' indexed item(s)<p />';
$size_bytes = piaDB::getScalarFloat('SELECT sum(size_bytes) FROM pia.index', array());
echo 'Total size of indexed items: ', piaApp::getFormattedNumber($size_bytes, 0, -9), ' (bytes)<p />';
#
# ----- show sources in a table
#
piaSource::reportSources();
#
/**
* Get a value from the metadata table core.metadata.
* @param string $name Name of the value to get.
* @return The metadata value if it exists, a blank string otherwise.
*/
public static function getMetadataValue($name)
{
return piaDB::getScalarString('SELECT val FROM core.metadata WHERE name = $1', array($name));
}
