summaryrefslogtreecommitdiffstats
path: root/kexi/kexidb/parser/parser.h
diff options
context:
space:
mode:
authortpearson <tpearson@283d02a7-25f6-0310-bc7c-ecb5cbfe19da>2010-01-20 01:29:50 +0000
committertpearson <tpearson@283d02a7-25f6-0310-bc7c-ecb5cbfe19da>2010-01-20 01:29:50 +0000
commit8362bf63dea22bbf6736609b0f49c152f975eb63 (patch)
tree0eea3928e39e50fae91d4e68b21b1e6cbae25604 /kexi/kexidb/parser/parser.h
downloadkoffice-8362bf63dea22bbf6736609b0f49c152f975eb63.tar.gz
koffice-8362bf63dea22bbf6736609b0f49c152f975eb63.zip
Added old abandoned KDE3 version of koffice
git-svn-id: svn://anonsvn.kde.org/home/kde/branches/trinity/applications/koffice@1077364 283d02a7-25f6-0310-bc7c-ecb5cbfe19da
Diffstat (limited to 'kexi/kexidb/parser/parser.h')
-rw-r--r--kexi/kexidb/parser/parser.h240
1 files changed, 240 insertions, 0 deletions
diff --git a/kexi/kexidb/parser/parser.h b/kexi/kexidb/parser/parser.h
new file mode 100644
index 00000000..ec2942e1
--- /dev/null
+++ b/kexi/kexidb/parser/parser.h
@@ -0,0 +1,240 @@
+/* This file is part of the KDE project
+ Copyright (C) 2003 Lucijan Busch <lucijan@kde.org>
+ Copyright (C) 2004 Jaroslaw Staniek <js@iidea.pl>
+
+ This library is free software; you can redistribute it and/or
+ modify it under the terms of the GNU Library General Public
+ License as published by the Free Software Foundation; either
+ version 2 of the License, or (at your option) any later version.
+
+ This library 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
+ Library General Public License for more details.
+
+ You should have received a copy of the GNU Library General Public License
+ along with this library; see the file COPYING.LIB. If not, write to
+ the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
+ * Boston, MA 02110-1301, USA.
+*/
+
+#ifndef KEXIDBPARSER_H
+#define KEXIDBPARSER_H
+
+#include <qobject.h>
+#include <qptrlist.h>
+#include <qvariant.h>
+
+#include <kexidb/field.h>
+#include <kexidb/expression.h>
+
+namespace KexiDB
+{
+
+class Connection;
+class QuerySchema;
+class TableSchema;
+class Field;
+
+/**
+ * Provides detailed i18n'ed error description about the \a Parser .
+ */
+class KEXI_DB_EXPORT ParserError
+{
+ public:
+
+ /**
+ * Empty constructor.
+ */
+ ParserError();
+
+ /**
+ * Constructor.
+ *
+ * \param type The errortype.
+ * \param error A description of the error.
+ * \param hint Token where the error happend.
+ * \param at The position where the error happend.
+ */
+ ParserError(const QString &type, const QString &error, const QString &hint, int at);
+
+ /**
+ * Destructor.
+ */
+ ~ParserError();
+
+ /**
+ * \return the errortype.
+ */
+ QString type() { return m_type; }
+
+ /**
+ * \return a descriping error message.
+ */
+ QString error() { return m_error; }
+
+ /**
+ * \return position where the error happend.
+ */
+ int at() { return m_at; }
+
+ private:
+ QString m_type;
+ QString m_error;
+ QString m_hint;
+ int m_at;
+// bool m_isNull;
+};
+
+class ParserPrivate;
+
+/**
+ * Parser for SQL statements.
+ *
+ * The best and prefeerred way to run queries is using the KexiDB::Parser functionality
+ * and use the resulting QuerySchema object since this offers a database-backend-independent
+ * way to deal with SQL statements on the one hand and offers high level
+ * functionality on the other. Also BLOBs like images are handled that way.
+ *
+ * For example if we like to use the SELECT statement
+ * "SELECT dir.path, media.filename FROM dir, media WHERE dir.id=media.dirId AND media.id=%s"
+ * we are able to use the \a Connection::prepareStatement method which takes the type of
+ * the statement (in our case \a PreparedStatement::SelectStatement ), a list of fields (in
+ * our case dir.path and media.filename) and returns a \a PreparedStatement::Ptr instance.
+ * By using the \a QuerySchema::addRelationship and \a QuerySchema::addToWhereExpression methods
+ * the SQL statement could be extended with relationships and WHERE expressions.
+ *
+ * For more, see \a KexiDB::PreparedStatement and \a Connection::selectStatement() . A more
+ * complex example that looks at what the user has defined and carefully builds
+ * \a KexiDB::QuerySchema object, including the WHERE expression can be found in
+ * the Query Designer's source code in the method \a KexiQueryDesignerGuiEditor::buildSchema().
+ */
+class KEXI_DB_EXPORT Parser
+{
+ public:
+
+ /**
+ * The operation-code of the statement.
+ */
+ enum OPCode
+ {
+ OP_None = 0, /// No statement parsed or reseted.
+ OP_Error, /// Error while parsing.
+ OP_CreateTable, /// Create a table.
+ OP_AlterTable, /// Alter an existing table
+ OP_Select, /// Query-statement.
+ OP_Insert, /// Insert new content.
+ OP_Update, /// Update existing content.
+ OP_Delete /// Delete existing content.
+ };
+
+ /**
+ * constructs an empty object of the parser
+ * \param connection is used for things like wildcard resolution. If 0 parser works in "pure mode"
+ */
+ Parser(Connection *connection);
+ ~Parser();
+
+ /**
+ * clears previous results and runs the parser
+ */
+ bool parse(const QString &statement);
+
+ /**
+ * rests results
+ */
+ void clear();
+
+ /**
+ * \return the resulting operation or OP_Error if failed
+ */
+ OPCode operation() const;
+
+ /**
+ * \return the resulting operation as string.
+ */
+ QString operationString() const;
+
+ /**
+ * \return a pointer to a KexiDBTable on CREATE TABLE
+ * or 0 on any other operation or error. Returned object is owned by you.
+ * You can call this method only once every time after doing parse().
+ * Next time, the call will return 0.
+ */
+ TableSchema *table();
+
+ /**
+ * \return a pointer to KexiDBSelect if 'SELECT ...' was called
+ * or 0 on any other operation or error. Returned object is owned by you.
+ * You can call this method only once every time after doing parse().
+ * Next time, the call will return 0.
+ */
+ QuerySchema *query();
+
+ /**
+ * \return a pointer to the used database connection or 0 if not set
+ * You can call this method only once every time after doing parse().
+ * Next time, the call will return 0.
+ */
+ Connection *db() const;
+
+ /**
+ * \return detailed information about last error.
+ * If no error occurred ParserError isNull()
+ */
+ ParserError error() const;
+
+ /**
+ * \return the statement passed on the last \a parse method-call.
+ */
+ QString statement() const;
+
+ /**
+ * \internal
+ * sets the operation (only parser will need to call this)
+ */
+ void setOperation(OPCode op);
+
+ /**
+ * \internal
+ * creates a new table (only parser will need to call this)
+ */
+ void createTable(const char *t);
+
+ /**
+ * \internal
+ * sets \a query schema object (only parser will need to call this)
+ */
+//todo: other query types
+ void setQuerySchema(QuerySchema *query);
+
+ /**
+ * \internal
+ * \return query schema
+ */
+ QuerySchema *select() const;
+
+ /**
+ * \internal
+ * INTERNAL use only: sets a error
+ */
+ void setError(const ParserError &err);
+
+ /**
+ * \return true if the \param str is an reserved
+ * keyword (see tokens.cpp for a list of reserved
+ * keywords).
+ */
+ bool isReservedKeyword(const char *str);
+
+ protected:
+ void init();
+
+ ParserError m_error; //!< detailed information about last error.
+ ParserPrivate *d; //!< \internal d-pointer class.
+};
+
+}
+
+#endif
+