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: */
4 * Copyright (C) 2007 Sergey Yanovich <ynvich@gmail.com>
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.
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.
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.
22 #include <abstract/aacore.h>
25 #include "nsIMutableArray.h"
26 #include "nsComponentManagerUtils.h"
27 #include "nsStringAPI.h"
28 #include "nsEmbedString.h"
31 #include "unstable/mozIStorageConnection.h"
32 #include "unstable/mozIStorageStatement.h"
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"
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"
45 aaLoadQuote::aaLoadQuote(nsISupports
*aOuter
)
50 aaLoadQuote::~aaLoadQuote()
54 NS_IMPL_ISUPPORTS_INHERITED0(aaLoadQuote
,
59 aaLoadQuote::getSelectQuery() const
61 return AA_LOADQUOTE_SELECT_QUERY
;
65 aaLoadQuote::fetchRow()
72 rv
= mStatement
->GetInt64(2, &time
);
77 rv
= mStatement
->GetDouble(3, &rate
);
81 rv
= mStatement
->GetInt64(0, &resourceId
);
85 nsEmbedCString resourceTag
;
86 rv
= mStatement
->GetUTF8String(1, resourceTag
);
90 nsCOMPtr
<aaIResource
> resource(do_CreateInstance("@aasii.org/base/resource;1"));
94 rv
= resource
->SetId(resourceId
);
98 rv
= resource
->SetTag(NS_ConvertUTF8toUTF16(resourceTag
));
104 CallCreateInstance("@aasii.org/base/quote;1", nsnull
, "e
);
108 quote
->SetResource(resource
);
109 quote
->SetTime(time
);
110 quote
->SetRate(rate
);