From: <nn...@us...> - 2009-04-26 14:22:12
|
Revision: 3175 http://tora.svn.sourceforge.net/tora/?rev=3175&view=rev Author: nneul Date: 2009-04-26 13:30:27 +0000 (Sun, 26 Apr 2009) Log Message: ----------- patch from zippydufus to fix duplicated constaints Modified Paths: -------------- trunk/tora/src/tobrowsertablewidget.cpp Modified: trunk/tora/src/tobrowsertablewidget.cpp =================================================================== --- trunk/tora/src/tobrowsertablewidget.cpp 2009-04-17 09:33:11 UTC (rev 3174) +++ trunk/tora/src/tobrowsertablewidget.cpp 2009-04-26 13:30:27 UTC (rev 3175) @@ -165,13 +165,15 @@ " c.search_condition,\n" " c.status,\n" " c.delete_rule,\n" - " c.generated\n" + " c.generated,\n" + " c.owner\n" " FROM\n" " sys.All_Constraints c,\n" " sys.all_cons_columns a\n" " WHERE\n" " c.constraint_name = a.constraint_name\n" " AND c.Owner = :f1<char[101]>\n" + " AND c.Owner = a.Owner\n" " AND c.Table_Name = :f2<char[101]>\n" " ORDER BY\n" " c.constraint_name, a.constraint_name, a.position\n" @@ -179,6 +181,7 @@ " sys.all_cons_columns refs\n" " WHERE\n" " main.r_constraint_name = refs.constraint_name (+)\n" + " AND main.owner = refs.owner (+)" " AND main.column_name = refs.column_name (+)", "List the constraints on a table", ""); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <su...@us...> - 2009-05-12 07:24:27
|
Revision: 3187 http://tora.svn.sourceforge.net/tora/?rev=3187&view=rev Author: subik Date: 2009-05-12 07:24:19 +0000 (Tue, 12 May 2009) Log Message: ----------- applied patch from Zippy Dufus to speedup constraints loading Modified Paths: -------------- trunk/tora/src/tobrowsertablewidget.cpp Modified: trunk/tora/src/tobrowsertablewidget.cpp =================================================================== --- trunk/tora/src/tobrowsertablewidget.cpp 2009-05-11 17:30:39 UTC (rev 3186) +++ trunk/tora/src/tobrowsertablewidget.cpp 2009-05-12 07:24:19 UTC (rev 3187) @@ -175,14 +175,24 @@ " AND c.Owner = :f1<char[101]>\n" " AND c.Owner = a.Owner\n" " AND c.Table_Name = :f2<char[101]>\n" - " ORDER BY\n" - " c.constraint_name, a.constraint_name, a.position\n" " ) main,\n" - " sys.all_cons_columns refs\n" + " (\n" + " SELECT\n" + " owner,\n" + " table_name,\n" + " column_name,\n" + " constraint_name\n" + " FROM\n" + " sys.all_cons_columns\n" + " WHERE\n" + " owner = :f1<char[101]>\n" + " AND table_Name = :f2<char[101]>\n" + " ) refs\n" " WHERE\n" " main.r_constraint_name = refs.constraint_name (+)\n" - " AND main.owner = refs.owner (+)" - " AND main.column_name = refs.column_name (+)", + " AND main.owner = refs.owner (+)\n" + " AND main.column_name = refs.column_name (+)\n" + " ORDER BY 1\n", "List the constraints on a table", ""); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <su...@us...> - 2009-05-13 04:52:16
|
Revision: 3188 http://tora.svn.sourceforge.net/tora/?rev=3188&view=rev Author: subik Date: 2009-05-13 04:52:06 +0000 (Wed, 13 May 2009) Log Message: ----------- previous patch removed Modified Paths: -------------- trunk/tora/src/tobrowsertablewidget.cpp Modified: trunk/tora/src/tobrowsertablewidget.cpp =================================================================== --- trunk/tora/src/tobrowsertablewidget.cpp 2009-05-12 07:24:19 UTC (rev 3187) +++ trunk/tora/src/tobrowsertablewidget.cpp 2009-05-13 04:52:06 UTC (rev 3188) @@ -175,24 +175,14 @@ " AND c.Owner = :f1<char[101]>\n" " AND c.Owner = a.Owner\n" " AND c.Table_Name = :f2<char[101]>\n" + " ORDER BY\n" + " c.constraint_name, a.constraint_name, a.position\n" " ) main,\n" - " (\n" - " SELECT\n" - " owner,\n" - " table_name,\n" - " column_name,\n" - " constraint_name\n" - " FROM\n" - " sys.all_cons_columns\n" - " WHERE\n" - " owner = :f1<char[101]>\n" - " AND table_Name = :f2<char[101]>\n" - " ) refs\n" + " sys.all_cons_columns refs\n" " WHERE\n" " main.r_constraint_name = refs.constraint_name (+)\n" " AND main.owner = refs.owner (+)\n" - " AND main.column_name = refs.column_name (+)\n" - " ORDER BY 1\n", + " AND main.column_name = refs.column_name (+)\n", "List the constraints on a table", ""); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <su...@us...> - 2009-08-16 17:37:32
|
Revision: 3240 http://tora.svn.sourceforge.net/tora/?rev=3240&view=rev Author: subik Date: 2009-08-16 17:37:19 +0000 (Sun, 16 Aug 2009) Log Message: ----------- fixed #2815244 Repeating references in Schema Browser Modified Paths: -------------- trunk/tora/src/tobrowsertablewidget.cpp Modified: trunk/tora/src/tobrowsertablewidget.cpp =================================================================== --- trunk/tora/src/tobrowsertablewidget.cpp 2009-08-16 17:17:23 UTC (rev 3239) +++ trunk/tora/src/tobrowsertablewidget.cpp 2009-08-16 17:37:19 UTC (rev 3240) @@ -216,11 +216,13 @@ " sys.all_cons_columns r,\n" " sys.all_cons_columns c\n" " WHERE a.constraint_type = 'R'\n" - " AND a.r_constraint_name IN ( SELECT b.constraint_name\n" - " FROM sys.all_constraints b\n" - " WHERE b.OWNER = :owner<char[101]>\n" - " AND b.TABLE_NAME = :tab<char[101]> )\n" + " AND (a.r_owner, a.r_constraint_name) IN ( SELECT b.owner, b.constraint_name\n" + " FROM sys.all_constraints b\n" + " WHERE b.OWNER = :owner<char[101]>\n" + " AND b.TABLE_NAME = :tab<char[101]> )\n" + " AND a.r_owner = r.owner\n" " AND a.r_constraint_name = r.constraint_name\n" + " AND a.owner = c.owner\n" " AND a.constraint_name = c.constraint_name\n" " UNION SELECT owner,\n" " name,\n" This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <su...@us...> - 2009-11-20 14:19:29
|
Revision: 3356 http://tora.svn.sourceforge.net/tora/?rev=3356&view=rev Author: subik Date: 2009-11-20 14:19:22 +0000 (Fri, 20 Nov 2009) Log Message: ----------- order data in the index view Modified Paths: -------------- trunk/tora/src/tobrowsertablewidget.cpp Modified: trunk/tora/src/tobrowsertablewidget.cpp =================================================================== --- trunk/tora/src/tobrowsertablewidget.cpp 2009-11-20 09:12:41 UTC (rev 3355) +++ trunk/tora/src/tobrowsertablewidget.cpp 2009-11-20 14:19:22 UTC (rev 3356) @@ -66,7 +66,8 @@ " AND EX.index_owner ( + ) = IND.index_owner\n" " AND EX.index_name ( + ) = IND.index_name\n" " AND IND.index_name = AL.index_name ( + )\n" - " AND IND.index_owner = AL.owner ( + )", + " AND IND.index_owner = AL.owner ( + )\n" + "ORDER BY ind.index_name, ind.column_position", "List the indexes on a table", ""); static toSQL SQLTableIndexSapDB("toBrowserTableWidget:TableIndex", This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <ibr...@us...> - 2011-04-15 10:50:10
|
Revision: 3939 http://tora.svn.sourceforge.net/tora/?rev=3939&view=rev Author: ibre5041 Date: 2011-04-15 10:50:04 +0000 (Fri, 15 Apr 2011) Log Message: ----------- Fix referential integrity query. This should fix: - child table column references table in another schema - child table column references column having different name Modified Paths: -------------- trunk/tora/src/tobrowsertablewidget.cpp Modified: trunk/tora/src/tobrowsertablewidget.cpp =================================================================== --- trunk/tora/src/tobrowsertablewidget.cpp 2011-04-15 09:26:11 UTC (rev 3938) +++ trunk/tora/src/tobrowsertablewidget.cpp 2011-04-15 10:50:04 UTC (rev 3939) @@ -174,7 +174,8 @@ " c.status,\n" " c.delete_rule,\n" " c.generated,\n" - " c.owner\n" + " c.owner,\n" + " c.r_owner\n" " FROM\n" " sys.All_Constraints c,\n" " sys.all_cons_columns a\n" @@ -189,8 +190,7 @@ " sys.all_cons_columns refs\n" " WHERE\n" " main.r_constraint_name = refs.constraint_name (+)\n" - " AND main.owner = refs.owner (+)\n" - " AND main.column_name = refs.column_name (+)\n", + " AND main.r_owner = refs.owner (+)\n", "List the constraints on a table", ""); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <ibr...@us...> - 2011-05-31 11:18:00
|
Revision: 3968 http://tora.svn.sourceforge.net/tora/?rev=3968&view=rev Author: ibre5041 Date: 2011-05-31 11:17:54 +0000 (Tue, 31 May 2011) Log Message: ----------- Display (sub)partition sizes. Modified Paths: -------------- trunk/tora/src/tobrowsertablewidget.cpp Modified: trunk/tora/src/tobrowsertablewidget.cpp =================================================================== --- trunk/tora/src/tobrowsertablewidget.cpp 2011-05-31 11:09:21 UTC (rev 3967) +++ trunk/tora/src/tobrowsertablewidget.cpp 2011-05-31 11:17:54 UTC (rev 3968) @@ -340,6 +340,7 @@ "select p.partition_name \"Partition\"\n" " , p.composite \"Composite\"\n" " , p.num_rows \"Partition rows\"\n" + " , round(seg.bytes/1024/1024) \"MB\"\n" " , p.high_value \"High value\"\n" " , p.subpartition_count \"Subpartitions\"\n" " , p.partition_position \"Position\"\n" @@ -347,12 +348,19 @@ " , s.num_rows \"Subpartition rows\"\n" " , s.subpartition_position \"Subpartition position\"\n" " from all_tab_partitions p,\n" - " all_tab_subpartitions s\n" + " all_tab_subpartitions s,\n" + " all_segments seg\n" " where p.table_owner = s.table_owner(+)\n" " and p.table_name = s.table_name(+)\n" " and p.partition_name = s.partition_name(+)\n" " and p.table_owner like upper(:table_owner<char[101]>)\n" " and p.table_name like upper(:table_name<char[101]>)\n" + " and ( \n" + " (p.partition_name = seg.partition_name and seg.segment_type='TABLE PARTITION') \n" + " or \n" + " (s.subpartition_name = seg.partition_name and seg.segment_type='TABLE SUBPARTITION') \n" + " ) \n" + " and p.table_name = seg.segment_name \n" " order by p.partition_name\n" " , s.subpartition_name\n", "Table partitions", This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <ibr...@us...> - 2011-06-21 11:02:46
|
Revision: 3981 http://tora.svn.sourceforge.net/tora/?rev=3981&view=rev Author: ibre5041 Date: 2011-06-21 11:02:40 +0000 (Tue, 21 Jun 2011) Log Message: ----------- Previous commit reverted. There is no view all_segments. Modified Paths: -------------- trunk/tora/src/tobrowsertablewidget.cpp Modified: trunk/tora/src/tobrowsertablewidget.cpp =================================================================== --- trunk/tora/src/tobrowsertablewidget.cpp 2011-06-20 20:15:51 UTC (rev 3980) +++ trunk/tora/src/tobrowsertablewidget.cpp 2011-06-21 11:02:40 UTC (rev 3981) @@ -340,7 +340,6 @@ "select p.partition_name \"Partition\"\n" " , p.composite \"Composite\"\n" " , p.num_rows \"Partition rows\"\n" - " , round(seg.bytes/1024/1024) \"MB\"\n" " , p.high_value \"High value\"\n" " , p.subpartition_count \"Subpartitions\"\n" " , p.partition_position \"Position\"\n" @@ -348,25 +347,50 @@ " , s.num_rows \"Subpartition rows\"\n" " , s.subpartition_position \"Subpartition position\"\n" " from all_tab_partitions p,\n" - " all_tab_subpartitions s,\n" - " all_segments seg\n" + " all_tab_subpartitions s\n" " where p.table_owner = s.table_owner(+)\n" " and p.table_name = s.table_name(+)\n" " and p.partition_name = s.partition_name(+)\n" " and p.table_owner like upper(:table_owner<char[101]>)\n" " and p.table_name like upper(:table_name<char[101]>)\n" - " and ( \n" - " (p.partition_name = seg.partition_name and seg.segment_type='TABLE PARTITION') \n" - " or \n" - " (s.subpartition_name = seg.partition_name and seg.segment_type='TABLE SUBPARTITION') \n" - " ) \n" - " and p.table_name = seg.segment_name \n" " order by p.partition_name\n" " , s.subpartition_name\n", "Table partitions", "0801"); +// NOTE: this query is not used yet we need to implement some kind of flag in connection +// saying: "User has 'admin' rights and can see dba_* v$* tables" +static toSQL SQLTablePartitionDBA("toBrowser:TablePartitions", + "select p.partition_name \"Partition\"\n" + " , p.composite \"Composite\"\n" + " , p.num_rows \"Partition rows\"\n" + " , round(seg.bytes/1024/1024) \"MB\"\n" + " , p.high_value \"High value\"\n" + " , p.subpartition_count \"Subpartitions\"\n" + " , p.partition_position \"Position\"\n" + " , s.subpartition_name \"Subpartition\"\n" + " , s.num_rows \"Subpartition rows\"\n" + " , s.subpartition_position \"Subpartition position\"\n" + " from all_tab_partitions p,\n" + " all_tab_subpartitions s,\n" + " dba_segments seg\n" + " where p.table_owner = s.table_owner(+)\n" + " and p.table_name = s.table_name(+)\n" + " and p.partition_name = s.partition_name(+)\n" + " and p.table_owner like upper(:table_owner<char[101]>)\n" + " and p.table_name like upper(:table_name<char[101]>)\n" + " and ( \n" + " (p.partition_name = seg.partition_name and seg.segment_type='TABLE PARTITION') \n" + " or \n" + " (s.subpartition_name = seg.partition_name and seg.segment_type='TABLE SUBPARTITION') \n" + " ) \n" + " and p.table_name = seg.segment_name \n" + " order by p.partition_name\n" + " , s.subpartition_name\n", + "Table partitions", + "0801"); + toBrowserTableWidget::toBrowserTableWidget(QWidget * parent) : toBrowserBaseWidget(parent) { This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <su...@us...> - 2011-09-05 11:05:07
|
Revision: 4055 http://tora.svn.sourceforge.net/tora/?rev=4055&view=rev Author: subik Date: 2011-09-05 11:05:00 +0000 (Mon, 05 Sep 2011) Log Message: ----------- fixed warning: ERROR:Overwrite description of nonmodified (toBrowser:TablePartitions) Modified Paths: -------------- trunk/tora/src/tobrowsertablewidget.cpp Modified: trunk/tora/src/tobrowsertablewidget.cpp =================================================================== --- trunk/tora/src/tobrowsertablewidget.cpp 2011-09-05 10:48:41 UTC (rev 4054) +++ trunk/tora/src/tobrowsertablewidget.cpp 2011-09-05 11:05:00 UTC (rev 4055) @@ -360,34 +360,34 @@ // NOTE: this query is not used yet we need to implement some kind of flag in connection // saying: "User has 'admin' rights and can see dba_* v$* tables" -static toSQL SQLTablePartitionDBA("toBrowser:TablePartitions", - "select p.partition_name \"Partition\"\n" - " , p.composite \"Composite\"\n" - " , p.num_rows \"Partition rows\"\n" - " , round(seg.bytes/1024/1024) \"MB\"\n" - " , p.high_value \"High value\"\n" - " , p.subpartition_count \"Subpartitions\"\n" - " , p.partition_position \"Position\"\n" - " , s.subpartition_name \"Subpartition\"\n" - " , s.num_rows \"Subpartition rows\"\n" - " , s.subpartition_position \"Subpartition position\"\n" - " from all_tab_partitions p,\n" - " all_tab_subpartitions s,\n" - " dba_segments seg\n" - " where p.table_owner = s.table_owner(+)\n" - " and p.table_name = s.table_name(+)\n" - " and p.partition_name = s.partition_name(+)\n" - " and p.table_owner like upper(:table_owner<char[101]>)\n" - " and p.table_name like upper(:table_name<char[101]>)\n" - " and ( \n" - " (p.partition_name = seg.partition_name and seg.segment_type='TABLE PARTITION') \n" - " or \n" - " (s.subpartition_name = seg.partition_name and seg.segment_type='TABLE SUBPARTITION') \n" - " ) \n" - " and p.table_name = seg.segment_name \n" - " order by p.partition_name\n" - " , s.subpartition_name\n", - "Table partitions", +static toSQL SQLTablePartitionDBA("toBrowser:TablePartitions", + "select p.partition_name \"Partition\"\n" + " , p.composite \"Composite\"\n" + " , p.num_rows \"Partition rows\"\n" + " , round(seg.bytes/1024/1024) \"MB\"\n" + " , p.high_value \"High value\"\n" + " , p.subpartition_count \"Subpartitions\"\n" + " , p.partition_position \"Position\"\n" + " , s.subpartition_name \"Subpartition\"\n" + " , s.num_rows \"Subpartition rows\"\n" + " , s.subpartition_position \"Subpartition position\"\n" + " from all_tab_partitions p,\n" + " all_tab_subpartitions s,\n" + " dba_segments seg\n" + " where p.table_owner = s.table_owner(+)\n" + " and p.table_name = s.table_name(+)\n" + " and p.partition_name = s.partition_name(+)\n" + " and p.table_owner like upper(:table_owner<char[101]>)\n" + " and p.table_name like upper(:table_name<char[101]>)\n" + " and ( \n" + " (p.partition_name = seg.partition_name and seg.segment_type='TABLE PARTITION') \n" + " or \n" + " (s.subpartition_name = seg.partition_name and seg.segment_type='TABLE SUBPARTITION') \n" + " ) \n" + " and p.table_name = seg.segment_name \n" + " order by p.partition_name\n" + " , s.subpartition_name\n", + "", "0801"); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <ibr...@us...> - 2012-06-24 20:39:56
|
Revision: 4364 http://tora.svn.sourceforge.net/tora/?rev=4364&view=rev Author: ibre5041 Date: 2012-06-24 20:39:50 +0000 (Sun, 24 Jun 2012) Log Message: ----------- do not show duplicit columns in FK constraints Modified Paths: -------------- trunk/tora/src/tobrowsertablewidget.cpp Modified: trunk/tora/src/tobrowsertablewidget.cpp =================================================================== --- trunk/tora/src/tobrowsertablewidget.cpp 2012-06-23 10:17:52 UTC (rev 4363) +++ trunk/tora/src/tobrowsertablewidget.cpp 2012-06-24 20:39:50 UTC (rev 4364) @@ -175,7 +175,8 @@ " c.delete_rule,\n" " c.generated,\n" " c.owner,\n" - " c.r_owner\n" + " c.r_owner,\n" + " a.position\n" " FROM\n" " sys.All_Constraints c,\n" " sys.all_cons_columns a\n" @@ -190,7 +191,8 @@ " sys.all_cons_columns refs\n" " WHERE\n" " main.r_constraint_name = refs.constraint_name (+)\n" - " AND main.r_owner = refs.owner (+)\n", + " AND main.r_owner = refs.owner (+)\n" + " AND main.position = refs.position (+)\n" , "List the constraints on a table", ""); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |