[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    koffice/kexi
From:       Jaroslaw Staniek <js () iidea ! pl>
Date:       2004-07-09 20:02:57
Message-ID: 20040709200257.848C716B27 () office ! kde ! org
[Download RAW message or body]

CVS commit by staniek: 

Query Designer
- joins defined by GUI are now visible in SQL View


  M +11 -0     doc/dev/CHANGELOG-Kexi-js   1.117
  M +10 -1     plugins/queries/kexiquerydesignerguieditor.cpp   1.72


--- koffice/kexi/doc/dev/CHANGELOG-Kexi-js  #1.116:1.117
@@ -332,4 +332,15 @@
 ===================== Kexi 0.1 Beta 4 =====================
 
+2004-07-09
+KexiDB
+- It's possible to define relationships for QuerySchema 
+  (with Relationship objects)
+- Connection: optimization: QString::reserve() used 
+   before generationg SQL statements
+- Connection::selectStatement() now generates joining rules 
+  (i.e. relationships using WHERE)
+Query Designer
+- joins defined by GUI are now visible in SQL View
+
 2004-07-08
 Query Designer

--- koffice/kexi/plugins/queries/kexiquerydesignerguieditor.cpp  #1.71:1.72
@@ -366,4 +366,14 @@ KexiQueryDesignerGuiEditor::buildSchema(
         }
 
+        //add relations (looking for connections)
+        for (ConnectionListIterator it(*m_relations->connections()); it.current(); \
++it) { +                KexiRelationViewTableContainer *masterTable = \
it.current()->masterTable(); +                KexiRelationViewTableContainer \
*detailsTable = it.current()->detailsTable(); +
+                temp->query->addRelationship(
+                        masterTable->table()->field(it.current()->masterField()),
+                        detailsTable->table()->field(it.current()->detailsField()) \
); +        }
+
         //add fields
         bool fieldsFound = false;
@@ -473,5 +483,4 @@ KexiQueryDesignerGuiEditor::afterSwitchF
                                 // show only these new and hide these unncecessary; \
                the same for connections)
                                 KexiDB::QuerySchema *q = tempData()->query;
-                                q->debug();
                                 for (QPtrListIterator<KexiDB::TableSchema> \
                it(*q->tables()); it.current(); ++it) {
                                         m_relations->addTable( it.current() );


[prev in list] [next in list] [prev in thread] [next in thread]