summaryrefslogtreecommitdiffstats
path: root/kexi/plugins/scripting/kexidb/kexidbfieldlist.h
blob: 1d7b7665ab41c1aabd60cb27a4f8f03963462d90 (plain)
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
/***************************************************************************
 * kexidbfieldlist.h
 * This file is part of the KDE project
 * copyright (C)2004-2005 by Sebastian Sauer ([email protected])
 *
 * This program 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 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
 * Library General Public License for more details.
 * You should have received a copy of the GNU Library General Public License
 * along with this program; see the file COPYING.  If not, write to
 * the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
 * Boston, MA 02110-1301, USA.
 ***************************************************************************/

#ifndef KROSS_KEXIDB_KEXIDBFIELDLIST_H
#define KROSS_KEXIDB_KEXIDBFIELDLIST_H

#include <tqstring.h>

#include <api/object.h>
#include <api/list.h>
#include <api/class.h>

#include <kexidb/drivermanager.h>
#include <kexidb/fieldlist.h>

namespace Kross { namespace KexiDB {

    // Forward declarations.
    class KexiDBField;
    class KexiDBFieldList;

    /**
    * A list of fields. The KexiDBFieldList can be used to handle KexiDBField objects
    * in a backend-independent way.
    *
    * Example (in Python) ;
    * @code
    * # Get the tableschema for the "dept" table.
    * table = connection.tableSchema("dept")
    * # Create a KexiDBFieldList based on the table and filled with the selected fields.
    * subfields = ["deptno","name","loc"]
    * fieldlist = table.fieldlist().subList(subfields)
    * # Create the "SELECT * from dept;" queryschema.
    * query = table.query()
    * # We change the queryschema to "SELECT deptno,name,loc FROM dept;" now.
    * query.fieldlist().setFields(fieldlist)
    * # and change the query to "SELECT deptno,name,loc FROM dept WHERE deptno=5;"
    * query.setWhereExpression("deptno=5")
    * # Execute the query and get a KexiDBCursor object as result which could be used to iterate through the result.
    * cursor = connection.executeQuerySchema(query)
    * @endcode
    */
    class KexiDBFieldList : public Kross::Api::Class<KexiDBFieldList>
    {
        public:
            KexiDBFieldList(::KexiDB::FieldList* fieldlist);
            virtual ~KexiDBFieldList();
            virtual const TQString getClassName() const;
            ::KexiDB::FieldList* fieldlist() { return m_fieldlist; }

        private:

            /** Returns the number of fields. */
            uint fieldCount();
            /** Return the field specified by the index-number passed as an argument. */
            KexiDBField* field(uint index);
            /** Return the field specified by the as an argument passed fieldname. */
            KexiDBField* fieldByName(const TQString& name);

            /** Returns a list of all fields. */
            Kross::Api::List* fields();
            /** Returns true if the KexiDBField object passed as an argument is in the field list. */
            bool hasField(KexiDBField* field);
            /** Return a list of field names. */
            const TQStringList names() const;

            /** Adds the KexiDBField object passed as an argument to the field list. */
            void addField(KexiDBField* field);
            /** Inserts the KexiDBField object passed as the second argument
            into the field list at the position defined by the first argument. */
            void insertField(uint index, KexiDBField* field);
            /** Removes the KexiDBField object passed as an argument from the field list. */
            void removeField(KexiDBField* field);
            /** Removes all KexiDBField objects from the fieldlist. */
            void clear();
            /** Set the fieldlist to the as argument passed list of fields. */
            void setFields(KexiDBFieldList* fieldlist);
            /** Creates and returns list that contain fields selected by name. */
            KexiDBFieldList* subList(TQValueList<TQVariant> list);

        private:
            ::KexiDB::FieldList* m_fieldlist;
    };

}}

#endif