Hi,
I am going to work on pgScript during Google Summer of Code. The goal
of this project is to add some capabilities to the SQL Query tool of
pgAdmin through a scripting language. The scripting language will be
based either on the C-syntax or the T-SQL syntax, it is up to the user
to decide which one he prefers. These capabilities are:
* Simple and efficient random data generators for generating huge
amount of test data,
* T-SQL syntax compatibility (however it is run on the pgAdmin/client
side, and the real T-SQL is on the server side),
* Control structures (if, for, while) and smart data types to have
more control in SQL scripts,
* Assert statements for a better control of returned data in SQL scripts
It is also going to be possible to use the piece of software as a
standalone program or shared library.
Example (with the C-syntax):
if (!(select 1 from my_table))
create table my_table ... /* create table if it does not exist */
my_gen = string(10, 20); /* string generator */
for (int i = 0; i < 5; i++)
insert into my_table ('{my_gen}'); /* insert random string */
assert((select * from my_table).size() == 5);
For this project I am going to be mentored by Magnus Hagander. The
project is already started because I made a demo for my Summer of Code
application. Therefore, in a first time I am going to finish it, I
mean finish and test pgScript as a standalone package. Then I am going
to focus on the pgAdmin integration. For the first part and before
getting something really usable I will essentially communicate with my
mentor. Then I will announce pgScript.
I look forward to working on this project.
Mickael
