Common_Wireless_Simulator/sim_save.m at main · JRW-lab/Common_Wireless_Simulator · GitHub

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
function sim_save(save_data,conn,table_name,current_frames,parameters,paramHash)

% Load data from DB and set new frame count
switch save_data.priority
    case "mysql"
        if save_data.save_mysql
            try
                T = mysql_load(conn,table_name,"*");
            catch
                conn = mysql_login(conn.DataSource);
                T = mysql_load(conn,table_name,"*");
            end
        elseif save_data.save_excel
            try
                T = readtable(save_data.excel_path, 'TextType', 'string');
            catch
                T = table;
            end
        end
    case "local"
        if save_data.save_excel
            try
                T = mysql_load(conn,table_name,"*");
            catch
                conn = mysql_login(conn.DataSource);
                T = mysql_load(conn,table_name,"*");
            end
        elseif save_data.save_mysql
            conn = mysql_login(conn.DataSource);
            T = mysql_load(conn,table_name,"*");
        end
end
try
    sim_result = T(string(T.param_hash) == paramHash, :);
catch
    sim_result = [];
end

if ~isempty(sim_result)
    % Find new frame count to simulate
    if sim_result.frames_simulated < current_frames
        new_frames = current_frames - sim_result.frames_simulated;
        run_flag = true;
    else
        run_flag = false;
    end
else
    % Simulate given frame count
    new_frames = current_frames;
    run_flag = true;
end

% Run if needed
if run_flag

    % Simulate needed system
    switch parameters.system_name
        case "TODDM"
            metrics_add = sim_fun_TODDM_v3(new_frames,parameters);
        case "ODDM"
            metrics_add = sim_fun_ODDM_v3(new_frames,parameters);
        case "OTFS"
            metrics_add = sim_fun_OTFS(new_frames,parameters); % Common method in literature
        case "OTFS-DD"
            metrics_add = sim_fun_OTFS_DD_v3(new_frames,parameters); % Dr. Jingxian Wu's design
        case "OFDM"
            metrics_add = sim_fun_OFDM_v2(new_frames,parameters);
        otherwise
            error("Invalid system selected.")
    end

    % Write to database
    switch save_data.priority
        case "mysql"
            if save_data.save_mysql
                try
                    mysql_write(conn,table_name,parameters,new_frames,metrics_add);
                catch
                    conn = mysql_login(conn.DataSource);
                    mysql_write(conn,table_name,parameters,new_frames,metrics_add);
                end
            end
            if save_data.save_excel
                T = mysql_load(conn,table_name,"*");
                excel_path = save_data.excel_path;
                writetable(T, excel_path);
            end
        case "local"
            if save_data.save_excel
                excel_path = save_data.excel_path;
                local_write(excel_path,parameters,new_frames,metrics_add);
            end
            if save_data.save_mysql
                try
                    mysql_write(conn,table_name,parameters,new_frames,metrics_add);
                catch
                    conn = mysql_login(conn.DataSource);
                    mysql_write(conn,table_name,parameters,new_frames,metrics_add);
                end
            end
    end

end