001: /*
002: * JFolder, Copyright 2001-2006 Gary Steinmetz
003: *
004: * Distributable under LGPL license.
005: * See terms of license at gnu.org.
006: */
007:
008: package org.jfolder.console.web.admin.macro.execute;
009:
010: //base classes
011: import java.io.IOException;
012: import java.io.PrintWriter;
013: import java.io.StringWriter;
014: import java.util.ArrayList;
015: import javax.servlet.ServletException;
016:
017: //project specific classes
018: import org.jfolder.common.function.WebPageTagPreferences;
019: import org.jfolder.common.tagging.ConceptRollupTag;
020: import org.jfolder.common.tagging.ConceptTagCharacteristic;
021: import org.jfolder.common.tagging.ConceptTagPreferences;
022: import org.jfolder.common.tagging.RootConceptTagHolder;
023: import org.jfolder.common.utils.misc.CommonSeparators;
024: import org.jfolder.common.utils.misc.MiscHelper;
025: import org.jfolder.common.utils.web.ParameterSet;
026: import org.jfolder.common.web.template.CreationParameterContext;
027: import org.jfolder.common.web.template.SubmitActionContext;
028: import org.jfolder.common.web.template.SubmitActionParameters;
029: import org.jfolder.console.base.BaseConsoleServlet;
030: import org.jfolder.console.base.ConsolePageContext;
031: import org.jfolder.console.base.ConsolePageParameters;
032: import org.jfolder.console.base.ConsolePageSession;
033: import org.jfolder.console.base.NamesForParentCpc;
034: import org.jfolder.console.macro.ConsoleMacro;
035: import org.jfolder.console.macro.ConsoleMacroTagHelper;
036: import org.jfolder.console.macro.v1.OpenSectionIfClosedConsoleMacroTag;
037: import org.jfolder.console.macro.v1.RootV1ConsoleMacroTag;
038: import org.jfolder.security.model.UserHolder;
039:
040: //other classes
041:
042: public class PetStoreDatabaseForHypersonicSQL extends PetStoreDatabase {
043:
044: //
045: public PetStoreDatabaseForHypersonicSQL() {
046: }
047:
048: //
049: //
050: //
051: //
052: public String getDropSupplierTable() {
053: //
054: String outValue = null;
055:
056: StringWriter sw = new StringWriter();
057: PrintWriter pw = new PrintWriter(sw);
058:
059: pw.println("DROP TABLE SUPPLIER;");
060:
061: pw.flush();
062: sw.flush();
063:
064: outValue = sw.toString();
065:
066: return outValue;
067: }
068:
069: public String getCreateSupplierTable() {
070: //
071: String outValue = null;
072:
073: StringWriter sw = new StringWriter();
074: PrintWriter pw = new PrintWriter(sw);
075:
076: pw.println("CREATE TABLE SUPPLIER (");
077: //
078: pw.println("LOCAL_ID BIGINT IDENTITY PRIMARY KEY,");
079: pw.println("NAME VARCHAR NOT NULL,");
080: pw.println("STATUS VARCHAR NOT NULL,");
081: pw.println("ADDRESS1 VARCHAR,");
082: pw.println("ADDRESS2 VARCHAR,");
083: pw.println("CITY VARCHAR,");
084: pw.println("STATE VARCHAR,");
085: pw.println("ZIP_CODE VARCHAR,");
086: pw.println("PHONE_NUMBER VARCHAR");
087: //
088: pw.println(");");
089:
090: pw.flush();
091: sw.flush();
092:
093: outValue = sw.toString();
094:
095: return outValue;
096: }
097:
098: //
099: public String getDropOrdersTable() {
100: //
101: String outValue = null;
102:
103: StringWriter sw = new StringWriter();
104: PrintWriter pw = new PrintWriter(sw);
105:
106: pw.println("DROP TABLE ORDERS;");
107:
108: pw.flush();
109: sw.flush();
110:
111: outValue = sw.toString();
112:
113: return outValue;
114: }
115:
116: public String getCreateOrdersTable() {
117: //
118: String outValue = null;
119:
120: StringWriter sw = new StringWriter();
121: PrintWriter pw = new PrintWriter(sw);
122:
123: pw.println("CREATE TABLE ORDERS (");
124: //
125: pw.println("ORDER_ID BIGINT IDENTITY PRIMARY KEY,");
126: pw.println("USER_ID VARCHAR NOT NULL,");
127: pw.println("ORDER_DATE TIMESTAMP NOT NULL,");
128: pw.println("SHIP_ADDRESS_1 VARCHAR NOT NULL,");
129: pw.println("SHIP_ADDRESS_2 VARCHAR,");
130: pw.println("SHIP_CITY VARCHAR NOT NULL,");
131: pw.println("SHIP_STATE VARCHAR NOT NULL,");
132: pw.println("SHIP_ZIP_CODE VARCHAR NOT NULL,");
133: pw.println("SHIP_COUNTRY VARCHAR NOT NULL,");
134: pw.println("BILL_ADDRESS_1 VARCHAR NOT NULL,");
135: pw.println("BILL_ADDRESS_2 VARCHAR,");
136: pw.println("BILL_CITY VARCHAR NOT NULL,");
137: pw.println("BILL_STATE VARCHAR NOT NULL,");
138: pw.println("BILL_ZIP_CODE VARCHAR NOT NULL,");
139: pw.println("BILL_COUNTRY VARCHAR NOT NULL,");
140: pw.println("COURIER VARCHAR NOT NULL,");
141: pw.println("TOTAL_PRICE DECIMAL NOT NULL,");
142: pw.println("BILL_TO_FIRSTNAME VARCHAR NOT NULL,");
143: pw.println("BILL_TO_LASTNAME VARCHAR NOT NULL,");
144: pw.println("SHIP_TO_FIRSTNAME VARCHAR NOT NULL,");
145: pw.println("SHIP_TO_LASTNAME VARCHAR NOT NULL,");
146: pw.println("CREDIT_CARD VARCHAR NOT NULL,");
147: pw.println("EXPIRE_DATE VARCHAR NOT NULL,");
148: pw.println("CARD_TYPE VARCHAR NOT NULL");//,");
149: //pw.println("LOCALE varchar(20) NOT NULL");
150: //
151: pw.println(");");
152:
153: pw.flush();
154: sw.flush();
155:
156: outValue = sw.toString();
157:
158: return outValue;
159: }
160:
161: //
162: public String getDropOrderStatusTable() {
163: //
164: String outValue = null;
165:
166: StringWriter sw = new StringWriter();
167: PrintWriter pw = new PrintWriter(sw);
168:
169: pw.println("DROP TABLE ORDER_STATUS;");
170:
171: pw.flush();
172: sw.flush();
173:
174: outValue = sw.toString();
175:
176: return outValue;
177: }
178:
179: public String getCreateOrderStatusTable() {
180: //
181: String outValue = null;
182:
183: StringWriter sw = new StringWriter();
184: PrintWriter pw = new PrintWriter(sw);
185:
186: pw.println("CREATE TABLE ORDER_STATUS (");
187: //
188: pw.println("ORDER_ID DECIMAL NOT NULL,");
189: pw.println("LINE_NUMBER DECIMAL NOT NULL,");
190: pw.println("ORDER_TIME TIMESTAMP NOT NULL,");
191: pw.println("STATUS VARCHAR NOT NULL");
192: //
193: pw.println(");");
194:
195: pw.flush();
196: sw.flush();
197:
198: outValue = sw.toString();
199:
200: return outValue;
201: }
202:
203: //
204: public String getDropCategoryTable() {
205: //
206: String outValue = null;
207:
208: StringWriter sw = new StringWriter();
209: PrintWriter pw = new PrintWriter(sw);
210:
211: pw.println("DROP TABLE CATEGORY;");
212:
213: pw.flush();
214: sw.flush();
215:
216: outValue = sw.toString();
217:
218: return outValue;
219: }
220:
221: public String getCreateCategoryTable() {
222: //
223: String outValue = null;
224:
225: StringWriter sw = new StringWriter();
226: PrintWriter pw = new PrintWriter(sw);
227:
228: pw.println("CREATE TABLE CATEGORY (");
229: //
230: pw.println("CATEGORY_ID VARCHAR NOT NULL,");
231: pw.println("CATEGORY_NAME VARCHAR,");
232: pw.println("DESCRIPTION VARCHAR");
233: //
234: pw.println(");");
235:
236: pw.flush();
237: sw.flush();
238:
239: outValue = sw.toString();
240:
241: return outValue;
242: }
243:
244: //
245: public String getDropProductTable() {
246: //
247: String outValue = null;
248:
249: StringWriter sw = new StringWriter();
250: PrintWriter pw = new PrintWriter(sw);
251:
252: pw.println("DROP TABLE PRODUCT;");
253:
254: pw.flush();
255: sw.flush();
256:
257: outValue = sw.toString();
258:
259: return outValue;
260: }
261:
262: public String getCreateProductTable() {
263: //
264: String outValue = null;
265:
266: StringWriter sw = new StringWriter();
267: PrintWriter pw = new PrintWriter(sw);
268:
269: pw.println("CREATE TABLE PRODUCT (");
270: //
271: pw.println("PRODUCT_ID VARCHAR NOT NULL,");
272: pw.println("CATEGORY VARCHAR NOT NULL,");
273: pw.println("CATEGORY_NAME VARCHAR,");
274: pw.println("DESCRIPTION VARCHAR");
275: //
276: pw.println(");");
277:
278: pw.flush();
279: sw.flush();
280:
281: outValue = sw.toString();
282:
283: return outValue;
284: }
285:
286: //
287: public String getDropSignonTable() {
288: //
289: String outValue = null;
290:
291: StringWriter sw = new StringWriter();
292: PrintWriter pw = new PrintWriter(sw);
293:
294: pw.println("DROP TABLE SIGNON;");
295:
296: pw.flush();
297: sw.flush();
298:
299: outValue = sw.toString();
300:
301: return outValue;
302: }
303:
304: public String getCreateSignonTable() {
305: //
306: String outValue = null;
307:
308: StringWriter sw = new StringWriter();
309: PrintWriter pw = new PrintWriter(sw);
310:
311: pw.println("CREATE TABLE SIGNON (");
312: //
313: pw.println("USERNAME VARCHAR NOT NULL,");
314: pw.println("PASSWORD VARCHAR NOT NULL");
315: //
316: pw.println(");");
317:
318: pw.flush();
319: sw.flush();
320:
321: outValue = sw.toString();
322:
323: return outValue;
324: }
325:
326: //
327: public String getDropBannerDataTable() {
328: //
329: String outValue = null;
330:
331: StringWriter sw = new StringWriter();
332: PrintWriter pw = new PrintWriter(sw);
333:
334: pw.println("DROP TABLE BANNER_DATA;");
335:
336: pw.flush();
337: sw.flush();
338:
339: outValue = sw.toString();
340:
341: return outValue;
342: }
343:
344: public String getCreateBannerDataTable() {
345: //
346: String outValue = null;
347:
348: StringWriter sw = new StringWriter();
349: PrintWriter pw = new PrintWriter(sw);
350:
351: pw.println("CREATE TABLE BANNER_DATA (");
352: //
353: pw.println("FAVORITE_CATEGORY VARCHAR NOT NULL,");
354: pw.println("BANNER_NAME VARCHAR");
355: //
356: pw.println(");");
357:
358: pw.flush();
359: sw.flush();
360:
361: outValue = sw.toString();
362:
363: return outValue;
364: }
365:
366: //
367: public String getDropProfileTable() {
368: //
369: String outValue = null;
370:
371: StringWriter sw = new StringWriter();
372: PrintWriter pw = new PrintWriter(sw);
373:
374: pw.println("DROP TABLE PROFILE;");
375:
376: pw.flush();
377: sw.flush();
378:
379: outValue = sw.toString();
380:
381: return outValue;
382: }
383:
384: public String getCreateProfileTable() {
385: //
386: String outValue = null;
387:
388: StringWriter sw = new StringWriter();
389: PrintWriter pw = new PrintWriter(sw);
390:
391: pw.println("CREATE TABLE PROFILE (");
392: //
393: pw.println("USER_ID VARCHAR NOT NULL,");
394: //pw.println("LANGPREF VARCHAR NOT NULL,");
395: pw.println("FAVORITE_CATEGORY VARCHAR,");
396: pw.println("MY_LIST_OPTION DECIMAL,");
397: pw.println("BANNER_OPTION DECIMAL");
398: //
399: pw.println(");");
400:
401: pw.flush();
402: sw.flush();
403:
404: outValue = sw.toString();
405:
406: return outValue;
407: }
408:
409: //
410: public String getDropAccountTable() {
411: //
412: String outValue = null;
413:
414: StringWriter sw = new StringWriter();
415: PrintWriter pw = new PrintWriter(sw);
416:
417: pw.println("DROP TABLE ACCOUNT;");
418:
419: pw.flush();
420: sw.flush();
421:
422: outValue = sw.toString();
423:
424: return outValue;
425: }
426:
427: public String getCreateAccountTable() {
428: //
429: String outValue = null;
430:
431: StringWriter sw = new StringWriter();
432: PrintWriter pw = new PrintWriter(sw);
433:
434: pw.println("CREATE TABLE ACCOUNT (");
435: //
436: pw.println("USER_ID VARCHAR NOT NULL,");
437: pw.println("EMAIL VARCHAR NOT NULL,");
438: pw.println("FIRSTNAME VARCHAR NOT NULL,");
439: pw.println("LASTNAME VARCHAR NOT NULL,");
440: pw.println("STATUS VARCHAR,");
441: pw.println("ADDRESS_1 VARCHAR NOT NULL,");
442: pw.println("ADDRESS_2 VARCHAR,");
443: pw.println("CITY VARCHAR NOT NULL,");
444: pw.println("STATE VARCHAR NOT NULL,");
445: pw.println("ZIP_CODE VARCHAR NOT NULL,");
446: pw.println("COUNTRY VARCHAR NOT NULL,");
447: pw.println("PHONE_NUMBER VARCHAR NOT NULL");
448: //
449: pw.println(");");
450:
451: pw.flush();
452: sw.flush();
453:
454: outValue = sw.toString();
455:
456: return outValue;
457: }
458:
459: //
460: public String getDropItemTable() {
461: //
462: String outValue = null;
463:
464: StringWriter sw = new StringWriter();
465: PrintWriter pw = new PrintWriter(sw);
466:
467: pw.println("DROP TABLE ITEM;");
468:
469: pw.flush();
470: sw.flush();
471:
472: outValue = sw.toString();
473:
474: return outValue;
475: }
476:
477: public String getCreateItemTable() {
478: //
479: String outValue = null;
480:
481: StringWriter sw = new StringWriter();
482: PrintWriter pw = new PrintWriter(sw);
483:
484: pw.println("CREATE TABLE ITEM (");
485: //
486: pw.println("ITEM_ID VARCHAR NOT NULL,");
487: pw.println("PRODUCT_ID VARCHAR NOT NULL,");
488: pw.println("LIST_PRICE DECIMAL,");
489: pw.println("UNIT_COST DECIMAL,");
490: pw.println("SUPPLIER DECIMAL,");
491: pw.println("STATUS VARCHAR,");
492: pw.println("ADRESS1 VARCHAR,");
493: pw.println("ADRESS2 VARCHAR,");
494: pw.println("ADRESS3 VARCHAR,");
495: pw.println("ADRESS4 VARCHAR,");
496: pw.println("ADRESS5 VARCHAR");
497: //
498: pw.println(");");
499:
500: pw.flush();
501: sw.flush();
502:
503: outValue = sw.toString();
504:
505: return outValue;
506: }
507:
508: //
509: public String getDropInventoryTable() {
510: //
511: String outValue = null;
512:
513: StringWriter sw = new StringWriter();
514: PrintWriter pw = new PrintWriter(sw);
515:
516: pw.println("DROP TABLE INVENTORY;");
517:
518: pw.flush();
519: sw.flush();
520:
521: outValue = sw.toString();
522:
523: return outValue;
524: }
525:
526: public String getCreateInventoryTable() {
527: //
528: String outValue = null;
529:
530: StringWriter sw = new StringWriter();
531: PrintWriter pw = new PrintWriter(sw);
532:
533: pw.println("CREATE TABLE INVENTORY (");
534: //
535: pw.println("ITEM_IT VARCHAR NOT NULL,");
536: pw.println("QUANTITY DECIMAL NOT NULL");
537: //
538: pw.println(");");
539:
540: pw.flush();
541: sw.flush();
542:
543: outValue = sw.toString();
544:
545: return outValue;
546: }
547:
548: //
549: public String getDropLineItemTable() {
550: //
551: String outValue = null;
552:
553: StringWriter sw = new StringWriter();
554: PrintWriter pw = new PrintWriter(sw);
555:
556: pw.println("DROP TABLE LINE_ITEM;");
557:
558: pw.flush();
559: sw.flush();
560:
561: outValue = sw.toString();
562:
563: return outValue;
564: }
565:
566: public String getCreateLineItemTable() {
567: //
568: String outValue = null;
569:
570: StringWriter sw = new StringWriter();
571: PrintWriter pw = new PrintWriter(sw);
572:
573: pw.println("CREATE TABLE LINE_ITEM (");
574: //
575: pw.println("ORDER_ID DECIMAL NOT NULL,");
576: pw.println("LINE_NUMBER DECIMAL NOT NULL,");
577: pw.println("ITEM_ID VARCHAR NOT NULL,");
578: pw.println("QUANTITY DECIMAL NOT NULL,");
579: pw.println("UNIT_PRICE DECIMAL NOT NULL");
580: //
581: pw.println(");");
582:
583: pw.flush();
584: sw.flush();
585:
586: outValue = sw.toString();
587:
588: return outValue;
589: }
590: }
|