bundles/org.simantics.jdbc/src/org/simantics/jdbc/SimanticsJDBC.java

   1 package org.simantics.jdbc;
   2
   3 import org.simantics.databoard.Bindings;
   4 import org.simantics.db.Resource;
   5 import org.simantics.db.WriteGraph;
   6 import org.simantics.db.exception.DatabaseException;
   7 import org.simantics.db.layer0.util.Layer0Utils;
   8 import org.simantics.db.layer0.variable.Variable;
   9 import org.simantics.db.layer0.variable.Variables;
  10 import org.simantics.layer0.Layer0;
  11
  12 /**
  13  * Simantics JDBC facade.
  14  *
  15  * @author Jani Simomaa
  16  */
  17 public class SimanticsJDBC {
  18
  19     public static final String PROP_SIMANTICS_JDBC_PROPERTYFILE = "simantics.jdbc.propertyfile";
  20     public static final String PROP_SIMANTICS_JDBC_HOST         = "simantics.jdbc.host";
  21     public static final String PROP_SIMANTICS_JDBC_PORT         = "simantics.jdbc.port";
  22     public static final String PROP_SIMANTICS_JDBC_USER         = "simantics.jdbc.user";
  23     public static final String PROP_SIMANTICS_JDBC_PASSWORD     = "simantics.jdbc.password";
  24     public static final String PROP_SIMANTICS_JDBC_DATABASE     = "simantics.jdbc.database";
  25
  26     public static String createJDBCSession(WriteGraph graph, String sessionGUID) throws DatabaseException {
  27         Resource projects = graph.getResource("http://Projects");
  28         Resource documentSessions = Layer0Utils.getPossibleChild(graph, projects, "DocumentSessions");
  29         Layer0 L0 = Layer0.getInstance(graph);
  30         Resource documentSession = Layer0Utils.getPossibleChild(graph, documentSessions, sessionGUID);
  31
  32         String sessionId = "http://Projects/DocumentSessions/" + sessionGUID + "/__jdbc__";
  33
  34         JDBCResource JDBC = JDBCResource.getInstance(graph);
  35         Resource jdbcSession = graph.newResource();
  36         graph.claim(jdbcSession, L0.InstanceOf, JDBC.Session);
  37         graph.claimLiteral(jdbcSession, L0.HasName, L0.NameOf, L0.String, "__jdbc__", Bindings.STRING);
  38         graph.claim(documentSession, L0.ConsistsOf, jdbcSession);
  39
  40         @SuppressWarnings("unused")
  41         Variable jdbcState = Variables.getVariable(graph, jdbcSession);
  42
  43         return sessionId;
  44     }
  45 }