Flickr JSON to SQL

by gkohen

HTML

<script src="http://cdnjs.cloudflare.com/ajax/libs/underscore.js/1.4.4/underscore-min.js"></script>

JavaScript

// First, checks if it isn't implemented yet.
if (!String.prototype.format) {
  String.prototype.format = function() {
    var args = arguments;
    return this.replace(/{(\d+)}/g, function(match, number) { 
      return typeof args[number] != 'undefined'
        ? args[number]
        : match
      ;
    });
  };
}
var flickerAPI = "http://api.flickr.com/services/rest/?method=flickr.photos.search&api_key=66adfbd7f75e163a39b56de954ef0d6d&jsoncallback=?";
                          $.getJSON( flickerAPI, {
                            user_id: '104700775@N04',
                            tagmode: "all",
                            safe_search :1,
                            extras : "tags,url_sq,sq_dims,url_m,m_dims",
                            page:1,
                            format: "json"
                          })
                            .done(function( data ) {
                                console.dir(data);
                            	retList=data.photos.photo;
                                _.each(retList,function(img){
                                    var tags=img.tags.split(' ');
                                    tags[0]=tags[0]|'';
                                    tags[1]=tags[1]|'';
                                    tags[2]=tags[2]|'';
                                    console.log("INSERT INTO IMAGE_INFO (IMAGE_ID, URL_M ,WIDTH_M,  HEIGHT_M,  URL_SQ,  WIDTH_SQ,  HEIGH_SQ,  BRAND,  COLOR,  CLUSTER) VALUES ( '{0}’,{1}, {2},{3},  '{4}’,  {5},  {6}, '{7}’,  '{8}’,  '{9}'); ".format(img.id),img.url_m,img.width_m,img.height_m,img.url_sq,img.width_sq,img.height_sq,tags[0],tags[1],tags[2]);                                      
                                       });                                
                            });