02d1ed6ad2 2008-02-02 stephan: /* 02d1ed6ad2 2008-02-02 stephan: ** Copyright (c) 2007 D. Richard Hipp 2ab3a2f603 2008-02-03 stephan: ** Copyright (c) 2008 Stephan Beal 02d1ed6ad2 2008-02-02 stephan: ** 02d1ed6ad2 2008-02-02 stephan: ** This program is free software; you can redistribute it and/or 02d1ed6ad2 2008-02-02 stephan: ** modify it under the terms of the GNU General Public 02d1ed6ad2 2008-02-02 stephan: ** License as published by the Free Software Foundation; either 02d1ed6ad2 2008-02-02 stephan: ** version 2 of the License, or (at your option) any later version. 02d1ed6ad2 2008-02-02 stephan: ** 02d1ed6ad2 2008-02-02 stephan: ** This program is distributed in the hope that it will be useful, 02d1ed6ad2 2008-02-02 stephan: ** but WITHOUT ANY WARRANTY; without even the implied warranty of 02d1ed6ad2 2008-02-02 stephan: ** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU 02d1ed6ad2 2008-02-02 stephan: ** General Public License for more details. 02d1ed6ad2 2008-02-02 stephan: ** 02d1ed6ad2 2008-02-02 stephan: ** You should have received a copy of the GNU General Public 02d1ed6ad2 2008-02-02 stephan: ** License along with this library; if not, write to the 02d1ed6ad2 2008-02-02 stephan: ** Free Software Foundation, Inc., 59 Temple Place - Suite 330, 02d1ed6ad2 2008-02-02 stephan: ** Boston, MA 02111-1307, USA. 02d1ed6ad2 2008-02-02 stephan: ** 02d1ed6ad2 2008-02-02 stephan: ** Author contact information: 02d1ed6ad2 2008-02-02 stephan: ** drh@hwaci.com 02d1ed6ad2 2008-02-02 stephan: ** http://www.hwaci.com/drh/ 02d1ed6ad2 2008-02-02 stephan: ** 02d1ed6ad2 2008-02-02 stephan: ******************************************************************************* 02d1ed6ad2 2008-02-02 stephan: ** 02d1ed6ad2 2008-02-02 stephan: ** Implementation of the Tag View page 02d1ed6ad2 2008-02-02 stephan: */ 02d1ed6ad2 2008-02-02 stephan: #include <assert.h> 02d1ed6ad2 2008-02-02 stephan: #include "config.h" 02d1ed6ad2 2008-02-02 stephan: #include "tagview.h" 02d1ed6ad2 2008-02-02 stephan: 02d1ed6ad2 2008-02-02 stephan: 2cb3290e67 2008-02-03 stephan: #if 1 2cb3290e67 2008-02-03 stephan: # define TAGVIEW_DEFAULT_FILTER "AND t.tagname NOT GLOB 'wiki-*' " 2cb3290e67 2008-02-03 stephan: #else 2cb3290e67 2008-02-03 stephan: # define TAGVIEW_DEFAULT_FILTER 02a7c850b4 2008-02-03 stephan: #endif 02a7c850b4 2008-02-03 stephan: 10437374a7 2008-02-02 drh: /* 007d1ce44f 2008-02-07 drh: ** Lists all tags matching the given LIKE clause (which 007d1ce44f 2008-02-07 drh: ** may be 0). 10437374a7 2008-02-02 drh: */ 007d1ce44f 2008-02-07 drh: static void tagview_page_list_tags(const char *zLike){ 007d1ce44f 2008-02-07 drh: char *zLikeClause = 0; 9c01af2d22 2008-02-03 stephan: const int limit = 10; 007d1ce44f 2008-02-07 drh: char *zLimit = 0; 007d1ce44f 2008-02-07 drh: char *zSql; 2ab3a2f603 2008-02-03 stephan: 007d1ce44f 2008-02-07 drh: if( zLike && zLike[0] ){ 007d1ce44f 2008-02-07 drh: zLikeClause = mprintf( "AND t.tagname LIKE '%%%q%%'", zLike ); 007d1ce44f 2008-02-07 drh: zLimit = ""; 007d1ce44f 2008-02-07 drh: @ <h2>Tags matching [%h(zLikeClause)]:</h2> 10437374a7 2008-02-02 drh: }else{ 007d1ce44f 2008-02-07 drh: zLimit = mprintf( "LIMIT %d", limit ); 007d1ce44f 2008-02-07 drh: zLikeClause = ""; 2ab3a2f603 2008-02-03 stephan: @ <h2>%d(limit) most recent tags:</h2> 10437374a7 2008-02-02 drh: } 007d1ce44f 2008-02-07 drh: zSql = mprintf( 007d1ce44f 2008-02-07 drh: "SELECT " 007d1ce44f 2008-02-07 drh: " linktagid(t.tagid) AS 'Tag ID'," 007d1ce44f 2008-02-07 drh: " linktagname(t.tagname) AS 'Name'," 007d1ce44f 2008-02-07 drh: " DATETIME(tx.mtime) AS 'Timestamp'," 007d1ce44f 2008-02-07 drh: " linkuuid(b.uuid) AS 'Version'" 007d1ce44f 2008-02-07 drh: " FROM tag t, tagxref tx, blob b " 0ff4e918f4 2008-02-13 stephan: " WHERE t.tagid=tx.tagid AND tx.rid=b.rid" 007d1ce44f 2008-02-07 drh: " AND tx.tagtype!=0 %s " 9c01af2d22 2008-02-03 stephan: TAGVIEW_DEFAULT_FILTER 007d1ce44f 2008-02-07 drh: " ORDER BY tx.mtime DESC %s", 007d1ce44f 2008-02-07 drh: zLikeClause, zLimit 007d1ce44f 2008-02-07 drh: ); 007d1ce44f 2008-02-07 drh: db_generic_query_view(zSql, 1); 007d1ce44f 2008-02-07 drh: free(zSql); 6d67f3c7c7 2008-02-08 stephan: if( zLikeClause[0] ) free(zLikeClause); 6d67f3c7c7 2008-02-08 stephan: if( zLimit[0] ) free(zLimit); 2ab3a2f603 2008-02-03 stephan: } 2ab3a2f603 2008-02-03 stephan: 007d1ce44f 2008-02-07 drh: /* 007d1ce44f 2008-02-07 drh: ** A small search form which forwards to ?like=SEARCH_STRING 9c01af2d22 2008-02-03 stephan: */ 2ab3a2f603 2008-02-03 stephan: static void tagview_page_search_miniform(void){ 2ab3a2f603 2008-02-03 stephan: char const * like = P("like"); 2ab3a2f603 2008-02-03 stephan: @ <div style='font-size:smaller'> 3984b1b2c1 2008-08-04 eric: @ <form action='tagview' method='post'> 2ab3a2f603 2008-02-03 stephan: @ Search for tags: 007d1ce44f 2008-02-07 drh: @ <input type='text' name='like' value='%h((like?like:""))' size='10'/> 2ab3a2f603 2008-02-03 stephan: @ <input type='submit'/> 2ab3a2f603 2008-02-03 stephan: @ </form> 2ab3a2f603 2008-02-03 stephan: @ </div> 2ab3a2f603 2008-02-03 stephan: } 2ab3a2f603 2008-02-03 stephan: 007d1ce44f 2008-02-07 drh: /* 007d1ce44f 2008-02-07 drh: ** tagview_page_default() renders the default page for tagview_page(). 9c01af2d22 2008-02-03 stephan: */ 2ab3a2f603 2008-02-03 stephan: static void tagview_page_default(void){ 2ab3a2f603 2008-02-03 stephan: tagview_page_list_tags( 0 ); 10437374a7 2008-02-02 drh: } 10437374a7 2008-02-02 drh: 10437374a7 2008-02-02 drh: /* 007d1ce44f 2008-02-07 drh: ** Lists all tags matching the given tagid. 10437374a7 2008-02-02 drh: */ 007d1ce44f 2008-02-07 drh: static void tagview_page_tag_by_id( int tagid ){ 007d1ce44f 2008-02-07 drh: char *zSql; 9c01af2d22 2008-02-03 stephan: @ <h2>Tag #%d(tagid):</h2> 007d1ce44f 2008-02-07 drh: zSql = mprintf( 007d1ce44f 2008-02-07 drh: "SELECT DISTINCT" 007d1ce44f 2008-02-07 drh: " linktagname(t.tagname) AS 'Tag Name'," 007d1ce44f 2008-02-07 drh: " DATETIME(tx.mtime) AS 'Timestamp'," 007d1ce44f 2008-02-07 drh: " linkuuid(b.uuid) AS 'Version'" 007d1ce44f 2008-02-07 drh: " FROM tag t, tagxref tx, blob b" 0ff4e918f4 2008-02-13 stephan: " WHERE t.tagid=%d AND t.tagid=tx.tagid AND tx.rid=b.rid " 9c01af2d22 2008-02-03 stephan: TAGVIEW_DEFAULT_FILTER 007d1ce44f 2008-02-07 drh: " ORDER BY tx.mtime DESC", 007d1ce44f 2008-02-07 drh: tagid 10437374a7 2008-02-02 drh: ); 007d1ce44f 2008-02-07 drh: db_generic_query_view(zSql, 1); 007d1ce44f 2008-02-07 drh: free(zSql); 2ab3a2f603 2008-02-03 stephan: } 2ab3a2f603 2008-02-03 stephan: 007d1ce44f 2008-02-07 drh: /* 007d1ce44f 2008-02-07 drh: ** Lists all tags matching the given tag name. 2cb3290e67 2008-02-03 stephan: */ 007d1ce44f 2008-02-07 drh: static void tagview_page_tag_by_name( char const * tagname ){ 007d1ce44f 2008-02-07 drh: char *zSql; 9c01af2d22 2008-02-03 stephan: @ <h2>Tag '%s(tagname)':</h2> 007d1ce44f 2008-02-07 drh: zSql = mprintf( 007d1ce44f 2008-02-07 drh: "SELECT DISTINCT" 007d1ce44f 2008-02-07 drh: " linktagid(t.tagid) AS 'Tag ID'," 007d1ce44f 2008-02-07 drh: " DATETIME(tx.mtime) AS 'Timestamp'," 007d1ce44f 2008-02-07 drh: " linkuuid(b.uuid) AS 'Version'" 007d1ce44f 2008-02-07 drh: " FROM tag t, tagxref tx, blob b " 0ff4e918f4 2008-02-13 stephan: " WHERE t.tagname='%q' AND t.tagid=tx.tagid AND tx.rid=b.rid " 9c01af2d22 2008-02-03 stephan: TAGVIEW_DEFAULT_FILTER 007d1ce44f 2008-02-07 drh: " ORDER BY tx.mtime DESC", 2ab3a2f603 2008-02-03 stephan: tagname); 007d1ce44f 2008-02-07 drh: db_generic_query_view(zSql, 1); 007d1ce44f 2008-02-07 drh: free(zSql); 02a7c850b4 2008-02-03 stephan: } 02a7c850b4 2008-02-03 stephan: 3984b1b2c1 2008-08-04 eric: /* 3984b1b2c1 2008-08-04 eric: ** Get the UUIDs for a tag 3984b1b2c1 2008-08-04 eric: */ 3984b1b2c1 2008-08-04 eric: char *tag_query_for_www(const char *pName){ 3984b1b2c1 2008-08-04 eric: static const char zBaseSql[] = 3984b1b2c1 2008-08-04 eric: @ SELECT 3984b1b2c1 2008-08-04 eric: @ blob.rid, 3984b1b2c1 2008-08-04 eric: @ uuid, 3984b1b2c1 2008-08-04 eric: @ datetime(event.mtime,'localtime') AS timestamp, 3984b1b2c1 2008-08-04 eric: @ coalesce(ecomment, comment), 3984b1b2c1 2008-08-04 eric: @ coalesce(euser, user), 3984b1b2c1 2008-08-04 eric: @ (SELECT count(*) FROM plink WHERE pid=blob.rid AND isprim=1), 3984b1b2c1 2008-08-04 eric: @ (SELECT count(*) FROM plink WHERE cid=blob.rid), 3984b1b2c1 2008-08-04 eric: @ NOT EXISTS (SELECT 1 FROM plink WHERE pid=blob.rid), 3984b1b2c1 2008-08-04 eric: @ coalesce(bgcolor, brbgcolor), 3984b1b2c1 2008-08-04 eric: @ event.type 3984b1b2c1 2008-08-04 eric: @ FROM event JOIN blob JOIN tagxref 3984b1b2c1 2008-08-04 eric: @ WHERE blob.rid=event.objid 3984b1b2c1 2008-08-04 eric: @ AND tagxref.rid = event.objid 3984b1b2c1 2008-08-04 eric: @ AND tagxref.tagid = (SELECT tagid FROM tag 3984b1b2c1 2008-08-04 eric: @ WHERE tagname = 'sym-'||%Q) 3984b1b2c1 2008-08-04 eric: @ ORDER BY 3 desc 3984b1b2c1 2008-08-04 eric: ; 3984b1b2c1 2008-08-04 eric: return mprintf(zBaseSql,pName); 2ab3a2f603 2008-02-03 stephan: } 2ab3a2f603 2008-02-03 stephan: 02d1ed6ad2 2008-02-02 stephan: /* 3984b1b2c1 2008-08-04 eric: ** WEBP AGE: /tagview 02d1ed6ad2 2008-02-02 stephan: */ 3984b1b2c1 2008-08-04 eric: void old_tagview_page(void){ 908009fdc4 2008-05-07 drh: char const * check = 0; 9c01af2d22 2008-02-03 stephan: login_check_credentials(); 9c01af2d22 2008-02-03 stephan: if( !g.okRdWiki ){ 9c01af2d22 2008-02-03 stephan: login_needed(); 9c01af2d22 2008-02-03 stephan: } 9c01af2d22 2008-02-03 stephan: style_header("Tags"); d57de28756 2008-05-05 drh: login_anonymous_available(); 9c01af2d22 2008-02-03 stephan: tagview_page_search_miniform(); 9c01af2d22 2008-02-03 stephan: @ <hr/> 007d1ce44f 2008-02-07 drh: if( 0 != (check = P("tagid")) ){ 9c01af2d22 2008-02-03 stephan: tagview_page_tag_by_id( atoi(check) ); 007d1ce44f 2008-02-07 drh: }else if( 0 != (check = P("like")) ){ 9c01af2d22 2008-02-03 stephan: tagview_page_list_tags( check ); 007d1ce44f 2008-02-07 drh: }else if( 0 != (check = P("name")) ){ 9c01af2d22 2008-02-03 stephan: tagview_page_tag_by_name( check ); 02d1ed6ad2 2008-02-02 stephan: }else{ 9c01af2d22 2008-02-03 stephan: tagview_page_default(); 02d1ed6ad2 2008-02-02 stephan: } 3984b1b2c1 2008-08-04 eric: style_footer(); 02d1ed6ad2 2008-02-02 stephan: } 02d1ed6ad2 2008-02-02 stephan: 02d1ed6ad2 2008-02-02 stephan: /* 02d1ed6ad2 2008-02-02 stephan: ** WEBPAGE: /tagview 02d1ed6ad2 2008-02-02 stephan: */ 02d1ed6ad2 2008-02-02 stephan: void tagview_page(void){ 3984b1b2c1 2008-08-04 eric: char const *zName = 0; 02d1ed6ad2 2008-02-02 stephan: login_check_credentials(); 3984b1b2c1 2008-08-04 eric: if( !g.okRead ){ 02d1ed6ad2 2008-02-02 stephan: login_needed(); 02d1ed6ad2 2008-02-02 stephan: } 3984b1b2c1 2008-08-04 eric: login_anonymous_available(); 3984b1b2c1 2008-08-04 eric: if( 0 != (zName = P("name")) ){ 3984b1b2c1 2008-08-04 eric: Blob uuid; 3984b1b2c1 2008-08-04 eric: char *zSql; 3984b1b2c1 2008-08-04 eric: Stmt q; 3984b1b2c1 2008-08-04 eric: if( sym_tag_to_uuid(zName, &uuid) > 0){ 3984b1b2c1 2008-08-04 eric: style_header("Tagged Baselines"); 3984b1b2c1 2008-08-04 eric: @ <h2>%s(zName):</h2> 3984b1b2c1 2008-08-04 eric: zSql = tag_query_for_www(zName); 3984b1b2c1 2008-08-04 eric: db_prepare(&q, zSql); 3984b1b2c1 2008-08-04 eric: free(zSql); 3984b1b2c1 2008-08-04 eric: www_print_timeline(&q); 3984b1b2c1 2008-08-04 eric: db_finalize(&q); 3984b1b2c1 2008-08-04 eric: }else{ 3984b1b2c1 2008-08-04 eric: style_header("TaggedBaselines"); 3984b1b2c1 2008-08-04 eric: @ <h2>%s(zName):</h2> 3984b1b2c1 2008-08-04 eric: @ There is no artifact with this tag. 3984b1b2c1 2008-08-04 eric: } 3984b1b2c1 2008-08-04 eric: }else{ 3984b1b2c1 2008-08-04 eric: Stmt q; 3984b1b2c1 2008-08-04 eric: const char *prefix = "sym-"; 3984b1b2c1 2008-08-04 eric: int preflen = strlen(prefix); 3984b1b2c1 2008-08-04 eric: style_header("Tags"); 3984b1b2c1 2008-08-04 eric: db_prepare(&q, 3984b1b2c1 2008-08-04 eric: "SELECT tagname" 3984b1b2c1 2008-08-04 eric: " FROM tag" 3984b1b2c1 2008-08-04 eric: " WHERE EXISTS(SELECT 1 FROM tagxref" 3984b1b2c1 2008-08-04 eric: " WHERE tagid=tag.tagid" 3984b1b2c1 2008-08-04 eric: " AND tagtype>0)" 3984b1b2c1 2008-08-04 eric: " ORDER BY tagname" 02a7c850b4 2008-02-03 stephan: ); 3984b1b2c1 2008-08-04 eric: @ <ul> 3984b1b2c1 2008-08-04 eric: while( db_step(&q)==SQLITE_ROW ){ 3984b1b2c1 2008-08-04 eric: const char *name = db_column_text(&q, 0); 3984b1b2c1 2008-08-04 eric: if( strncmp(name, prefix, preflen)==0 ){ 3984b1b2c1 2008-08-04 eric: @ <li><a href=%s(g.zBaseURL)/tagview?name=%s(name+preflen)> 3984b1b2c1 2008-08-04 eric: @ %s(name+preflen)</a></li> 3984b1b2c1 2008-08-04 eric: } 3984b1b2c1 2008-08-04 eric: } 3984b1b2c1 2008-08-04 eric: @ </ul> 3984b1b2c1 2008-08-04 eric: db_finalize(&q); 2ab3a2f603 2008-02-03 stephan: } 02d1ed6ad2 2008-02-02 stephan: style_footer(); 02d1ed6ad2 2008-02-02 stephan: } 02d1ed6ad2 2008-02-02 stephan: 2cb3290e67 2008-02-03 stephan: #undef TAGVIEW_DEFAULT_FILTER
File Annotation