Changes between Version 2 and Version 3 of IMPORT roe

Timestamp:

Jun 21, 2018 2:59:27 PM (7 years ago)

Author:

cedric

Comment:

--

IMPORT roe

@@ -13 +13 @@
 psql -U postgres -c "Comment on table roe_v4.roe IS 'Version Mai 2014'"  eda2.2
 }}}
+
+From the excel table loaded, we create a temporary table corresponding to the new dam.
+These might not correspond to those already in the database.
+lb.tempmerge is the merge between the table coming from excel and the new ROE database.
+
+{{{#!r
+aaouvtemp=data[,c("dep","modif","ouv_rinom","ouv_id","ouv_libelle")]
+sqldf(
+                "DROP TABLE IF EXISTS lb.aaouvtemp"
+                )
+
+sqldf("create table lb.aaouvtemp as select * from aaouvtemp ")
+# je vais rechercher les tableaux ROE mais dans l'autre base correspondant à ces ouvrages
+
+roetemp<-sqldf(
+                "SELECT * from roe_v4.roe",
+                dbname="eda2.2",
+                host="localhost",
+        password=passwordlocal)
+colnames(data)[c(31:35)]<-c("Mortalite.Francis.70.cm","Mortalite.Francis.18.cm",   
+                "Mortalite.kaplan.70.cm","Mortalite.kaplan.18.cm","Nb.turbine.entree")
+tempmerge<-merge(roetemp,data, by.x="cdobstecou",by.y="ouv_id")
+sqldf("DROP TABLE IF EXISTS lb.tempmerge")
+sqldf("CREATE table lb.tempmerge as select * from tempmerge")
+}}}