Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ya5hg-0005Ck-PK for pgsql-students@arkaria.postgresql.org; Mon, 23 Mar 2015 16:59:52 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Ya5hf-0004gz-V5 for pgsql-students@arkaria.postgresql.org; Mon, 23 Mar 2015 16:59:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Ya5hf-0004gt-DY for pgsql-students@postgresql.org; Mon, 23 Mar 2015 16:59:51 +0000 Received: from mx-out.zmailcloud.com ([192.198.85.98] helo=mx-out-1.zmailcloud.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ya5ha-0007KU-5k for pgsql-students@postgresql.org; Mon, 23 Mar 2015 16:59:49 +0000 Received: from smtp.01.com (smtp.01.com [10.10.0.43]) by mx-out-1.zmailcloud.com (Postfix) with ESMTP id DCD735646ED; Mon, 23 Mar 2015 11:59:43 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by smtp-out-2.01.com (Postfix) with ESMTP id CEAA1601B9; Mon, 23 Mar 2015 11:59:43 -0500 (CDT) X-Virus-Scanned: amavisd-new at smtp-out-2.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-2.01.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id idNkd4wkCz8J; Mon, 23 Mar 2015 11:59:43 -0500 (CDT) Received: from smtp.01.com (localhost [127.0.0.1]) by smtp-out-2.01.com (Postfix) with ESMTP id AC597601DA; Mon, 23 Mar 2015 11:59:43 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by smtp-out-2.01.com (Postfix) with ESMTP id 95897601B9; Mon, 23 Mar 2015 11:59:43 -0500 (CDT) X-Virus-Scanned: amavisd-new at smtp-out-2.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-2.01.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id NpiSSFdTOTvN; Mon, 23 Mar 2015 11:59:43 -0500 (CDT) Received: from [172.47.23.102] (50-0-89-53.dsl.dynamic.fusionbroadband.com [50.0.89.53]) by smtp-out-2.01.com (Postfix) with ESMTPSA id 62550601E5; Mon, 23 Mar 2015 11:59:39 -0500 (CDT) Message-ID: <55104679.8060406@agliodbs.com> Date: Mon, 23 Mar 2015 09:59:37 -0700 From: Josh Berkus Organization: PostgreSQL Experts Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.4.0 MIME-Version: 1.0 To: Muhammad Suleman Mahmood , "pgsql-students@postgresql.org" Subject: Re: Project Proposal: Automated Test Case Generation for PL/pgSQL References: In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-students Precedence: bulk Sender: pgsql-students-owner@postgresql.org 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 ). > > 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