760
761
762
763
764
765
766
767
768
769
770
771
772
773
|
}
int db_lget_int(const char *zName, int dflt){
return db_int(dflt, "SELECT value FROM vvar WHERE name=%Q", zName);
}
void db_lset_int(const char *zName, int value){
db_multi_exec("REPLACE INTO vvar(name,value) VALUES(%Q,%d)", zName, value);
}
/*
** COMMAND: open
**
** Create a new local repository.
*/
void cmd_open(void){
|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
|
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
|
}
int db_lget_int(const char *zName, int dflt){
return db_int(dflt, "SELECT value FROM vvar WHERE name=%Q", zName);
}
void db_lset_int(const char *zName, int value){
db_multi_exec("REPLACE INTO vvar(name,value) VALUES(%Q,%d)", zName, value);
}
int db_row_to_table(const char *zFormat, ...){
Stmt q;
va_list ap;
int rc;
va_start(ap, zFormat);
rc = db_vprepare(&q, zFormat, ap);
va_end(ap);
if( rc!=SQLITE_OK ){
return rc;
}
@ <table border="0" cellpadding="0" cellspacing="0">
if( db_step(&q)==SQLITE_ROW ){
int ii;
for(ii=0; ii<sqlite3_column_count(q.pStmt); ii++){
char *zCol = htmlize(sqlite3_column_name(q.pStmt, ii), -1);
char *zVal = htmlize(sqlite3_column_text(q.pStmt, ii), -1);
@ <tr><td align=right>%s(zCol):<td width=10><td>%s(zVal)
free(zVal);
free(zCol);
}
}
@ </table>
return db_finalize(&q);
}
/*
** COMMAND: open
**
** Create a new local repository.
*/
void cmd_open(void){
|