Mercurial > dive4elements > river

comparison flys-backend/src/main/java/de/intevation/flys/App.java @ 1229:8b12b338a3f6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Re-enabled Hibernate schema dumps. flys-backend/trunk@2485 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 11 Aug 2011 10:47:43 +0000
parents d37ccb04ab5d
children 76c75c8b9ee0
comparison
equal deleted inserted replaced
1228:a964636a0be3 1229:8b12b338a3f6
1 package de.intevation.flys; 1 package de.intevation.flys;
2
3 import de.intevation.flys.backend.SessionFactoryProvider;
2 4
3 import org.hibernate.cfg.Configuration; 5 import org.hibernate.cfg.Configuration;
4 6
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; 7 import org.hibernate.dialect.resolver.DialectFactory;
24
25 import java.util.Properties;
26
27 import org.hibernate.cfg.Environment;
28 8
29 public class App 9 public class App
30 { 10 {
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) { 11 public static void dumpSchema(Configuration cfg) {
38 System.out.println("BEGIN;"); 12 System.out.println("BEGIN;");
39 13
40 String [] setupScript = cfg.generateSchemaCreationScript( 14 String [] setupScript = cfg.generateSchemaCreationScript(
41 DialectFactory.constructDialect( 15 DialectFactory.constructDialect(
42 "org.hibernate.dialect.PostgreSQLDialect")); 16 SessionFactoryProvider.DEFAULT_DIALECT));
43 17
44 for (String line: setupScript) { 18 for (String line: setupScript) {
45 System.out.println(line + ";"); 19 System.out.println(line + ";");
46 } 20 }
47 21
48 System.out.println("COMMIT;"); 22 System.out.println("COMMIT;");
49 } 23 }
50 24
51 public static void main(String [] args) 25 public static void main(String [] args) {
52 throws Exception 26 dumpSchema(SessionFactoryProvider.createConfiguration());
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 } 27 }
120 } 28 }
121 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : 29 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :
http://dive4elements.wald.intevation.org