C++ (Cpp) TSqlORMapper Examples

Example #1

File: tsessionsqlobjectstore.cpp Project: AbhimanyuAryan/treefrog-framework

int TSessionSqlObjectStore::gc(const QDateTime &expire)
{
    TSqlORMapper<TSessionObject> mapper;
    TCriteria cri(TSessionObject::UpdatedAt, TSql::LessThan, expire);
    int cnt = mapper.removeAll(cri);
    return cnt;
}

Example #2

File: tsessionsqlobjectstore.cpp Project: skipbit/treefrog-framework

bool TSessionSqlObjectStore::store(TSession &session)
{
    TSqlORMapper<TSessionObject> mapper;
    TCriteria cri(TSessionObject::Id, TSql::Equal, session.id());
    TSessionObject so = mapper.findFirst(cri);

#ifndef TF_NO_DEBUG
    {
        QByteArray badummy;
        QDataStream dsdmy(&badummy, QIODevice::ReadWrite);
        dsdmy << *static_cast<const QVariantMap *>(&session);

        TSession dummy;
        dsdmy.device()->seek(0);
        dsdmy >> *static_cast<QVariantMap *>(&dummy);
        if (dsdmy.status() != QDataStream::Ok) {
            tSystemError("Failed to store a session into the cookie store. Must set objects that can be serialized.");
        }
    }
#endif

    QDataStream ds(&so.data, QIODevice::WriteOnly);
    ds << *static_cast<const QVariantMap *>(&session);

    if (ds.status() != QDataStream::Ok) {
        tSystemError("Failed to store session. Must set objects that can be serialized.");
        return false;
    }

    if (so.isNull()) {
        so.id = session.id();
        return so.create();
    }
    return so.update();
}

Example #3

File: tsessionsqlobjectstore.cpp Project: Keloran/treefrog-framework

bool TSessionSqlObjectStore::remove(const QDateTime &garbageExpiration)
{
    TSqlORMapper<TSessionObject> mapper;
    TCriteria cri(TSessionObject::UpdatedAt, TSql::LessThan, garbageExpiration);
    int cnt = mapper.removeAll(cri);
    return (cnt >= 0);
}

Example #4

File: refpackingdef.cpp Project: hks2002/AM

RefPackingDef RefPackingDef::get(const QString &createdBy, const QString &updatedBy)
{
    TCriteria cri;
    cri.add(RefPackingDefObject::CreatedBy, createdBy);
    cri.add(RefPackingDefObject::UpdatedBy, updatedBy);
    TSqlORMapper<RefPackingDefObject> mapper;
    return RefPackingDef(mapper.findFirst(cri));
}

Example #5

File: vehicles.cpp Project: czjin/bbpark

Vehicles Vehicles::get(int id, int lockRevision)
{
    TSqlORMapper<VehiclesObject> mapper;
    TCriteria cri;
    cri.add(VehiclesObject::Id, id);
    cri.add(VehiclesObject::LockRevision, lockRevision);
    return Vehicles(mapper.findFirst(cri));
}

Example #6

File: parkattendants.cpp Project: czjin/bbpark

ParkAttendants ParkAttendants::get(int id, int lockRevision)
{
    TSqlORMapper<ParkAttendantsObject> mapper;
    TCriteria cri;
    cri.add(ParkAttendantsObject::Id, id);
    cri.add(ParkAttendantsObject::LockRevision, lockRevision);
    return ParkAttendants(mapper.findFirst(cri));
}

Example #7

File: chatlog.cpp Project: treefrogframework/chatapp

ChatLog ChatLog::get(int id, int lockRevision)
{
    TSqlORMapper<ChatLogObject> mapper;
    TCriteria cri;
    cri.add(ChatLogObject::Id, id);
    cri.add(ChatLogObject::LockRevision, lockRevision);
    return ChatLog(mapper.findFirst(cri));
}

Example #8

File: uservehicle.cpp Project: czjin/bbpark

UserVehicle UserVehicle::get(int id, int lockRevision)
{
    TSqlORMapper<UserVehicleObject> mapper;
    TCriteria cri;
    cri.add(UserVehicleObject::Id, id);
    cri.add(UserVehicleObject::LockRevision, lockRevision);
    return UserVehicle(mapper.findFirst(cri));
}

Example #9

File: accountsrecharge.cpp Project: czjin/bbpark

QJsonArray AccountsRecharge::getAllJson()
{
    QJsonArray array;
    TSqlORMapper<AccountsRechargeObject> mapper;

    if (mapper.find() > 0) {
        for (TSqlORMapperIterator<AccountsRechargeObject> i(mapper); i.hasNext(); ) {
            array.append(QJsonValue(QJsonObject::fromVariantMap(AccountsRecharge(i.next()).toVariantMap())));
        }
    }
    return array;
}

Example #10

File: parkattendants.cpp Project: czjin/bbpark

QJsonArray ParkAttendants::getAllJson()
{
    QJsonArray array;
    TSqlORMapper<ParkAttendantsObject> mapper;

    if (mapper.find() > 0) {
        for (TSqlORMapperIterator<ParkAttendantsObject> i(mapper); i.hasNext(); ) {
            array.append(QJsonValue(QJsonObject::fromVariantMap(ParkAttendants(i.next()).toVariantMap())));
        }
    }
    return array;
}

Example #11

File: uservehicle.cpp Project: czjin/bbpark

QJsonArray UserVehicle::getAllJson()
{
    QJsonArray array;
    TSqlORMapper<UserVehicleObject> mapper;

    if (mapper.find() > 0) {
        for (TSqlORMapperIterator<UserVehicleObject> i(mapper); i.hasNext(); ) {
            array.append(QJsonValue(QJsonObject::fromVariantMap(UserVehicle(i.next()).toVariantMap())));
        }
    }
    return array;
}

Example #12

File: chatlog.cpp Project: treefrogframework/chatapp

void ChatLog::removeOldLogs(int remainingCount)
{
    int del = count() - remainingCount;
    if (del > 0) {
        TSqlORMapper<ChatLogObject> mapper;
        mapper.setSortOrder(ChatLogObject::Id, Tf::DescendingOrder);
        auto log = mapper.findFirst();
        int maxId = log.id;

        TCriteria ctr(ChatLogObject::Id, TSql::LessEqual, maxId - remainingCount);
        mapper.removeAll(ctr);
    }
}

Example #13

File: tsessionsqlobjectstore.cpp Project: Keloran/treefrog-framework

bool TSessionSqlObjectStore::store(TSession &session)
{
    TSqlORMapper<TSessionObject> mapper;
    TCriteria cri(TSessionObject::Id, TSql::Equal, session.id());
    TSessionObject so = mapper.findFirst(cri);

    QDataStream ds(&so.data, QIODevice::WriteOnly);
    ds << *static_cast<const QVariantHash *>(&session);

    if (so.isEmpty()) {
        so.id = session.id();
        return so.create();
    }
    return so.update();
}

Example #14

File: tsessionsqlobjectstore.cpp Project: Keloran/treefrog-framework

TSession TSessionSqlObjectStore::find(const QByteArray &id, const QDateTime &modified)
{
    TSqlORMapper<TSessionObject> mapper;
    TCriteria cri;
    cri.add(TSessionObject::Id, TSql::Equal, id);
    cri.add(TSessionObject::UpdatedAt, TSql::GreaterEqual, modified);

    TSessionObject sess = mapper.findFirst(cri);
    if (sess.isEmpty())
        return TSession();
    
    TSession result(id);
    QDataStream ds(&sess.data, QIODevice::ReadOnly);
    ds >> *static_cast<QVariantHash *>(&result);
    return result;  
}

Example #15

File: tsessionsqlobjectstore.cpp Project: skipbit/treefrog-framework

TSession TSessionSqlObjectStore::find(const QByteArray &id)
{
    QDateTime modified = QDateTime::currentDateTime().addSecs(-lifeTimeSecs());
    TSqlORMapper<TSessionObject> mapper;
    TCriteria cri;
    cri.add(TSessionObject::Id, TSql::Equal, id);
    cri.add(TSessionObject::UpdatedAt, TSql::GreaterEqual, modified);

    TSessionObject so = mapper.findFirst(cri);
    if (so.isNull()) {
        return TSession();
    }

    TSession session(id);
    QDataStream ds(&so.data, QIODevice::ReadOnly);
    ds >> *static_cast<QVariantMap *>(&session);

    if (ds.status() != QDataStream::Ok) {
        tSystemError("Failed to load a session from the sqlobject store.");
    }
    return session;
}

Example #16

File: vmenusgroupmenurole.cpp Project: hks2002/AM

VMenusGroupMenuRole VMenusGroupMenuRole::get(int roleId, int menusGroupOrder, int menusGroupId, const QString &menusGroupCd, const QString &menusGroupNameZh, const QString &menusGroupNameEn, const QString &menusGroupTooltip, const QString &menusGroupDesc, int menuId, int menuOrder, const bool &breakBool, const QString &menuCd, const QString &menuNameZh, const QString &menuNameEn, const QString &menuTooltip, const QString &menuDesc, const QString &controller, const QString &action)
{
    TCriteria cri;
    cri.add(VMenusGroupMenuRoleObject::RoleId, roleId);
    cri.add(VMenusGroupMenuRoleObject::MenusGroupOrder, menusGroupOrder);
    cri.add(VMenusGroupMenuRoleObject::MenusGroupId, menusGroupId);
    cri.add(VMenusGroupMenuRoleObject::MenusGroupCd, menusGroupCd);
    cri.add(VMenusGroupMenuRoleObject::MenusGroupNameZh, menusGroupNameZh);
    cri.add(VMenusGroupMenuRoleObject::MenusGroupNameEn, menusGroupNameEn);
    cri.add(VMenusGroupMenuRoleObject::MenusGroupTooltip, menusGroupTooltip);
    cri.add(VMenusGroupMenuRoleObject::MenusGroupDesc, menusGroupDesc);
    cri.add(VMenusGroupMenuRoleObject::MenuId, menuId);
    cri.add(VMenusGroupMenuRoleObject::MenuOrder, menuOrder);
    cri.add(VMenusGroupMenuRoleObject::BreakBool, breakBool);
    cri.add(VMenusGroupMenuRoleObject::MenuCd, menuCd);
    cri.add(VMenusGroupMenuRoleObject::MenuNameZh, menuNameZh);
    cri.add(VMenusGroupMenuRoleObject::MenuNameEn, menuNameEn);
    cri.add(VMenusGroupMenuRoleObject::MenuTooltip, menuTooltip);
    cri.add(VMenusGroupMenuRoleObject::MenuDesc, menuDesc);
    cri.add(VMenusGroupMenuRoleObject::Controller, controller);
    cri.add(VMenusGroupMenuRoleObject::Action, action);
    TSqlORMapper<VMenusGroupMenuRoleObject> mapper;
    return VMenusGroupMenuRole(mapper.findFirst(cri));
}

Example #17

File: evtvendor.cpp Project: hks2002/AM

int EvtVendor::count()
{
    TSqlORMapper<EvtVendorObject> mapper;
    return mapper.findCount();
}

Example #18

File: evtvendor.cpp Project: hks2002/AM

EvtVendor EvtVendor::get(int eventId, int vendorId)
{
    TSqlORMapper<EvtVendorObject> mapper;
    return EvtVendor(mapper.findByPrimaryKey(QVariantList()<<QVariant(eventId)<<QVariant(vendorId)));
}

Example #19

File: taskschedrulemesur.cpp Project: hks2002/AM

int TaskSchedRuleMesur::count()
{
    TSqlORMapper<TaskSchedRuleMesurObject> mapper;
    return mapper.findCount();
}

Example #20

File: taskschedrulemesur.cpp Project: hks2002/AM

TaskSchedRuleMesur TaskSchedRuleMesur::get(int taskId, int dataTypeId, int mesurUnitId)
{
    TSqlORMapper<TaskSchedRuleMesurObject> mapper;
    return TaskSchedRuleMesur(mapper.findByPrimaryKey(QVariantList()<<QVariant(taskId)<<QVariant(dataTypeId)<<QVariant(mesurUnitId)));
}

Example #21

File: refreceivepriority.cpp Project: hks2002/AM

int RefReceivePriority::count()
{
    TSqlORMapper<RefReceivePriorityObject> mapper;
    return mapper.findCount();
}

Example #22

File: eqpassmblbomdatatype.cpp Project: hks2002/AM

EqpAssmblBomDataType EqpAssmblBomDataType::get(int assmblBomId, int dataTypeId)
{
    TSqlORMapper<EqpAssmblBomDataTypeObject> mapper;
    return EqpAssmblBomDataType(mapper.findByPrimaryKey(QVariantList()<<QVariant(assmblBomId)<<QVariant(dataTypeId)));
}

Example #23

File: warrantyinit.cpp Project: hks2002/AM

WarrantyInit WarrantyInit::get(int warrantyInitId)
{
    TSqlORMapper<WarrantyInitObject> mapper;
    return WarrantyInit(mapper.findByPrimaryKey(warrantyInitId));
}

Example #24

File: evthr.cpp Project: hks2002/AM

EvtHr EvtHr::get(int eventId, int userId)
{
    TSqlORMapper<EvtHrObject> mapper;
    return EvtHr(mapper.findByPrimaryKey(QVariantList()<<QVariant(eventId)<<QVariant(userId)));
}

Example #25

File: orgvendorapproval.cpp Project: hks2002/AM

int OrgVendorApproval::count()
{
    TSqlORMapper<OrgVendorApprovalObject> mapper;
    return mapper.findCount();
}

Example #26

File: tasktask.cpp Project: hks2002/AM

TaskTask TaskTask::get(int taskId)
{
    TSqlORMapper<TaskTaskObject> mapper;
    return TaskTask(mapper.findByPrimaryKey(taskId));
}

Example #27

File: tasktask.cpp Project: hks2002/AM

int TaskTask::count()
{
    TSqlORMapper<TaskTaskObject> mapper;
    return mapper.findCount();
}

Example #28

File: warrantyinit.cpp Project: hks2002/AM

int WarrantyInit::count()
{
    TSqlORMapper<WarrantyInitObject> mapper;
    return mapper.findCount();
}

Example #29

File: eqpassmblbomdatatype.cpp Project: hks2002/AM

int EqpAssmblBomDataType::count()
{
    TSqlORMapper<EqpAssmblBomDataTypeObject> mapper;
    return mapper.findCount();
}

Example #30

File: refreceivepriority.cpp Project: hks2002/AM

RefReceivePriority RefReceivePriority::get(const QString &rcvPriorityCd)
{
    TSqlORMapper<RefReceivePriorityObject> mapper;
    return RefReceivePriority(mapper.findByPrimaryKey(rcvPriorityCd));
}