我试图对以下类执行一个联合查询:
public class EquipmentCharacteristic {
@DatabaseField(canBeNull = false, foreign = true, uniqueCombo = true)
private Equipment equipment;
@DatabaseField(canBeNull = false, foreign = true, uniqueCombo = true)
private Characteristic characteristic;
...
}
public class Characteristic {
...
}
public class Equipment {
...
}QueryBuilder:
QueryBuilder<EquipmentCharacteristic, ?> daoEC = entityDAO.getDAO(
EquipmentCharacteristic.class).queryBuilder();
daoEC.where().eq(EquipmentCharacteristic.EQUIPMENT + "_id", equipment.getId());
QueryBuilder<Characteristic, ?> daoCharacteristic = entityDAO.getDAO(
Characteristic.class).queryBuilder();
return daoEC.join(daoCharacteristic)
.selectRaw(
"EquipmentCharacteristic." + EquipmentCharacteristic.ID,
"EquipmentCharacteristic." + EquipmentCharacteristic.EQUIPMENT + "_" + Equipment.ID,
"EquipmentCharacteristic." + EquipmentCharacteristic.POSSIBLE_VALUES,
"EquipmentCharacteristic." + EquipmentCharacteristic.CHARACTERISTIC + "_" + Characteristic.ID,
"EquipmentCharacteristic." + EquipmentCharacteristic.VALUE,
"Characteristic." + Characteristic.FIXED_VALUE,
"Characteristic." + Characteristic.UNIT,
"Characteristic." + Characteristic.CHARACTERISTIC)
.queryRaw().closeableIterator();问题是创建的查询与设备连接,而不是特性:
SELECT
EquipmentCharacteristic.id,
EquipmentCharacteristic.equipment_id,
EquipmentCharacteristic.possibleValues,
EquipmentCharacteristic.characteristic_id,
EquipmentCharacteristic.value,
Characteristic.fixedValue,
Characteristic.unit,
Characteristic.characteristic
FROM `EquipmentCharacteristic` INNER JOIN `Characteristic` ON `EquipmentCharacteristic`.`equipment_id` = `Characteristic`.`id` 如果我在设备前在EquipmentCharacteristic中放置特征参考,问题就不会发生.
public class EquipmentCharacteristic {
@DatabaseField(canBeNull = false, foreign = true, uniqueCombo = true)
private Characteristic characteristic;
@DatabaseField(canBeNull = false, foreign = true, uniqueCombo = true)
private Equipment equipment;
...
}是否有一种方法可以通知QueryBuilder用于连接的表(类)?
谢谢。
发布于 2013-07-22 17:37:46
问题是创建的查询与设备连接,而不是特性:
对不起,我没能复制这个。我在主干中添加了以下测试。如果您能够找出为什么我的测试工作,但您的代码失败,这将是非常有帮助的。
https://github.com/j256/ormlite-core/commit/78223c682aa0d7063c095afc0e26b466aeb618af
不幸的是,没有多少答案。
https://stackoverflow.com/questions/16966970
复制相似问题