Changes between Version 46 and Version 47 of Noeud - parcours RHT

Timestamp:

Jan 6, 2012 4:47:16 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ -328 +328 @@
         DROP sequence IF EXISTS  seq;
         CREATE sequence seq;
-        EXECUTE 'create temporary table sousselection as SELECT id_drain, nextval(''seq'') as num FROM (SELECT * FROM rht.rht_topology WHERE noeudsource=FALSE ORDER BY id_drain) as sub WHERE id_drain >='|| min || ' AND id_drain<='||max ;
-        SELECT COUNT(*) FROM sousselection INTO nbligne;
+        EXECUTE 'create temporary table sousselection as SELECT id_drain, nextval(''seq'') as num FROM (SELECT * FROM rht.rhtvs2 WHERE noeudsource=FALSE ORDER BY id_drain) as sub WHERE id_drain >='|| min || ' AND id_drain<='||max ;
+        SELECT COUNT(*) FROM sousselection INTO nbligne;
         WHILE ligne <=nbligne LOOP
                   -- pour vérification décommenter ensuite
                   SELECT * from sousselection where num=ligne INTO id_drains;
                   RAISE NOTICE 'distance_source for %', quote_ident(CAST(id_drains.id_drain as text));
-                  EXECUTE 'INSERT INTO rht.distance_source SELECT '||id_drains.id_drain||', MAX(dmer+length/2) as dmer FROM rht.rht_topology WHERE id_drain IN (
-                        SELECT CAST(ltree2text(subpath(chemin, -1, 1))as integer) FROM rht.rht_topology where chemin ~  ''*.'||
+                  EXECUTE 'INSERT INTO rht.distance_source SELECT '||id_drains.id_drain||', MAX(dmer+length/2) as dmer FROM rht.rhtvs2 WHERE id_drain IN (
+                        SELECT CAST(ltree2text(subpath(chemin, -1, 1))as integer) FROM rht.rhtvs2 where chemin ~  ''*.'||
                         id_drains.id_drain
                         || '.*'' )';  
@@ -349 +349 @@
 
 -- pour essai pour voir ce qui se passe dans la requête
-
+-- je l'ai pas lancé !
 SELECT 212340,  MAX(dmer+length/2) as dmer FROM rht.rht_topology WHERE id_drain IN (
                         SELECT CAST(ltree2text(subpath(chemin, -1, 1))as integer) FROM rht.rht_topology where chemin ~  '*.212340.*' )
@@ -355 +355 @@
 
 -- POUR LES LANCEMENTS FINAUX IL A FALLU LANCER UN INDEX ET RAJOUTER UNE CLE PRIMAIRE
-Alter table rht.rht_topology add constraint c_pk_id_drain primary key (id_drain);
-CREATE INDEX id_drain_index  ON rht.rht_topology
+Alter table rht.rhtvs2 add constraint c_pk_id_drain primary key (id_drain);
+CREATE INDEX id_drain_index  ON rht.rhtvs2
   USING btree
   (id_drain);
-
-select rht.distance_source(100000,200000);
-select rht.distance_source(200001,300000);
-select rht.distance_source(300001,400000);
+select rht.distance_source(1,50000); --- ok
+select rht.distance_source(100001,200000);  ---ok
+select rht.distance_source(200001,300000);  --- ok
+select rht.distance_source(300001,400000); --- en cours
 select rht.distance_source(400001,600000);