|| || || || || || || ||

---

TableDataSourceFlickrPhotoList.h

Go to the documentation of this file.

#ifndef TABLEDATASOURCEFLICKRPHOTOLIST_H
#define TABLEDATASOURCEFLICKRPHOTOLIST_H

#include "TableDataSource.h"

#include "RemoteRetriever.h"

#include "Util/XmlDoc.h"
#include "Persistency/XmlFileReader.h"

namespace Impala { namespace Application { namespace MediaTable {

class TableDataSourceFlickrPhotoList : public TableDataSource, public Util::XmlDoc
{
public:
        TableDataSourceFlickrPhotoList(std::string url = ""):
        TableDataSource()
    {
        mRemoteRetriever = RemoteRetriever::GetInstance();
        Init(url);
    }

    ~TableDataSourceFlickrPhotoList()
    {
    }


    /* get individual row characteristics ************************/
    virtual String
    GetTextDataByID(String column, int row)
    {
                return GetAttributeValue(mPhotos[row], column.c_str());
    }

    virtual int
    GetIntDataByID(String column, int row)
    {
        return atoi(GetTextDataByID(column, row));
    }

    virtual double
    GetDoubleDataByID(String column, int row)
    {
        return atof(GetTextDataByID(column, row));
    }

    //virtual int
    //GetRowHeight(int row)
    //{
    //    return 40;
    //}

    virtual double
    GetNormalizedDataByID(String column, int row)
    {
        double v = row / (double)mTotalRows;
        if (column == "red")
            return v;
        if (column == "green")
            return 1.0 - v;
        if (column == "blue") {
            return (row % 10) / 10.0;
        }

        return atof(GetTextDataByID(column, row));
    }

    virtual Array2dVec3UInt8*
    GetImageDataByID(String column, int row)
    {
        std::string sizeSuffix = "s";
        std::string imageUrl = "http://farm";
        imageUrl += GetAttributeValue(mPhotos[row], "farm") + ".static.flickr.com/";
        imageUrl += GetAttributeValue(mPhotos[row], "server") + "/";
        imageUrl += GetAttributeValue(mPhotos[row], "id") + "_";
        imageUrl += GetAttributeValue(mPhotos[row], "secret");
        if(sizeSuffix.length() > 0) imageUrl += "_" + sizeSuffix;
        imageUrl += ".jpg";

        Array2dVec3UInt8* ar = 0;
        ar = mRemoteRetriever->RetrieveImageData(imageUrl);
        return ar;
    }

    int GetTotalRows() {
        return mTotalRows;
    }

private:

    void Init(std::string url)
    {
        AddStaticColumn("id", TYPE_TEXT, 50);
        AddStaticColumn("photo", TYPE_IMAGE, 50);
        AddColumn("secret", TYPE_TEXT, 50);
        AddColumn("farm", TYPE_INT, 50);
        AddColumn("server", TYPE_INT, 50);
        AddColumn("owner", TYPE_TEXT, 50);
        AddColumn("title", TYPE_TEXT, 50);
        AddColumn("ownername", TYPE_TEXT, 50);
        AddColumn("latitude", TYPE_DOUBLE, 50);
        AddColumn("longitude", TYPE_DOUBLE, 50);
        AddColumn("views", TYPE_INT, 50);
        AddColumn("tags", TYPE_TEXT, 50);
        AddColumn("red", TYPE_NORMALIZEDVALUE, 50, 1);
        AddColumn("green", TYPE_NORMALIZEDVALUE, 50, 2);
        AddColumn("blue", TYPE_NORMALIZEDVALUE, 50, 3);

        loadXML(url);
    }

        void loadXML(std::string url) {
                //string url = "http://api.flickr.com/services/rest/?method=flickr.photos.search&api_key=78c291da0267f70420521d1a04b788a0&sort=date-posted-asc&tag_mode=all&media=photos&extras=license,date_upload,date_taken,owner_name,icon_server,original_format,last_update,geo,tags,machine_tags,o_dims,views,media&per_page=500&tags=obama";
                if(url == "")
                        url = "http://api.flickr.com/services/rest/?method=flickr.panda.getPhotos&api_key=78c291da0267f70420521d1a04b788a0&extras=license,date_upload,date_taken,owner_name,icon_server,original_format,last_update,geo,tags,machine_tags,o_dims,views,media&per_page=500&panda_name=wang%20wang";
                std::string xmlFile = "photos.xml";

                mRemoteRetriever->RetrieveFile(url, false, true, xmlFile);

        ILOG_INFO("reading XML file: " + xmlFile);
                DOMDocument* doc = reader.Read(xmlFile);
                DOMNode* root = GetChildNode(GetChildNode(doc, "rsp", true), "photos", true);

                mPhotos = GetChildNodes(root, "photo");
                mTotalRows = mPhotos.size();
        }

        Persistency::XmlFileReader      reader;
        std::vector<DOMNode*>           mPhotos;
    RemoteRetriever*                    mRemoteRetriever;
    int                                                 mTotalRows;

    ILOG_VAR_DEC;
};

ILOG_VAR_INIT(TableDataSourceFlickrPhotoList, Application.MediaTable);

} } } // namespace Impala::Application::MediaTable

#endif // TABLEDATASOURCEFLICKRPHOTOLIST_H

---