ExecuteNonQuery() public méthode

public ExecuteNonQuery ( string sql ) : int
sql string
Résultat int
DB Class Documentation
Exemple #1
0
		static void CleanupLogins ()
		{
			int r;
			try {
				Stopwatch watch = new Stopwatch ();
				watch.Start ();
				using (DB db = new DB ()) {
					r = db.ExecuteNonQuery ("DELETE FROM login WHERE expires < now();");
				}
				watch.Stop ();
				Logger.Log ("Maintenance: successfully cleaned up logins ({0} affected records) in {1} seconds", r, watch.Elapsed.TotalSeconds);
			} catch (Exception ex) {
				Logger.Log ("Maintenance: failed to cleanup logins: {0}", ex);
			}
		}
Exemple #2
0
		static void CleanupEmptyRevisionWorks ()
		{
			int r;
			try {
				Stopwatch watch = new Stopwatch ();
				watch.Start ();
				using (DB db = new DB ()) {
					r = db.ExecuteNonQuery (
@"UPDATE revisionwork SET workhost_id = NULL, state = 10 WHERE id IN
	(SELECT id FROM revisionwork WHERE NOT EXISTS
		(SELECT work.id FROM work WHERE work.revisionwork_id = revisionwork.id)
    )
;");
				}
				watch.Stop ();
				Logger.Log ("Maintenance: successfully cleaned up empty revision works ({0} affected records) in {1} seconds", r, watch.Elapsed.TotalSeconds);
			} catch (Exception ex) {
				Logger.Log ("Maintenance: failed to cleanup empty revision work: {0}", ex);
			}
		}