Snapshots

ORMExecuteQuery - Implement params including parameter placeholder su… #234

Sign in to view logs

GitHub Actions / Test Results succeeded Jan 21, 2025 in 0s

All 98 tests pass, 19 skipped in 2s

28 files ±0 28 suites ±0 2s ⏱️ ±0s
117 tests +1 98 ✅ +2 19 💤 - 1 0 ❌ ±0
118 runs +1 99 ✅ +2 19 💤 - 1 0 ❌ ±0

Results for commit 6613496. ± Comparison against earlier commit 26c4681.

Annotations

Check notice on line 0 in .github

github-actions / Test Results

19 skipped tests found

There are 19 skipped tests, see "Raw output" for the full list of skipped tests.

Raw output


            ortus.boxlang.modules.orm.bifs.EntityLoadByExampleTest ‑ It can test the ExampleBIF
ortus.boxlang.modules.orm.bifs.EntityLoadByPKTest ‑ It can load an entity by composite key
ortus.boxlang.modules.orm.bifs.EntityLoadByPKTest ‑ It will add add* methods for *-to-many associations
ortus.boxlang.modules.orm.bifs.EntityLoadByPKTest ‑ It will add remove* methods for associations
ortus.boxlang.modules.orm.bifs.EntityNewTest ‑ It emits events
ortus.boxlang.modules.orm.bifs.EntityReloadTest ‑ It can reload entities using a string variable name, for compat
ortus.boxlang.modules.orm.bifs.ORMClearSessionTest ‑ It can clear the session on a named (alternate) datasource
ortus.boxlang.modules.orm.bifs.ORMEvictCollectionTest ‑ It can test the ExampleBIF
ortus.boxlang.modules.orm.bifs.ORMEvictEntityTest ‑ It can test the ExampleBIF
ortus.boxlang.modules.orm.bifs.ORMEvictQueriesTest ‑ It can test the ExampleBIF
ortus.boxlang.modules.orm.bifs.ORMExecuteQueryTest ‑ It can run an HQL query with HQL, params, and unique boolean
ortus.boxlang.modules.orm.bifs.ORMExecuteQueryTest ‑ It supports positional params
ortus.boxlang.modules.orm.config.EntityEventsTest ‑ It fires preDelete,postDelete
ortus.boxlang.modules.orm.config.EntityEventsTest ‑ It fires preLoad,postLoad
ortus.boxlang.modules.orm.config.ORMConfigTest ‑ testDialectNormalization()
ortus.boxlang.modules.orm.config.ORMConfigTest ‑ testDialectTranslation()
ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ It can map a struct/map collection
ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ It can map an array/bag collection
ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ testMultipleFKColumns(String)

Check notice on line 0 in .github

github-actions / Test Results

117 tests found

There are 117 tests, see "Raw output" for the full list of tests.

Raw output


            ortus.boxlang.modules.orm.TransactionManagementTest ‑ Can save/flush entity modifications outside of a transaction block
ortus.boxlang.modules.orm.TransactionManagementTest ‑ It commits on transaction close
ortus.boxlang.modules.orm.TransactionManagementTest ‑ It commits on transaction commit, despite rollback
ortus.boxlang.modules.orm.TransactionManagementTest ‑ It rolls back on transaction rollback
ortus.boxlang.modules.orm.TransactionManagementTest ‑ It wont cause table/connection locking when ORM and native JDBC queries coexist
ortus.boxlang.modules.orm.bifs.EntityDeleteTest ‑ It can delete existing entities from the database
ortus.boxlang.modules.orm.bifs.EntityLoadByExampleTest ‑ It can test the ExampleBIF
ortus.boxlang.modules.orm.bifs.EntityLoadByPKTest ‑ It can load an entity by composite key
ortus.boxlang.modules.orm.bifs.EntityLoadByPKTest ‑ It can load an entity by integer key
ortus.boxlang.modules.orm.bifs.EntityLoadByPKTest ‑ It can load an entity by varchar key
ortus.boxlang.modules.orm.bifs.EntityLoadByPKTest ‑ It can load an entity from the non-default datasource
ortus.boxlang.modules.orm.bifs.EntityLoadByPKTest ‑ It can load an entity from the non-default datasource and call a getter method
ortus.boxlang.modules.orm.bifs.EntityLoadByPKTest ‑ It will add add* methods for *-to-many associations
ortus.boxlang.modules.orm.bifs.EntityLoadByPKTest ‑ It will add has* methods for associations
ortus.boxlang.modules.orm.bifs.EntityLoadByPKTest ‑ It will add remove* methods for associations
ortus.boxlang.modules.orm.bifs.EntityLoadTest ‑ It can load SINGLE entity by filter criteria
ortus.boxlang.modules.orm.bifs.EntityLoadTest ‑ It can load UNIQUE entity by ID
ortus.boxlang.modules.orm.bifs.EntityLoadTest ‑ It can load array of entities by ID
ortus.boxlang.modules.orm.bifs.EntityLoadTest ‑ It can load array of entities by filter criteria
ortus.boxlang.modules.orm.bifs.EntityLoadTest ‑ It can load array of entities by filter criteria, sorting by custom order clause
ortus.boxlang.modules.orm.bifs.EntityLoadTest ‑ It can load array of entities with maxResults and offset options
ortus.boxlang.modules.orm.bifs.EntityLoadTest ‑ It can load array of entities with no filter or ID
ortus.boxlang.modules.orm.bifs.EntityMergeTest ‑ It can merge an entity into the persistence context
ortus.boxlang.modules.orm.bifs.EntityNameArrayTest ‑ It can get entities for a custom datasource name
ortus.boxlang.modules.orm.bifs.EntityNameArrayTest ‑ It returns an array of entity names for ALL datasources
ortus.boxlang.modules.orm.bifs.EntityNameListTest ‑ It can get entities for a custom datasource name
ortus.boxlang.modules.orm.bifs.EntityNameListTest ‑ It returns a list of entity names
ortus.boxlang.modules.orm.bifs.EntityNameListTest ‑ It returns a list of entity names with a custom delimiter
ortus.boxlang.modules.orm.bifs.EntityNewTest ‑ It can create new entities
ortus.boxlang.modules.orm.bifs.EntityNewTest ‑ It can populate new entities with association UDFs
ortus.boxlang.modules.orm.bifs.EntityNewTest ‑ It can populate new entities with data
ortus.boxlang.modules.orm.bifs.EntityNewTest ‑ It emits events
ortus.boxlang.modules.orm.bifs.EntityReloadTest ‑ It can reload entities
ortus.boxlang.modules.orm.bifs.EntityReloadTest ‑ It can reload entities using a string variable name, for compat
ortus.boxlang.modules.orm.bifs.EntityReloadTest ‑ It throws if the argument is not a valid entity
ortus.boxlang.modules.orm.bifs.EntitySaveTest ‑ It can save new entities to the database
ortus.boxlang.modules.orm.bifs.EntitySaveTest ‑ It can save new entities to the database with forceinsert:true
ortus.boxlang.modules.orm.bifs.EntityToQueryTest ‑ It can convert one entity into a single-row query
ortus.boxlang.modules.orm.bifs.GetHibernateVersionTest ‑ It can get the hibernate version
ortus.boxlang.modules.orm.bifs.ORMClearSessionTest ‑ It can clear the session for the default datasource
ortus.boxlang.modules.orm.bifs.ORMClearSessionTest ‑ It can clear the session on a named (alternate) datasource
ortus.boxlang.modules.orm.bifs.ORMCloseAllSessionsTest ‑ It can close all ORM sessions
ortus.boxlang.modules.orm.bifs.ORMCloseSessionTest ‑ It can close the session for the default datasource
ortus.boxlang.modules.orm.bifs.ORMCloseSessionTest ‑ It can close the session on a named (alternate) datasource
ortus.boxlang.modules.orm.bifs.ORMEvictCollectionTest ‑ It can test the ExampleBIF
ortus.boxlang.modules.orm.bifs.ORMEvictEntityTest ‑ It can test the ExampleBIF
ortus.boxlang.modules.orm.bifs.ORMEvictQueriesTest ‑ It can test the ExampleBIF
ortus.boxlang.modules.orm.bifs.ORMExecuteQueryTest ‑ It can run an HQL query on another datasource
ortus.boxlang.modules.orm.bifs.ORMExecuteQueryTest ‑ It can run an HQL query with HQL and params
ortus.boxlang.modules.orm.bifs.ORMExecuteQueryTest ‑ It can run an HQL query with HQL, params, and unique boolean
ortus.boxlang.modules.orm.bifs.ORMExecuteQueryTest ‑ It can run an HQL query with hql, unique, and options
ortus.boxlang.modules.orm.bifs.ORMExecuteQueryTest ‑ It can run an HQL query with just HQL
ortus.boxlang.modules.orm.bifs.ORMExecuteQueryTest ‑ It supports positional params
ortus.boxlang.modules.orm.bifs.ORMFlushAllTest ‑ It can flush ALL sessions
ortus.boxlang.modules.orm.bifs.ORMFlushTest ‑ It can flush the session
ortus.boxlang.modules.orm.bifs.ORMGetSessionFactoryTest ‑ It can get the default ORM session factory
ortus.boxlang.modules.orm.bifs.ORMGetSessionFactoryTest ‑ It can get the session factory from a named datasource
ortus.boxlang.modules.orm.bifs.ORMGetSessionFactoryTest ‑ It throws if the named datasource does not exist
ortus.boxlang.modules.orm.bifs.ORMGetSessionTest ‑ It can get the ORM session from a named datasource
ortus.boxlang.modules.orm.bifs.ORMGetSessionTest ‑ It can get the current ORM session
ortus.boxlang.modules.orm.bifs.ORMGetSessionTest ‑ It can use queryExecute after opening ORM session
ortus.boxlang.modules.orm.bifs.ORMGetSessionTest ‑ It throws if the named datasource does not exist or is not configured for ORM
ortus.boxlang.modules.orm.bifs.ORMReloadTest ‑ It can reload the ORM application
ortus.boxlang.modules.orm.config.EntityEventsTest ‑ It fires preDelete,postDelete
ortus.boxlang.modules.orm.config.EntityEventsTest ‑ It fires preInsert,postInsert
ortus.boxlang.modules.orm.config.EntityEventsTest ‑ It fires preLoad,postLoad
ortus.boxlang.modules.orm.config.EntityEventsTest ‑ It fires preUpdate,postUpdate
ortus.boxlang.modules.orm.config.ORMConfigTest ‑ testDefaultConfig()
ortus.boxlang.modules.orm.config.ORMConfigTest ‑ testDefaultOpposites()
ortus.boxlang.modules.orm.config.ORMConfigTest ‑ testDialectNormalization()
ortus.boxlang.modules.orm.config.ORMConfigTest ‑ testDialectTranslation()
ortus.boxlang.modules.orm.config.ORMConfigTest ‑ testGenericSettings()
ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ It can map a struct/map collection
ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ It can map an array/bag collection
ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ It generates the entity-name from the class name
ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1]  class persistent {
 	property
 		name="the_id"
 		fieldtype="id"
 		generator="select"
generated="insert"
selectKey="foo";
 }

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class
	persistent="true"
	entityName="Car"
	table="vehicles"
	schema="foo"
	catalog="morefoo"
	optimisticLock="all"
{}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent cacheuse="transactional" cacheName="foo" cacheInclude="non-lazy" {}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent discriminatorValue="Ford" discriminatorColumn="autoType" {}
ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent readonly="true" {}
ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
	property
		fieldtype="version"
		generated="never"
		column="itemVersion"
		ormType="integer"
		insert="false"
		name="version";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
	property
		insert=false
		update=false
		unique=true
		table="foo"
		notNull=true
		dbDefault="test"
		name="title";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
	property
		length=12
		scale=10
		precision=2
		column="amountCol"
		name="amount";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
	property
		name        = "owner"
		cfc         = "Person"
		fieldtype   = "one-to-one"
		fkcolumn    = "FK_owner"
		foreignKey  = "fooID"
		cascade     = "all"
		constrained = "true";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
	property
		name="createdBy"
		fieldtype="many-to-one"
		cfc="Vehicle"
		fkcolumn="FK_manufacturer"
		fetch="select"
		cascade="all"
		insert="false"
		update="false"
		lazy="true"
		persistent=true;
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
	property
		name="name"
		insert=false
		update=false;
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
	property
		name="owner"
		cfc="Person"
		mappedBy="id"
		fieldtype="one-to-one"
		foreignKey="fooID"
		cascade="all-delete-orphan"
		constrained="true"
		fetch="join"
		lazy="extra";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
	property
		name="owners"
		type="array"
		cfc="Person"
		cascade="all"
		fieldtype="many-to-many"
		linkTable="tblOwners"
		linkCatalog="myDB"
		linkSchema="dbo"
		fkcolumn="FK_owner"
		mappedBy="owners"
		orderBy="name";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
	property
		name="owners"
		type="array"
		cfc="Person"
		cascade="all"
		fieldtype="one-to-many"
		fkcolumn="FK_owner"
		mappedBy="owners"
		orderBy="name DESC"
		where="Age IS NOT NULL"
		optimisticLock="false";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
	property
		name="the_id"
		fieldtype="id"
		generator="increment";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
	property
		name="the_id"
		fieldtype="id"
		ormtype="integer";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
	property
		name="the_name"
		column="NameColumn"
		sqltype="varchar";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
	property
	name="the_name"
	formula="SELECT TOP 1 name from theNames";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
 property name="the_name" ormtype="varchar(50)";
 property name="foo" ormtype="java.sql.Timestamp";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent {
 property name="the_name";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent { property name="name"; property name="notMapped" persistent="false"; }
ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent{
	property name="id1" fieldtype="id";
	property name="id2" fieldtype="id" sqltype="varchar(50)";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [1] class persistent{ property name="the_id" fieldtype="id"; }
ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] 	@Discriminator {
		"name"    : "autoType",
		"value"   : "Ford",
		"type"    : "string",
		"formula" : "foo",
		"force"   : "false",
		"insert"  : "true",
	}
	class {}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2]   @Entity
  class {
  	@Column
property name="the_name";
  }

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] @Cache {
	strategy: "transactional",
	region  : "foo",
	include   : "non-lazy"
}
@Entity
class {}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] @Entity
class {
	@Column{
		"table"      : "foo",
		"unique"     : true,
		"nullable"   : false,
		"insertable" : false,
		"updateable" : false,
		"default"    : "test"
	}
	property name="title";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] @Entity
class {
	@Column{
		formula="SELECT TOP 1 name from theNames"
	}
 	property name="the_name";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] @Entity
class {
	@Column{
		name      : "amountCol",
		length    : 12,
		scale     : 10,
		precision : 2
	}
	property name="amount";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] @Entity
class {
	@Column{
		sqltype="varchar",
		name="NameColumn"
	}
 	property name="the_name";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] @Entity
class {
	@Id
	@GeneratedValue{
		"strategy"  : "select",
		"selectKey" : "foo",
		"generated" : "insert"
	}
	property name="the_id";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] @Entity
class {
	@Id
	@GeneratedValue{
		"strategy" : "increment"
	}
	property name="the_id";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] @Entity
class {
	@Immutable
	@Column
	property name="name";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] @Entity
class {
	@OneToMany{
		"mappedBy"       : "owners",
		"orderBy"        : "name DESC",
		"where"          : "Age IS NOT NULL",
		"optimisticLock" : false,
		"fkcolumn"       : "FK_owner",
		"cascade"        : "all",
		"class"          : "Person"
	}
	property name="owners" type="array";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] @Entity
class {
	@OneToOne {
		// "mappedBy" : "id",
		"fkcolumn"   : "FK_owner",
		"foreignKey" : "fooID",
		"cascade"    : "all",
		"constrained": true,
		"fetch"      : "join",
		"lazy"       : "extra"
	}
	property name="owner";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] @Entity "Car"
@Table{
	"name"   : "vehicles",
	"schema" : "foo",
	"catalog": "morefoo"
}
@OptimisticLock "all"
class {}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] @Immutable 
class {}
ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] class {
	@Id
	@ORMType "integer"
	property name="the_id";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] class { @Column property name="name"; @Transient property name="notMapped"; }
ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] class{
	@Id property name="id1";
	@Id property name="id2" sqltype="varchar(50)";
}

ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ [2] class{ @Id property name="the_id"; }
ortus.boxlang.modules.orm.mapping.HibernateXMLWriterTest ‑ testMultipleFKColumns(String)

View more details on GitHub Actions