|
1 package jimm.datavision.testdata.postgres;
2 import jimm.datavision.testdata.Office;
3 import jimm.datavision.testdata.Job;
4 import jimm.datavision.testdata.AggregateTestData;
5 import java.util.Iterator  ;
6 import java.util.Calendar ;
7
8 class CreateData {
9
10 public static void main(String [] args) {
11 System.out.println("delete from office;");
12 for (Iterator iter = Office.offices(); iter.hasNext(); ) {
13 Office o = (Office)iter.next();
14 System.out.println("insert into office values (" + o.id + ", '"
15 + o.name + "', '" + o.abbrev + "', '" + o.fax
16 + "', '" + o.email + "', '"
17 + (o.visible ? 't' : 'f') + "');");
18 }
19
20 System.out.println("delete from jobs;");
21 for (Iterator iter = Job.jobs(); iter.hasNext(); ) {
22 Job j = (Job)iter.next();
23 System.out.println("insert into jobs values (" + j.id + ", '"
24 + j.title + "', " + j.fk_office_id + ", '"
25 + j.company + "', '" + j.location + "', '"
26 + j.description + "', '"
27 + (j.visible ? 't' : 'f') + "', '"
28 + j.post_date.get(Calendar.YEAR) + '-'
29 + (j.post_date.get(Calendar.MONTH) + 1) + '-'
30 + j.post_date.get(Calendar.DATE) + "', "
31 + (j.hourly_rate == null ? "NULL"
32 : j.hourly_rate.toString())
33 + ");");
34 }
35
36 System.out.println("delete from aggregate_test;");
37 for (Iterator iter =
38 AggregateTestData.aggregateTestData("../aggregate_test.dat");
39 iter.hasNext(); ) {
40 AggregateTestData data = (AggregateTestData)iter.next();
41 System.out.println("insert into aggregate_test values ('" + data.col1()
42 + "', '" + data.col2() + "', " + data.value()
43 + ");");
44
45 }
46 }
47
48 }
49 |
Popular Tags |
Java API By Example, From Geeks To Geeks.