5 #include <pdbcalbase/PdbBankID.h>
6 #include <pdbcalbase/PdbCalBank.h>
11 #include <RDBC/TSQLConnection.h>
12 #include <RDBC/TSQLPreparedStatement.h>
45 cout <<
"Calibration Description : " <<
description << endl;
46 cout <<
"User Name = " <<
userName << endl;
57 sqlcmd <<
"insert into " << ((*this).getTableName())
58 <<
" values(?,?,?,?,?,?,?);";
59 cout <<
"query: " << sqlcmd.str() << endl;
60 TSQLPreparedStatement *pstmt = con->PrepareStatement(sqlcmd.str().c_str());
61 pstmt->SetInt(1, ((*this).getBankID()).getInternalValue());
62 pstmt->SetLong(2, ((*this).getInsertTime()).getTics());
63 pstmt->SetLong(3, ((*this).getStartValTime()).getTics());
64 pstmt->SetLong(4, ((*this).getEndValTime()).getTics());
65 pstmt->SetString(5, ((*this).getDescription()));
66 pstmt->SetString(6, ((*this).getUserName()));
67 pstmt->SetObject(7,
this);
69 res = pstmt->ExecuteUpdate();
74 cout <<
"Make sure you commit to the master database on phnxdb2.phenix.bnl.gov" << endl;
75 cout <<
"and that " <<
tableName <<
" exists in the master database" << endl;
78 cout <<
"Committed " << res <<
" row, sleeping 1 sec to make sure we have distinct insert times" << endl;
87 cout <<
"Bank is a nullptr pointer" << endl;