首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >ORMLite:是否有一种方法可以通知QueryBuilder在连接中应该使用哪种引用?

问ORMLite:是否有一种方法可以通知QueryBuilder在连接中应该使用哪种引用?
EN

Stack Overflow用户
提问于 2013-06-06 16:09:05
回答 1查看 163关注 0票数 0

我试图对以下类执行一个联合查询:

代码语言:javascript
复制
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:

代码语言:javascript
复制
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();

问题是创建的查询与设备连接,而不是特性:

代码语言:javascript
复制
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中放置特征参考,问题就不会发生.

代码语言:javascript
复制
public class EquipmentCharacteristic {
    @DatabaseField(canBeNull = false, foreign = true, uniqueCombo = true)
    private Characteristic characteristic;

    @DatabaseField(canBeNull = false, foreign = true, uniqueCombo = true)
    private Equipment equipment;

    ...
}

是否有一种方法可以通知QueryBuilder用于连接的表(类)?

谢谢。

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2013-07-22 17:37:46

问题是创建的查询与设备连接,而不是特性:

对不起,我没能复制这个。我在主干中添加了以下测试。如果您能够找出为什么我的测试工作,但您的代码失败,这将是非常有帮助的。

https://github.com/j256/ormlite-core/commit/78223c682aa0d7063c095afc0e26b466aeb618af

不幸的是,没有多少答案。

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/16966970

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档