g.mapset mapset=zone location=local -c

db.connect driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db'
db.connect -p

db.in.ogr dsn=J:\PROTEI\fukushima\inter\bary.dbf db_table=bary
db.in.ogr dsn=J:\PROTEI\fukushima\sortie\distance\drone_1.dbf db_table=drone_1
db.in.ogr dsn=J:\PROTEI\fukushima\sortie\distance\drone_2.dbf db_table=drone_2

v.db.connect map=bary@zone driver=sqlite database=$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db table=bary -o
v.db.connect map=drone_1@zone driver=sqlite database=$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db table=drone_1 -o
v.db.connect map=drone_2@zone driver=sqlite database=$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db table=drone_2 -o

v.db.addcol map=bary@zone columns="DIST_drone_1"
v.db.addcol map=bary@zone columns="DIST_drone_2"
v.db.addcol map=bary@zone columns="VAL_drone_1"
v.db.addcol map=bary@zone columns="VAL_drone_2"
v.db.addcol map=bary@zone columns="VAL_source"

echo update bary set VAL_drone_1=(select VAL from drone_1) | db.execute
echo update bary set VAL_drone_2=(select VAL from drone_2) | db.execute
echo update bary set DIST_drone_1=(select DIST from drone_1) | db.execute
echo update bary set DIST_drone_2=(select DIST from drone_2) | db.execute

echo update bary set VAL_source=(-((DIST_drone_1*(VAL_drone_1-VAL_drone_2) / (DIST_drone_1-DIST_drone_2)))+VAL_drone_1) | db.execute