Skip site navigation (1) Skip section navigation (2)

pgScript presentation

From: "Mickael Deloison" <mdeloison(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: pgScript presentation
Date: 2008-04-25 07:49:26
Message-ID: 1f8f052b0804250049j5fe254dcwfbd4eeb8af6e1959@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
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

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2008-04-25 07:59:31
Subject: Re: pgScript presentation
Previous:From: Guillaume LelargeDate: 2008-04-24 07:20:00
Subject: Re: bug: no SQL generated for comment on column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group