sounyuu++ - 経済統計練習帳

function myFunction() {
 
id_or="16zlbESM_0PL9DVz7BpKayLwLdAMFTxHFQKoPxbfL";
 
 
   var id3="1FhD3f3Z1yC4lYW73Pe-hHRfPJCkON4sCwveJ1e5klfs";
 
 
 var ex3 = SpreadsheetApp.openById(id3);
 var sh3 = ex3.getSheetByName("data");
 
 
 number=sh3.getLastRow()-1;
 
 var codex=new Array();
var namex=new Array();
 
  var v=sh3.getRange(1,1,number+1,2).getValues();
 
var s;
 
for(s=1;s<number+1;s++){
namex[s]=v[s][0]; 
codex[s]=""+v[s][1];
}
 
 
for(s=1001;s<1101;s++){
 
c3=codex[s];
if(c3.length<2){
c3=select(id_or,namex[s]);
}
 
 
if(c3.length<2){
c3=search(namex[s]);
if(c3.length>2)insert(id_or,namex[s],c3);
Logger.log(namex[s]+","+c3);
}
 
 
h=0;
if(codex[s].length<2)h=h+1;
if(c3.length>2)h=h+1;
if(h==2)sh3.getRange(s+1,2).setValue(c3);
 
codex[s]=c3;
 
}
 
 
 
 
 
 
 
}
 
 
function search(wo) {
 
 var s;
 
  word=ecl.EscapeSJIS(wo)
 
 
 
   uu="http://www.oricon.co.jp/search/result.php?types=artist&search_string="+word;
 
 
       try {
 
 var response = UrlFetchApp.fetch(uu);
 str=response.getContentText("SJIS");
 
    } 
    catch (e) {Logger.log("Fail")}
 
 
 
 
  p1=str.indexOf("</strong>を含む芸能人名</span></h3>");
 
p2=str.indexOf("lock-search-box bottom mb0",p1);
 
  str=str.substring(p1,p2);
 
 
  var x=str.split("\n");
 
 
 
  var code="";
        for(s=1;s<x.length;s++){
        h=0;
       if(x[s].indexOf("/prof/")>-1)h=h+1;
        if(code.length<1)h=h+1;
        if(h==2)code=x[s];
 
        }
 
  p1=code.indexOf("prof");
 p1=code.indexOf("/",p1);
 p2=code.indexOf("/",p1+1);
  if(p1>-1)code=code.substring(p1+1,p2);
 
 
      return code;
 
 
 
 
 
 
}
 
 
 
function check(id,n1) {
 
  var sql = 'SELECT * FROM ' +id;
   sql =sql+ " WHERE artist='"+n1+"'";
 
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
  sx=0;
    for(var i in r){
   sx=sx+1;
  }
 
return sx;
 
 
}
 
 
 function select(id,n1) {
 
  var sql = 'SELECT * FROM ' +id;
   sql =sql+ " WHERE artist='"+n1+"'";
 
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
sx=0; 
  cc="";
    for(var i in r){
   sx=sx+1;
  cc=""+r[i][1];
  }
 
return cc;
 
 
}
 
 
function insert(id,n1,c1) {
 
var sql = "INSERT INTO "+id+ "  (artist,code)  VALUES ('"+n1+"',"+c1+")";
 
 Logger.log(sql);
 
 
 var res = FusionTables.Query.sql(sql);
 
 
 
 
}