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 "xpcom-config.h"
25 #include "nsIMutableArray.h"
26 #include "nsComponentManagerUtils.h"
27 #include "nsStringAPI.h"
28 #include "nsEmbedString.h"
31 #include "mozIStorageConnection.h"
32 #include "mozIStorageStatement.h"
34 /* Project includes */
38 #include "aaLoadPendingFacts.h"
40 #define AA_LOADPENDINGFACTS_SELECT_QUERY "SELECT strftime('%s',transfer.day),\
41 transfer.event_id, transfer.id, fromF.flow_id, toF.flow_id, transfer.amount\
43 LEFT JOIN txn ON transfer.day == txn.day AND transfer.event_id == txn.event_id\
44 AND transfer.id == txn.transfer_id\
45 LEFT JOIN fact AS fromF ON transfer.day == fromF.day AND transfer.event_id\
46 == fromF.event_id AND transfer.id == fromF.transfer_id AND\
48 LEFT JOIN fact AS toF ON transfer.day == toF.day AND transfer.event_id ==\
49 toF.event_id AND transfer.id == toF.transfer_id AND toF.side == 0\
50 WHERE txn.value IS NULL"
52 aaLoadPendingFacts::aaLoadPendingFacts(nsISupports
*aOuter
)
57 aaLoadPendingFacts::~aaLoadPendingFacts()
61 NS_IMPL_ISUPPORTS_INHERITED0(aaLoadPendingFacts
,
66 aaLoadPendingFacts::getSelectQuery() const
68 return AA_LOADPENDINGFACTS_SELECT_QUERY
;
72 aaLoadPendingFacts::fetchRow()
75 PRInt64 id
, eventId
, fromId
, toId
;
79 rv
= mStatement
->GetInt64(0, &time
);
84 rv
= mStatement
->GetInt64(1, &eventId
);
88 nsCOMPtr
<aaIEvent
> event
= do_CreateInstance("@aasii.org/base/event;1");
89 if (NS_UNLIKELY( ! event
))
91 event
->SetTime( time
);
92 event
->SetId( eventId
);
94 rv
= mStatement
->GetInt64(2, &id
);
95 NS_ENSURE_SUCCESS(rv
, nsnull
);
97 nsCOMPtr
<aaIFlow
> fromFlow(do_CreateInstance("@aasii.org/base/flow;1"));
98 nsCOMPtr
<aaIFlow
> toFlow(do_CreateInstance("@aasii.org/base/flow;1"));
99 NS_ENSURE_TRUE(fromFlow
&& toFlow
, nsnull
);
101 rv
= mStatement
->GetInt64(3, &fromId
);
102 NS_ENSURE_SUCCESS(rv
, nsnull
);
103 fromFlow
->SetId(fromId
);
105 rv
= mStatement
->GetInt64(4, &toId
);
106 NS_ENSURE_SUCCESS(rv
, nsnull
);
109 rv
= mStatement
->GetDouble(5, &sum
);
110 NS_ENSURE_SUCCESS(rv
, nsnull
);
113 CallCreateInstance("@aasii.org/base/fact;1", nsnull
, &fact
);
118 fact
->SetEvent(event
);
119 fact
->SetTakeFrom(fromFlow
);
120 fact
->SetGiveTo(toFlow
);
121 fact
->SetAmount(sum
);