From d6d9d37abf17071ff050e45ea37c693e659a4e98 Mon Sep 17 00:00:00 2001
From: Fabian Mastenbroek <mail.fabianm@gmail.com>
Date: Thu, 28 Sep 2017 03:27:36 +0200
Subject: Implement JPA integration

---
 .../src/main/resources/META-INF/persistence.xml    |  44 +++
 .../src/main/resources/jpa/schema.xml              | 325 +++++++++++++++++++++
 2 files changed, 369 insertions(+)
 create mode 100644 opendc-integration-jpa/src/main/resources/META-INF/persistence.xml
 create mode 100644 opendc-integration-jpa/src/main/resources/jpa/schema.xml

(limited to 'opendc-integration-jpa/src/main/resources')

diff --git a/opendc-integration-jpa/src/main/resources/META-INF/persistence.xml b/opendc-integration-jpa/src/main/resources/META-INF/persistence.xml
new file mode 100644
index 00000000..c997ab8d
--- /dev/null
+++ b/opendc-integration-jpa/src/main/resources/META-INF/persistence.xml
@@ -0,0 +1,44 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+  ~ MIT License
+  ~
+  ~ Copyright (c) 2017 atlarge-research
+  ~
+  ~ Permission is hereby granted, free of charge, to any person obtaining a copy
+  ~ of this software and associated documentation files (the "Software"), to deal
+  ~ in the Software without restriction, including without limitation the rights
+  ~ to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
+  ~ copies of the Software, and to permit persons to whom the Software is
+  ~ furnished to do so, subject to the following conditions:
+  ~
+  ~ The above copyright notice and this permission notice shall be included in all
+  ~ copies or substantial portions of the Software.
+  ~
+  ~ THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
+  ~ IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
+  ~ FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
+  ~ AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
+  ~ LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
+  ~ OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
+  ~ SOFTWARE.
+  -->
+
+<persistence xmlns="http://java.sun.com/xml/ns/persistence"
+			 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+			 xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
+			 version="2.0">
+	<persistence-unit name="opendc-frontend">
+		<provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
+		<mapping-file>jpa/schema.xml</mapping-file>
+		<properties>
+			<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver" />
+			<property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/opendc" />
+			<property name="javax.persistence.jdbc.user" value="opendc" />
+			<property name="javax.persistence.jdbc.password" value="opendcpassword" />
+
+			<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />
+			<property name="hibernate.show_sql" value="false" />
+			<property name="hibernate.hbm2ddl.auto" value="validate" />
+		</properties>
+	</persistence-unit>
+</persistence>
diff --git a/opendc-integration-jpa/src/main/resources/jpa/schema.xml b/opendc-integration-jpa/src/main/resources/jpa/schema.xml
new file mode 100644
index 00000000..a14fb96d
--- /dev/null
+++ b/opendc-integration-jpa/src/main/resources/jpa/schema.xml
@@ -0,0 +1,325 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+  ~ MIT License
+  ~
+  ~ Copyright (c) 2017 atlarge-research
+  ~
+  ~ Permission is hereby granted, free of charge, to any person obtaining a copy
+  ~ of this software and associated documentation files (the "Software"), to deal
+  ~ in the Software without restriction, including without limitation the rights
+  ~ to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
+  ~ copies of the Software, and to permit persons to whom the Software is
+  ~ furnished to do so, subject to the following conditions:
+  ~
+  ~ The above copyright notice and this permission notice shall be included in all
+  ~ copies or substantial portions of the Software.
+  ~
+  ~ THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
+  ~ IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
+  ~ FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
+  ~ AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
+  ~ LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
+  ~ OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
+  ~ SOFTWARE.
+  -->
+<entity-mappings version="2.1"
+				 xmlns="http://xmlns.jcp.org/xml/ns/persistence/orm"
+				 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+				 xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence/orm_2_1.xsd">
+
+	<package>nl.atlarge.opendc.integration.jpa.schema</package>
+
+	<entity class="Experiment" access="FIELD" name="experiments">
+		<convert converter="nl.atlarge.opendc.integration.jpa.converter.SchedulerConverter" attribute-name="scheduler" />
+		<attributes>
+			<id name="id" />
+
+			<basic name="name">
+				<column column-definition="text" />
+			</basic>
+
+			<basic name="state">
+				<column column-definition="text" />
+				<enumerated>STRING</enumerated>
+			</basic>
+
+			<basic name="last">
+				<column name="last_simulated_tick" column-definition="int(11)" />
+			</basic>
+
+			<basic name="scheduler">
+				<column name="scheduler_name" />
+			</basic>
+
+			<many-to-one name="trace" target-entity="nl.atlarge.opendc.integration.jpa.schema.Trace">
+				<join-column name="trace_id" />
+			</many-to-one>
+
+			<one-to-one name="path" target-entity="nl.atlarge.opendc.integration.jpa.schema.Path">
+				<join-column name="path_id" />
+			</one-to-one>
+		</attributes>
+	</entity>
+
+	<entity class="Path" access="FIELD" name="paths">
+		<attributes>
+			<id name="id" />
+
+			<one-to-many name="sections" target-entity="nl.atlarge.opendc.integration.jpa.schema.Section">
+				<join-column name="path_id" />
+			</one-to-many>
+		</attributes>
+	</entity>
+
+	<entity class="Section" access="FIELD" name="sections">
+		<attributes>
+			<id name="id" />
+
+			<basic name="startTime">
+				<column name="start_tick" column-definition="int(11)" />
+			</basic>
+
+			<many-to-one name="datacenter">
+				<join-column name="datacenter_id" />
+			</many-to-one>
+		</attributes>
+	</entity>
+
+	<entity class="Trace" access="FIELD" name="traces">
+		<attributes>
+			<id name="id" />
+			<basic name="name">
+				<column column-definition="text" />
+			</basic>
+			<one-to-many name="jobs" target-entity="nl.atlarge.opendc.integration.jpa.schema.Job">
+				<join-column name="trace_id" />
+			</one-to-many>
+		</attributes>
+	</entity>
+
+	<entity class="Job" access="FIELD" name="jobs">
+		<attributes>
+			<id name="id" />
+			<one-to-many name="tasks" target-entity="nl.atlarge.opendc.integration.jpa.schema.Task">
+				<join-column name="job_id" />
+			</one-to-many>
+			<transient name="owner" />
+		</attributes>
+	</entity>
+
+	<entity class="Task" access="FIELD" name="tasks">
+		<convert converter="nl.atlarge.opendc.integration.jpa.converter.ParallelizableConverter" attribute-name="parallelizable" />
+		<attributes>
+			<id name="id" />
+			<basic name="flops">
+				<column name="total_flop_count" column-definition="int(11)" />
+			</basic>
+			<basic name="startTime">
+				<column name="start_tick" column-definition="int(11)" />
+			</basic>
+			<basic name="parallelizable">
+				<column name="parallelizability" column-definition="text" />
+			</basic>
+
+			<one-to-one name="dependency" target-entity="nl.atlarge.opendc.integration.jpa.schema.Task">
+				<join-column name="task_dependency_id" />
+			</one-to-one>
+			<transient name="_dependencies" />
+			<transient name="_remaining" />
+			<transient name="accepted" />
+			<transient name="started" />
+			<transient name="finished" />
+		</attributes>
+	</entity>
+
+	<entity class="Datacenter" access="FIELD" name="datacenters">
+		<attributes>
+			<id name="id" />
+
+			<one-to-many name="rooms" target-entity="Room">
+				<join-column name="datacenter_id" />
+			</one-to-many>
+			<transient name="scheduler" />
+			<transient name="interval" />
+			<transient name="initialState" />
+		</attributes>
+	</entity>
+
+	<entity class="Room" access="FIELD" name="rooms">
+		<attributes>
+			<id name="id" />
+			<basic name="name">
+				<column column-definition="text" />
+			</basic>
+			<basic name="type">
+				<enumerated>STRING</enumerated>
+			</basic>
+			<one-to-many name="objects">
+				<join-table name="tiles">
+					<join-column name="room_id" />
+					<inverse-join-column name="object_id" />
+				</join-table>
+			</one-to-many>
+			<transient name="initialState" />
+		</attributes>
+	</entity>
+
+	<entity class="RoomObject" access="FIELD" name="objects">
+		<inheritance strategy="JOINED" />
+		<discriminator-column name="type" />
+		<attributes>
+			<id name="id"/>
+		</attributes>
+	</entity>
+
+	<entity class="Rack" access="FIELD" name="racks">
+		<discriminator-value>RACK</discriminator-value>
+		<attributes>
+			<id name="id" />
+			<basic name="name">
+				<column column-definition="text" />
+			</basic>
+			<basic name="capacity" />
+			<basic name="powerCapacity">
+				<column name="power_capacity_w" />
+			</basic>
+
+			<one-to-many name="machines">
+				<join-column name="rack_id" />
+			</one-to-many>
+			<transient name="initialState" />
+		</attributes>
+	</entity>
+
+	<entity class="Machine" access="FIELD" name="machines">
+		<attributes>
+			<id name="id" />
+			<basic name="position" />
+
+			<many-to-many name="cpus">
+				<join-table name="machine_cpus">
+					<join-column name="machine_id" />
+					<inverse-join-column name="cpu_id" />
+				</join-table>
+			</many-to-many>
+
+			<many-to-many name="gpus">
+				<join-table name="machine_gpus">
+					<join-column name="machine_id" />
+					<inverse-join-column name="gpu_id" />
+				</join-table>
+			</many-to-many>
+			<transient name="initialState" />
+		</attributes>
+	</entity>
+
+	<entity class="Cpu" access="FIELD" name="cpus">
+		<attributes>
+			<id name="id" />
+			<basic name="manufacturer">
+				<column column-definition="text" />
+			</basic>
+			<basic name="family">
+				<column column-definition="text" />
+			</basic>
+			<basic name="generation">
+				<column column-definition="text" />
+			</basic>
+			<basic name="model">
+				<column column-definition="text" />
+			</basic>
+			<basic name="clockRate">
+				<column name="clock_rate_mhz" />
+			</basic>
+			<basic name="cores">
+				<column name="number_of_cores" />
+			</basic>
+			<basic name="energyConsumption">
+				<column name="energy_consumption_w" />
+			</basic>
+			<transient name="initialState" />
+		</attributes>
+	</entity>
+
+	<entity class="Gpu" access="FIELD" name="gpus">
+		<attributes>
+			<id name="id" />
+			<basic name="manufacturer">
+				<column column-definition="text" />
+			</basic>
+			<basic name="family">
+				<column column-definition="text" />
+			</basic>
+			<basic name="generation">
+				<column column-definition="text" />
+			</basic>
+			<basic name="model">
+				<column column-definition="text" />
+			</basic>
+			<basic name="clockRate">
+				<column name="clock_rate_mhz" />
+			</basic>
+			<basic name="cores">
+				<column name="number_of_cores" />
+			</basic>
+			<basic name="energyConsumption">
+				<column name="energy_consumption_w" />
+			</basic>
+			<transient name="initialState" />
+		</attributes>
+	</entity>
+
+	<entity class="MachineState" access="FIELD" name="machine_states">
+		<attributes>
+			<id name="id">
+				<generated-value strategy="IDENTITY" />
+			</id>
+			<basic name="time">
+				<column name="tick" column-definition="int(11)" />
+			</basic>
+			<basic name="temperature">
+				<column name="temperature_c" />
+			</basic>
+			<basic name="memoryUsage">
+				<column name="in_use_memory_mb" />
+			</basic>
+			<basic name="load">
+				<column name="load_fraction" />
+			</basic>
+
+			<many-to-one name="task">
+				<join-column name="task_id" />
+			</many-to-one>
+			<many-to-one name="machine">
+				<join-column name="machine_id" />
+			</many-to-one>
+			<many-to-one name="experiment">
+				<join-column name="experiment_id" />
+			</many-to-one>
+		</attributes>
+	</entity>
+
+	<entity class="TaskState" access="FIELD" name="task_states">
+		<attributes>
+			<id name="id">
+				<generated-value strategy="IDENTITY" />
+			</id>
+			<basic name="time">
+				<column name="tick" column-definition="int(11)" />
+			</basic>
+			<basic name="remaining">
+				<column name="flops_left" />
+			</basic>
+			<basic name="cores">
+				<column name="cores_used" />
+			</basic>
+
+			<many-to-one name="task">
+				<join-column name="task_id" />
+			</many-to-one>
+			<many-to-one name="experiment">
+				<join-column name="experiment_id" />
+			</many-to-one>
+		</attributes>
+	</entity>
+</entity-mappings>
-- 
cgit v1.2.3