Return-Path: X-Original-To: apmail-cayenne-user-archive@www.apache.org Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DEC1D1811B for ; Thu, 17 Mar 2016 13:33:51 +0000 (UTC) Received: (qmail 29685 invoked by uid 500); 17 Mar 2016 13:33:51 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 29655 invoked by uid 500); 17 Mar 2016 13:33:51 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 29642 invoked by uid 99); 17 Mar 2016 13:33:51 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Mar 2016 13:33:51 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id EB62EC323B for ; Thu, 17 Mar 2016 13:33:50 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.999 X-Spam-Level: X-Spam-Status: No, score=0.999 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001] autolearn=disabled Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id vf1ZEr3bJL1D for ; Thu, 17 Mar 2016 13:33:48 +0000 (UTC) Received: from mail-03.1984.is (mail-03.1984.is [93.95.224.70]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 8BB945F1EC for ; Thu, 17 Mar 2016 13:33:48 +0000 (UTC) Received: from localhost by mail-03.1984.is with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.84) (envelope-from ) id 1agY3Y-0003DJ-B2 for user@cayenne.apache.org; Thu, 17 Mar 2016 13:33:40 +0000 Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 9.2 \(3112\)) Subject: Re: Populating a test DB for use with Cayenne From: Hugi Thordarson In-Reply-To: Date: Thu, 17 Mar 2016 13:33:35 +0000 Content-Transfer-Encoding: quoted-printable Message-Id: <98FEDABE-9063-43A5-99EC-126CEAF3E2C7@karlmenn.is> References: <2FB978FD-4564-49A2-98F2-45A92F3B41B2@karlmenn.is> To: user@cayenne.apache.org X-Mailer: Apple Mail (2.3112) Thanks, Michael and Ari! I=E2=80=99m going to look at both this and = DBUnit (I=E2=80=99m currently using H2 so RunScript looks like it might = fit the bill). Cheers, - hugi > On 16. mar. 2016, at 22:22, Michael Gentry = wrote: >=20 > For H2, I've used: >=20 > http://www.h2database.com/javadoc/org/h2/tools/RunScript.html >=20 > Then create some SQL scripts with bulk inserts of test data. >=20 > mrg >=20 >=20 > On Wed, Mar 16, 2016 at 6:31 AM, Hugi Thordarson = wrote: >=20 >> Hi all. >>=20 >> Just out of curiosity; how are you guys populating your test DBs = before >> running tests? Has anyone written something brilliant to do it with = e.g. >> .yml-files (via Cayenne)? Are you doing it via SQL-scripts? In code = perhaps? >>=20 >> I=E2=80=99m currently creating my test DBs in code (using Cayenne) = and it becomes >> cumbersome when they reach a certain size :). >>=20 >> Cheers, >> - hugi