comparison flys-backend/src/main/java/de/intevation/flys/App.java @ 508:a9c7f6ec3a5a 2.3.1

merged flys-backend/2.3.1
author Thomas Arendsen Hein <thomas@intevation.de>
date Fri, 28 Sep 2012 12:14:12 +0200
parents d37ccb04ab5d
children 8b12b338a3f6
comparison
equal deleted inserted replaced
462:ebf049a1eb53 508:a9c7f6ec3a5a
1 package de.intevation.flys;
2
3 import org.hibernate.cfg.Configuration;
4
5 import de.intevation.flys.model.Annotation;
6 import de.intevation.flys.model.Attribute;
7 import de.intevation.flys.model.DischargeTable;
8 import de.intevation.flys.model.DischargeTableValue;
9 import de.intevation.flys.model.Gauge;
10 import de.intevation.flys.model.MainValueType;
11 import de.intevation.flys.model.NamedMainValue;
12 import de.intevation.flys.model.MainValue;
13 import de.intevation.flys.model.Position;
14 import de.intevation.flys.model.Range;
15 import de.intevation.flys.model.River;
16 import de.intevation.flys.model.TimeInterval;
17 import de.intevation.flys.model.WstColumn;
18 import de.intevation.flys.model.WstColumnQRange;
19 import de.intevation.flys.model.WstColumnValue;
20 import de.intevation.flys.model.Wst;
21 import de.intevation.flys.model.WstQRange;
22
23 import org.hibernate.dialect.resolver.DialectFactory;
24
25 import java.util.Properties;
26
27 import org.hibernate.cfg.Environment;
28
29 public class App
30 {
31 private static final String USER =
32 System.getProperty("flys.user", "flys");
33
34 private static final String PASS =
35 System.getProperty("flys.pass", "flys");
36
37 public static void dumpSchema(Configuration cfg) {
38 System.out.println("BEGIN;");
39
40 String [] setupScript = cfg.generateSchemaCreationScript(
41 DialectFactory.constructDialect(
42 "org.hibernate.dialect.PostgreSQLDialect"));
43
44 for (String line: setupScript) {
45 System.out.println(line + ";");
46 }
47
48 System.out.println("COMMIT;");
49 }
50
51 public static void main(String [] args)
52 throws Exception
53 {
54 Configuration cfg = new Configuration();
55
56 cfg.addAnnotatedClass(Annotation.class);
57 cfg.addAnnotatedClass(Attribute.class);
58 cfg.addAnnotatedClass(DischargeTable.class);
59 cfg.addAnnotatedClass(DischargeTableValue.class);
60 cfg.addAnnotatedClass(Gauge.class);
61 cfg.addAnnotatedClass(MainValueType.class);
62 cfg.addAnnotatedClass(NamedMainValue.class);
63 cfg.addAnnotatedClass(MainValue.class);
64 cfg.addAnnotatedClass(Position.class);
65 cfg.addAnnotatedClass(Range.class);
66 cfg.addAnnotatedClass(River.class);
67 cfg.addAnnotatedClass(TimeInterval.class);
68 cfg.addAnnotatedClass(WstColumn.class);
69 cfg.addAnnotatedClass(WstColumnQRange.class);
70 cfg.addAnnotatedClass(WstColumnValue.class);
71 cfg.addAnnotatedClass(Wst.class);
72 cfg.addAnnotatedClass(WstQRange.class);
73 Properties props = new Properties();
74
75 dumpSchema(cfg);
76
77 props.setProperty(
78 Environment.DIALECT,
79 "org.hibernate.dialect.PostgreSQLDialect");
80
81 props.setProperty(
82 "hibernate.connection.provider_class",
83 "org.hibernate.connection.DBCPConnectionProvider");
84
85 props.setProperty(
86 Environment.USER,
87 USER);
88
89 props.setProperty(
90 Environment.PASS,
91 PASS);
92
93 props.setProperty(
94 Environment.DRIVER,
95 "org.postgresql.Driver");
96
97 props.setProperty(
98 Environment.URL,
99 "jdbc:postgresql://localhost:54321/flystest1");
100
101 cfg.mergeProperties(props);
102
103 /*
104
105 SessionFactory sessionFactory = cfg.buildSessionFactory();
106
107 Session session = sessionFactory.openSession();
108 session.beginTransaction();
109
110 River river = new River("Hase-" + new java.util.Date());
111
112 session.save(river);
113
114 System.out.println("river id: " + river.getId());
115
116 session.getTransaction().commit();
117 session.close();
118 */
119 }
120 }
121 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

http://dive4elements.wald.intevation.org