1 package jimm.datavision.testdata.odbc; 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 12 class CreateData { 13 14 public static void main(String [] args) { 15 System.out.println("delete from office;"); 16 for (Iterator iter = Office.offices(); iter.hasNext(); ) { 17 Office o = (Office)iter.next(); 18 System.out.println("insert into office values (" + o.id + ", '" 19 + o.name + "', '" + o.abbrev + "', '" + o.fax 20 + "', '" + o.email + "', " 21 + (o.visible ? 1 : 0) + ");"); 22 } 23 24 System.out.println("delete from jobs;"); 25 for (Iterator iter = Job.jobs(); iter.hasNext(); ) { 26 Job j = (Job)iter.next(); 27 System.out.println("insert into jobs values (" + j.id + ", '" 28 + j.title + "', " + j.fk_office_id + ", '" 29 + j.company + "', '" + j.location + "', '" 30 + j.description + "', " 31 + (j.visible ? 1 : 0) + ", '" 32 + j.post_date.get(Calendar.YEAR) + '-' 33 + j.post_date.get(Calendar.MONTH) + '-' 34 + j.post_date.get(Calendar.DATE) + "', " 35 + (j.hourly_rate == null ? "NULL" 36 : j.hourly_rate.toString()) 37 + ");"); 38 } 39 40 System.out.println("delete from aggregate_test;"); 41 for (Iterator iter = 42 AggregateTestData.aggregateTestData("../aggregate_test.dat"); 43 iter.hasNext(); ) { 44 AggregateTestData data = (AggregateTestData)iter.next(); 45 System.out.println("insert into aggregate_test values ('" + data.col1() 46 + "', '" + data.col2() + "', " + data.value() 47 + ");"); 48 49 } 50 } 51 52 } 53 | Popular Tags |