com.c123.billbuddy.dal.UserDal.java Source code

Introduction

Here is the source code for com.c123.billbuddy.dal.UserDal.java

Source

/***************************************************************************
****
 * Copyright (c) 2013 GigaSpaces Technologies Ltd. and 123Completed Ltd. All rights reserved
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *       http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
     
****************************************************************************
***/
package com.c123.billbuddy.dal;

import java.util.List;

import javax.annotation.PostConstruct;
import javax.annotation.Resource;

import org.openspaces.core.GigaSpace;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Component;

import com.c123.billbuddy.model.Payment;
import com.c123.billbuddy.model.User;
import java.util.Arrays;
import com.j_spaces.core.client.SQLQuery;

/** 
 *   Data Access Layer design pattern.
 *   
 *   Enables access to Administrative User operations(getUserPayments,getAllUsers etc.)
 *
 *   Dal object is injected by Spring framework as a singleton, thus, BillBuddy space 
 *   also injected to Dal instance.
 * 
 * @author 123Completed
 */
@Component
public class UserDal {

    private static UserDal instance;

    @Resource
    @Qualifier(value = "gigaSpace")
    private GigaSpace gigaSpace;

    public static UserDal getInstance() {
        return instance;
    }

    public UserDal() {
    }

    @PostConstruct
    @SuppressWarnings("unused")
    private void init() {
        instance = this;
    }

    public List<User> getAllUsers() {
        List<User> allUsers = null;
        SQLQuery<User> query = new SQLQuery<User>(User.class, "order by userAccountId");
        User[] users = (User[]) gigaSpace.readMultiple(query, Integer.MAX_VALUE);

        if (users != null) {
            allUsers = Arrays.asList(users);
        }

        return allUsers;
    }

    public List<Payment> getUserPayments(User user) {
        List<Payment> userPaymentList = null;
        SQLQuery<Payment> paymentQuery = new SQLQuery<Payment>(Payment.class,
                "payingAccountId = ? order by paymentId ");
        paymentQuery.setParameter(1, user.getUserAccountId());
        Payment[] userPayments = (Payment[]) gigaSpace.readMultiple(paymentQuery, Integer.MAX_VALUE);
        if (userPayments != null) {
            userPaymentList = Arrays.asList(userPayments);
        }

        return userPaymentList;
    }

}