pg.ddx.io  pgsql-students@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Muhammad Suleman Mahmood <m.suleman.mahmood@gmail.com>
To: pgsql-students@postgresql.org <pgsql-students@postgresql.org>
Subject: Re: Project Proposal: Automated Test Case Generation for PL/pgSQL
Date: Mon, 23 Mar 2015 09:59:37 -0700
Message-ID: <55104679.8060406@agliodbs.com> (raw)
In-Reply-To: <CAByiCu0yhdUYXX2_f+owOHU1i2nhnySShrObbe9RGJhcOnPFeQ@mail.gmail.com>
References: <CAByiCu0yhdUYXX2_f+owOHU1i2nhnySShrObbe9RGJhcOnPFeQ@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-students>

Muhammad:

I'm copying this over to the pgsql-students mailing list, which is the
normal place to discuss GSOC proposals.

See below for my comments.

On 03/23/2015 07:06 AM, Muhammad Suleman Mahmood wrote:
> Hi,
> 
> I am a Masters Student in Computer Science at Lahore University of
> Management Sciences (www.lums.edu.pk <http://www.lums.edu.pk;).
> 
> I am working on Automated Test Case generation for Pl/pgSQL procedures
> for my Thesis i.e. Both procedure inputs and table data is generated to
> drive the procedure execution along a particular path. The aim is to
> automatically generate a test suite for a procedure that explores all
> reachable paths.
> 
> I would like to propose this in Google summer of code but first I wanted
> to share some details with you.
> 
> The high level idea is to instrument the PostgreSQL database to produce
> detailed logs of procedure execution and an external program will
> convert this to constraints that are solved by Z3 solver to generate a
> test case.
> 
> The proposal for Google Summer of code is to add the instrumentation
> code in PostgreSQL and activate/deactivate the instrumentation based on
> compile time configuration. We can also add the development of the
> external program to this and offer this as a utility with PostgreSQL.
> The external program is written so far is available on Github as a
> public repository. https://github.com/SulemanMahmood/Thesis.git
> 
> We have had some success in this so far for simple cases. If you wish I
> can share some results with you. What is your opinion on this as a
> proposed project.
> 
> Regards
> Suleman
> 
> PS:
> The technique we are using is based on concolic execution which has been
> applied in a wide variety of test case generation tools.

I'm not certain that GSOC allows for testing projects.  They have some
restrictions on what kind of projects you can do for GSOC, which
generally doesn't include "support" projects.  We'd have to ask.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


-- 
Sent via pgsql-students mailing list (pgsql-students@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-students



Message-ID: <55104679.8060406@agliodbs.com>
Permalink:  ../55104679.8060406@agliodbs.com/
Also on:    postgresql.org/message-id/55104679.8060406@agliodbs.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-students@postgresql.org
  Cc: josh@agliodbs.com, m.suleman.mahmood@gmail.com
  Subject: Re: Project Proposal: Automated Test Case Generation for PL/pgSQL
  In-Reply-To: <55104679.8060406@agliodbs.com>
  References: <CAByiCu0yhdUYXX2_f+owOHU1i2nhnySShrObbe9RGJhcOnPFeQ@mail.gmail.com> <55104679.8060406@agliodbs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox