View Javadoc

1   // Do not edit this file!  It was generated by Melati POEM's DSD preprocessor.
2   
3   package org.paneris.bibliomania.generated;
4   
5   
6   import java.sql.Timestamp;
7   import org.melati.poem.AccessPoemException;
8   import org.melati.poem.Column;
9   import org.melati.poem.Database;
10  import org.melati.poem.DefinitionSource;
11  import org.melati.poem.DisplayLevel;
12  import org.melati.poem.DoublePoemType;
13  import org.melati.poem.Field;
14  import org.melati.poem.IntegerPoemType;
15  import org.melati.poem.JdbcPersistent;
16  import org.melati.poem.Persistent;
17  import org.melati.poem.PoemException;
18  import org.melati.poem.ReferencePoemType;
19  import org.melati.poem.Searchability;
20  import org.melati.poem.TimestampPoemType;
21  import org.melati.poem.TroidPoemType;
22  import org.melati.poem.ValidationPoemException;
23  import org.paneris.bibliomania.BibliomaniaDatabaseTables;
24  import org.paneris.bibliomania.BibliomaniaTable;
25  import org.paneris.bibliomania.OrderStatus;
26  import org.paneris.bibliomania.Product;
27  import org.paneris.bibliomania.ShopOrder;
28  import org.paneris.bibliomania.ShopOrderItem;
29  import org.paneris.bibliomania.Supplier;
30  // FIXME extended table 
31  import org.paneris.bibliomania.User;
32  
33  
34  /**
35   * Melati POEM generated base class for <code>Table</code> <code>ShopOrderItem</code>.
36   *
37   * see org.melati.poem.prepro.TableDef#generateTableBaseJava 
38   */
39  
40  public class ShopOrderItemTableBase<T extends ShopOrderItem> extends BibliomaniaTable<T> {
41  
42    private Column<Integer> col_id = null;
43    private Column<Integer> col_user = null;
44    private Column<Integer> col_product = null;
45    private Column<Integer> col_supplier = null;
46    private Column<Integer> col_status = null;
47    private Column<Integer> col_quantity = null;
48    private Column<Timestamp> col_date = null;
49    private Column<Timestamp> col_fufilleddate = null;
50    private Column<Integer> col_order = null;
51    private Column<Double> col_amount = null;
52    private Column<Double> col_delivery = null;
53    private Column<Double> col_amountUK = null;
54    private Column<Double> col_deliveryUK = null;
55  
56   /**
57    * Constructor. 
58    * 
59    * see org.melati.poem.prepro.TableDef#generateTableBaseJava 
60    * @param database          the POEM database we are using
61    * @param name              the name of this <code>Table</code>
62    * @param definitionSource  which definition is being used
63    * @throws PoemException    if anything goes wrong
64    */
65  
66    public ShopOrderItemTableBase(
67        Database database, String name,
68        DefinitionSource definitionSource) throws PoemException {
69      super(database, name, definitionSource);
70    }
71  
72  
73   /**
74    * Get the database tables.
75    *
76    * see org.melati.poem.prepro.TableDef#generateTableBaseJava 
77    * @return the database tables
78    */
79    public BibliomaniaDatabaseTables getBibliomaniaDatabaseTables() {
80      return (BibliomaniaDatabaseTables)getDatabase();
81    }
82  
83  
84   /**
85    * Initialise this table by defining its columns.
86    *
87    * see org.melati.poem.prepro.TableDef#generateTableBaseJava 
88    */
89    public void init() throws PoemException {
90      super.init();
91      defineColumn(col_id =
92          new Column<Integer>(this, "id",
93                     new TroidPoemType(),
94                     DefinitionSource.dsd) { 
95            public Object getCooked(Persistent g)
96                throws AccessPoemException, PoemException {
97              return ((ShopOrderItem)g).getId();
98            }
99  
100           public void setCooked(Persistent g, Object cooked)
101               throws AccessPoemException, ValidationPoemException {
102             ((ShopOrderItem)g).setId((Integer)cooked);
103           }
104 
105           public Field<Integer> asField(Persistent g) {
106             return ((ShopOrderItem)g).getIdField();
107           }
108 
109           public boolean defaultUserEditable() {
110             return false;
111           }
112 
113           public boolean defaultUserCreateable() {
114             return false;
115           }
116 
117           public DisplayLevel defaultDisplayLevel() {
118             return DisplayLevel.record;
119           }
120 
121           public Searchability defaultSearchability() {
122             return Searchability.no;
123           }
124 
125           public int defaultDisplayOrder() {
126             return 0;
127           }
128 
129           public Object getRaw_unsafe(Persistent g)
130               throws AccessPoemException {
131             return ((ShopOrderItem)g).getId_unsafe();
132           }
133 
134           public void setRaw_unsafe(Persistent g, Object raw)
135               throws AccessPoemException {
136             ((ShopOrderItem)g).setId_unsafe((Integer)raw);
137           }
138 
139           public Object getRaw(Persistent g)
140               throws AccessPoemException {
141             return ((ShopOrderItem)g).getId();
142           }
143 
144           public void setRaw(Persistent g, Object raw)
145               throws AccessPoemException {
146             ((ShopOrderItem)g).setId((Integer)raw);
147           }
148         });
149 
150     defineColumn(col_user =
151         new Column<Integer>(this, "user",
152                    new ReferencePoemType(getBibliomaniaDatabaseTables().
153                                              getUserTable(), false),
154                    DefinitionSource.dsd) { 
155           public Object getCooked(Persistent g)
156               throws AccessPoemException, PoemException {
157             return ((ShopOrderItem)g).getUser();
158           }
159 
160           public void setCooked(Persistent g, Object cooked)
161               throws AccessPoemException, ValidationPoemException {
162             ((ShopOrderItem)g).setUser((User)cooked);
163           }
164 
165           public Field<Integer> asField(Persistent g) {
166             return ((ShopOrderItem)g).getUserField();
167           }
168 
169           public DisplayLevel defaultDisplayLevel() {
170             return DisplayLevel.summary;
171           }
172 
173           public Searchability defaultSearchability() {
174             return Searchability.primary;
175           }
176 
177           public Integer defaultDisplayOrderPriority() {
178             return new Integer(0);
179           }
180 
181           public String defaultDisplayName() {
182             return "User";
183           }
184 
185           public int defaultDisplayOrder() {
186             return 1;
187           }
188 
189           public boolean defaultIndexed() {
190             return true;
191           }
192 
193           public String defaultRenderinfo() {
194             return "SelectionWindow";
195           }
196 
197           public Object getRaw_unsafe(Persistent g)
198               throws AccessPoemException {
199             return ((ShopOrderItem)g).getUser_unsafe();
200           }
201 
202           public void setRaw_unsafe(Persistent g, Object raw)
203               throws AccessPoemException {
204             ((ShopOrderItem)g).setUser_unsafe((Integer)raw);
205           }
206 
207           public Object getRaw(Persistent g)
208               throws AccessPoemException {
209             return ((ShopOrderItem)g).getUserTroid();
210           }
211 
212           public void setRaw(Persistent g, Object raw)
213               throws AccessPoemException {
214             ((ShopOrderItem)g).setUserTroid((Integer)raw);
215           }
216         });
217 
218     defineColumn(col_product =
219         new Column<Integer>(this, "product",
220                    new ReferencePoemType(getBibliomaniaDatabaseTables().
221                                              getProductTable(), false),
222                    DefinitionSource.dsd) { 
223           public Object getCooked(Persistent g)
224               throws AccessPoemException, PoemException {
225             return ((ShopOrderItem)g).getProduct();
226           }
227 
228           public void setCooked(Persistent g, Object cooked)
229               throws AccessPoemException, ValidationPoemException {
230             ((ShopOrderItem)g).setProduct((Product)cooked);
231           }
232 
233           public Field<Integer> asField(Persistent g) {
234             return ((ShopOrderItem)g).getProductField();
235           }
236 
237           public DisplayLevel defaultDisplayLevel() {
238             return DisplayLevel.summary;
239           }
240 
241           public Searchability defaultSearchability() {
242             return Searchability.yes;
243           }
244 
245           public Integer defaultDisplayOrderPriority() {
246             return new Integer(1);
247           }
248 
249           public String defaultDisplayName() {
250             return "Product";
251           }
252 
253           public int defaultDisplayOrder() {
254             return 2;
255           }
256 
257           public boolean defaultIndexed() {
258             return true;
259           }
260 
261           public Object getRaw_unsafe(Persistent g)
262               throws AccessPoemException {
263             return ((ShopOrderItem)g).getProduct_unsafe();
264           }
265 
266           public void setRaw_unsafe(Persistent g, Object raw)
267               throws AccessPoemException {
268             ((ShopOrderItem)g).setProduct_unsafe((Integer)raw);
269           }
270 
271           public Object getRaw(Persistent g)
272               throws AccessPoemException {
273             return ((ShopOrderItem)g).getProductTroid();
274           }
275 
276           public void setRaw(Persistent g, Object raw)
277               throws AccessPoemException {
278             ((ShopOrderItem)g).setProductTroid((Integer)raw);
279           }
280         });
281 
282     defineColumn(col_supplier =
283         new Column<Integer>(this, "supplier",
284                    new ReferencePoemType(getBibliomaniaDatabaseTables().
285                                              getSupplierTable(), false),
286                    DefinitionSource.dsd) { 
287           public Object getCooked(Persistent g)
288               throws AccessPoemException, PoemException {
289             return ((ShopOrderItem)g).getSupplier();
290           }
291 
292           public void setCooked(Persistent g, Object cooked)
293               throws AccessPoemException, ValidationPoemException {
294             ((ShopOrderItem)g).setSupplier((Supplier)cooked);
295           }
296 
297           public Field<Integer> asField(Persistent g) {
298             return ((ShopOrderItem)g).getSupplierField();
299           }
300 
301           public DisplayLevel defaultDisplayLevel() {
302             return DisplayLevel.record;
303           }
304 
305           public Searchability defaultSearchability() {
306             return Searchability.yes;
307           }
308 
309           public String defaultDisplayName() {
310             return "Supplier";
311           }
312 
313           public int defaultDisplayOrder() {
314             return 3;
315           }
316 
317           public boolean defaultIndexed() {
318             return true;
319           }
320 
321           public Object getRaw_unsafe(Persistent g)
322               throws AccessPoemException {
323             return ((ShopOrderItem)g).getSupplier_unsafe();
324           }
325 
326           public void setRaw_unsafe(Persistent g, Object raw)
327               throws AccessPoemException {
328             ((ShopOrderItem)g).setSupplier_unsafe((Integer)raw);
329           }
330 
331           public Object getRaw(Persistent g)
332               throws AccessPoemException {
333             return ((ShopOrderItem)g).getSupplierTroid();
334           }
335 
336           public void setRaw(Persistent g, Object raw)
337               throws AccessPoemException {
338             ((ShopOrderItem)g).setSupplierTroid((Integer)raw);
339           }
340         });
341 
342     defineColumn(col_status =
343         new Column<Integer>(this, "status",
344                    new ReferencePoemType(getBibliomaniaDatabaseTables().
345                                              getOrderStatusTable(), false),
346                    DefinitionSource.dsd) { 
347           public Object getCooked(Persistent g)
348               throws AccessPoemException, PoemException {
349             return ((ShopOrderItem)g).getStatus();
350           }
351 
352           public void setCooked(Persistent g, Object cooked)
353               throws AccessPoemException, ValidationPoemException {
354             ((ShopOrderItem)g).setStatus((OrderStatus)cooked);
355           }
356 
357           public Field<Integer> asField(Persistent g) {
358             return ((ShopOrderItem)g).getStatusField();
359           }
360 
361           public DisplayLevel defaultDisplayLevel() {
362             return DisplayLevel.summary;
363           }
364 
365           public Searchability defaultSearchability() {
366             return Searchability.yes;
367           }
368 
369           public String defaultDisplayName() {
370             return "Status";
371           }
372 
373           public int defaultDisplayOrder() {
374             return 4;
375           }
376 
377           public String defaultDescription() {
378             return "The status of this order item";
379           }
380 
381           public boolean defaultIndexed() {
382             return true;
383           }
384 
385           public Object getRaw_unsafe(Persistent g)
386               throws AccessPoemException {
387             return ((ShopOrderItem)g).getStatus_unsafe();
388           }
389 
390           public void setRaw_unsafe(Persistent g, Object raw)
391               throws AccessPoemException {
392             ((ShopOrderItem)g).setStatus_unsafe((Integer)raw);
393           }
394 
395           public Object getRaw(Persistent g)
396               throws AccessPoemException {
397             return ((ShopOrderItem)g).getStatusTroid();
398           }
399 
400           public void setRaw(Persistent g, Object raw)
401               throws AccessPoemException {
402             ((ShopOrderItem)g).setStatusTroid((Integer)raw);
403           }
404         });
405 
406     defineColumn(col_quantity =
407         new Column<Integer>(this, "quantity",
408                    new IntegerPoemType(false),
409                    DefinitionSource.dsd) { 
410           public Object getCooked(Persistent g)
411               throws AccessPoemException, PoemException {
412             return ((ShopOrderItem)g).getQuantity();
413           }
414 
415           public void setCooked(Persistent g, Object cooked)
416               throws AccessPoemException, ValidationPoemException {
417             ((ShopOrderItem)g).setQuantity((Integer)cooked);
418           }
419 
420           public Field<Integer> asField(Persistent g) {
421             return ((ShopOrderItem)g).getQuantityField();
422           }
423 
424           public DisplayLevel defaultDisplayLevel() {
425             return DisplayLevel.summary;
426           }
427 
428           public Searchability defaultSearchability() {
429             return Searchability.yes;
430           }
431 
432           public String defaultDisplayName() {
433             return "Quantity";
434           }
435 
436           public int defaultDisplayOrder() {
437             return 5;
438           }
439 
440           public Object getRaw_unsafe(Persistent g)
441               throws AccessPoemException {
442             return ((ShopOrderItem)g).getQuantity_unsafe();
443           }
444 
445           public void setRaw_unsafe(Persistent g, Object raw)
446               throws AccessPoemException {
447             ((ShopOrderItem)g).setQuantity_unsafe((Integer)raw);
448           }
449 
450           public Object getRaw(Persistent g)
451               throws AccessPoemException {
452             return ((ShopOrderItem)g).getQuantity();
453           }
454 
455           public void setRaw(Persistent g, Object raw)
456               throws AccessPoemException {
457             ((ShopOrderItem)g).setQuantity((Integer)raw);
458           }
459         });
460 
461     defineColumn(col_date =
462         new Column<Timestamp>(this, "date",
463                    new TimestampPoemType(false),
464                    DefinitionSource.dsd) { 
465           public Object getCooked(Persistent g)
466               throws AccessPoemException, PoemException {
467             return ((ShopOrderItem)g).getDate();
468           }
469 
470           public void setCooked(Persistent g, Object cooked)
471               throws AccessPoemException, ValidationPoemException {
472             ((ShopOrderItem)g).setDate((Timestamp)cooked);
473           }
474 
475           public Field<Timestamp> asField(Persistent g) {
476             return ((ShopOrderItem)g).getDateField();
477           }
478 
479           public DisplayLevel defaultDisplayLevel() {
480             return DisplayLevel.summary;
481           }
482 
483           public Searchability defaultSearchability() {
484             return Searchability.yes;
485           }
486 
487           public String defaultDisplayName() {
488             return "Date";
489           }
490 
491           public int defaultDisplayOrder() {
492             return 6;
493           }
494 
495           public Object getRaw_unsafe(Persistent g)
496               throws AccessPoemException {
497             return ((ShopOrderItem)g).getDate_unsafe();
498           }
499 
500           public void setRaw_unsafe(Persistent g, Object raw)
501               throws AccessPoemException {
502             ((ShopOrderItem)g).setDate_unsafe((Timestamp)raw);
503           }
504 
505           public Object getRaw(Persistent g)
506               throws AccessPoemException {
507             return ((ShopOrderItem)g).getDate();
508           }
509 
510           public void setRaw(Persistent g, Object raw)
511               throws AccessPoemException {
512             ((ShopOrderItem)g).setDate((Timestamp)raw);
513           }
514         });
515 
516     defineColumn(col_fufilleddate =
517         new Column<Timestamp>(this, "fufilleddate",
518                    new TimestampPoemType(true),
519                    DefinitionSource.dsd) { 
520           public Object getCooked(Persistent g)
521               throws AccessPoemException, PoemException {
522             return ((ShopOrderItem)g).getFufilleddate();
523           }
524 
525           public void setCooked(Persistent g, Object cooked)
526               throws AccessPoemException, ValidationPoemException {
527             ((ShopOrderItem)g).setFufilleddate((Timestamp)cooked);
528           }
529 
530           public Field<Timestamp> asField(Persistent g) {
531             return ((ShopOrderItem)g).getFufilleddateField();
532           }
533 
534           public DisplayLevel defaultDisplayLevel() {
535             return DisplayLevel.record;
536           }
537 
538           public Searchability defaultSearchability() {
539             return Searchability.no;
540           }
541 
542           public boolean defaultSortDescending() {
543             return true;
544           }
545 
546           public String defaultDisplayName() {
547             return "Fufilled Date";
548           }
549 
550           public int defaultDisplayOrder() {
551             return 7;
552           }
553 
554           public String defaultDescription() {
555             return "The date that this order was fufilled (leave blank to autocomplete)";
556           }
557 
558           public Object getRaw_unsafe(Persistent g)
559               throws AccessPoemException {
560             return ((ShopOrderItem)g).getFufilleddate_unsafe();
561           }
562 
563           public void setRaw_unsafe(Persistent g, Object raw)
564               throws AccessPoemException {
565             ((ShopOrderItem)g).setFufilleddate_unsafe((Timestamp)raw);
566           }
567 
568           public Object getRaw(Persistent g)
569               throws AccessPoemException {
570             return ((ShopOrderItem)g).getFufilleddate();
571           }
572 
573           public void setRaw(Persistent g, Object raw)
574               throws AccessPoemException {
575             ((ShopOrderItem)g).setFufilleddate((Timestamp)raw);
576           }
577         });
578 
579     defineColumn(col_order =
580         new Column<Integer>(this, "order",
581                    new ReferencePoemType(getBibliomaniaDatabaseTables().
582                                              getShopOrderTable(), false),
583                    DefinitionSource.dsd) { 
584           public Object getCooked(Persistent g)
585               throws AccessPoemException, PoemException {
586             return ((ShopOrderItem)g).getOrder();
587           }
588 
589           public void setCooked(Persistent g, Object cooked)
590               throws AccessPoemException, ValidationPoemException {
591             ((ShopOrderItem)g).setOrder((ShopOrder)cooked);
592           }
593 
594           public Field<Integer> asField(Persistent g) {
595             return ((ShopOrderItem)g).getOrderField();
596           }
597 
598           public DisplayLevel defaultDisplayLevel() {
599             return DisplayLevel.record;
600           }
601 
602           public Searchability defaultSearchability() {
603             return Searchability.yes;
604           }
605 
606           public String defaultDisplayName() {
607             return "Order Number";
608           }
609 
610           public int defaultDisplayOrder() {
611             return 8;
612           }
613 
614           public String defaultDescription() {
615             return "The order number for this pruchase";
616           }
617 
618           public Object getRaw_unsafe(Persistent g)
619               throws AccessPoemException {
620             return ((ShopOrderItem)g).getOrder_unsafe();
621           }
622 
623           public void setRaw_unsafe(Persistent g, Object raw)
624               throws AccessPoemException {
625             ((ShopOrderItem)g).setOrder_unsafe((Integer)raw);
626           }
627 
628           public Object getRaw(Persistent g)
629               throws AccessPoemException {
630             return ((ShopOrderItem)g).getOrderTroid();
631           }
632 
633           public void setRaw(Persistent g, Object raw)
634               throws AccessPoemException {
635             ((ShopOrderItem)g).setOrderTroid((Integer)raw);
636           }
637         });
638 
639     defineColumn(col_amount =
640         new Column<Double>(this, "amount",
641                    new DoublePoemType(false),
642                    DefinitionSource.dsd) { 
643           public Object getCooked(Persistent g)
644               throws AccessPoemException, PoemException {
645             return ((ShopOrderItem)g).getAmount();
646           }
647 
648           public void setCooked(Persistent g, Object cooked)
649               throws AccessPoemException, ValidationPoemException {
650             ((ShopOrderItem)g).setAmount((Double)cooked);
651           }
652 
653           public Field<Double> asField(Persistent g) {
654             return ((ShopOrderItem)g).getAmountField();
655           }
656 
657           public DisplayLevel defaultDisplayLevel() {
658             return DisplayLevel.record;
659           }
660 
661           public Searchability defaultSearchability() {
662             return Searchability.no;
663           }
664 
665           public String defaultDisplayName() {
666             return "Amount (in customer's currency)";
667           }
668 
669           public int defaultDisplayOrder() {
670             return 9;
671           }
672 
673           public String defaultDescription() {
674             return "The amount of this line (in customer's currency)";
675           }
676 
677           public Object getRaw_unsafe(Persistent g)
678               throws AccessPoemException {
679             return ((ShopOrderItem)g).getAmount_unsafe();
680           }
681 
682           public void setRaw_unsafe(Persistent g, Object raw)
683               throws AccessPoemException {
684             ((ShopOrderItem)g).setAmount_unsafe((Double)raw);
685           }
686 
687           public Object getRaw(Persistent g)
688               throws AccessPoemException {
689             return ((ShopOrderItem)g).getAmount();
690           }
691 
692           public void setRaw(Persistent g, Object raw)
693               throws AccessPoemException {
694             ((ShopOrderItem)g).setAmount((Double)raw);
695           }
696         });
697 
698     defineColumn(col_delivery =
699         new Column<Double>(this, "delivery",
700                    new DoublePoemType(false),
701                    DefinitionSource.dsd) { 
702           public Object getCooked(Persistent g)
703               throws AccessPoemException, PoemException {
704             return ((ShopOrderItem)g).getDelivery();
705           }
706 
707           public void setCooked(Persistent g, Object cooked)
708               throws AccessPoemException, ValidationPoemException {
709             ((ShopOrderItem)g).setDelivery((Double)cooked);
710           }
711 
712           public Field<Double> asField(Persistent g) {
713             return ((ShopOrderItem)g).getDeliveryField();
714           }
715 
716           public DisplayLevel defaultDisplayLevel() {
717             return DisplayLevel.record;
718           }
719 
720           public Searchability defaultSearchability() {
721             return Searchability.no;
722           }
723 
724           public String defaultDisplayName() {
725             return "Delivery (in customer's currency)";
726           }
727 
728           public int defaultDisplayOrder() {
729             return 10;
730           }
731 
732           public String defaultDescription() {
733             return "The delivery charge for this line (in customer's currency)";
734           }
735 
736           public Object getRaw_unsafe(Persistent g)
737               throws AccessPoemException {
738             return ((ShopOrderItem)g).getDelivery_unsafe();
739           }
740 
741           public void setRaw_unsafe(Persistent g, Object raw)
742               throws AccessPoemException {
743             ((ShopOrderItem)g).setDelivery_unsafe((Double)raw);
744           }
745 
746           public Object getRaw(Persistent g)
747               throws AccessPoemException {
748             return ((ShopOrderItem)g).getDelivery();
749           }
750 
751           public void setRaw(Persistent g, Object raw)
752               throws AccessPoemException {
753             ((ShopOrderItem)g).setDelivery((Double)raw);
754           }
755         });
756 
757     defineColumn(col_amountUK =
758         new Column<Double>(this, "amountUK",
759                    new DoublePoemType(false),
760                    DefinitionSource.dsd) { 
761           public Object getCooked(Persistent g)
762               throws AccessPoemException, PoemException {
763             return ((ShopOrderItem)g).getAmountUK();
764           }
765 
766           public void setCooked(Persistent g, Object cooked)
767               throws AccessPoemException, ValidationPoemException {
768             ((ShopOrderItem)g).setAmountUK((Double)cooked);
769           }
770 
771           public Field<Double> asField(Persistent g) {
772             return ((ShopOrderItem)g).getAmountUKField();
773           }
774 
775           public DisplayLevel defaultDisplayLevel() {
776             return DisplayLevel.record;
777           }
778 
779           public Searchability defaultSearchability() {
780             return Searchability.no;
781           }
782 
783           public String defaultDisplayName() {
784             return "Amount (UK Sterling Equivalent)";
785           }
786 
787           public int defaultDisplayOrder() {
788             return 11;
789           }
790 
791           public String defaultDescription() {
792             return "The amount of this line (UK Sterling Equivalent)";
793           }
794 
795           public Object getRaw_unsafe(Persistent g)
796               throws AccessPoemException {
797             return ((ShopOrderItem)g).getAmountUK_unsafe();
798           }
799 
800           public void setRaw_unsafe(Persistent g, Object raw)
801               throws AccessPoemException {
802             ((ShopOrderItem)g).setAmountUK_unsafe((Double)raw);
803           }
804 
805           public Object getRaw(Persistent g)
806               throws AccessPoemException {
807             return ((ShopOrderItem)g).getAmountUK();
808           }
809 
810           public void setRaw(Persistent g, Object raw)
811               throws AccessPoemException {
812             ((ShopOrderItem)g).setAmountUK((Double)raw);
813           }
814         });
815 
816     defineColumn(col_deliveryUK =
817         new Column<Double>(this, "deliveryUK",
818                    new DoublePoemType(false),
819                    DefinitionSource.dsd) { 
820           public Object getCooked(Persistent g)
821               throws AccessPoemException, PoemException {
822             return ((ShopOrderItem)g).getDeliveryUK();
823           }
824 
825           public void setCooked(Persistent g, Object cooked)
826               throws AccessPoemException, ValidationPoemException {
827             ((ShopOrderItem)g).setDeliveryUK((Double)cooked);
828           }
829 
830           public Field<Double> asField(Persistent g) {
831             return ((ShopOrderItem)g).getDeliveryUKField();
832           }
833 
834           public DisplayLevel defaultDisplayLevel() {
835             return DisplayLevel.record;
836           }
837 
838           public Searchability defaultSearchability() {
839             return Searchability.no;
840           }
841 
842           public String defaultDisplayName() {
843             return "Delivery (UK Sterling Equivalent)";
844           }
845 
846           public int defaultDisplayOrder() {
847             return 12;
848           }
849 
850           public String defaultDescription() {
851             return "The delivery charge for this line (UK Sterling Equivalent)";
852           }
853 
854           public Object getRaw_unsafe(Persistent g)
855               throws AccessPoemException {
856             return ((ShopOrderItem)g).getDeliveryUK_unsafe();
857           }
858 
859           public void setRaw_unsafe(Persistent g, Object raw)
860               throws AccessPoemException {
861             ((ShopOrderItem)g).setDeliveryUK_unsafe((Double)raw);
862           }
863 
864           public Object getRaw(Persistent g)
865               throws AccessPoemException {
866             return ((ShopOrderItem)g).getDeliveryUK();
867           }
868 
869           public void setRaw(Persistent g, Object raw)
870               throws AccessPoemException {
871             ((ShopOrderItem)g).setDeliveryUK((Double)raw);
872           }
873         });
874   }
875 
876 
877  /**
878   * Retrieves the <code>Id</code> <code>Column</code> for this 
879   * <code>ShopOrderItem</code> <code>Table</code>.
880   * 
881   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
882   * @return the id <code>Column</code>
883   */
884   public final Column<Integer> getIdColumn() {
885     return col_id;
886   }
887 
888 
889  /**
890   * Retrieves the <code>User</code> <code>Column</code> for this 
891   * <code>ShopOrderItem</code> <code>Table</code>.
892   * 
893   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
894   * @return the user <code>Column</code>
895   */
896   public final Column<Integer> getUserColumn() {
897     return col_user;
898   }
899 
900 
901  /**
902   * Retrieves the <code>Product</code> <code>Column</code> for this 
903   * <code>ShopOrderItem</code> <code>Table</code>.
904   * 
905   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
906   * @return the product <code>Column</code>
907   */
908   public final Column<Integer> getProductColumn() {
909     return col_product;
910   }
911 
912 
913  /**
914   * Retrieves the <code>Supplier</code> <code>Column</code> for this 
915   * <code>ShopOrderItem</code> <code>Table</code>.
916   * 
917   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
918   * @return the supplier <code>Column</code>
919   */
920   public final Column<Integer> getSupplierColumn() {
921     return col_supplier;
922   }
923 
924 
925  /**
926   * Retrieves the <code>Status</code> <code>Column</code> for this 
927   * <code>ShopOrderItem</code> <code>Table</code>.
928   * 
929   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
930   * @return the status <code>Column</code>
931   */
932   public final Column<Integer> getStatusColumn() {
933     return col_status;
934   }
935 
936 
937  /**
938   * Retrieves the <code>Quantity</code> <code>Column</code> for this 
939   * <code>ShopOrderItem</code> <code>Table</code>.
940   * 
941   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
942   * @return the quantity <code>Column</code>
943   */
944   public final Column<Integer> getQuantityColumn() {
945     return col_quantity;
946   }
947 
948 
949  /**
950   * Retrieves the <code>Date</code> <code>Column</code> for this 
951   * <code>ShopOrderItem</code> <code>Table</code>.
952   * 
953   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
954   * @return the date <code>Column</code>
955   */
956   public final Column<Timestamp> getDateColumn() {
957     return col_date;
958   }
959 
960 
961  /**
962   * Retrieves the <code>Fufilleddate</code> <code>Column</code> for this 
963   * <code>ShopOrderItem</code> <code>Table</code>.
964   * 
965   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
966   * @return the fufilleddate <code>Column</code>
967   */
968   public final Column<Timestamp> getFufilleddateColumn() {
969     return col_fufilleddate;
970   }
971 
972 
973  /**
974   * Retrieves the <code>Order</code> <code>Column</code> for this 
975   * <code>ShopOrderItem</code> <code>Table</code>.
976   * 
977   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
978   * @return the order <code>Column</code>
979   */
980   public final Column<Integer> getOrderColumn() {
981     return col_order;
982   }
983 
984 
985  /**
986   * Retrieves the <code>Amount</code> <code>Column</code> for this 
987   * <code>ShopOrderItem</code> <code>Table</code>.
988   * 
989   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
990   * @return the amount <code>Column</code>
991   */
992   public final Column<Double> getAmountColumn() {
993     return col_amount;
994   }
995 
996 
997  /**
998   * Retrieves the <code>Delivery</code> <code>Column</code> for this 
999   * <code>ShopOrderItem</code> <code>Table</code>.
1000   * 
1001   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
1002   * @return the delivery <code>Column</code>
1003   */
1004   public final Column<Double> getDeliveryColumn() {
1005     return col_delivery;
1006   }
1007 
1008 
1009  /**
1010   * Retrieves the <code>AmountUK</code> <code>Column</code> for this 
1011   * <code>ShopOrderItem</code> <code>Table</code>.
1012   * 
1013   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
1014   * @return the amountUK <code>Column</code>
1015   */
1016   public final Column<Double> getAmountUKColumn() {
1017     return col_amountUK;
1018   }
1019 
1020 
1021  /**
1022   * Retrieves the <code>DeliveryUK</code> <code>Column</code> for this 
1023   * <code>ShopOrderItem</code> <code>Table</code>.
1024   * 
1025   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
1026   * @return the deliveryUK <code>Column</code>
1027   */
1028   public final Column<Double> getDeliveryUKColumn() {
1029     return col_deliveryUK;
1030   }
1031 
1032 
1033  /**
1034   * Retrieve the <code>ShopOrderItem</code> as a <code>ShopOrderItem</code>.
1035   *
1036   * see org.melati.poem.prepro.TableDef#generateTableBaseJava 
1037   * @param troid a Table Row Oject ID
1038   * @return the <code>Persistent</code> identified by the <code>troid</code>
1039   */
1040   public ShopOrderItem getShopOrderItemObject(Integer troid) {
1041     return (ShopOrderItem)getObject(troid);
1042   }
1043 
1044 
1045  /**
1046   * Retrieve the <code>ShopOrderItem</code> 
1047   * as a <code>ShopOrderItem</code>.
1048   *
1049   * see org.melati.poem.prepro.TableDef#generateTableBaseJava 
1050   * @param troid a Table Row Object ID
1051   * @return the <code>Persistent</code> identified   */
1052   public ShopOrderItem getShopOrderItemObject(int troid) {
1053     return (ShopOrderItem)getObject(troid);
1054   }
1055 
1056   protected JdbcPersistent _newPersistent() {
1057     return new ShopOrderItem();
1058   }
1059   public String defaultDisplayName() {
1060     return "Order Item";
1061   }
1062 
1063   public String defaultDescription() {
1064     return "Order Item";
1065   }
1066 
1067   public String defaultCategory() {
1068     return "Shop";
1069   }
1070 
1071   public int defaultDisplayOrder() {
1072     return 1270;
1073   }
1074 }
1075