1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
|
/*
* Copyright (c) 2010, 2014, Oracle and/or its affiliates. All rights reserved.
*
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License as
* published by the Free Software Foundation; version 2 of the
* License.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
* 02110-1301 USA
*/
#ifndef _DB_QUERY_RESULTSET_H_
#define _DB_QUERY_RESULTSET_H_
#include <grts/structs.db.query.h>
#include "sqlide/recordset_be.h"
#include <cppconn/resultset.h>
db_query_ResultsetRef WBPUBLICBACKEND_PUBLIC_FUNC grtwrap_recordset(GrtObjectRef owner, Recordset::Ref rset);
db_query_ResultsetRef WBPUBLICBACKEND_PUBLIC_FUNC grtwrap_recordset(GrtObjectRef owner, boost::shared_ptr<sql::ResultSet> result);
class WBPUBLICBACKEND_PUBLIC_FUNC db_query_Resultset::ImplData
{
protected:
ImplData(db_query_ResultsetRef aself);
db_query_Resultset *self;
public:
std::map<std::string, ssize_t> column_by_name;
virtual ~ImplData();
virtual void refresh() = 0;
virtual grt::StringRef sql() const = 0;
virtual grt::IntegerRef currentRow() const = 0;
virtual grt::IntegerRef rowCount() const = 0;
virtual grt::DoubleRef floatFieldValue(ssize_t column) = 0;
virtual grt::DoubleRef floatFieldValueByName(const std::string &column) = 0;
virtual grt::IntegerRef goToFirstRow() = 0;
virtual grt::IntegerRef goToLastRow() = 0;
virtual grt::IntegerRef goToRow(ssize_t row) = 0;
virtual grt::IntegerRef intFieldValue(ssize_t column) = 0;
virtual grt::IntegerRef intFieldValueByName(const std::string &column) = 0;
virtual grt::IntegerRef nextRow() = 0;
virtual grt::IntegerRef previousRow() = 0;
virtual grt::IntegerRef saveFieldValueToFile(ssize_t column, const std::string &file) = 0;
virtual grt::StringRef stringFieldValue(ssize_t column) = 0;
virtual grt::StringRef stringFieldValueByName(const std::string &column) = 0;
virtual grt::StringRef geoStringFieldValue(ssize_t column) = 0;
virtual grt::StringRef geoStringFieldValueByName(const std::string &column) = 0;
virtual grt::StringRef geoJsonFieldValue(ssize_t column) = 0;
virtual grt::StringRef geoJsonFieldValueByName(const std::string &column) = 0;
};
class WBPUBLICBACKEND_PUBLIC_FUNC WBRecordsetResultset : public db_query_Resultset::ImplData
{
public:
size_t cursor;
boost::shared_ptr<Recordset> recordset;
WBRecordsetResultset(db_query_ResultsetRef aself, boost::shared_ptr<Recordset> rset);
virtual grt::StringRef sql() const;
virtual grt::IntegerRef currentRow() const;
virtual grt::IntegerRef rowCount() const;
virtual grt::DoubleRef floatFieldValue(ssize_t column);
virtual grt::DoubleRef floatFieldValueByName(const std::string &column);
virtual grt::IntegerRef goToFirstRow();
virtual grt::IntegerRef goToLastRow();
virtual grt::IntegerRef goToRow(ssize_t row);
virtual grt::IntegerRef intFieldValue(ssize_t column);
virtual grt::IntegerRef intFieldValueByName(const std::string &column);
virtual grt::IntegerRef nextRow();
virtual grt::IntegerRef previousRow();
virtual void refresh();
virtual grt::StringRef stringFieldValue(ssize_t column);
virtual grt::StringRef stringFieldValueByName(const std::string &column);
virtual grt::StringRef geoStringFieldValue(ssize_t column);
virtual grt::StringRef geoStringFieldValueByName(const std::string &column);
virtual grt::StringRef geoJsonFieldValue(ssize_t column);
virtual grt::StringRef geoJsonFieldValueByName(const std::string &column);
virtual grt::IntegerRef saveFieldValueToFile(ssize_t column, const std::string &file);
};
#endif
|
