diff options
Diffstat (limited to 'debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql')
3 files changed, 0 insertions, 149 deletions
diff --git a/debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02400-mysql.sqc b/debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02400-mysql.sqc deleted file mode 100644 index ec8ad604..00000000 --- a/debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02400-mysql.sqc +++ /dev/null @@ -1,55 +0,0 @@ -#include <stdlib.h> -#include <stdio.h> - -/*----------------------------------------------------------------*/ -EXEC SQL INCLUDE SQLCA; -short sqlcode; - -EXEC SQL BEGIN DECLARE SECTION; - int host_a; - double host_b; - char host_c; -EXEC SQL END DECLARE SECTION; - -EXEC SQL DECLARE csr1 CURSOR FOR - SELECT a, b, c - FROM table1 - WHERE x = :hostvar1; - -/* dollar sign notation */ -$ DECLARE cursorName CURSOR for - SELECT - a, - b - INTO - $struct->a, - $struct->b - FROM table; - -/*----------------------------------------------------------------*/ -void main(void) -{ - hostvar1 = 42; - - EXEC SQL OPEN csr1; - if (sqlcode < 0) - { - exit(0); - } - - while (rc >= 0 && rc != 100) - { - EXEC SQL FETCH csr1 INTO :host_a, :host_b, :host_c; - printf("Fetch %d, %lf, %s\n", host_a, host_b, host_c); - } - - EXEC SQL CLOSE csr1; -} - -void foo(void) -{ - strcpy(demoquery1, "some SQL statement"); - EXEC SQL prepare demo3id from :demoquery1; - /* a comment */ - EXEC SQL declare demo3cursor cursor for demo3id; -} diff --git a/debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02401-sta-select.sqc b/debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02401-sta-select.sqc deleted file mode 100644 index 1142c3b9..00000000 --- a/debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02401-sta-select.sqc +++ /dev/null @@ -1,76 +0,0 @@ -/******************************************************* -** -** A sample program that demonstrates the use of Static embedded SQL. -** Before compiling this program, be sure you have created a table -** called video and inserted some tuples in it. -** -********************************************************/ -#include <stdio.h> - -/* sqlca: is the sql communications area. All error codes - * are returned from db2 in that structure which is filled - * each time an interaction with db2 takes place. - */ - -EXEC SQL INCLUDE SQLCA; /* SQL communication area structure */ - -EXEC SQL BEGIN DECLARE SECTION; /* declare host variables */ - char db_name[8]; /* database name */ - char video_title[30]; /* title of the video */ - short video_id; /* serial number */ - char director[20]; /* director name */ -EXEC SQL END DECLARE SECTION; - -/* These lines are redundant here because the default - * action is to continue. They just show the kind of - * errors that could arise and one way to control them. - */ - -EXEC SQL WHENEVER SQLWARNING CONTINUE; /* sqlca.sqlcode > 0 */ -EXEC SQL WHENEVER SQLERROR CONTINUE; /* sqlca.sqlcode < 0 */ -EXEC SQL WHENEVER NOT FOUND CONTINUE; /* sqlca.sqlcode = 100 */ - /* sqlca.sqlcode = 0 (no error) */ - -void main() -{ - strcpy(db_name, "csc343h"); - -/* C variables are preceded by a colon when they are passed to DB2 */ - - EXEC SQL CONNECT TO :db_name; - - if (sqlca.sqlcode != 0) - { - printf("Connect failed!: reason %ld\n", sqlca.sqlcode); - exit(1); - } - -/* cursor delcaration. Have to declare a cursor each time you - * want tuples back from db2 - */ - - EXEC SQL DECLARE c1 CURSOR FOR - SELECT video_title - FROM video; - -/* you have to open the cursor in order to get tuples back */ - - EXEC SQL OPEN c1; - - do - { - /* fetch tuples from the cursor. This will execute the statement - * the cursor implements and will return the results */ - - EXEC SQL FETCH c1 into :video_title; - if (SQLCODE != 0) - { - break; /* SQLCODE refers to sqlca.sqlcode */ - } - /* host variables should have ':' prefix when they are used in DB2 commands */ - - printf("%s\n", video_title); - } while (1); - EXEC SQL CLOSE c1; - EXEC SQL CONNECT RESET; -} diff --git a/debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02402-issue_527.sqc b/debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02402-issue_527.sqc deleted file mode 100644 index 17ccfa3b..00000000 --- a/debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02402-issue_527.sqc +++ /dev/null @@ -1,18 +0,0 @@ -void myfunc1()
-{
- EXEC SQL create or replace
- function my_func (in_str IN varchar2)
- return date
- IS
- x date;
- BEGIN
- IF in_str IS NULL THEN
- x := NULL;
- ELSIF substr
- (in_str, 5, 1) = '-' THEN
- x := to_date(in_str, 'YYYY-MM-DD HH24:MI:SS');
- END IF;
- return x;
- END my_func;
- END-EXEC;
-}
|