summaryrefslogtreecommitdiff
path: root/cpp/demo/Database/Oracle/proc/DeptFactoryI.pc
diff options
context:
space:
mode:
authorMatthew Newhook <matthew@zeroc.com>2015-03-18 12:58:16 -0230
committerMatthew Newhook <matthew@zeroc.com>2015-03-18 12:58:16 -0230
commit9b7668c7c92cf9cb311fe444cdddb489cd2a219d (patch)
tree5016567c58c81f5654e9d01935e199c6bf4761d2 /cpp/demo/Database/Oracle/proc/DeptFactoryI.pc
parentVS add-in & build updates: (diff)
downloadice-9b7668c7c92cf9cb311fe444cdddb489cd2a219d.tar.bz2
ice-9b7668c7c92cf9cb311fe444cdddb489cd2a219d.tar.xz
ice-9b7668c7c92cf9cb311fe444cdddb489cd2a219d.zip
Removed demos.
Moved demoscript to distribution.
Diffstat (limited to 'cpp/demo/Database/Oracle/proc/DeptFactoryI.pc')
-rw-r--r--cpp/demo/Database/Oracle/proc/DeptFactoryI.pc155
1 files changed, 0 insertions, 155 deletions
diff --git a/cpp/demo/Database/Oracle/proc/DeptFactoryI.pc b/cpp/demo/Database/Oracle/proc/DeptFactoryI.pc
deleted file mode 100644
index c54c02550d1..00000000000
--- a/cpp/demo/Database/Oracle/proc/DeptFactoryI.pc
+++ /dev/null
@@ -1,155 +0,0 @@
-// **********************************************************************
-//
-// Copyright (c) 2003-2015 ZeroC, Inc. All rights reserved.
-//
-// This copy of Ice is licensed to you under the terms described in the
-// ICE_LICENSE file included in this distribution.
-//
-// **********************************************************************
-
-#include <DeptFactoryI.h>
-#include <Util.h>
-#include <sqlca.h>
-
-EXEC SQL WHENEVER SQLERROR DO handleSqlError(sqlca, ctx);
-
-using namespace std;
-
-DeptFactoryI::DeptFactoryI(const CurrentSqlContext& currentCtx, const string& deptCategory, const string& empCategory) :
- _currentCtx(currentCtx),
- _deptCategory(deptCategory),
- _empCategory(empCategory)
-{
-}
-
-HR::DeptPrx
-DeptFactoryI::createDept(int key, const HR::DeptDesc& desc, const Ice::Current& current)
-{
- sqlca sqlca;
- EXEC SQL BEGIN DECLARE SECTION;
- sql_context ctx = _currentCtx;
- int deptno = key;
- const char* dname = desc.dname.c_str();
- const char* loc = desc.loc.c_str();
- EXEC SQL END DECLARE SECTION;
-
- EXEC SQL CONTEXT USE :ctx;
- EXEC SQL INSERT INTO DEPT(deptno, dname, loc) VALUES(:deptno, :dname, :loc);
- EXEC SQL COMMIT;
-
- Ice::Identity deptId;
- deptId.name = encodeName(deptno);
- deptId.category = _deptCategory;
- return HR::DeptPrx::uncheckedCast(current.adapter->createProxy(deptId));
-}
-
-EXEC SQL WHENEVER NOT FOUND DO break;
-
-HR::DeptPrxSeq
-DeptFactoryI::findAll(const Ice::Current& current)
-{
- sqlca sqlca;
- EXEC SQL BEGIN DECLARE SECTION;
- sql_context ctx = _currentCtx;
- int deptno;
- EXEC SQL END DECLARE SECTION;
-
- EXEC SQL CONTEXT USE :ctx;
- EXEC SQL DECLARE depCursor1 CURSOR FOR SELECT DEPTNO FROM DEPT;
- EXEC SQL OPEN depCursor1;
-
- HR::DeptPrxSeq result;
-
- for(;;)
- {
- EXEC SQL FETCH depCursor1 INTO :deptno;
-
- Ice::Identity deptId;
- deptId.category = _deptCategory;
- deptId.name = encodeName(deptno);
-
- result.push_back(HR::DeptPrx::uncheckedCast(current.adapter->createProxy(deptId)));
- }
-
- EXEC SQL CLOSE depCursor1;
- EXEC SQL COMMIT;
- return result;
-}
-
-HR::DeptPrxSeq
-DeptFactoryI::findByName(const string& name, const Ice::Current& current)
-{
- sqlca sqlca;
- EXEC SQL BEGIN DECLARE SECTION;
- const char* dname = name.c_str();
- sql_context ctx = _currentCtx;
- int deptno;
- EXEC SQL END DECLARE SECTION;
-
- EXEC SQL CONTEXT USE :ctx;
- EXEC SQL DECLARE depCursor2 CURSOR FOR SELECT DEPTNO FROM DEPT WHERE DNAME = :dname;
- EXEC SQL OPEN depCursor2;
-
- HR::DeptPrxSeq result;
-
- for(;;)
- {
- EXEC SQL FETCH depCursor2 INTO :deptno;
-
- Ice::Identity deptId;
- deptId.category = _deptCategory;
- deptId.name = encodeName(deptno);
-
- result.push_back(HR::DeptPrx::uncheckedCast(current.adapter->createProxy(deptId)));
- }
-
- EXEC SQL CLOSE depCursor2;
- EXEC SQL COMMIT;
- return result;
-}
-
-HR::DeptPrx
-DeptFactoryI::findDeptByNo(int deptno, const Ice::Current& current)
-{
- Ice::Identity deptId;
- deptId.category = _deptCategory;
- deptId.name = encodeName(deptno);
- Ice::ObjectPrx prx = current.adapter->createProxy(deptId);
-
- //
- // Check that this deptno exists
- //
- try
- {
- prx->ice_ping();
- }
- catch(const Ice::ObjectNotExistException&)
- {
- return 0;
- }
-
- return HR::DeptPrx::uncheckedCast(prx);
-}
-
-HR::EmpPrx
-DeptFactoryI::findEmpByNo(int empno, const Ice::Current& current)
-{
- Ice::Identity empId;
- empId.category = _empCategory;
- empId.name = encodeName(empno);
- Ice::ObjectPrx prx = current.adapter->createProxy(empId);
-
- //
- // Check that this empno exists
- //
- try
- {
- prx->ice_ping();
- }
- catch(const Ice::ObjectNotExistException&)
- {
- return 0;
- }
-
- return HR::EmpPrx::uncheckedCast(prx);
-}