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
114
115
116
117
118
119
120
121
122
123
|
//////////////////////////////////////////////////////////////////////////
//
// pgScript - PostgreSQL Tools
//
// Copyright (C) 2002 - 2012, The pgAdmin Development Team
// This software is released under the PostgreSQL Licence
//
//////////////////////////////////////////////////////////////////////////
#include "pgAdmin3.h"
#include "pgscript/expressions/pgsGenDate.h"
#include "pgscript/exceptions/pgsParameterException.h"
#include "pgscript/generators/pgsDateGen.h"
#include "pgscript/objects/pgsGenerator.h"
pgsGenDate::pgsGenDate(const pgsExpression *min, const pgsExpression *max,
const pgsExpression *sequence, const pgsExpression *seed) :
pgsExpression(), m_min(min), m_max(max), m_sequence(sequence), m_seed(seed)
{
}
pgsGenDate::~pgsGenDate()
{
pdelete(m_min);
pdelete(m_max);
pdelete(m_sequence);
pdelete(m_seed);
}
pgsExpression *pgsGenDate::clone() const
{
return pnew pgsGenDate(*this);
}
pgsGenDate::pgsGenDate(const pgsGenDate &that) :
pgsExpression(that)
{
m_min = that.m_min->clone();
m_max = that.m_max->clone();
m_sequence = that.m_sequence->clone();
m_seed = that.m_seed->clone();
}
pgsGenDate &pgsGenDate::operator =(const pgsGenDate &that)
{
if (this != &that)
{
pgsExpression::operator=(that);
pdelete(m_min);
pdelete(m_max);
pdelete(m_sequence);
pdelete(m_seed);
m_min = that.m_min->clone();
m_max = that.m_max->clone();
m_sequence = that.m_sequence->clone();
m_seed = that.m_seed->clone();
}
return (*this);
}
wxString pgsGenDate::value() const
{
return wxString() << wxT("date[ min = ") << m_min->value() << wxT(" max = ")
<< m_max->value() << wxT(" sequence = ") << m_sequence->value()
<< wxT(" seed = ") << m_seed->value() << wxT(" ]");
}
pgsOperand pgsGenDate::eval(pgsVarMap &vars) const
{
// Evaluate parameters
pgsOperand min(m_min->eval(vars));
pgsOperand max(m_max->eval(vars));
pgsOperand sequence(m_sequence->eval(vars));
pgsOperand seed(m_seed->eval(vars));
// Check parameters and create the generator
if (min->is_string() && max->is_string() && sequence->is_integer()
&& seed->is_integer())
{
wxDateTime aux_min, aux_max;
if (aux_min.ParseDate(min->value()) != 0 && aux_max.ParseDate(max->value()) != 0
&& aux_min.IsValid() && aux_max.IsValid())
{
long aux_sequence, aux_seed;
sequence->value().ToLong(&aux_sequence);
seed->value().ToLong(&aux_seed);
return pnew pgsGenerator(pgsVariable::pgsTString,
pnew pgsDateGen(aux_min, aux_max, aux_sequence != 0, aux_seed));
}
else
{
throw pgsParameterException(wxString() << value()
<< wxT(":\nmin and/or max dates are not valid"));
}
}
else
{
// Deal with errors
if (!min->is_string())
{
throw pgsParameterException(wxString() << value()
<< wxT(":\nmin should be a string"));
}
else if (!max->is_string())
{
throw pgsParameterException(wxString() << value()
<< wxT(":\nmax should be a string"));
}
else if (!sequence->is_integer())
{
throw pgsParameterException(wxString() << value()
<< wxT(":\nsequence should be an integer"));
}
else
{
throw pgsParameterException(wxString() << value()
<< wxT(":\nseed should be an integer"));
}
}
}
|
