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
|
/*
* This file is part of the xTuple ERP: PostBooks Edition, a free and
* open source Enterprise Resource Planning software suite,
* Copyright (c) 1999-2010 by OpenMFG LLC, d/b/a xTuple.
* It is licensed to you under the Common Public Attribution License
* version 1.0, the full text of which (including xTuple-specific Exhibits)
* is available at www.xtuple.com/CPAL. By using this software, you agree
* to be bound by its terms.
*/
#include "script.h"
#include <QDomDocument>
#include <QSqlError>
#include "xsqlquery.h"
#define DEBUG false
QString Script::_sqlerrtxt = TR("The following error was encountered "
"while trying to import %1 into the "
"database:<br><pre>%2<br>%3</pre>");
Script::Script(const QString & name, OnError onError, const QString & comment)
: _name(name), _comment(comment), _onError(onError)
{
}
Script::Script(const QDomElement & elem, QStringList &msg, QList<bool> &fatal)
{
_name = elem.attribute("name");
if (elem.hasAttribute("file"))
_name = elem.attribute("file");
_onError = nameToOnError(elem.attribute("onerror"));
_comment = elem.text();
if (_name.isEmpty())
{
msg.append(TR("This script does not have a name."));
fatal.append(true);
}
}
Script::~Script()
{
}
QString Script::filename() const
{
return _name; // _name and _filename are interchangable
}
QDomElement Script::createElement(QDomDocument & doc)
{
QDomElement elem = doc.createElement("script");
elem.setAttribute("name", _name);
elem.setAttribute("file", _name);
elem.setAttribute("onerror", onErrorToName(_onError));
if(!_comment.isEmpty())
elem.appendChild(doc.createTextNode(_comment));
return elem;
}
QString Script::onErrorToName(OnError onError)
{
QString str = "Default";
if(Stop == onError)
str = "Stop";
else if(Prompt == onError)
str = "Prompt";
else if(Ignore == onError)
str = "Ignore";
return str;
}
Script::OnError Script::nameToOnError(const QString & name)
{
if("Stop" == name)
return Stop;
else if("Prompt" == name)
return Prompt;
else if("Ignore" == name)
return Ignore;
return Default;
}
QStringList Script::onErrorList(bool includeDefault)
{
QStringList list;
if(includeDefault)
list << "Default";
list << "Stop";
list << "Prompt";
list << "Ignore";
return list;
}
int Script::writeToDB(const QByteArray &pdata, const QString annotation, QString &errMsg)
{
if (DEBUG)
qDebug("Script::writeToDb(%s, %s, &errMsg) with onError %d",
pdata.data(), qPrintable(annotation), _onError);
if (pdata.isEmpty())
{
errMsg = TR("The file %1 is empty.").arg(filename());
return -1;
}
XSqlQuery create;
create.exec(QString(pdata));
if (create.lastError().type() != QSqlError::NoError)
{
errMsg = _sqlerrtxt.arg(filename())
.arg(create.lastError().databaseText())
.arg(create.lastError().driverText());
return -3;
}
return 0;
}
|
