1 -- first some tests of basic functionality
11 -- check static and global data
25 SELECT global_test_one();
27 --------------------------------------------------------
28 SD: set by global_test_one, GD: set by global_test_one
31 SELECT global_test_two();
33 --------------------------------------------------------
34 SD: set by global_test_two, GD: set by global_test_one
37 -- import python modules
40 NOTICE: ('import socket failed -- No module named foosocket',)
46 SELECT import_succeed();
48 ------------------------
49 succeeded, as expected
52 -- test import and simple argument handling
54 SELECT import_test_one('sha hash of this string');
56 ------------------------------------------
57 a04e23cb9b1a09cd1051a04a7c571aae0f90346c
60 -- test import and tuple argument handling
62 select import_test_two(users) from users where fname = 'willem';
64 -------------------------------------------------------------------
65 sha hash of willemdoe is 3cde6b574953b0ca937b4d76ebc40d534d910759
68 -- test multiple arguments
70 select argument_test_one(users, fname, lname) from users where lname = 'doe' order by 1;
72 -----------------------------------------------------------------------
73 jane doe => {fname: jane, lname: doe, userid: 1, username: j_doe}
74 john doe => {fname: john, lname: doe, userid: 2, username: johnd}
75 willem doe => {fname: willem, lname: doe, userid: 3, username: w_doe}
78 -- spi and nested calls
80 select nested_call_one('pass this along');
82 -----------------------------------------------------------------
83 {'nested_call_two': "{'nested_call_three': 'pass this along'}"}
86 select spi_prepared_plan_test_one('doe');
87 spi_prepared_plan_test_one
88 ----------------------------
92 select spi_prepared_plan_test_one('smith');
93 spi_prepared_plan_test_one
94 ----------------------------
98 select spi_prepared_plan_test_nested('smith');
99 spi_prepared_plan_test_nested
100 -------------------------------
104 -- quick peek at the table
107 fname | lname | username | userid
108 --------+-------+----------+--------
109 jane | doe | j_doe | 1
110 john | doe | johnd | 2
111 willem | doe | w_doe | 3
112 rick | smith | slash | 4
117 UPDATE users SET fname = 'william' WHERE fname = 'willem';
118 -- should modify william to willem and create username
120 INSERT INTO users (fname, lname) VALUES ('william', 'smith');
121 INSERT INTO users (fname, lname, username) VALUES ('charles', 'darwin', 'beagle');
123 fname | lname | username | userid
124 ---------+--------+----------+--------
125 jane | doe | j_doe | 1
126 john | doe | johnd | 2
127 willem | doe | w_doe | 3
128 rick | smith | slash | 4
129 willem | smith | w_smith | 5
130 charles | darwin | beagle | 6
133 SELECT join_sequences(sequences) FROM sequences;
144 SELECT join_sequences(sequences) FROM sequences
145 WHERE join_sequences(sequences) ~* '^A';
156 SELECT join_sequences(sequences) FROM sequences
157 WHERE join_sequences(sequences) ~* '^B';
165 -- Check Universal Newline Support
179 SELECT newline_crlf();
185 -- Tests for functions returning void
186 SELECT test_void_func1(), test_void_func1() IS NULL AS "is null";
187 test_void_func1 | is null
188 -----------------+---------
192 SELECT test_void_func2(); -- should fail
193 ERROR: unexpected return value from plpython procedure
194 DETAIL: void-returning functions must return "None"
195 SELECT test_return_none(), test_return_none() IS NULL AS "is null";
196 test_return_none | is null
197 ------------------+---------