617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
|
while( db_step(&q)==SQLITE_ROW ){
const char *zName = db_column_text(&q, 0);
sqlite3_int64 mtime = db_column_int(&q, 1);
const char *zHash = db_column_text(&q, 2);
int fullSize = db_column_int(&q, 3);
const char *zLogin = db_column_text(&q, 4);
if( zLogin==0 ) zLogin = "";
blob_appendf(&json, "%s{\"name\":\"", zSep);
zSep = ",\n ";
blob_append_json_string(&json, zName);
blob_appendf(&json, "\",\n \"mtime\":%lld,\n \"hash\":\"", mtime);
blob_append_json_string(&json, zHash);
blob_appendf(&json, "\",\n \"size\":%d,\n \"user\":\"", fullSize);
blob_append_json_string(&json, zLogin);
blob_appendf(&json, "\"}");
}
db_finalize(&q);
blob_appendf(&json,"]\n");
cgi_set_content(&json);
}
|
|
|
|
<
|
<
|
|
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
|
while( db_step(&q)==SQLITE_ROW ){
const char *zName = db_column_text(&q, 0);
sqlite3_int64 mtime = db_column_int(&q, 1);
const char *zHash = db_column_text(&q, 2);
int fullSize = db_column_int(&q, 3);
const char *zLogin = db_column_text(&q, 4);
if( zLogin==0 ) zLogin = "";
blob_appendf(&json, "%s{\"name\":\"%j\",\n", zSep, zName);
zSep = ",\n ";
blob_appendf(&json, " \"mtime\":%lld,\n", mtime);
blob_appendf(&json, " \"hash\":\"%j\",\n", zHash);
blob_appendf(&json, " \"size\":%d,\n", fullSize);
blob_appendf(&json, " \"user\":\"%j\"}", zLogin);
}
db_finalize(&q);
blob_appendf(&json,"]\n");
cgi_set_content(&json);
}
|