Mapping SQL to Abstract Class

[icu222much]

My project is using the hexagonal architecture and I am wondering if I can use sql2o custom converters (https://github.com/aaberg/sql2o/wiki/Implementing-and-using-custom-converters) to determine which Adapter sql2o should be mapped to.

Would it be possible use sql2o custom converters (https://github.com/aaberg/sql2o/wiki/Implementing-and-using-custom-converters) to map to an abstracted class based on the result from the database? So for example, I have the abstract class Device, and two classes that implements Device (ElectricDevice, SolarDevice). Device has the property 'type' specifying if it is electric or solar. Would it be possible to write a sql2o custom converter that can read the response from the fetch, and then determine whether to create an ElectricDevice object or SolarDevice object based off the database fetch?

I have tried following the instructions on the custom converter page (https://github.com/aaberg/sql2o/wiki/Implementing-and-using-custom-converters) but the custom converter code I wrote never got executed. Is this custom converter used for converting values and cannot be used for determine which class sql2o maps the sql response into?

public Device fetch(int id) {
	final String query = "SELECT * FROM device WHERE id = :idParam";

	try (Connection connection = sql2o.open()) {
		List<Device> devices = connection.createQuery(query)
				.addParameter("idParam", id.toString())
				.executeAndFetch(Device.class); // Can we use a converter here to specify ElectricDevice.class or SoloarDevice.class?
		if (!devices.isEmpty()) {
			return devices.get(0);
		}
		return null;
	} catch (Exception e) {
		e.printStackTrace();
	}
}

public abstract class Device {
	private int id;
	private string type;
	private string name;
}

public class ElectricDevice extends Device { ... }

public class SolarDevice extends Device { ... }

[arnaudroger]

@icu222much simpleflatmapper supports discriminator and support sql2o, unfortunately right now it's not possible to directly customised the SfmResultSetHandlerFactoryBuilder to add discriminator definition. just added a ticket to allow for that. arnaudroger/SimpleFlatMapper#608

[icu222much]

@arnaudroger Great, thank you.

[arnaudroger]

@icu222much pushed 3.2.0 of sfm-sql2o , I put an example in the release notes
https://simpleflatmapper.org/2019/02/11/v6.3.0.html
the test is there
https://github.com/arnaudroger/SimpleFlatMapper/blob/4cf83f8cc1992efd728ba21120a601fb2c5f0906/sfm-sql2o/src/test/java/org/simpleflatmapper/sql2o/test/Sql2oIntegrationTest.java#L47

[icu222much]

@arnaudroger thank you!