summaryrefslogtreecommitdiff
path: root/test/scanners/sql/maintenance.in.sql
diff options
context:
space:
mode:
authormurphy <murphy@rubychan.de>2009-04-20 21:19:41 +0000
committermurphy <murphy@rubychan.de>2009-04-20 21:19:41 +0000
commit32701fcf0c5f0e54d7172ceb86e44664aa4bae10 (patch)
tree5185f2c879f0478a89b2dcbc2a0a632ddaf838b9 /test/scanners/sql/maintenance.in.sql
parentcf0b7a2a80808c06cb51ad2ee8971082d96cd41e (diff)
downloadcoderay-32701fcf0c5f0e54d7172ceb86e44664aa4bae10.tar.gz
New: *PHP and SQL Scanners*
* Both not well tested yet, preview versions. * Some example code for both languages. * PHP scanner original by Stefan Walk. * SQL scanner using code by Keith Pitt and Josh Goebel.
Diffstat (limited to 'test/scanners/sql/maintenance.in.sql')
-rw-r--r--test/scanners/sql/maintenance.in.sql24
1 files changed, 24 insertions, 0 deletions
diff --git a/test/scanners/sql/maintenance.in.sql b/test/scanners/sql/maintenance.in.sql
new file mode 100644
index 0000000..7b06db6
--- /dev/null
+++ b/test/scanners/sql/maintenance.in.sql
@@ -0,0 +1,24 @@
+--RANDOM SQL QUERIES THAT DO NOTHING INTERESTING
+--Copyright (C) 2009 - Keith Pitt <keith@keithpitt.com>
+
+--This program is free software: you can redistribute it and/or modify
+--it under the terms of the GNU General Public License as published by
+--the Free Software Foundation, either version 3 of the License, or
+--(at your option) any later version.
+
+--This program is distributed in the hope that it will be useful,
+--but WITHOUT ANY WARRANTY; without even the implied warranty of
+--MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+--GNU General Public License for more details.
+
+--You should have received a copy of the GNU General Public License
+--along with this program. If not, see <http://www.gnu.org/licenses/>.
+
+INSERT INTO users (first_name, last_name) VALUES ('John', 'Doe');
+
+INSERT INTO users (first_name, last_name) VALUES ("John", "Doe");
+
+UPDATE users SET first_name = 'Keith' WHERE first_name = 'JOHN';
+
+DELETE FROM users WHERE first_name = 'Keith';
+