asd

Alejandro Acuña

2024-09-16 816cb391a192e357426312ab8e591fd49d1d242e

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
package art.servers.rtzserver.controller;
 
import art.library.model.devices.colors.controller.RTZ32.information.RTZ32_Information_Program;
import art.library.model.devices.colors.controller.RTZ32.information.RTZ32_Information_Programs;
import art.library.model.devices.colors.controller.RTZ32.types.RTZ32_Persistent_Configuration;
import art.library.model.devices.colors.controller.RTZ32.types.RTZ32_Persistent_Configurations;
import art.servers.Shared;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
 
 
 
public class Controller_RTZ32_Database
{
    
  
    //<editor-fold desc="Programs">
 
    public static RTZ32_Information_Programs listPrograms(String deviceIdentifier) throws Exception
    {
        String where = "device = '" + deviceIdentifier + "'";
        List<Object> result = Shared.controllerDatabase.historical_getObject_Summary(RTZ32_Information_Program.class.getName(), where);
        RTZ32_Information_Programs programs = new RTZ32_Information_Programs();
        programs.programs = (List<RTZ32_Information_Program>)(List<?>)result;
        return programs;
    }
    
    
    public static RTZ32_Information_Program getProgram(String deviceIdentifier, String programNumber) throws Exception
    {
        String where = "device = '" + deviceIdentifier + "' AND program = " + programNumber;
        List<Object> result = Shared.controllerDatabase.historical_getObject(RTZ32_Information_Program.class.getName(), where);
        if (result.size() == 1) return (RTZ32_Information_Program)result.get(0);
        return null;
    }
    
    public static boolean addProgram(RTZ32_Information_Program program) throws Exception
    {
        Shared.controllerDatabase.historical_updateOrAddObject(program);
        return true;
    }
    
 
    public static boolean deleteProgram(String deviceIdentifier, String programNumber) throws Exception
    {
        String where = "device = '" + deviceIdentifier + "' AND program = " + programNumber;
        Shared.controllerDatabase.historical_deleteObject(RTZ32_Information_Program.class.getName(), where);
        return true;
    }
        
    
    //</editor-fold>
    
    
    
    
    
    //<editor-fold desc="Configurations">
    
    public static RTZ32_Persistent_Configurations listConfigurations(String deviceIdentifier) throws Exception
    {
        String where = "device = '" + deviceIdentifier + "'";
        List<Object> result = Shared.controllerDatabase.historical_getObject_Summary(RTZ32_Persistent_Configuration.class.getName(), where);
        RTZ32_Persistent_Configurations configurations = new RTZ32_Persistent_Configurations();
        configurations.configurations = (List<RTZ32_Persistent_Configuration>)(List<?>)result;
        return configurations;
    }
 
    public static RTZ32_Persistent_Configurations listConfigurations(String deviceIdentifier, long timestamp1, long timestamp2) throws Exception
    {
        SimpleDateFormat formato1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        String where = "device = '" + deviceIdentifier + "' AND datetime >= '" + formato1.format(timestamp1) + "' AND datetime < '" + formato1.format(timestamp2) + "'";
        List<Object> result = Shared.controllerDatabase.historical_getObject_Summary(RTZ32_Persistent_Configuration.class.getName(), where);
        RTZ32_Persistent_Configurations configurations = new RTZ32_Persistent_Configurations();
        configurations.configurations = (List<RTZ32_Persistent_Configuration>)(List<?>)result;
        return configurations;
    }
    
    
    public static RTZ32_Persistent_Configuration getConfiguration(String deviceIdentifier, long timestamp) throws Exception
    {
        SimpleDateFormat formato1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");
        String where = "device = '" + deviceIdentifier + "' AND datetime = '" + formato1.format(timestamp) + "'";
        List<Object> result = Shared.controllerDatabase.historical_getObject(RTZ32_Persistent_Configuration.class.getName(), where);
        if (result.size() == 1) return (RTZ32_Persistent_Configuration)result.get(0);
        return null;
    }
 
    
    public static boolean addConfiguration (RTZ32_Persistent_Configuration configuration) throws Exception
    {
        configuration.datetime = new Date();
        Shared.controllerDatabase.historical_addObject(configuration);
        return true;
    }
    
    
 
    public static boolean deleteConfiguration(String deviceIdentifier, long timestamp) throws Exception
    {
        
        SimpleDateFormat formato1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");
        String where = "device = '" + deviceIdentifier + "' AND datetime = '" + formato1.format(timestamp) + "'";
        Shared.controllerDatabase.historical_deleteObject(RTZ32_Information_Program.class.getName(), where);
        return true;
    }
 
    
    
    //</editor-fold>
    
}