diff options
Diffstat (limited to 'opendc-integration-jpa/src/main/resources')
| -rw-r--r-- | opendc-integration-jpa/src/main/resources/META-INF/persistence.xml | 44 | ||||
| -rw-r--r-- | opendc-integration-jpa/src/main/resources/jpa/schema.xml | 325 |
2 files changed, 369 insertions, 0 deletions
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> |