1 -- first some tests of basic functionality
7 -- check static and global data
11 SELECT global_test_one();
12 SELECT global_test_two();
14 -- import python modules
17 SELECT import_succeed();
19 -- test import and simple argument handling
21 SELECT import_test_one('sha hash of this string');
23 -- test import and tuple argument handling
25 select import_test_two(users) from users where fname = 'willem';
27 -- test multiple arguments
29 select argument_test_one(users, fname, lname) from users where lname = 'doe' order by 1;
32 -- spi and nested calls
34 select nested_call_one('pass this along');
35 select spi_prepared_plan_test_one('doe');
36 select spi_prepared_plan_test_one('smith');
37 select spi_prepared_plan_test_nested('smith');
39 -- quick peek at the table
45 UPDATE users SET fname = 'william' WHERE fname = 'willem';
47 -- should modify william to willem and create username
49 INSERT INTO users (fname, lname) VALUES ('william', 'smith');
50 INSERT INTO users (fname, lname, username) VALUES ('charles', 'darwin', 'beagle');
55 SELECT join_sequences(sequences) FROM sequences;
56 SELECT join_sequences(sequences) FROM sequences
57 WHERE join_sequences(sequences) ~* '^A';
58 SELECT join_sequences(sequences) FROM sequences
59 WHERE join_sequences(sequences) ~* '^B';
65 -- Check Universal Newline Support
70 SELECT newline_crlf();