Index: src/json_timeline.c ================================================================== --- src/json_timeline.c +++ src/json_timeline.c @@ -291,29 +291,20 @@ cson_value * json_get_changed_files(int rid){ cson_value * rowsV = NULL; cson_array * rows = NULL; Stmt q = empty_Stmt; db_prepare(&q, -#if 0 - "SELECT (mlink.pid==0) AS isNew," - " (mlink.fid==0) AS isDel," - " filename.name AS name" - " FROM mlink, filename" - " WHERE mid=%d" - " AND pid!=fid" - " AND filename.fnid=mlink.fnid" - " ORDER BY 3 /*sort*/", -#else "SELECT (pid==0) AS isnew," " (fid==0) AS isdel," " (SELECT name FROM filename WHERE fnid=mlink.fnid) AS name," - " (SELECT uuid FROM blob WHERE rid=fid) as uuid," - " (SELECT uuid FROM blob WHERE rid=pid) as parent" - " FROM mlink" + " blob.uuid as uuid," + " (SELECT uuid FROM blob WHERE rid=pid) as parent," + " blob.size as size" + " FROM mlink, blob" " WHERE mid=%d AND pid!=fid" + " AND blob.rid=fid " " ORDER BY name /*sort*/", -#endif rid ); while( (SQLITE_ROW == db_step(&q)) ){ cson_value * rowV = cson_value_new_object(); cson_object * row = cson_value_get_object(rowV); @@ -328,10 +319,12 @@ cson_object_set(row, "name", json_new_string(db_column_text(&q,2))); cson_object_set(row, "uuid", json_new_string(db_column_text(&q,3))); if(!isNew){ cson_object_set(row, "parent", json_new_string(db_column_text(&q,4))); } + cson_object_set(row, "size", json_new_int(db_column_int(&q,5))); + cson_object_set(row, "state", json_new_string(json_artifact_status_to_string(isNew,isDel))); zDownload = mprintf("/raw/%s?name=%s", /* reminder: g.zBaseURL is of course not set for CLI mode. */ db_column_text(&q,2),