Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bjjOG-00053a-8a for pgadmin-hackers@arkaria.postgresql.org; Tue, 13 Sep 2016 08:48:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bjjOF-000815-Ie for pgadmin-hackers@arkaria.postgresql.org; Tue, 13 Sep 2016 08:48:27 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bjjO2-0007mj-CY for pgadmin-hackers@postgresql.org; Tue, 13 Sep 2016 08:48:14 +0000 Received: from mail-it0-x229.google.com ([2607:f8b0:4001:c0b::229]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bjjNz-0005KA-1W for pgadmin-hackers@postgresql.org; Tue, 13 Sep 2016 08:48:12 +0000 Received: by mail-it0-x229.google.com with SMTP id x192so7674511itb.0 for ; Tue, 13 Sep 2016 01:48:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-transfer-encoding; bh=is8Ec575NZ+TkYP/oET2R7AoUfKO40WwSSM7LWChE/w=; b=AC5J1NSk08i1Oz2cnz3hiIfYf0+3k+H/Cl0K6RFMjAr/4JCMtrK0JBiYQCYGYh6xYe bIPbsimZQdactg+NpKS7wbJ3SXMImrsunIk778pw0fii45aq1n4OkULuYzDsJtn2T6ro E32VfUbOMxDOyVhCCCvSsUtxPUoN/+q2rc7y3I/Vsvx2IJIgi/9tjhEGAEw/5Q0upt4Y qvU6IMa28K7Ry0Y585VcGh3CkITkoGx/T7BoCQl9iEv5bOWoMn55GtQbr5CU95OFGMCA yglCVoZEqitEhny6UaSvdWF18ht2ocA1JMlNsEF7SObvqKv1ITIeQmMNb0Ku2yhnglXx i5jw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc:content-transfer-encoding; bh=is8Ec575NZ+TkYP/oET2R7AoUfKO40WwSSM7LWChE/w=; b=PbHG6iEr+6pV3hwH8LhCPupv8hsGz4/roCLw3wvT0oQXRoi0YNnRCbdvUpCqoGYWUO EJ5/GNrY4PzvoGDyAhYwuANqcCZ/337ARaQGRBD//1EsFxBYKDv0P+tZ40/x1V3Dbijl vpYPSRS4AA/qibOHyowOa0NOmK4kkosmoj8b9GmMkz4QCJGqS0L7yYHJVKNEL8RIvvtw MYWC653bvJ5IGz/ekFMrluMDqlH9wH8fKg4KMZTnAUiGnWlkF22ks9H48//0l8yBHoIN bLv/Vn73UiPhzLmhSOiHwmqZBlvsmJm64t5vvlkA8i6i7H6mRVzjibH8mrol3KL756c4 58rQ== X-Gm-Message-State: AE9vXwMYuvedPIguPmUUOHSVAijk/ainKqARjdMR/3U137oyW8aiO5kmayLrOj7HHH1k1DKyzT+SpetBS1nYxnPmq3YogoVm517EJ3ILOJAMPSXSY+b856kpW/AGSU82AXLq0MRXNMarF+Sy5KYFoI+p4wQD3tSEaH+aaRom6FEXp7b9SUxzGEgDPEPWa8zpTgO80Fzzcw== X-Received: by 10.107.181.211 with SMTP id e202mr157135iof.99.1473756489975; Tue, 13 Sep 2016 01:48:09 -0700 (PDT) Received: from mail-it0-f52.google.com (mail-it0-f52.google.com. [209.85.214.52]) by smtp.gmail.com with ESMTPSA id x100sm2787786ioe.31.2016.09.13.01.48.09 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 13 Sep 2016 01:48:09 -0700 (PDT) Received: by mail-it0-f52.google.com with SMTP id x192so7674405itb.0 for ; Tue, 13 Sep 2016 01:48:09 -0700 (PDT) X-Received: by 10.107.130.25 with SMTP id e25mr165131iod.46.1473756488905; Tue, 13 Sep 2016 01:48:08 -0700 (PDT) MIME-Version: 1.0 Received: by 10.64.1.203 with HTTP; Tue, 13 Sep 2016 01:48:08 -0700 (PDT) In-Reply-To: References: From: Dave Page Date: Tue, 13 Sep 2016 09:48:08 +0100 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: Server specific advanced config file for testsuite To: Navnath Gadakh Cc: Kanchan Mohitey , pgadmin-hackers Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -2.1 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org Hi On Mon, Sep 12, 2016 at 6:26 PM, Navnath Gadakh wrote: > Hi Dave, > As we know that, we are using two JSON files one is for basic > configuration of server(test_config.json) and second for detailed > configuration of server(test_advanced_config.json). > In test_advanced_config.json, we give detail for database, schema, > extension, collation etc. These details are generic I mean these details = are > not server specific. > - Do we need to allow user to give server specific details? I don't see any reason to do so. Honestly I don't see much need for test_advanced_config.json at all - I can't see anyone ever customising the tests. I certainly doubt I will. > If yes, there should be some identification(like =E2=80=98server_type=E2= =80=99, =E2=80=98version=E2=80=99) > for each detail so that we can read server appropriate details. > We have one approach in mind, to attach 'server_type' & 'version' to each > detail > So, modified test_advanced_config.json can be like this, > { > "add_database_data=E2=80=9D:[ > { > "conn_limit": -1, > =E2=80=9Cowner=E2=80=9D: =E2=80=9Cpostres=E2=80=9D, > . > . > . > . > =E2=80=9Cserver_type=E2=80=9D: =E2=80=9Cpg=E2=80=9D, > =E2=80=9Cversion=E2=80=9D: =E2=80=9Cpg9.4=E2=80=9D > }, > { > { > "conn_limit": -1, > =E2=80=9Cowner=E2=80=9D: =E2=80=9Centerprisedb=E2=80=9D, > . > . > . > . > =E2=80=9Cserver_type=E2=80=9D: =E2=80=9Cppas=E2=80=9D, > =E2=80=9Cversion=E2=80=9D: =E2=80=9Cppas9.6=E2=80=9D > } > }], > =E2=80=9Cschema_credentials=E2=80=9D: > [{"func_acl": [], > "seq_acl": [], > . > . > . > . > =E2=80=9Cserver_type=E2=80=9D: =E2=80=9Cpg=E2=80=9D, > =E2=80=9Cversion=E2=80=9D: =E2=80=9Cpg9.4=E2=80=9D > }] > . > . > . > . > . > } > > Any suggestions? > > For multiple server currently we used 'owner' to identify the server, but > that fails if two servers have the same owner. > > > -- > Thanks, > Navnath Gadakh > Software Engineer > EnterpriseDB Corporation > Mobile: +91 9975389878 > > --=20 Dave Page VP, Chief Architect, Tools & Installers EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company Blog: http://pgsnake.blogspot.com Twitter: @pgsnake --=20 Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers