Adwizard/Optimization/OptimizationProject.mqh
327 lines
27 KiB
MQL5
Yuriy Bykov
2025-04-11 13:28:40 +03:00
<EFBFBD><EFBFBD>//+------------------------------------------------------------------+
//| OptimizationProject.mqh |
//| Copyright 2025, Yuriy Bykov |
//| https://www.mql5.com/ru/users/antekov |
Yuriy Bykov
2025-04-11 15:16:52 +03:00
Yuriy Bykov
2025-04-11 13:28:40 +03:00
//+------------------------------------------------------------------+
Yuriy Bykov
2025-04-11 15:16:52 +03:00
Yuriy Bykov
2025-04-11 13:28:40 +03:00
#property copyright "Copyright 2025, Yuriy Bykov"
#property link "https://www.mql5.com/ru/articles/17328"
#property version "1.01"
#include "../Database/Database.mqh"
// @5420@8B5;L=>5 >1JO2;5=85 :;0AA0 ?@>5:B0 >?B8<870F88
class COptimizationProject;
#include "OptimizationTask.mqh"
#include "OptimizationJob.mqh"
#include "OptimizationStage.mqh"
// !>740=85 =>2>3> B8?0 - C:070B5;O =0 DC=:F8N 35=5@0F88 AB@>:8
// ?0@0<5B@>2 @01>BK >?B8<870F88 (job), ?@8=8<0NI59 2 :0G5AB25
// 0@3C<5=B0 C:070B5;L =0 >1J5:B ?@>5:B0 >?B8<870F88
typedef string (*TJobsTemplateFunc)(COptimizationProject*);
//+------------------------------------------------------------------+
//| ;0AA 4;O ?@>5:B0 >?B8<870F88 |
//+------------------------------------------------------------------+
class COptimizationProject {
public:
string m_fileName; // <O 107K 40==KE
// !2>9AB20, =0?@O<CN A>E@0=O5<K5 2 1075 40==KE
ulong id_project; // 45=B8D8:0B>@ ?@>5:B0
string name; // 0720=85
string version; // 5@A8O
string description; // ?8A0=85
string status; // !B0BCA
// 0AA82K 2A5E MB0?>2, @01>B 8 7040G ?@>5:B0
COptimizationStage* m_stages[]; // -B0?K ?@>5:B0
COptimizationJob* m_jobs[]; // 01>BK 2A5E MB0?>2 ?@>5:B0
COptimizationTask* m_tasks[]; // 040G8 2A5E @01>B MB0?>2 ?@>5:B0
// !2>9AB20 4;O B5:CI53> A>AB>O=8O ?@>F5AA0 A>740=8O ?@>5:B0
string m_symbol; // "5:CI89 A8<2>;
string m_timeframe; // "5:CI89 B09<D@59<
COptimizationStage* m_stage; // >A;54=89 A>740==K9 MB0? (B5:CI89 MB0?)
COptimizationJob* m_job; // >A;54=OO A>740==0O @01>B0 (B5:CI0O @01>B0)
COptimizationTask* m_task; // >A;54=OO A>740==0O 7040G0 (B5:CI0O 7040G0)
// 5B>4K
COptimizationProject(string p_fileName); // >=AB@C:B>@
~COptimizationProject(); // 5AB@:B>@
// !>740=85 =>2>3> ?@>5:B0 2 1075 40==KE
COptimizationProject* COptimizationProject::Create(string p_name,
string p_version = "", string p_description = "", string p_status = "Done");
void Insert(); // AB02:0 70?8A8 2 107C 40==KE
void Update(); // 1=>2;5=85 70?8A8 2 1075 40==KE
// >102;5=85 =>2>3> MB0?0 2 107C 40==KE
COptimizationProject* AddStage(COptimizationStage* parentStage, string stageName, string stageExpertName,
string stageSymbol, string stageTimeframe, int stageOptimization, int stageModel,
datetime stageFromDate, datetime stageToDate,
int stageForwardMode, datetime stageForwardDate,
int stageDeposit = 10000, string stageCurrency = "USD",
int stageProfitInPips = 0, int stageLeverage = 200,
int stageExecutionMode = 0, int stageOptimizationCriterion = 7,
string stageStatus = "Done");
// >102;5=85 =>2KE @01>B 2 107C 40==KE 4;O 7040==KE A8<2>;>2 8 B09<D@59<>2
COptimizationProject* AddJobs(string p_symbols, string p_timeframes, TJobsTemplateFunc p_templateFunc);
COptimizationProject* AddJobs(string &p_symbols[], string &p_timeframes[], TJobsTemplateFunc p_templateFunc);
// >102;5=85 =>2KE 7040G 2 107C 40==KE 4;O 7040==KE :@8B5@852 >?B8<870F88
COptimizationProject* AddTasks(string p_criterions);
COptimizationProject* AddTasks(string &p_criterions[]);
void Queue(); // >AB0=>2:0 ?@>5:B0 2 >G5@54L =0 2K?>;=5=585
// @5>1@07>20=85 AB@>:>2>3> =0720=8O 2 B09<D@59<
static ENUM_TIMEFRAMES StringToTimeframe(string s);
};
//+------------------------------------------------------------------+
//| >=AB@C:B>@ |
//+------------------------------------------------------------------+
COptimizationProject::COptimizationProject(string p_fileName) :
m_fileName(p_fileName), id_project(0) {
// >4:;NG05<AO : 1075 40==KE
if (DB::Connect(m_fileName)) {
// 0G8=05< B@0=70:F8N
DatabaseTransactionBegin(DB::Id());
}
}
//+------------------------------------------------------------------+
//| 5AB@C:B>@ |
//+------------------------------------------------------------------+
COptimizationProject::~COptimizationProject() {
// A;8 =5 2>7=8:;> >H81>:, B>
if(DB::Res()) {
// >4B25@6405< B@0=70:F8N
DatabaseTransactionCommit(DB::Id());
} else {
// =0G5 >B<5=O5< B@0=70:F8N
DatabaseTransactionRollback(DB::Id());
}
// 0:@K205< A>548=5=85 A 107>9 40==KE
DB::Close();
// #40;O5< A>740==K5 >1J5:BK 7040G, @01>B 8 MB0?>2
FOREACH(m_tasks) {
delete m_tasks[i];
}
FOREACH(m_jobs) {
delete m_jobs[i];
}
FOREACH(m_stages) {
delete m_stages[i];
}
}
//+------------------------------------------------------------------+
//| !>740=85 =>2>3> ?@>5:B0 2 1075 40==KE |
//+------------------------------------------------------------------+
COptimizationProject* COptimizationProject::Create(string p_name,
string p_version = "", string p_description = "", string p_status = "Done") {
// #AB0=02;8205< ?5@540==K5 7=0G5=8O A2>9AB2
name = p_name;
version = p_version;
description = p_description;
status = p_status;
// AB02;O5< 2 107C 40==KE
Insert();
return &this;
}
//+------------------------------------------------------------------+
//| AB02:0 70?8A8 2 107C 40==KE |
//+------------------------------------------------------------------+
void COptimizationProject::Insert() {
string query = StringFormat("INSERT INTO projects "
" VALUES (NULL,'%s','%s','%s',NULL,'%s');",
name, version, description, status);
id_project = DB::Insert(query);
PrintFormat(__FUNCTION__" | %s -> %I64u", query, id_project);
}
//+------------------------------------------------------------------+
//| 1=>2;5=85 70?8A8 2 1075 40==KE |
//+------------------------------------------------------------------+
void COptimizationProject::Update() {
string query = StringFormat("UPDATE projects "
" SET name='%s', version='%s',description='%s',status='%s' "
" WHERE id_project=%I64u;",
name, version, description, status, id_project);
DB::Execute(query);