1770
1771
1772
1773
1774
1775
1776
1777
1778
1779
1780
1781
1782
1783
1784
1785
1786
1787
1788
1789
1790
1791
1792
1793
1794
1795
1796
1797
|
**
** This routine is called after certain webpages have been run and
** have already responded.
*/
void email_auto_exec(void){
int iJulianDay;
if( g.db==0 ) return;
db_begin_transaction();
if( !email_tables_exist() ) goto autoexec_done;
if( !db_get_boolean("email-autoexec",0) ) goto autoexec_done;
if( !db_exists("SELECT 1 FROM pending_alert") ) goto autoexec_done;
email_send_alerts(0);
iJulianDay = db_int(0, "SELECT julianday('now')");
if( g.fSqlTrace ) fossil_trace("-- iJulianDay: %d\n", iJulianDay);
db_multi_exec(
"REPLACE INTO repository.config(name,value,mtime)"
" VALUES('email-last-digest',%d,now())",
iJulianDay
);
email_send_alerts(SENDALERT_DIGEST);
}
autoexec_done:
db_end_transaction(0);
}
/*
|
>
>
>
>
<
|
<
|
>
|
<
|
>
|
1770
1771
1772
1773
1774
1775
1776
1777
1778
1779
1780
1781
1782
1783
1784
1785
1786
1787
1788
1789
1790
1791
1792
1793
1794
1795
1796
1797
1798
1799
1800
|
**
** This routine is called after certain webpages have been run and
** have already responded.
*/
void email_auto_exec(void){
int iJulianDay;
if( g.db==0 ) return;
if( db_transaction_nesting_depth()!=0 ){
fossil_warning("Called email_auto_exec() from within a transaction");
return;
}
db_begin_transaction();
if( !email_tables_exist() ) goto autoexec_done;
if( !db_get_boolean("email-autoexec",0) ) goto autoexec_done;
if( !db_exists("SELECT 1 FROM pending_alert") ) goto autoexec_done;
email_send_alerts(0);
iJulianDay = db_int(0, "SELECT julianday('now')");
if( iJulianDay>db_get_int("email-last-digest",0) ){
if( db_transaction_nesting_depth()!=1 ){
fossil_warning("Transaction nesting error prior to digest processing");
}else{
db_set_int("email-last-digest",iJulianDay,0);
email_send_alerts(SENDALERT_DIGEST);
}
}
autoexec_done:
db_end_transaction(0);
}
/*
|