1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26 package fr.ifremer.isisfish.entity;
27
28 import java.util.Collection;
29
30 import org.apache.commons.logging.Log;
31 import org.apache.commons.logging.LogFactory;
32 import org.nuiton.topia.TopiaContext;
33 import org.junit.After;
34 import org.junit.Before;
35 import org.junit.Test;
36
37 import fr.ifremer.isisfish.AbstractIsisFishTest;
38 import fr.ifremer.isisfish.IsisFishDAOHelper;
39 import fr.ifremer.isisfish.datastore.RegionStorage;
40 import fr.ifremer.isisfish.entities.Cell;
41 import fr.ifremer.isisfish.entities.CellDAO;
42 import fr.ifremer.isisfish.entities.EffortDescription;
43 import fr.ifremer.isisfish.entities.EffortDescriptionDAO;
44 import fr.ifremer.isisfish.entities.FisheryRegion;
45 import fr.ifremer.isisfish.entities.FisheryRegionDAO;
46 import fr.ifremer.isisfish.entities.Gear;
47 import fr.ifremer.isisfish.entities.GearDAO;
48 import fr.ifremer.isisfish.entities.Metier;
49 import fr.ifremer.isisfish.entities.MetierDAO;
50 import fr.ifremer.isisfish.entities.MetierSeasonInfo;
51 import fr.ifremer.isisfish.entities.MetierSeasonInfoDAO;
52 import fr.ifremer.isisfish.entities.Population;
53 import fr.ifremer.isisfish.entities.PopulationDAO;
54 import fr.ifremer.isisfish.entities.PopulationGroup;
55 import fr.ifremer.isisfish.entities.PopulationGroupDAO;
56 import fr.ifremer.isisfish.entities.PopulationSeasonInfo;
57 import fr.ifremer.isisfish.entities.PopulationSeasonInfoDAO;
58 import fr.ifremer.isisfish.entities.Port;
59 import fr.ifremer.isisfish.entities.PortDAO;
60 import fr.ifremer.isisfish.entities.Result;
61 import fr.ifremer.isisfish.entities.ResultDAO;
62 import fr.ifremer.isisfish.entities.Season;
63 import fr.ifremer.isisfish.entities.SeasonDAO;
64 import fr.ifremer.isisfish.entities.Selectivity;
65 import fr.ifremer.isisfish.entities.SelectivityDAO;
66 import fr.ifremer.isisfish.entities.SetOfVessels;
67 import fr.ifremer.isisfish.entities.SetOfVesselsDAO;
68 import fr.ifremer.isisfish.entities.Species;
69 import fr.ifremer.isisfish.entities.SpeciesDAO;
70 import fr.ifremer.isisfish.entities.Strategy;
71 import fr.ifremer.isisfish.entities.StrategyDAO;
72 import fr.ifremer.isisfish.entities.StrategyMonthInfo;
73 import fr.ifremer.isisfish.entities.StrategyMonthInfoDAO;
74 import fr.ifremer.isisfish.entities.TargetSpecies;
75 import fr.ifremer.isisfish.entities.TargetSpeciesDAO;
76 import fr.ifremer.isisfish.entities.TripType;
77 import fr.ifremer.isisfish.entities.TripTypeDAO;
78 import fr.ifremer.isisfish.entities.VesselType;
79 import fr.ifremer.isisfish.entities.VesselTypeDAO;
80 import fr.ifremer.isisfish.entities.Zone;
81 import fr.ifremer.isisfish.entities.ZoneDAO;
82
83
84
85
86
87
88
89
90
91
92
93
94 public class PersistenceTest extends AbstractIsisFishTest {
95
96
97
98
99 private static final Log log = LogFactory.getLog(PersistenceTest.class);
100
101
102 protected TopiaContext context = null;
103 protected RegionStorage rs;
104
105 @Before
106 public void setUp() throws Exception {
107 rs = RegionStorage.create("test");
108 context = rs.getStorage();
109 }
110
111 @After
112 public void tearDown() throws Exception {
113 rs.delete(false);
114 }
115
116 @Test
117 public void testInstanciate() throws Exception {
118 TopiaContext context = this.context.beginTransaction();
119
120 FisheryRegionDAO fisheryRegionDAO = IsisFishDAOHelper.getFisheryRegionDAO(context);
121 FisheryRegion fisheryRegion = fisheryRegionDAO.create();
122 log.debug(fisheryRegion + " - " + fisheryRegion.getClass().getName());
123
124 EffortDescriptionDAO effortDescriptionDAO = IsisFishDAOHelper.getEffortDescriptionDAO(context);
125 EffortDescription effortDescription = effortDescriptionDAO.create();
126 log.debug(effortDescription + " - " + effortDescription.getClass().getName());
127
128 GearDAO gearDAO = IsisFishDAOHelper.getGearDAO(context);
129 Gear gear = gearDAO.create();
130 log.debug(gear + " - " + gear.getClass().getName());
131
132 CellDAO cellDAO = IsisFishDAOHelper.getCellDAO(context);
133 Cell cell = cellDAO.create();
134 log.debug(cell + " - " + cell.getClass().getName());
135
136 SpeciesDAO speciesDAO = IsisFishDAOHelper.getSpeciesDAO(context);
137 Species species = speciesDAO.create();
138 log.debug(species + " - " + species.getClass().getName());
139
140 MetierDAO metierDAO = IsisFishDAOHelper.getMetierDAO(context);
141 Metier metier = metierDAO.create();
142 log.debug(metier + " - " + metier.getClass().getName());
143
144 MetierSeasonInfoDAO metierSeasonInfoDAO = IsisFishDAOHelper.getMetierSeasonInfoDAO(context);
145 MetierSeasonInfo metierSeasonInfo = metierSeasonInfoDAO.create();
146 log.debug(metierSeasonInfo + " - " +metierSeasonInfo.getClass().getName());
147
148 PopulationGroupDAO populationGroupDAO = IsisFishDAOHelper.getPopulationGroupDAO(context);
149 PopulationGroup populationGroup = populationGroupDAO.create();
150 log.debug(populationGroup + " - " + populationGroup.getClass().getName());
151
152 PopulationDAO populationDAO = IsisFishDAOHelper.getPopulationDAO(context);
153 Population population = populationDAO.create();
154 log.debug(population + " - " + population.getClass().getName());
155
156 PortDAO portDAO = IsisFishDAOHelper.getPortDAO(context);
157 Port port = portDAO.create();
158 log.debug(port + " - " + port.getClass().getName());
159
160 ResultDAO resultDAO = IsisFishDAOHelper.getResultDAO(context);
161 Result result = resultDAO.create();
162 log.debug(result + " - " + result.getClass().getName());
163
164 SeasonDAO seasonDAO = IsisFishDAOHelper.getSeasonDAO(context);
165 Season season = seasonDAO.create();
166 log.debug(season + " - " + season.getClass().getName());
167
168 PopulationSeasonInfoDAO PopulationSeasonInfoDAO = IsisFishDAOHelper.getPopulationSeasonInfoDAO(context);
169 PopulationSeasonInfo PopulationSeasonInfo = PopulationSeasonInfoDAO.create();
170 log.debug(PopulationSeasonInfo + " - " + PopulationSeasonInfo.getClass().getName());
171
172 SelectivityDAO selectivityDAO = IsisFishDAOHelper.getSelectivityDAO(context);
173 Selectivity selectivity = selectivityDAO.create();
174 log.debug(selectivity + " - " + selectivity.getClass().getName());
175
176 SetOfVesselsDAO setOfVesselsDAO = IsisFishDAOHelper.getSetOfVesselsDAO(context);
177 SetOfVessels setOfVessels = setOfVesselsDAO.create();
178 log.debug(setOfVessels + " - " + setOfVessels.getClass().getName());
179
180 StrategyMonthInfoDAO strategyMonthInfoDAO = IsisFishDAOHelper.getStrategyMonthInfoDAO(context);
181 StrategyMonthInfo strategyMonthInfo = strategyMonthInfoDAO.create();
182 log.debug(strategyMonthInfo + " - " + strategyMonthInfo.getClass().getName());
183
184 StrategyDAO strategyDAO = IsisFishDAOHelper.getStrategyDAO(context);
185 Strategy strategy = strategyDAO.create();
186 log.debug(strategy + " - " + strategy.getClass().getName());
187
188 TargetSpeciesDAO targetSpeciesDAO = IsisFishDAOHelper.getTargetSpeciesDAO(context);
189 TargetSpecies targetSpecies = targetSpeciesDAO.create();
190 log.debug(targetSpecies + " - " + targetSpecies.getClass().getName());
191
192 TripTypeDAO tripTypeDAO = IsisFishDAOHelper.getTripTypeDAO(context);
193 TripType tripType = tripTypeDAO.create();
194 log.debug(tripType + " - " + tripType.getClass().getName());
195
196 VesselTypeDAO vesselTypeDAO = IsisFishDAOHelper.getVesselTypeDAO(context);
197 VesselType vesselType = vesselTypeDAO.create();
198 log.debug(vesselType + " - " + vesselType.getClass().getName());
199
200 ZoneDAO zoneDAO = IsisFishDAOHelper.getZoneDAO(context);
201 Zone zone = zoneDAO.create();
202 log.debug(zone + " - " + zone.getClass().getName());
203
204 context.rollbackTransaction();
205 context.closeContext();
206 }
207
208
209 @Test
210 public void testMakePersistence() throws Exception {
211 TopiaContext context = this.context.beginTransaction();
212
213
214
215
216
217 {
218 FisheryRegionDAO ps = IsisFishDAOHelper.getFisheryRegionDAO(context);
219 FisheryRegion o = ps.create();
220 o = ps.update(o);
221 }
222
223
224
225
226
227 {
228 EffortDescriptionDAO ps = IsisFishDAOHelper.getEffortDescriptionDAO(context);
229 EffortDescription o = ps.create();
230 o = ps.update(o);
231 }
232
233
234
235
236
237
238
239
240
241
242 {
243 GearDAO ps = IsisFishDAOHelper.getGearDAO(context);
244 Gear o = ps.create();
245 o = ps.update(o);
246 }
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262 {
263 CellDAO ps = IsisFishDAOHelper.getCellDAO(context);
264 Cell o = ps.create();
265 o = ps.update(o);
266 }
267 {
268 SpeciesDAO ps = IsisFishDAOHelper.getSpeciesDAO(context);
269 Species o = ps.create();
270 o = ps.update(o);
271 }
272 {
273 MetierDAO ps = IsisFishDAOHelper.getMetierDAO(context);
274 Metier o = ps.create();
275 o = ps.update(o);
276 }
277 {
278 MetierSeasonInfoDAO ps = IsisFishDAOHelper.getMetierSeasonInfoDAO(context);
279 MetierSeasonInfo o = ps.create();
280 o = ps.update(o);
281 }
282
283
284
285
286
287 {
288
289 PopulationGroupDAO ps = IsisFishDAOHelper.getPopulationGroupDAO(context);
290 PopulationGroup o = ps.create();
291 o = ps.update(o);
292
293
294
295
296 }
297 {
298 PopulationDAO ps = IsisFishDAOHelper.getPopulationDAO(context);
299 Population o = ps.create();
300 o = ps.update(o);
301 }
302 {
303 PortDAO ps = IsisFishDAOHelper.getPortDAO(context);
304 Port o = ps.create();
305 o = ps.update(o);
306 }
307 {
308 ResultDAO ps = IsisFishDAOHelper.getResultDAO(context);
309 Result o = ps.create();
310 o = ps.update(o);
311 }
312 {
313 PopulationSeasonInfoDAO ps = IsisFishDAOHelper.getPopulationSeasonInfoDAO(context);
314 PopulationSeasonInfo o = ps.create();
315 o = ps.update(o);
316 }
317 {
318 SelectivityDAO ps = IsisFishDAOHelper.getSelectivityDAO(context);
319 Selectivity o = ps.create();
320 o = ps.update(o);
321 }
322 {
323 SetOfVesselsDAO ps = IsisFishDAOHelper.getSetOfVesselsDAO(context);
324 SetOfVessels o = ps.create();
325 o = ps.update(o);
326 }
327
328
329
330
331
332 {
333 StrategyMonthInfoDAO ps = IsisFishDAOHelper.getStrategyMonthInfoDAO(context);
334 StrategyMonthInfo o = ps.create();
335 o = ps.update(o);
336 }
337 {
338 StrategyDAO ps = IsisFishDAOHelper.getStrategyDAO(context);
339 Strategy o = ps.create();
340 o = ps.update(o);
341 }
342 {
343 TargetSpeciesDAO ps = IsisFishDAOHelper.getTargetSpeciesDAO(context);
344 TargetSpecies o = ps.create();
345 o = ps.update(o);
346 }
347 {
348 TripTypeDAO ps = IsisFishDAOHelper.getTripTypeDAO(context);
349 TripType o = ps.create();
350 o = ps.update(o);
351 }
352 {
353 VesselTypeDAO ps = IsisFishDAOHelper.getVesselTypeDAO(context);
354 VesselType o = ps.create();
355 o = ps.update(o);
356 }
357 {
358 ZoneDAO ps = IsisFishDAOHelper.getZoneDAO(context);
359 Zone o = ps.create();
360 o = ps.update(o);
361 }
362 context.rollbackTransaction();
363 context.closeContext();
364 }
365
366 @Test
367 public void testFindAll() throws Exception {
368 TopiaContext context = this.context.beginTransaction();
369
370
371
372
373
374 {
375 FisheryRegionDAO ps = IsisFishDAOHelper.getFisheryRegionDAO(context);
376 Collection<FisheryRegion> list = ps.findAll();
377 log.debug(list + " - " +ps.getClass().getName());
378 }
379
380
381
382
383 {
384 EffortDescriptionDAO ps = IsisFishDAOHelper.getEffortDescriptionDAO(context);
385 Collection<EffortDescription> list = ps.findAll();
386 log.debug(list + " - " +ps.getClass().getName());
387 }
388
389
390
391
392
393 {
394 GearDAO ps = IsisFishDAOHelper.getGearDAO(context);
395 Collection<Gear> list = ps.findAll();
396 log.debug(list + " - " +ps.getClass().getName());
397 }
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413 {
414 CellDAO ps = IsisFishDAOHelper.getCellDAO(context);
415 Collection<Cell> list = ps.findAll();
416 log.debug(list + " - " +ps.getClass().getName());
417 }
418 {
419 SpeciesDAO ps = IsisFishDAOHelper.getSpeciesDAO(context);
420 Collection<Species> list = ps.findAll();
421 log.debug(list + " - " +ps.getClass().getName());
422 }
423 {
424 MetierDAO ps = IsisFishDAOHelper.getMetierDAO(context);
425 Collection<Metier> list = ps.findAll();
426 log.debug(list + " - " +ps.getClass().getName());
427 }
428 {
429 MetierSeasonInfoDAO ps = IsisFishDAOHelper.getMetierSeasonInfoDAO(context);
430 Collection<MetierSeasonInfo> list = ps.findAll();
431 log.debug(list + " - " +ps.getClass().getName());
432 }
433
434
435
436
437
438 {
439 PopulationGroupDAO ps = IsisFishDAOHelper.getPopulationGroupDAO(context);
440 Collection<PopulationGroup> list = ps.findAll();
441 log.debug(list + " - " +ps.getClass().getName());
442 }
443 {
444 PopulationDAO ps = IsisFishDAOHelper.getPopulationDAO(context);
445 Collection<Population> list = ps.findAll();
446 log.debug(list + " - " +ps.getClass().getName());
447 }
448 {
449 PortDAO ps = IsisFishDAOHelper.getPortDAO(context);
450 Collection<Port> list = ps.findAll();
451 log.debug(list + " - " +ps.getClass().getName());
452 }
453 {
454 ResultDAO ps = IsisFishDAOHelper.getResultDAO(context);
455 Collection<Result> list = ps.findAll();
456 log.debug(list + " - " +ps.getClass().getName());
457 }
458 {
459 PopulationSeasonInfoDAO ps = IsisFishDAOHelper.getPopulationSeasonInfoDAO(context);
460 Collection<PopulationSeasonInfo> list = ps.findAll();
461 log.debug(list + " - " +ps.getClass().getName());
462 }
463 {
464 SelectivityDAO ps = IsisFishDAOHelper.getSelectivityDAO(context);
465 Collection<Selectivity> list = ps.findAll();
466 log.debug(list + " - " +ps.getClass().getName());
467 }
468 {
469 SetOfVesselsDAO ps = IsisFishDAOHelper.getSetOfVesselsDAO(context);
470 Collection<SetOfVessels> list = ps.findAll();
471 log.debug(list + " - " +ps.getClass().getName());
472 }
473
474
475
476
477 {
478 StrategyMonthInfoDAO ps = IsisFishDAOHelper.getStrategyMonthInfoDAO(context);
479 Collection<StrategyMonthInfo> list = ps.findAll();
480 log.debug(list + " - " +ps.getClass().getName());
481 }
482 {
483 StrategyDAO ps = IsisFishDAOHelper.getStrategyDAO(context);
484 Collection<Strategy> list = ps.findAll();
485 log.debug(list + " - " +ps.getClass().getName());
486 }
487 {
488 TargetSpeciesDAO ps = IsisFishDAOHelper.getTargetSpeciesDAO(context);
489 Collection<TargetSpecies> list = ps.findAll();
490 log.debug(list + " - " +ps.getClass().getName());
491 }
492 {
493 TripTypeDAO ps = IsisFishDAOHelper.getTripTypeDAO(context);
494 Collection<TripType> list = ps.findAll();
495 log.debug(list + " - " +ps.getClass().getName());
496 }
497 {
498 VesselTypeDAO ps = IsisFishDAOHelper.getVesselTypeDAO(context);
499 Collection<VesselType> list = ps.findAll();
500 log.debug(list + " - " +ps.getClass().getName());
501 }
502 {
503 ZoneDAO ps = IsisFishDAOHelper.getZoneDAO(context);
504 Collection<Zone> list = ps.findAll();
505 log.debug(list + " - " +ps.getClass().getName());
506 }
507 context.rollbackTransaction();
508 context.closeContext();
509 }
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768 }
769