storage/base/aaInsertQuote.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) 2008 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 "xpcom-config.h"
  23
  24 #include "nsCOMPtr.h"
  25 #include "nsComponentManagerUtils.h"
  26 #include "nsXPCOMCID.h"
  27 #include "nsIMutableArray.h"
  28 #include "nsISupportsPrimitives.h"
  29
  30 /* Unfrozen API */
  31
  32 /* Project includes */
  33 #include "aaIMoney.h"
  34 #include "aaIQuote.h"
  35 #include "aaInsertQuote.h"
  36
  37 static const char *sql =
  38   "INSERT INTO quote (resource_id, day, rate, diff)\
  39   VALUES (?, (replace(round(julianday(?,'unixepoch')),'.0','')), ?, ?)";
  40
  41 aaInsertQuote::aaInsertQuote()
  42 {
  43   mSql = sql;
  44 }
  45
  46 NS_IMPL_ISUPPORTS_INHERITED0(aaInsertQuote,
  47                              aaSaveRequest)
  48
  49 /* aaSaveRequest */
  50 NS_IMETHODIMP
  51 aaInsertQuote::SetFilter(nsISupports * aFilter)
  52 {
  53   nsresult rv;
  54   mQuote = do_QueryInterface(aFilter, &rv);
  55   NS_ENSURE_SUCCESS(rv, rv);
  56
  57   return NS_OK;
  58 }
  59
  60 NS_IMETHODIMP
  61 aaInsertQuote::GetParams(nsIArray * * aParams)
  62 {
  63   NS_ENSURE_TRUE(mQuote, NS_ERROR_NOT_INITIALIZED);
  64   NS_ENSURE_ARG_POINTER(mQuote->PickResource());
  65   nsresult rv;
  66
  67   nsCOMPtr<nsIMutableArray> result
  68     = do_CreateInstance(NS_ARRAY_CONTRACTID, &rv);
  69   NS_ENSURE_SUCCESS(rv, rv);
  70
  71   nsCOMPtr<nsISupportsPRInt64> valInt64;
  72   nsCOMPtr<nsISupportsPRInt32> valInt32;
  73   nsCOMPtr<nsISupportsDouble> valDouble;
  74
  75   valInt64 = do_CreateInstance(NS_SUPPORTS_PRINT64_CONTRACTID, &rv);
  76   NS_ENSURE_SUCCESS(rv, rv);
  77   rv = valInt64->SetData(mQuote->PickResource()->PickId());
  78   NS_ENSURE_SUCCESS(rv, rv);
  79   rv = result->InsertElementAt(valInt64, 0, PR_FALSE);
  80   NS_ENSURE_SUCCESS(rv, rv);
  81
  82   valInt64 = do_CreateInstance(NS_SUPPORTS_PRINT64_CONTRACTID, &rv);
  83   NS_ENSURE_SUCCESS(rv, rv);
  84   rv = valInt64->SetData(mQuote->PickTime() / 1000000);
  85   NS_ENSURE_SUCCESS(rv, rv);
  86   rv = result->InsertElementAt(valInt64, 1, PR_FALSE);
  87   NS_ENSURE_SUCCESS(rv, rv);
  88
  89   valDouble = do_CreateInstance(NS_SUPPORTS_DOUBLE_CONTRACTID, &rv);
  90   NS_ENSURE_SUCCESS(rv, rv);
  91   rv = valDouble->SetData(mQuote->PickRate());
  92   NS_ENSURE_SUCCESS(rv, rv);
  93   rv = result->InsertElementAt(valDouble, 2, PR_FALSE);
  94   NS_ENSURE_SUCCESS(rv, rv);
  95
  96   valDouble = do_CreateInstance(NS_SUPPORTS_DOUBLE_CONTRACTID, &rv);
  97   NS_ENSURE_SUCCESS(rv, rv);
  98   rv = valDouble->SetData(mQuote->PickDiff());
  99   NS_ENSURE_SUCCESS(rv, rv);
 100   rv = result->InsertElementAt(valDouble, 3, PR_FALSE);
 101   NS_ENSURE_SUCCESS(rv, rv);
 102
 103   *aParams = result;
 104   result.forget();
 105
 106   return NS_OK;
 107 }