/* -*- Mode: C; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 2 -*- */
/* vim: set ts=2 et sw=2 tw=80: */
/*
** Copyright (c) 2013 D. Richard Hipp
**
** This program is free software; you can redistribute it and/or
** modify it under the terms of the Simplified BSD License (also
** known as the "2-Clause License" or "FreeBSD License".)
**
** This program is distributed in the hope that it will be useful,
** but without any warranty; without even the implied warranty of
** merchantability or fitness for a particular purpose.
**
** Author contact information:
** drh@hwaci.com
** http://www.hwaci.com/drh/
**
*******************************************************************************
** This file implements a basic timeline [test] app using the
** libfossil API.
*/
#include "fossil-scm/fossil-cli.h"
/**
** fsl_stmt_each_f() implementation for a basic timeline view. The
** state parameter is ignored.
*/
int stmt_each_f_timeline1( fsl_stmt * q, void * state ){
fsl_cx * f = fcli.f;
char const * x;
/* Tip to copy/pasters: q->rowCount can be used to determine what
row number we're on. It starts counting at 1, not 0.
*/
fsl_outputf(f, "%-2s [%.*s] @ %s by [%s]",
fsl_stmt_g_text(q,3,NULL)/*type*/,
12, fsl_stmt_g_text(q,0,NULL)/*uuid*/,
fsl_stmt_g_text(q,1,NULL)/*time*/,
fsl_stmt_g_text(q,2,NULL)/*user*/
);
if( (x = fsl_stmt_g_text(q,4,NULL)) ){
fsl_outputf(f, " in branch [%s]", x);
}
fsl_outputf(f, "\n\t%s\n\n", fsl_stmt_g_text(q,5,NULL));
return 0;
}
static struct TLApp_ {
int limit;
char utc;
} TLApp = {
-1/*limit*/,
0/*utc*/
};
static int my_timeline(){
fcli_t * a = &fcli;
fsl_buffer sql = fsl_buffer_empty;
int rc;
fsl_db * db = fsl_cx_db_repo(a->f);
rc = fsl_buffer_appendf(&sql, "SELECT "
/*0*/"substr(uuid,1,12) AS uuid, "
/*1*/"datetime(event.mtime%s) AS timestampString, "
/*2*/"coalesce(euser, user) AS user, "
/*3*/"event.type AS eventType, "
/*4*/"(SELECT group_concat(substr(tagname,5), ',') FROM tag, tagxref "
"WHERE tagname GLOB 'sym-*' AND tag.tagid=tagxref.tagid "
"AND tagxref.rid=blob.rid AND tagxref.tagtype>0) as tags, "
/*5*/"coalesce(ecomment, comment) AS comment "
"FROM event JOIN blob "
"WHERE blob.rid=event.objid "
"ORDER BY event.mtime DESC",
TLApp.utc ? "" : ", 'localtime'");
if(rc) goto end;
if(TLApp.limit > 0){
rc = fsl_buffer_appendf(&sql, " LIMIT %d", TLApp.limit);
if(rc) goto end;
}
rc = fsl_db_each(db, stmt_each_f_timeline1, NULL,
"%b", &sql);
fsl_flush(a->f);
end:
fsl_buffer_clear(&sql);
if(rc && db->error.code){
rc = fsl_cx_uplift_db_error(a->f, db);
}
return rc;
}
static void fcli_local_help(){
printf("Usage:\n\t%s [options]\n\n", fcli.appName);
puts("Displays timeline information for a Fossil repository db.");
puts("Options:\n");
puts("\t-n|-limit=NUMBER limits the results to that many. "
"n=0 means unlimited. Negative values are ignored "
"and use the default limit.\n");
puts("\t--utc Changes time values from local time to UTC.\n");
}
int main(int argc, char * const * argv ){
int rc = 0;
char * zLimit = NULL;
fsl_cx * f = NULL;
fcli.appHelp = fcli_local_help;
rc = fcli_setup(argc, argv);
if(FSL_RC_BREAK==rc) return 0;
else if(rc) goto end;
f = fcli.f;
TLApp.utc = fcli_flag("utc", NULL);
fcli_flag2("n", "limit", &zLimit);
if(zLimit){
TLApp.limit = atoi(zLimit);
fsl_free(zLimit);
zLimit = NULL;
}
if(TLApp.limit<0) TLApp.limit = 5;
if(fcli_has_unused_flags(0)) goto end;
if(!fsl_cx_db_repo(f)){
rc = fsl_cx_err_set(f, FSL_RC_MISUSE, "Repo db required.");
goto end;
}
rc = my_timeline();
end:
return (fcli_err_report(0) || rc)
? EXIT_FAILURE : EXIT_SUCCESS;
}