All Downloads are FREE. Search and download functionalities are using the official Maven repository.
  • Log In
  • Register

    • com.cobweb.io.service.ReadService Maven / Gradle / Ivy

    The newest version!
    package com.cobweb.io.service;

import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Locale;

import com.cobweb.io.meta.Device;
import com.cobweb.io.meta.DeviceType;
import com.cobweb.io.meta.FriendRequest;
import com.cobweb.io.meta.LoggedUser;
import com.cobweb.io.meta.Payload;
import com.cobweb.io.meta.Sensor;
import com.cobweb.io.meta.SensorType;
import com.cobweb.io.meta.User;
import com.orientechnologies.orient.core.record.impl.ODocument;
import com.orientechnologies.orient.core.sql.query.OSQLSynchQuery;
import com.tinkerpop.blueprints.Vertex;


/**
 * The Class ReadService.
 *
 * @author Yasith Lokuge
 */

public class ReadService implements AbstractService{

	/** The invalid. */
	private final String INVALID = "Invalid user name or password"; 
	
	/**
	 * Read.
	 *
	 * @param loggedUser the logged user
	 * @param data the data
	 * @return the string
	 */
	public String read(LoggedUser loggedUser,String data){
	
		String email= loggedUser.getEmail();
		String password = loggedUser.getPassword();
		String info;
		
		List result =  graph.getRawGraph().query(new OSQLSynchQuery("select from User where email=\""+email+"\" and password=\""+password+"\""));
		 		
		if(!result.isEmpty()){			
			Vertex v = graph.getVertex(result.get(0).getIdentity());
			info = v.getProperty(data);
			return info;
		}else{
			return INVALID;
		}
		
	}
	
	/**
	 * Gets the confirmed user names list.
	 *
	 * @return the list
	 */
	public List getConfirmedUserNamesList(){
		
		List userNameList = new ArrayList<>();
		List result =  graph.getRawGraph().query(new OSQLSynchQuery("Select email from User WHERE isDeleted=false"));		
		
		for (ODocument oDocument : result) {
			userNameList.add(oDocument.field("email"));
		}		
		return userNameList;		
	}
	
	/**
	 * Gets the Unconfirmed user names list.
	 *
	 * @return the deleted user names list
	 */
	public List getUnconfirmedUserNamesList(){
		
		List userNameList = new ArrayList<>();
		List result =  graph.getRawGraph().query(new OSQLSynchQuery("Select email from User WHERE isDeleted=true"));		
		
		for (ODocument oDocument : result) {
			userNameList.add(oDocument.field("email"));
		}		
		return userNameList;		
	}
	
	
	/**
	 * Check user name exists.
	 *
	 * @param email the email
	 * @return true, if successful
	 */
	public boolean checkUserNameExistsByEmail(String email){				
		try {
			ODocument result = (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("Select email from User where email='"+email+"' AND isDeleted=false")).get(0);
			String data = result.field("email");
			return data.equals(email);
		} catch (Exception e) {			
			return false;
		}	
	}
	
	/**
	 * Check user name exists by id.
	 *
	 * @param userId the user id
	 * @return true, if successful
	 */
	public boolean checkUserNameExistsById(String userId){				
		try {
			ODocument result = (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("Select idValue from User where idValue='"+userId+"' AND isDeleted=false")).get(0);
			String data = result.field("idValue");
			return data.equals(userId);
		} catch (Exception e) {			
			return false;
		}	
	}
	
	/**
	 * Check password exists.
	 *
	 * @param password the password
	 * @return true, if successful
	 */
	public boolean checkPasswordExists(String password){				
		try {
			ODocument result = (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("Select password from User where password='"+password+"' AND isDeleted=false")).get(0);
			String data = result.field("password");
			return data.equals(password);
		} catch (Exception e) {			
			return false;
		}	
	}
	
	/**
	 * Gets the user id.
	 *
	 * @param email the email
	 * @return the user id
	 */
	public String getUserId(String email){
		ODocument result;
		String idValue = null;
		try {
			result = (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("Select idValue from User where email='"+email+"' AND isDeleted=false")).get(0);
			idValue = result.field("idValue");		
		} catch (Exception e) {
			idValue = null;
		}
		return idValue;
	}
	
	
	/**
	 * Gets the email.
	 *
	 * @param userId the user id
	 * @return the email
	 */
	public String getEmail(String userId){
		ODocument result;
		String email = null;
		try {
			result = (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("Select email from User where idValue='"+userId+"'")).get(0);
			email = result.field("email");		
		} catch (Exception e) {
			email = null;
		}
		return email;
	}

	/**
	 * Gets the salt.
	 *
	 * @param userId the user id
	 * @return the salt
	 */
	public String getSalt(String userId){
		
		String salt = null;
		try {
			ODocument result =  (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("Select salt from User where idValue='"+userId+"' AND isDeleted=false")).get(0);
			salt = result.field("salt");
		} catch (Exception e) {
			salt = null;
		}
		return salt;
	}
	
	
	/**
	 * Gets the device id list.
	 *
	 * @param userId the user id
	 * @return the device id list
	 */
	public List getDeviceIdList(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(out('UserHasDevices')[isDeleted = false]) from User where idValue='"+userId+"' AND isDeleted=false"));
		List	deviceIdList = new ArrayList();
		
		for (ODocument result:resultList) {			
			deviceIdList.add(result.field("idValue"));			
		}		
		return deviceIdList;		
	}
	
	
	/**
	 * Gets the sensor id list.
	 *
	 * @param userId the user id
	 * @return the sensor id list
	 */
	public List getSensorIdList(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(out('UserHasDevices')[isDeleted = false].out('DeviceHasSensors')[isDeleted = false]) from User where idValue='"+userId+"'"));
		List	sensorIdList = new ArrayList();
		
		for (ODocument result:resultList) {			
			sensorIdList.add(result.field("idValue"));			
		}		
		return sensorIdList;		
	}
	
	
	
	/**
	 * Gets the sensor list.
	 *
	 * @param userId the user id
	 * @return the sensor list
	 */
	public List getSensorList(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(out('UserHasDevices')[isDeleted = false].out('DeviceHasSensors')[isDeleted = false]) from User where idValue='"+ userId+"'"));
		List	sensorList = new ArrayList();
		
		for (ODocument result:resultList) {
			
			String name 		= result.field("name"); 
			String id 			= result.field("idValue");
			String description 	= result.field("description");
			String sensorType 	= result.field("sensorType");
			String otherType 	= result.field("otherType");
			
			String parentDevice = getParentDeviceIdFromSensor(id);
			
			Sensor sensor = new Sensor(name, description, SensorType.valueOf(sensorType));
			sensor.setId(id);
			sensor.setOtherType(otherType);
			sensor.setParentDeviceId(parentDevice);			
									
			sensorList.add(sensor);
		}		
		return sensorList;				
	}
	
	
	/**
	 * Gets the device list.
	 *
	 * @param userId the user id
	 * @return the device list
	 */
	public List getDeviceList(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(out('UserHasDevices')[isDeleted = false]) from User where idValue='"+ userId+"'"));
		List	deviceList = new ArrayList();
		
		for (ODocument result:resultList) {
			
			String name 		= result.field("name"); 
			String id 			= result.field("idValue");
			String description 	= result.field("description");
			String deviceType 	= result.field("deviceType");
			String otherType 	= result.field("otherType");
			
			String parentUserId = getParentUserIdFromDevice(id);
			
			List attachedSensorList = getAttachedSensorList(id);
			
			Device device = new Device(name, description, DeviceType.valueOf(deviceType));
			device.setId(id);
			device.setOtherType(otherType);
			device.setSensorIdList(attachedSensorList);
			device.setParentUserId(parentUserId);
			
								
			deviceList.add(device);
		}		
		return deviceList;				
	}
	
	/**
	 * Check device exists.
	 *
	 * @param deviceId the device id
	 * @return true, if successful
	 */
	public boolean checkDeviceExists(String deviceId){
		try {
			ODocument result = (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("Select idValue from Device where idValue='"+deviceId+"'")).get(0);
			String data = result.field("idValue");
			return data.equals(deviceId);
		} catch (Exception e) {			
			return false;
		}
	}

	/**
	 * Gets the payload list.
	 *
	 * @param sensorId the sensor id
	 * @return the payload list
	 */
	public List getDevicePayloadList(String deviceId){
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(out('DeviceHasPayload')[isDeleted = false]) from Device where idValue='"+deviceId+"'"));
		
		List	payloadList = new ArrayList();

		
		for (ODocument result:resultList) {
			
			String id = result.field("idValue");
			String message = result.field("message");
			String dateTime = result.field("dateTime");
			
			Payload payload = new Payload(message);
			payload.setId(id);
			payload.setMessage(message);
			
			payload.setDeviceId(deviceId);			
			String userId = getParentUserIdFromDevice(deviceId);		
			payload.setUserId(userId);			
			
			DateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss", Locale.ENGLISH);
			
			
			try {
				Date date = format.parse(dateTime);
				payload.setDateTime(date);
			} catch (ParseException e) {
				e.printStackTrace();
			}
			
			payloadList.add(payload);
		}
		
		return payloadList;		
	}
	
	
	/**
	 * Gets the sensor payload list.
	 *
	 * @param sensorId the sensor id
	 * @return the sensor payload list
	 */
	public List getSensorPayloadList(String sensorId){
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(out('SensorHasPayload')[isDeleted = false]) from Sensor where idValue='"+sensorId+"'"));
		
		List	payloadList = new ArrayList();

		
		for (ODocument result:resultList) {
			
			String id = result.field("idValue");
			String message = result.field("message");
			String dateTime = result.field("dateTime");
			
			Payload payload = new Payload(message);
			payload.setId(id);
			payload.setMessage(message);
			payload.setSensorId(sensorId);
			
			String deviceId = getParentDeviceIdFromSensor(sensorId);
			String userId = getParentUserIdFromDevice(deviceId);
			
			payload.setDeviceId(deviceId);
			payload.setUserId(userId);
			
			DateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss", Locale.ENGLISH);
			
			
			try {
				Date date = format.parse(dateTime);
				payload.setDateTime(date);
			} catch (ParseException e) {
				e.printStackTrace();
			}
			
			payloadList.add(payload);
		}
		
		return payloadList;		
	}
	
	
	
	/**
	 * Gets the attached sensor list.
	 *
	 * @param deviceId the device id
	 * @return the attached sensor list
	 */
	public List getAttachedSensorList(String deviceId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(out('DeviceHasSensors')[isDeleted = false]) from Device where idValue='"+deviceId+"'"));
		List	sensorIdList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");			
			sensorIdList.add(id);
		}		
		return sensorIdList;		
	}
	
	
	/**
	 * Gets the parent device id.
	 *
	 * @param sensorId the sensor id
	 * @return the parent device id
	 */
	public String getParentDeviceIdFromSensor(String sensorId){
		
		ODocument result = (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("select expand(in('DeviceHasSensors')[isDeleted=false]) from Sensor where idValue='"+sensorId+"'")).get(0);
		String data = result.field("idValue");
		return data;		
	}
	
	/**
	 * Gets the parent device id from payload.
	 *
	 * @param payloadId the payload id
	 * @return the parent device id from payload
	 */
	public String getParentDeviceIdFromPayload(String payloadId){
		
		ODocument result = (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("select expand(in('DeviceHasPayload')[isDeleted=false]) from Payload where idValue='"+payloadId+"'")).get(0);
		String data = result.field("idValue");
		return data;		
	}
	
	/**
	 * Gets the parent sensor id from payload.
	 *
	 * @param payloadId the payload id
	 * @return the parent sensor id from payload
	 */
	public String getParentSensorIdFromPayload(String payloadId){
		
		ODocument result = (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("select expand(in('SensorHasPayload')[isDeleted=false]) from Payload where idValue='"+payloadId+"'")).get(0);
		String data = result.field("idValue");
		return data;		
	}
	
	
	
	/**
	 * Gets the parent user id.
	 *
	 * @param deviceId the device id
	 * @return the parent user id
	 */
	public String getParentUserIdFromDevice(String deviceId){
		
		ODocument result = (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("select expand(in('UserHasDevices')[isDeleted=false]) from Device where idValue='"+deviceId+"'")).get(0);
		String data = result.field("idValue");
		return data;		
	}
	
	/**
	 * Gets the parent user id from sensor.
	 *
	 * @param sensorId the sensor id
	 * @return the parent user id from sensor
	 */
	public String getParentUserIdFromSensor(String sensorId){
		
		ODocument result = (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("select expand(in('DeviceHasSensors')[isDeleted=false].in('UserHasDevices')[isDeleted=false]) from Sensor where idValue='"+sensorId+"'")).get(0);
		String data = result.field("idValue");
		return data;		
	}
	
	
	/**
	 * Gets the parent user id from payload.
	 *
	 * @param payloadId the payload id
	 * @return the parent user id from payload
	 */
	public String getParentUserIdFromPayload(String payloadId){
		
		ODocument result;
		
		try {
			result = (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("select expand(in('SensorHasPayload')[isDeleted=false].in('DeviceHasSensors')[isDeleted=false].in('UserHasDevices')[isDeleted=false]) from Payload where idValue='"+payloadId+"'")).get(0);
		} catch (Exception e) {				
			try {
				result = (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("select expand(in('DeviceHasPayload')[isDeleted=false].in('UserHasDevices')[isDeleted=false]) from Payload where idValue='"+payloadId+"'")).get(0);
			} catch (Exception c) {			
				return null;
			}
		}		
			String data= result.field("idValue");
			return data;
	}


	/**
	 * Gets the subscribed device payloads.
	 *
	 * @param userId the user id
	 * @return the subscribed device payloads
	 */
	public List getSubscribedDevicePayloads(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(outE('UserSubscribesDevice')[isAccepted=true].inV().out('DeviceHasPayload')[isDeleted=false]) from User where idValue='"+userId+"'"));
		List	payloadList = new ArrayList();

		
		for (ODocument result:resultList) {
			
			String id = result.field("idValue");
			String message = result.field("message");
			String dateTime = result.field("dateTime");
			
			Payload payload = new Payload(message);
			payload.setId(id);
			payload.setMessage(message);
			
			String deviceId = getParentDeviceIdFromPayload(id);
			String ownerId = getParentUserIdFromDevice(deviceId);
			
			payload.setDeviceId(deviceId);
			payload.setUserId(ownerId);
			
			DateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss", Locale.ENGLISH);
			
			
			try {
				Date date = format.parse(dateTime);
				payload.setDateTime(date);
			} catch (ParseException e) {
				e.printStackTrace();
			}
			
			payloadList.add(payload);	
				
		}
		return payloadList;			
	}
	
	
	/**
	 * Gets the subscribed sensor payloads.
	 *
	 * @param userId the user id
	 * @return the subscribed sensor payloads
	 */
	public List getSubscribedSensorPayloads(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(outE('UserSubscribesSensor')[isAccepted=true].inV().out('SensorHasPayload')[isDeleted=false]) from User where idValue='"+userId+"'"));
		List	payloadList = new ArrayList();

		
		for (ODocument result:resultList) {
			
			String id = result.field("idValue");
			String message = result.field("message");
			String dateTime = result.field("dateTime");
			String sensorId = getParentSensorIdFromPayload(id);
			
			Payload payload = new Payload(message);
			payload.setId(id);
			payload.setMessage(message);
			payload.setSensorId(sensorId);
			
			String deviceId = getParentDeviceIdFromSensor(sensorId);
			String ownerId = getParentUserIdFromDevice(deviceId);
			
			payload.setDeviceId(deviceId);
			payload.setUserId(ownerId);
			
			DateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss", Locale.ENGLISH);
			
			
			try {
				Date date = format.parse(dateTime);
				payload.setDateTime(date);
			} catch (ParseException e) {
				e.printStackTrace();
			}
			
			payloadList.add(payload);	
				
		}
		return payloadList;			
	}
	
	
	/**
	 * Gets the subscribed sensor payload id list.
	 *
	 * @param userId the user id
	 * @return the subscribed sensor payload id list
	 */
	public List getSubscribedSensorPayloadIdList(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(outE('UserSubscribesSensor')[isAccepted=true].inV().out('SensorHasPayload')[isDeleted=false]) from User where idValue='"+userId+"'"));
		List	payloadIdList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");			
			payloadIdList.add(id);					
		}
		return payloadIdList;			
	}
	
	
	/**
	 * Gets the subscribed device payload id list.
	 *
	 * @param userId the user id
	 * @return the subscribed device payload id list
	 */
	public List getSubscribedDevicePayloadIdList(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(outE('UserSubscribesDevice')[isAccepted=true].inV().out('DeviceHasPayload')[isDeleted=false]) from User where idValue='"+userId+"'"));
		List	payloadIdList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");			
			payloadIdList.add(id);					
		}
		return payloadIdList;			
	}


	/**
	 * Gets the subscribed sensor id list.
	 *
	 * @param userId the user id
	 * @return the subscribed sensor id list
	 */
	public List getSubscribedSensorIdList(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(outE('UserSubscribesSensor')[isAccepted=true].inV()) from User where idValue='"+userId+"'"));
		List	sensorIdList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");			
			sensorIdList.add(id);
		}		
		return sensorIdList;
	}
	
	
	/**
	 * Gets the subscribed device id list.
	 *
	 * @param userId the user id
	 * @return the subscribed device id list
	 */
	public List getSubscribedDeviceIdList(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(outE('UserSubscribesDevice')[isAccepted=true].inV()) from User where idValue='"+userId+"'"));
		List	deviceIdList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");			
			deviceIdList.add(id);
		}		
		return deviceIdList;
	}
	
	/**
	 * Gets the sensor payload id list.
	 *
	 * @param userId the user id
	 * @return the sensor payload id list
	 */
	public List getSensorPayloadIdListFromUser(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(out('UserHasDevices')[isDeleted = false].out('DeviceHasSensors')[isDeleted = false].out('SensorHasPayload')[isDeleted = false]) from User where idValue='"+userId+"'"));
		List	sensorPayloadIdList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");			
			sensorPayloadIdList.add(id);
		}		
		return sensorPayloadIdList;		
	}
	
	/**
	 * Gets the sensor payload id list from sensor.
	 *
	 * @param sensorId the sensor id
	 * @return the sensor payload id list from sensor
	 */
	public List getSensorPayloadIdListFromSensor(String sensorId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(out('SensorHasPayload')[isDeleted = false]) from Sensor where idValue='"+sensorId+"'"));
		List	sensorPayloadIdList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");			
			sensorPayloadIdList.add(id);
		}		
		return sensorPayloadIdList;		
	}
	
	
	/**
	 * Gets the device payload id list from user.
	 *
	 * @param userId the user id
	 * @return the device payload id list from user
	 */
	public List getDevicePayloadIdListFromUser(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(out('UserHasDevices')[isDeleted=false].out('DeviceHasPayload')[isDeleted = false]) from User where idValue='"+userId+"'"));
		List	devicePayloadIdList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");			
			devicePayloadIdList.add(id);
		}		
		return devicePayloadIdList;		
	}

	/**
	 * Gets the device payload id list.
	 *
	 * @param deviceId the device id
	 * @return the device payload id list
	 */
	public List getDevicePayloadIdListFromDevice(String deviceId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(out('DeviceHasPayload')[isDeleted = false]) from Device where idValue='"+deviceId+"'"));
		List	devicePayloadIdList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");			
			devicePayloadIdList.add(id);
		}		
		return devicePayloadIdList;		
	}
	

	/**
	 * Gets the device subscriber request list.
	 *
	 * @param deviceId the device id
	 * @return the device subscriber request list
	 */
	public List getDeviceSubscriberRequestList(String deviceId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(inE('UserSubscribesDevice')[isAccepted=false].outV()) from Device where idValue='"+deviceId+"'"));
		List	deviceSubscriberRequestList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");	
			deviceSubscriberRequestList.add(id);
		}		
		return deviceSubscriberRequestList;		
	}
	
	
	/**
	 * Gets the sensor subscriber request list.
	 *
	 * @param sensorId the sensor id
	 * @return the sensor subscriber request list
	 */
	public List getSensorSubscriberRequestList(String sensorId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(inE('UserSubscribesSensor')[isAccepted=false].outV()) from Sensor where idValue='"+sensorId+"'"));
		List	sensorSubscriberRequestList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");			
			sensorSubscriberRequestList.add(id);
		}		
		return sensorSubscriberRequestList;		
	}
	
	
	/**
	 * Gets the device subscription list.
	 *
	 * @param deviceId the device id
	 * @return the device subscription list
	 */
	public List getDeviceSubscriptionList(String deviceId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(inE('UserSubscribesDevice')[isAccepted=true].outV()) from Device where idValue='"+deviceId+"'"));
		List	deviceSubscriptionList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");	
			deviceSubscriptionList.add(id);
		}		
		return deviceSubscriptionList;		
	}
	
	
	/**
	 * Gets the sensor subscription list.
	 *
	 * @param sensorId the sensor id
	 * @return the sensor subscription list
	 */
	public List getSensorSubscriptionList(String sensorId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(inE('UserSubscribesSensor')[isAccepted=true].outV()) from Sensor where idValue='"+sensorId+"'"));
		List	sensorSubscriptionList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");			
			sensorSubscriptionList.add(id);
		}		
		return sensorSubscriptionList;		
	}
	
	
	/**
	 * Gets the user subscribed device list.
	 *
	 * @param userId the user id
	 * @return the user subscribed device list
	 */
	public List getUserSubscribedDeviceList(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(outE('UserSubscribesDevice')[isAccepted=true].inV()[isDeleted=false]) from User where idValue='"+userId+"'"));
		List	deviceSubscriptionList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");			
			deviceSubscriptionList.add(id);
		}		
		return deviceSubscriptionList;		
	}
	
	/**
	 * Gets the user subscribed sensor list.
	 *
	 * @param userId the user id
	 * @return the user subscribed sensor list
	 */
	public List getUserSubscribedSensorList(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(outE('UserSubscribesSensor')[isAccepted=true].inV()[isDeleted=false]) from User where idValue='"+userId+"'"));
		List	sensorSubscriptionList = new ArrayList();
		
		for (ODocument result:resultList) {			
			String id = result.field("idValue");			
			sensorSubscriptionList.add(id);
		}		
		return sensorSubscriptionList;		
	}

	
	/**
	 * Gets the friends id list.
	 *
	 * @param userId the user id
	 * @return the friends id list
	 */
	public List getFriendsIdList(String userId){
		
		List	followerIdList = new ArrayList();
		List resultList1 = graph.getRawGraph().query(new OSQLSynchQuery("select expand(inE('UserFollowsUser')[isAccepted=true].outV()) from User where idValue='"+userId+"'"));
		List resultList2 = graph.getRawGraph().query(new OSQLSynchQuery("select expand(outE('UserFollowsUser')[isAccepted=true].inV()) from User where idValue='"+userId+"'"));
		
		for (ODocument result:resultList1) {			
			String id = result.field("idValue");			
			followerIdList.add(id);
		}		
		
		for (ODocument result:resultList2) {			
			String id = result.field("idValue");			
			followerIdList.add(id);
		}			
		return followerIdList;
	}
	
	/**
	 * Gets the friend request list.
	 *
	 * @param userId the user id
	 * @return the friend request list
	 */
	public List getFriendRequestList(String userId){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select expand(inE('UserFollowsUser')[isAccepted=false].outV()) from User where idValue='"+userId+"'"));
		List	friendRequestList = new ArrayList();
		
		for (ODocument result:resultList) {			
			
			FriendRequest friendRequest = new FriendRequest();
			String id 			= result.field("idValue");	
			String firstname 	= result.field("firstname");
			String lastname		= result.field("lastname");
			
			friendRequest.setFirstname(firstname);
			friendRequest.setLastname(lastname);
			friendRequest.setUserId(id);
			
			friendRequestList.add(friendRequest);
		}		
		return friendRequestList;	
	}
	
	
	/**
	 * Gets the sensor key list.
	 *
	 * @return the sensor key list
	 */
	public List getSensorKeyList(){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select privateKey from Sensor where isDeleted=false"));
		List	sensorKeyList = new ArrayList();
		
		for (ODocument result:resultList) {			
			sensorKeyList.add(result.field("privateKey"));			
		}		
		return sensorKeyList;		
	}
	
	/**
	 * Gets the sensor id list.
	 *
	 * @return the sensor id list
	 */
	public List getSensorIdList(){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select idValue from Sensor where isDeleted=false"));
		List	sensorIdList = new ArrayList();
		
		for (ODocument result:resultList) {			
			sensorIdList.add(result.field("idValue"));			
		}		
		return sensorIdList;	
	}

	/**
	 * Gets the device key list.
	 *
	 * @return the device key list
	 */
	public List getDeviceKeyList(){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select privateKey from Device where isDeleted=false"));
		List	deviceKeyList = new ArrayList();
		
		for (ODocument result:resultList) {			
			deviceKeyList.add(result.field("privateKey"));			
		}		
		return deviceKeyList;		
	}
	
	/**
	 * Gets the device id list.
	 *
	 * @return the device id list
	 */
	public List getDeviceIdList(){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select idValue from Device where isDeleted=false"));
		List	deviceIdList = new ArrayList();
		
		for (ODocument result:resultList) {			
			deviceIdList.add(result.field("idValue"));			
		}		
		return deviceIdList;	
	}
	
	/**
	 * Gets the device id from key.
	 *
	 * @param key the key
	 * @return the device id from key
	 */
	public String getDeviceIdFromKey(String key){
		
		ODocument result =  (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("Select idValue from Device where privateKey='"+key+"' AND isDeleted=false")).get(0);
		String idValue = result.field("idValue");		
		
		return idValue;			
	}
	
	/**
	 * Gets the sensor id from key.
	 *
	 * @param key the key
	 * @return the sensor id from key
	 */
	public String getSensorIdFromKey(String key){
		
		ODocument result =  (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("Select idValue from Sensor where privateKey='"+key+"' AND isDeleted=false")).get(0);
		String idValue = result.field("idValue");		
		
		return idValue;			
	}
	
	
	/**
	 * Gets the key from sensor id.
	 *
	 * @param sensorId the sensor id
	 * @return the key from sensor id
	 */
	public String getKeyFromSensorId(String sensorId){
		
		ODocument result =  (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("Select privateKey from Sensor where idValue='"+sensorId+"' AND isDeleted=false")).get(0);
		String key = result.field("privateKey");		
		
		return key;			
	}
	
	
	/**
	 * Gets the key from device id.
	 *
	 * @param deviceId the device id
	 * @return the key from device id
	 */
	public String getKeyFromDeviceId(String deviceId){
		
		ODocument result =  (ODocument) graph.getRawGraph().query(new OSQLSynchQuery("Select privateKey from Device where idValue='"+deviceId+"' AND isDeleted=false")).get(0);
		String key = result.field("privateKey");		
		
		return key;			
	}

	
	/**
	 * Gets the user search list.
	 *
	 * @return the user search list
	 */
	public List getUserSearchList(){
		
		List resultList = graph.getRawGraph().query(new OSQLSynchQuery("select from User where isDeleted = false"));
		List	userList = new ArrayList();
		
		
		for (ODocument result:resultList) {			
			
			String id 			= result.field("idValue");
			String email		= result.field("email");
			String firstname 	= result.field("firstname");
			String lastname		= result.field("lastname");
			
			User user = new User(firstname,lastname, email);
			user.setUid(id);
			user.setEmailHash();
			
			userList.add(user);			
		}	
		
		return userList;		
	}
	
	/**
	 * Sync database.
	 *
	 * @param email the email
	 */
	public void syncDatabase(String email){
		graph.getRawGraph().query(new OSQLSynchQuery("Select email from User where email='"+email+"'")).get(0);
	}
}
    
    
    
    

    




    
    
    © 2015 - 2024 Weber Informatics LLC | Privacy Policy