tenprt - 経済統計練習帳

var dic_name=new Array();
var dic_code=new Array();
var dic_key=new Array();
 
var namex=new Array();
var codex=new Array();
var number,numberx;
 
var subnamex=new Array();
var subcodex=new Array();
 
 
function myFunction() {
 
 
dicx();
 
number=3;
 
namex[1]="茶い";
codex[1]=3218;
 
namex[2]="茶c";
codex[2]=38881;
 
namex[3]="猫p";
codex[3]=3881999;
 
var subname=new Array();
var subcode=new Array();
 
 
 
tx=0;
for(s=1;s<number+1;s++){
sx=dic_key.indexOf(namex[s]);
str=""+codex[s];
if(str==0)sx=999999;
if(sx<0)tx=tx+1;
if(sx<0)subname[tx]=namex[s];
if(sx<0)subcode[tx]=codex[s];;
}
 
subnumber=tx;
 
Logger.log(subnumber)
 
numberx=0;
for(s=1;s<subnumber+1;s++){
h=0;
for(sx=1;sx<numberx+1;sx++){
if(subname[s]==subnamex[sx])h=100;
}
if(h<50)numberx=numberx+1;
if(h<50)subnamex[numberx]=subname[s];
if(h<50)subcodex[numberx]=subcode[s];
}
 
insert();
 
 
}
 
function insert(){
 
sqlx="";
 
for(k=1;k<numberx+1;k++){
sqlx =sqlx+ "INSERT INTO 1R-0xIKWP-geRnSrRcHpX1sKs4BXOR3zmZojI0Qtb (artist,code) VALUES ('"+subnamex[k]+"',"+subcodex[k]+");"
}
 
FusionTables.Query.sql(sqlx);
 
}
 
 
function dicx() {
 
id_or="1R-0xIKWP-geRnSrRcHpX1sKs4BXOR3zmZojI0Qtb";
 
  var sql = 'SELECT artist,code FROM ' +id_or;
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
 dic_key.push("noname");
 
  sxs=0;
    for(var i in r){   
  sx=dic_key.indexOf(r[i][0]);
  if(sx<1)dic_key.push(r[i][0]);
   if(sx<1)sxs=sxs+1;
  if(sx<1)dic_name[sxs]=r[i][0];
  if(sx<1)dic_code[sxs]=r[i][1];
   }
 
 
 
 
 
}