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 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214
|
/*****
*
* TOra - An Oracle Toolkit for DBA's and developers
* Copyright (C) 2003-2005 Quest Software, Inc
* Portions Copyright (C) 2005 Other Contributors
*
* 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; only version 2 of
* the License is valid for this program.
*
* 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., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*
* As a special exception, you have permission to link this program
* with the Oracle Client libraries and distribute executables, as long
* as you follow the requirements of the GNU GPL in regard to all of the
* software in the executable aside from Oracle client libraries.
*
* Specifically you are not permitted to link this program with the
* Qt/UNIX, Qt/Windows or Qt Non Commercial products of TrollTech.
* And you are not permitted to distribute binaries compiled against
* these libraries without written consent from Quest Software, Inc.
* Observe that this does not disallow linking to the Qt Free Edition.
*
* You may link this product with any GPL'd Qt library such as Qt/Free
*
* All trademarks belong to their respective owners.
*
*****/
#ifndef TORESULTLINE_H
#define TORESULTLINE_H
#include "config.h"
#include "tobackground.h"
#include "tolinechart.h"
#include "toresult.h"
#include <time.h>
#include <list>
class toNoBlockQuery;
class toSQL;
/** Display the result of a query in a piechart. The first column of the query should
* contain the x value and the rest of the columns should be values of the diagram. The
* legend is the column name. Connects to the tool timer for updates automatically.
*/
class toResultLine : public toLineChart, public toResult
{
Q_OBJECT
/** Display flow in change per second instead of actual values.
*/
bool Flow;
bool Started;
/** Timestamp of last fetch.
*/
time_t LastStamp;
/** Last read values.
*/
std::list<double> LastValues;
bool First;
toNoBlockQuery *Query;
toBackground Poll;
unsigned int Columns;
void query(const QString &sql, const toQList ¶m, bool first);
public:
/** Create widget.
* @param parent Parent of list.
* @param name Name of widget.
*/
toResultLine(QWidget *parent, const char *name = NULL);
/** Destroy chart
*/
~toResultLine();
/** Stop automatic updating from tool timer.
*/
void stop();
/** Start automatic updating from tool timer.
*/
void start();
/** Display actual values or flow/s.
* @param on Display flow or absolute values.
*/
void setFlow(bool on)
{
Flow = on;
}
/** Return if flow is displayed.
* @return If flow is used.
*/
bool flow(void)
{
return Flow;
}
/** Reimplemented for internal reasons.
*/
virtual void query(const QString &sql, const toQList ¶m)
{
query(sql, param, true);
}
/** Reimplemented for internal reasons.
*/
virtual void clear(void)
{
LastStamp = 0;
LastValues.clear();
toLineChart::clear();
}
/** Transform valueset. Make it possible to perform more complex transformation.
* called directly before adding the valueset to the chart. After flow transformation.
* Default is passthrough.
* @param input The untransformed valueset.
* @return The valueset actually added to the chart.
*/
virtual std::list<double> transform(std::list<double> &input);
/** Handle any connection
*/
virtual bool canHandle(toConnection &)
{
return true;
}
// Why are these needed?
#if 1
/** Set the SQL statement of this list
* @param sql String containing statement.
*/
void setSQL(const QString &sql)
{
toResult::setSQL(sql);
}
/** Set the SQL statement of this list. This will also affect @ref Name.
* @param sql SQL containing statement.
*/
void setSQL(const toSQL &sql)
{
toResult::setSQL(sql);
}
/** Set new SQL and run query.
* @param sql New sql.
* @see setSQL
*/
void query(const QString &sql)
{
toResult::query(sql);
}
/** Set new SQL and run query.
* @param sql New sql.
* @see setSQL
*/
void query(const toSQL &sql)
{
toResult::query(sql);
}
/** Set new SQL and run query.
* @param sql New sql.
* @see setSQL
*/
void query(const toSQL &sql, toQList &par)
{
toResult::query(sql, par);
}
#endif
public slots:
/** Reimplemented for internal reasons.
*/
virtual void refresh(void)
{
query(sql(), params(), false);
}
/** Reimplemented for internal reasons.
*/
virtual void changeParams(const QString &Param1)
{
toResult::changeParams(Param1);
}
/** Reimplemented For internal reasons.
*/
virtual void changeParams(const QString &Param1, const QString &Param2)
{
toResult::changeParams(Param1, Param2);
}
/** Reimplemented for internal reasons.
*/
virtual void changeParams(const QString &Param1, const QString &Param2, const QString &Param3)
{
toResult::changeParams(Param1, Param2, Param3);
}
protected slots:
/** Reimplemented for internal reasons.
*/
virtual void connectionChanged(void);
/** Reimplemented for internal reasons.
*/
virtual void addMenues(QPopupMenu *);
private slots:
void poll(void);
void editSQL(void);
};
#endif
|