storage/aaLoadQuote.cpp

   1 /* -*- Mode: C++; tab-width: 2; indent-tabs-mode: nil; c-basic-offset: 2 -*- */
   2 /* vim:set ts=2 sw=2 sts=2 et cindent tw=79 ft=cpp: */
   3 /*
   4  * Copyright (C) 2007 Sergey Yanovich <ynvich@gmail.com>
   5  *
   6  * This program is free software; you can redistribute it and/or
   7  * modify it under the terms of the GNU General Public License as
   8  * published by the Free Software Foundation; either version 2 of the
   9  * License, or (at your option) any later version.
  10  *
  11  * This program is distributed in the hope that it will be useful,
  12  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  13  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
  14  * General Public License for more details.
  15  *
  16  * You should have received a copy of the GNU General Public
  17  * License along with this program; if not, write to the
  18  * Free Software Foundation, Inc., 59 Temple Place - Suite 330,
  19  * Boston, MA 02111-1307, USA.
  20  */
  21
  22 #include <abstract/aacore.h>
  23
  24 #include "nsCOMPtr.h"
  25 #include "nsIMutableArray.h"
  26 #include "nsComponentManagerUtils.h"
  27 #include "nsStringAPI.h"
  28 #include "nsEmbedString.h"
  29
  30 /* Unfrozen API */
  31 #include "unstable/mozIStorageConnection.h"
  32 #include "unstable/mozIStorageStatement.h"
  33
  34 /* Project includes */
  35 #include <abstract/base/aaIResource.h>
  36 #include <abstract/base/aaIQuote.h>
  37 #include <abstract/storage/aaILoadQuery.h>
  38 #include "aaLoadQuote.h"
  39
  40 #define AA_LOADQUOTE_SELECT_QUERY "SELECT quote.resource_id, resource.tag,\
  41   strftime('%s',quote.day), quote.rate\
  42   FROM quote LEFT JOIN resource ON quote.resource_id == resource.id"
  43 #define AA_QUOTE_ITEM_CONTRACT "@aasii.org/base/quote;1"
  44
  45 aaLoadQuote::aaLoadQuote(nsISupports *aOuter)
  46   :aaLoadQuery(aOuter)
  47 {
  48 }
  49
  50 aaLoadQuote::~aaLoadQuote()
  51 {
  52 }
  53
  54 NS_IMPL_ISUPPORTS_INHERITED0(aaLoadQuote,
  55                              aaLoadQuery)
  56
  57 /* Virtual methods */
  58 const char*
  59 aaLoadQuote::getSelectQuery() const
  60 {
  61   return AA_LOADQUOTE_SELECT_QUERY;
  62 }
  63
  64 aaIDataNode*
  65 aaLoadQuote::fetchRow()
  66 {
  67   nsresult rv;
  68   PRInt64 resourceId;
  69   PRTime time;
  70   nsEmbedCString tag;
  71   double rate;
  72   rv = mStatement->GetInt64(2, &time);
  73   if (NS_FAILED(rv))
  74     return nsnull;
  75   time *= 1000000;
  76
  77   rv = mStatement->GetDouble(3, &rate);
  78   if (NS_FAILED(rv))
  79     return nsnull;
  80
  81   rv = mStatement->GetInt64(0, &resourceId);
  82   if (NS_FAILED(rv))
  83     return nsnull;
  84
  85   nsEmbedCString resourceTag;
  86   rv = mStatement->GetUTF8String(1, resourceTag);
  87   if (NS_FAILED(rv))
  88     return nsnull;
  89
  90   nsCOMPtr<aaIResource> resource(do_CreateInstance("@aasii.org/base/resource;1"));
  91   if (! resource)
  92     return nsnull;
  93
  94   rv = resource->SetId(resourceId);
  95   if (NS_FAILED(rv))
  96     return nsnull;
  97
  98   rv = resource->SetTag(NS_ConvertUTF8toUTF16(resourceTag));
  99   if (NS_FAILED(rv))
 100     return nsnull;
 101
 102
 103   aaIQuote* quote;
 104   CallCreateInstance("@aasii.org/base/quote;1", nsnull, &quote);
 105   if (! quote)
 106     return nsnull;
 107
 108   quote->SetResource(resource);
 109   quote->SetTime(time);
 110   quote->SetRate(rate);
 111
 112   return quote;
 113 }
 114