PersonHasRole( RelationManager manager, boolean full, Person subject, Role object, java.sql.Timestamp _ctime, java.sql.Timestamp _mtime, Person _createdBy) { if (subject == null || object == null) { throw new IllegalArgumentException(); } this.manager = manager; this.subject = subject; this.subject_refid = subject.id(); this.object = object; this.object_refid = object.id(); this._ctime = _ctime; this.fetched_ctime = true; this._mtime = _mtime; this.fetched_mtime = true; this._createdBy = _createdBy; this.ref_createdBy = _createdBy.id(); this.fetched_createdBy = true; }
@Override public void create() throws de.fu.weave.orm.DatabaseException { String query = "INSERT INTO " + "\"scetris\".\"personHasRole\"" + " (Person, Role, , \"ctime\", \"mtime\", \"created_by\")" + " VALUES (?, ?, ?);"; try { java.sql.PreparedStatement stmt = manager.connectionManager.getConnection().prepareStatement(query); stmt.setInt(1, subject.id()); stmt.setInt(2, object.id()); int i = 3; stmt.setTimestamp(i++, _ctime); stmt.setTimestamp(i++, _mtime); if (ref_createdBy != null) { stmt.setInt(i++, ref_createdBy); } else { stmt.setNull(i++, java.sql.Types.INTEGER); } stmt.execute(); } catch (java.sql.SQLException e) { throw new de.fu.weave.orm.DatabaseException(query, e); } }
/** tests the behavior of XML id/idref. */ public void testXMLIDIDREF() throws Exception { Person person = new Person(); person.id = "me"; person.name = "me"; person.father = new Person(); person.father.id = "father"; person.father.name = "father"; person.mother = new Person(); person.mother.id = "mother"; person.mother.name = "mother"; NonRefPerson nonRefperson = new NonRefPerson(); nonRefperson.id = "me"; nonRefperson.name = "me"; nonRefperson.father = "father"; nonRefperson.mother = "mother"; Marshaller marshaller = JAXBContext.newInstance(NonRefPerson.class).createMarshaller(); ByteArrayOutputStream out = new ByteArrayOutputStream(); marshaller.marshal(nonRefperson, out); Unmarshaller unmarshaller = JAXBContext.newInstance(Person.class).createUnmarshaller(); byte[] bytes = out.toByteArray(); // System.out.println(new String(bytes, "utf-8")); Person deserializedPerson = (Person) unmarshaller.unmarshal(new ByteArrayInputStream(bytes)); assertEquals("me", deserializedPerson.id); assertEquals("me", deserializedPerson.name); assertNull( "The XMLID/IDREF tests have failed, meaning JAXB's doing some inference, and you may need add back the ID/IDREF warnings.", deserializedPerson.father); assertNull( "The XMLID/IDREF tests have failed, meaning JAXB's doing some inference, and you may need add back the ID/IDREF warnings.", deserializedPerson.mother); }
public void testOneToOneExplicitJoinColumn() throws Exception { assertTrue(SchemaUtil.isColumnPresent("MedicalHistory", "FK1", getCfg())); assertTrue(SchemaUtil.isColumnPresent("MedicalHistory", "FK2", getCfg())); assertTrue(!SchemaUtil.isColumnPresent("MedicalHistory", "firstname", getCfg())); Person e = new Person(); e.id = new PersonId(); e.id.firstName = "Emmanuel"; e.id.lastName = "Bernard"; Session s = openSession(); s.getTransaction().begin(); s.persist(e); MedicalHistory d = new MedicalHistory(); d.patient = e; s.persist(d); s.flush(); s.clear(); PersonId pId = new PersonId(); pId.firstName = e.id.firstName; pId.lastName = e.id.lastName; d = (MedicalHistory) s.get(MedicalHistory.class, pId); assertEquals(pId.firstName, d.patient.id.firstName); s.delete(d); s.delete(d.patient); s.getTransaction().commit(); s.close(); }
PersonHasRole(RelationManager manager, Person subject, Role object) { if (subject == null || object == null) { throw new IllegalArgumentException(); } this.manager = manager; this.subject = subject; this.subject_refid = subject.id(); this.object = object; this.object_refid = object.id(); }
public List<Person> queryAll() { List<Person> persons = new ArrayList<>(); Cursor cursor = db.rawQuery("SELECT id,name,age,phone FROM person", null); Person person; while (cursor != null && cursor.moveToNext()) { person = new Person(); person.id = cursor.getInt(cursor.getColumnIndex("id")); person.name = cursor.getString(cursor.getColumnIndex("name")); person.age = cursor.getInt(cursor.getColumnIndex("age")); person.phone = cursor.getString(cursor.getColumnIndex("phone")); persons.add(person); } return persons; }
PersonTakesPartInElementInstance( RelationManager manager, Person subject, CourseElementInstance object, Timeslot _timeslot) { if (subject == null || object == null) { throw new IllegalArgumentException(); } this.manager = manager; this.subject = subject; this.subject_refid = subject.id(); this.object = object; this.object_refid = object.id(); this._timeslot = _timeslot; this.ref_timeslot = _timeslot.id(); this.fetched_timeslot = true; }
@Override public void create() throws de.fu.weave.orm.DatabaseException { String query = "INSERT INTO " + "\"scetris\".\"personTakesPartInElementInstance\"" + " (Person, CourseElementInstance, , \"timeslot\")" + " VALUES (?);"; try { java.sql.PreparedStatement stmt = manager.connectionManager.getConnection().prepareStatement(query); stmt.setInt(1, subject.id()); stmt.setInt(2, object.id()); int i = 3; stmt.setInt(i++, ref_timeslot); stmt.execute(); } catch (java.sql.SQLException e) { throw new de.fu.weave.orm.DatabaseException(query, e); } }
public void testOneToOneExplicitJoinColumn() throws Exception { assertTrue(SchemaUtil.isColumnPresent("MedicalHistory", "FK1", getCfg())); assertTrue(SchemaUtil.isColumnPresent("MedicalHistory", "FK2", getCfg())); assertTrue(!SchemaUtil.isColumnPresent("MedicalHistory", "firstname", getCfg())); Person e = new Person(); e.id = new PersonId(); e.id.firstName = "Emmanuel"; e.id.lastName = "Bernard"; Session s = openSession(); s.getTransaction().begin(); s.persist(e); MedicalHistory d = new MedicalHistory(); // d.id = new PersonId(); // d.id.firstName = "Emmanuel"; //FIXME not needed when foreign is enabled // d.id.lastName = "Bernard"; //FIXME not needed when foreign is enabled d.patient = e; s.persist(d); s.flush(); s.clear(); d = (MedicalHistory) s.get(MedicalHistory.class, d.id); assertEquals(d.id.firstName, d.patient.id.firstName); s.getTransaction().rollback(); s.close(); }