Редакция 45 | Редакция 59 | К новейшей редакции | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 45 | Редакция 56 | ||
|---|---|---|---|
| 1 | #include "mysql.h"
|
1 | #include "mysql.h"
|
| 2 | 2 | ||
| 3 | MySql::MySql(QObject *parent) : |
3 | MySql::MySql(QObject *parent) : |
| 4 | QObject(parent) |
4 | QObject(parent) |
| 5 | {
|
5 | {
|
| 6 | }
|
6 | }
|
| 7 | 7 | ||
| 8 | 8 | ||
| 9 | 9 | ||
| 10 | /************************************************
|
10 | /************************************************
|
| 11 | ** Ôóíêöèÿ ïðèñâîåíèÿ çíà÷åíèÿ èìåíè áàçû äàííûõ
|
11 | ** Ôóíêöèÿ ïðèñâîåíèÿ çíà÷åíèÿ èìåíè áàçû äàííûõ
|
| 12 | **
|
12 | **
|
| 13 | ************************************************/
|
13 | ************************************************/
|
| 14 | 14 | ||
| 15 | 15 | ||
| 16 | 16 | ||
| 17 | void MySql::setDatabaseName(QString name){ |
17 | void MySql::setDatabaseName(QString name){ |
| 18 | MySql::sqlDatabaseName = name; |
18 | MySql::sqlDatabaseName = name; |
| 19 | }
|
19 | }
|
| 20 | 20 | ||
| 21 | 21 | ||
| 22 | bool MySql::connect(){ |
22 | bool MySql::connect(){ |
| 23 | db = QSqlDatabase::addDatabase("QMYSQL"); |
23 | db = QSqlDatabase::addDatabase("QMYSQL"); |
| 24 | 24 | ||
| 25 | db.setHostName(MySql::sqlHostName); |
25 | db.setHostName(MySql::sqlHostName); |
| 26 | db.setDatabaseName(MySql::sqlDatabaseName); |
26 | db.setDatabaseName(MySql::sqlDatabaseName); |
| 27 | db.setUserName(MySql::sqlUserName); |
27 | db.setUserName(MySql::sqlUserName); |
| 28 | db.setPassword(MySql::sqlPassword); |
28 | db.setPassword(MySql::sqlPassword); |
| 29 | bool ok = db.open(); |
29 | bool ok = db.open(); |
| 30 | if (ok) return true; |
30 | if (ok) return true; |
| 31 | else { |
31 | else { |
| 32 | MySql::mysqlLastError = db.lastError().text(); |
32 | MySql::mysqlLastError = db.lastError().text(); |
| 33 | return false; } |
33 | return false; } |
| 34 | 34 | ||
| 35 | /*
|
35 | /*
|
| 36 | pdb->setHostName(hostName);
|
36 | pdb->setHostName(hostName);
|
| 37 | pdb->setDatabaseName(baseName);
|
37 | pdb->setDatabaseName(baseName);
|
| 38 | pdb->setUserName(userName);
|
38 | pdb->setUserName(userName);
|
| 39 | pdb->setPassword(password);
|
39 | pdb->setPassword(password);
|
| 40 | bool ok = pdb->open();
|
40 | bool ok = pdb->open();
|
| 41 | 41 | ||
| 42 | if (!ok) {
|
42 | if (!ok) {
|
| 43 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
43 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
| 44 | QWidget(this->parent()), // Ðîäèòåëüñêèé âèäæåò.
|
44 | QWidget(this->parent()), // Ðîäèòåëüñêèé âèäæåò.
|
| 45 | QObject::tr("Database Error"), // Çàãîëîâîê.
|
45 | QObject::tr("Database Error"), // Çàãîëîâîê.
|
| 46 | db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
46 | db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
| 47 | }
|
47 | }
|
| 48 | */
|
48 | */
|
| 49 | 49 | ||
| 50 | return true; |
50 | return true; |
| 51 | }
|
51 | }
|
| 52 | 52 | ||
| 53 | 53 | ||
| 54 | void MySql::setUserName(QString uname){ |
54 | void MySql::setUserName(QString uname){ |
| 55 | MySql::sqlUserName = uname; |
55 | MySql::sqlUserName = uname; |
| 56 | }
|
56 | }
|
| 57 | 57 | ||
| 58 | void MySql::setPassword(QString passwrd){ |
58 | void MySql::setPassword(QString passwrd){ |
| 59 | MySql::sqlPassword = passwrd; |
59 | MySql::sqlPassword = passwrd; |
| 60 | }
|
60 | }
|
| 61 | 61 | ||
| 62 | 62 | ||
| 63 | void MySql::setHostName(QString hname){ |
63 | void MySql::setHostName(QString hname){ |
| 64 | MySql::sqlHostName = hname; |
64 | MySql::sqlHostName = hname; |
| 65 | }
|
65 | }
|
| 66 | 66 | ||
| 67 | bool MySql::createTable(SqlTable* table){ // ñîçäàåò â áàçå äàííûõ òàáëèöó |
67 | bool MySql::createTable(SqlTable* table){ // ñîçäàåò â áàçå äàííûõ òàáëèöó |
| 68 | QSqlQuery q;
|
68 | QSqlQuery q;
|
| 69 | bool ok; |
69 | bool ok; |
| 70 | ok = q.prepare(table->sqlString()); |
70 | ok = q.prepare(table->sqlString()); |
| 71 | if(!ok) { |
71 | if(!ok) { |
| 72 | MySql::mysqlLastError = q.lastError().text(); |
72 | MySql::mysqlLastError = q.lastError().text(); |
| 73 | return false;} |
73 | return false;} |
| 74 | ok = q.exec(); |
74 | ok = q.exec(); |
| 75 | if(!ok) { |
75 | if(!ok) { |
| 76 | MySql::mysqlLastError = q.lastError().text(); |
76 | MySql::mysqlLastError = q.lastError().text(); |
| 77 | return false;} |
77 | return false;} |
| 78 | else return true; |
78 | else return true; |
| 79 | }
|
79 | }
|
| 80 | 80 | ||
| 81 | 81 | ||
| 82 | 82 | ||
| 83 | QString MySql::lasError(){ |
83 | QString MySql::lasError(){ |
| 84 | 84 | ||
| 85 | return MySql::mysqlLastError; |
85 | return MySql::mysqlLastError; |
| 86 | }
|
86 | }
|
| 87 | 87 | ||
| 88 | 88 | ||
| 89 | 89 | ||
| 90 | /************************************************
|
90 | /************************************************
|
| 91 | ** Ôóíêöèÿ ñîçäàåò íåîáõîäèìûå òàáëèöû â áàçå äàííûõ
|
91 | ** Ôóíêöèÿ ñîçäàåò íåîáõîäèìûå òàáëèöû â áàçå äàííûõ
|
| 92 | ** äëÿ õðàíåíèÿ íàçâàíèÿ è îïèñàíèÿ êëàññîâ
|
92 | ** äëÿ õðàíåíèÿ íàçâàíèÿ è îïèñàíèÿ êëàññîâ
|
| 93 | ** (Òàáëèöà ListOfClasses è Òàáëèöà DescriptionOfClasses)
|
93 | ** (Òàáëèöà ListOfClasses è Òàáëèöà DescriptionOfClasses)
|
| 94 | ************************************************/
|
94 | ************************************************/
|
| 95 | 95 | ||
| 96 | 96 | ||
| 97 | bool MySql::createDataBase(){ |
97 | bool MySql::createDataBase(){ |
| 98 | SqlTable* tbl; |
98 | SqlTable* tbl; |
| 99 | TableField* fld; |
99 | TableField* fld; |
| 100 | if (!db.isOpen()){ |
100 | if (!db.isOpen()){ |
| 101 | MySql::mysqlLastError = tr("Database is not open!"); |
101 | MySql::mysqlLastError = tr("Database is not open!"); |
| 102 | return false; |
102 | return false; |
| 103 | }
|
103 | }
|
| 104 | tbl = new SqlTable(tr("ListOfClasses")); // ñîçäàäèì òàáëèöó ñ èìåíåì ListOfClasses äëÿ õðàíåíèÿ ñïèñêà êëàññîâ |
104 | tbl = new SqlTable(tr("ListOfClasses")); // ñîçäàäèì òàáëèöó ñ èìåíåì ListOfClasses äëÿ õðàíåíèÿ ñïèñêà êëàññîâ |
| 105 | fld = new TableField(tr("ClassName"), tbl); // ýòî âòîðîå ïîëå òàáëèöû áóäåò õðàíèòü èìåíà êëàññîâ, ïåðâîå ïîëå ID óæå èìååòñÿ â íîâîé òàáëèöå (îíî ñîçäàåòñÿ ïî óìîë÷àíèþ) |
105 | fld = new TableField(tr("ClassName"), tbl); // ýòî âòîðîå ïîëå òàáëèöû áóäåò õðàíèòü èìåíà êëàññîâ, ïåðâîå ïîëå ID óæå èìååòñÿ â íîâîé òàáëèöå (îíî ñîçäàåòñÿ ïî óìîë÷àíèþ) |
| 106 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
106 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
| 107 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
107 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
| 108 | fld->setDefaultValue(tr("New class")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
108 | fld->setDefaultValue(tr("New class")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
| 109 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
109 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
| 110 | 110 | ||
| 111 | fld = new TableField(tr("ClassAlias"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
111 | fld = new TableField(tr("ClassAlias"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
| 112 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
112 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
| 113 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
113 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
| 114 | fld->setDefaultValue(tr("New class alias")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
114 | fld->setDefaultValue(tr("New class alias")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
| 115 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
115 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
| 116 | 116 | ||
| 117 | fld = new TableField(tr("TableWhithInstance"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
117 | fld = new TableField(tr("TableWhithInstance"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
| 118 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
118 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
| 119 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
119 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
| 120 | fld->setDefaultValue(tr("New class instance")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
120 | fld->setDefaultValue(tr("New class instance")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
| 121 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
121 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
| 122 | 122 | ||
| 123 | fld = new TableField(tr("Comment"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
123 | fld = new TableField(tr("Comment"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
| 124 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
124 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
| 125 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
125 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
| 126 | fld->setDefaultValue(tr("without comments")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
126 | fld->setDefaultValue(tr("without comments")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
| 127 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
127 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
| 128 | 128 | ||
| 129 | 129 | ||
| 130 | if(!MySql::createTable(tbl)){ // åñëè íå óäàåòñÿ ñîçäàòü òàáëèöó |
130 | if(!MySql::createTable(tbl)){ // åñëè íå óäàåòñÿ ñîçäàòü òàáëèöó |
| 131 | 131 | ||
| 132 | // delete fld;
|
132 | // delete fld;
|
| 133 | delete tbl; // ÷èñòèì çà ñîáîé |
133 | delete tbl; // ÷èñòèì çà ñîáîé |
| 134 | return false; // âûâîäèì îøèáêó |
134 | return false; // âûâîäèì îøèáêó |
| 135 | }
|
135 | }
|
| 136 | 136 | ||
| 137 | 137 | ||
| 138 | else { // òàáëèöó óñïåøíî ñîçäàíà |
138 | else { // òàáëèöó óñïåøíî ñîçäàíà |
| 139 | // delete fld;
|
139 | // delete fld;
|
| 140 | delete tbl; // ÷èñòèì çà ñîáîé |
140 | delete tbl; // ÷èñòèì çà ñîáîé |
| 141 | return true; // ñîîáùàåì îá óñïåõå |
141 | return true; // ñîîáùàåì îá óñïåõå |
| 142 | 142 | ||
| 143 | }
|
143 | }
|
| 144 | 144 | ||
| - | 145 | tbl = new SqlTable(tr("DescriptionOfClasses")); // ñîçäàäèì òàáëèöó ñ èìåíåì DescriptionOfClassess äëÿ õðàíåíèÿ îïèñàíèÿ ïîëåé êëàññîâ |
|
| - | 146 | fld = new TableField(tr("FieldName"), tbl); // ýòî âòîðîå ïîëå òàáëèöû áóäåò õðàíèòü èìåíà ïîëåé, ïåðâîå ïîëå ID óæå èìååòñÿ â íîâîé òàáëèöå (îíî ñîçäàåòñÿ ïî óìîë÷àíèþ) |
|
| - | 147 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
| - | 148 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
| - | 149 | fld->setDefaultValue(tr("New field")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
| - | 150 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
| - | 151 | ||
| - | 152 | fld = new TableField(tr("FieldAlias"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû ïîëåé êëàññîâ |
|
| - | 153 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
| - | 154 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
| - | 155 | fld->setDefaultValue(tr("New class alias")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
| - | 156 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
| - | 157 | ||
| - | 158 | fld = new TableField(tr("FieldType"), tbl); // ýòî ÷åòâåðòîå ïîëå òàáëèöû áóäåò òèï ïîëÿ êëàññà |
|
| - | 159 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
| - | 160 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
| - | 161 | fld->setDefaultValue(tr("CHAR(30)")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
| - | 162 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
| - | 163 | ||
| - | 164 | fld = new TableField(tr("ClassIdentifer"), tbl); // ýòî ïÿòîå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
| - | 165 | fld->setNotNull(false); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
| - | 166 | fld->setType(tr("INT(10)")); // òèï ïîëÿ - öåëîå ÷èñëî |
|
| - | 167 | fld->setDefaultValue(tr("NULL")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
| - | 168 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
| - | 169 | ||
| - | 170 | ||
| - | 171 | ||
| - | 172 | fld = new TableField(tr("Comment"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
| - | 173 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
| - | 174 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
| - | 175 | fld->setDefaultValue(tr("without comments")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
| - | 176 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
| - | 177 | ||
| - | 178 | ||
| - | 179 | if(!MySql::createTable(tbl)){ // åñëè íå óäàåòñÿ ñîçäàòü òàáëèöó |
|
| - | 180 | ||
| - | 181 | // delete fld;
|
|
| - | 182 | delete tbl; // ÷èñòèì çà ñîáîé |
|
| - | 183 | return false; // âûâîäèì îøèáêó |
|
| - | 184 | }
|
|
| - | 185 | ||
| - | 186 | ||
| - | 187 | else { // òàáëèöó óñïåøíî ñîçäàíà |
|
| - | 188 | // delete fld;
|
|
| - | 189 | delete tbl; // ÷èñòèì çà ñîáîé |
|
| - | 190 | return true; // ñîîáùàåì îá óñïåõå |
|
| - | 191 | ||
| - | 192 | }
|
|
| - | 193 | ||
| - | 194 | ||
| - | 195 | ||
| - | 196 | ||
| - | 197 | ||
| - | 198 | }
|
|
| - | 199 | ||
| - | 200 | ||
| - | 201 | ||
| - | 202 | ||
| - | 203 | bool MySql::createListOfClassesTable(){ |
|
| - | 204 | ||
| - | 205 | SqlTable* tbl; |
|
| - | 206 | TableField* fld; |
|
| - | 207 | if (!db.isOpen()){ |
|
| - | 208 | MySql::mysqlLastError = tr("Database is not open!"); |
|
| - | 209 | return false; |
|
| - | 210 | }
|
|
| - | 211 | tbl = new SqlTable(tr("ListOfClasses")); // ñîçäàäèì òàáëèöó ñ èìåíåì ListOfClasses äëÿ õðàíåíèÿ ñïèñêà êëàññîâ |
|
| - | 212 | fld = new TableField(tr("ClassName"), tbl); // ýòî âòîðîå ïîëå òàáëèöû áóäåò õðàíèòü èìåíà êëàññîâ, ïåðâîå ïîëå ID óæå èìååòñÿ â íîâîé òàáëèöå (îíî ñîçäàåòñÿ ïî óìîë÷àíèþ) |
|
| - | 213 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
| - | 214 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
| - | 215 | fld->setDefaultValue(tr("New class")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
| - | 216 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
| - | 217 | ||
| - | 218 | fld = new TableField(tr("ClassAlias"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
| - | 219 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
| - | 220 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
| - | 221 | fld->setDefaultValue(tr("New class alias")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
| - | 222 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
| - | 223 | ||
| - | 224 | fld = new TableField(tr("TableWhithInstance"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
| - | 225 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
| - | 226 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
| - | 227 | fld->setDefaultValue(tr("New class instance")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
| - | 228 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
| - | 229 | ||
| - | 230 | fld = new TableField(tr("Comment"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
| - | 231 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
| - | 232 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
| - | 233 | fld->setDefaultValue(tr("without comments")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
| - | 234 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
| - | 235 | ||
| - | 236 | ||
| - | 237 | if(!MySql::createTable(tbl)){ // åñëè íå óäàåòñÿ ñîçäàòü òàáëèöó |
|
| - | 238 | ||
| - | 239 | // delete fld;
|
|
| - | 240 | delete tbl; // ÷èñòèì çà ñîáîé |
|
| - | 241 | return false; // âûâîäèì îøèáêó |
|
| - | 242 | }
|
|
| - | 243 | ||
| - | 244 | ||
| - | 245 | else { // òàáëèöó óñïåøíî ñîçäàíà |
|
| - | 246 | // delete fld;
|
|
| - | 247 | delete tbl; // ÷èñòèì çà ñîáîé |
|
| - | 248 | return true; // ñîîáùàåì îá óñïåõå |
|
| - | 249 | ||
| - | 250 | }
|
|
| - | 251 | ||
| - | 252 | ||
| - | 253 | ||
| - | 254 | }
|
|
| - | 255 | ||
| - | 256 | ||
| - | 257 | ||
| - | 258 | ||
| - | 259 | bool MySql::createDescriptionOfClassesTable(){ // ñîçäàåò íåîáõîäèìóþ òàáëèöó â áàçå äàííûõ äëÿ õðàíåíèÿ îïèñàíèÿ êëàññîâ (Òàáëèöà DescriptionOfClasses) |
|
| - | 260 | SqlTable* tbl; |
|
| - | 261 | TableField* fld; |
|
| - | 262 | if (!db.isOpen()){ |
|
| - | 263 | MySql::mysqlLastError = tr("Database is not open!"); |
|
| - | 264 | return false; |
|
| - | 265 | }
|
|
| - | 266 | tbl = new SqlTable(tr("DescriptionOfClasses")); // ñîçäàäèì òàáëèöó ñ èìåíåì DescriptionOfClassess äëÿ õðàíåíèÿ îïèñàíèÿ ïîëåé êëàññîâ |
|
| - | 267 | fld = new TableField(tr("FieldName"), tbl); // ýòî âòîðîå ïîëå òàáëèöû áóäåò õðàíèòü èìåíà ïîëåé, ïåðâîå ïîëå ID óæå èìååòñÿ â íîâîé òàáëèöå (îíî ñîçäàåòñÿ ïî óìîë÷àíèþ) |
|
| - | 268 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
| - | 269 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
| - | 270 | fld->setDefaultValue(tr("New field")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
| - | 271 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
| - | 272 | ||
| - | 273 | fld = new TableField(tr("FieldAlias"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû ïîëåé êëàññîâ |
|
| - | 274 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
| - | 275 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
| - | 276 | fld->setDefaultValue(tr("New class alias")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
| - | 277 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
| - | 278 | ||
| - | 279 | fld = new TableField(tr("FieldType"), tbl); // ýòî ÷åòâåðòîå ïîëå òàáëèöû áóäåò òèï ïîëÿ êëàññà |
|
| - | 280 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
| - | 281 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
| - | 282 | fld->setDefaultValue(tr("CHAR(30)")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
| - | 283 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
| - | 284 | ||
| - | 285 | fld = new TableField(tr("ClassIdentifer"), tbl); // ýòî ïÿòîå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
| - | 286 | fld->setNotNull(false); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
| - | 287 | fld->setType(tr("INT(10)")); // òèï ïîëÿ - öåëîå ÷èñëî |
|
| - | 288 | fld->setDefaultValue(tr("NULL")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
| - | 289 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
| - | 290 | ||
| - | 291 | ||
| - | 292 | ||
| - | 293 | fld = new TableField(tr("Comment"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
| - | 294 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
| - | 295 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
| - | 296 | fld->setDefaultValue(tr("without comments")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
| - | 297 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
| - | 298 | ||
| - | 299 | ||
| - | 300 | if(!MySql::createTable(tbl)){ // åñëè íå óäàåòñÿ ñîçäàòü òàáëèöó |
|
| - | 301 | ||
| - | 302 | // delete fld;
|
|
| - | 303 | delete tbl; // ÷èñòèì çà ñîáîé |
|
| - | 304 | return false; // âûâîäèì îøèáêó |
|
| - | 305 | }
|
|
| - | 306 | ||
| - | 307 | ||
| - | 308 | else { // òàáëèöó óñïåøíî ñîçäàíà |
|
| - | 309 | // delete fld;
|
|
| - | 310 | delete tbl; // ÷èñòèì çà ñîáîé |
|
| - | 311 | return true; // ñîîáùàåì îá óñïåõå |
|
| - | 312 | ||
| - | 313 | }
|
|
| - | 314 | ||
| 145 | 315 | ||
| 146 | }
|
316 | }
|
| 147 | 317 | ||