Редакция 39 | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 39 | Редакция 70 | ||
|---|---|---|---|
| 1 | 1 | #include "sqltable.h"
|
|
| 2 | 2 | ||
| 3 | 3 | SqlTable::SqlTable(QString tname, QObject *parent) : |
|
| 4 | 4 | QObject(parent) |
|
| 5 | 5 | {
|
|
| 6 | 6 | ||
| 7 | 7 | tableName = tname; |
|
| 8 | 8 | field_tmp = new TableField("ID", this); // ïðè ñîçäàíèè òàáëèöû äîáàâèì ïîëå "ID" (ñ÷åò÷èê) |
|
| 9 | 9 | field_tmp->setType(tr("INT(10)")); |
|
| 10 | 10 | field_tmp->setAutoIncrement(true); |
|
| 11 | 11 | tableFields.append(field_tmp); // äîáàâëÿåì íîâîå ïîëå (óêàçàòåëü) â ñïèñîê (óêàçàòåëåé) ïîëåé |
|
| 12 | 12 | tablePrimaryKey = field_tmp->name(); // äåëàåì íàøå åäèíñòâåííîå ïîëå ïåðâè÷íûì êëþ÷îì |
|
| 13 | 13 | tablePrimaryKeyIndex = 0; |
|
| 14 | 14 | tableEngine = tr("MyISAM"); |
|
| 15 | 15 | tableCharacterSet = tr("cp1251"); |
|
| - | 16 | SqlTable::createSqlString(); |
|
| 16 | 17 | //delete field_tmp;
|
|
| - | 18 | }
|
|
| - | 19 | ||
| - | 20 | /***************************************************************************************
|
|
| - | 21 | ** ôóíêöèÿ ïðèñâàèâàåò èìÿ òàáëèöå, íîâîå èìÿ ïåðåäàåòñÿ â ïàðàìåòðå ôóíêöèè tname
|
|
| - | 22 | **
|
|
| - | 23 | **
|
|
| - | 24 | ***************************************************************************************/
|
|
| - | 25 | ||
| - | 26 | ||
| - | 27 | void SqlTable::setName(QString tname){ |
|
| - | 28 | SqlTable::tableName = tname; |
|
| - | 29 | SqlTable::createSqlString(); |
|
| - | 30 | }
|
|
| - | 31 | ||
| - | 32 | /***************************************************************************************
|
|
| - | 33 | ** ôóíêöèÿ âîçâðàùàåò èìÿ òàáëèöû
|
|
| - | 34 | **
|
|
| - | 35 | **
|
|
| - | 36 | ***************************************************************************************/
|
|
| - | 37 | ||
| - | 38 | ||
| - | 39 | QString SqlTable::name(){ |
|
| - | 40 | ||
| - | 41 | return SqlTable::tableName; |
|
| - | 42 | }
|
|
| - | 43 | ||
| - | 44 | ||
| - | 45 | /***************************************************************************************
|
|
| - | 46 | ** ôóíêöèÿ âîçâðàùàåò ñïèñîê óêàçàòåëåé íà ïîëÿ òàáëèöû
|
|
| - | 47 | **
|
|
| - | 48 | **
|
|
| - | 49 | ***************************************************************************************/
|
|
| - | 50 | ||
| - | 51 | QList<TableField*> SqlTable::fields(){ |
|
| - | 52 | ||
| - | 53 | return SqlTable::tableFields; |
|
| - | 54 | }
|
|
| - | 55 | ||
| - | 56 | ||
| - | 57 | /***************************************************************************************
|
|
| - | 58 | ** ôóíêöèÿ óñòàíàâëèâàåò ïåðâè÷íûì êëþ÷îì ïîëå,
|
|
| - | 59 | ** èìåíÿ êîòîðîãî ñîâïàäàåò ñ ïåðåäàâàåìûì ïàðàìåòðîì fieldName
|
|
| - | 60 | ** Âîçâðàùàåò true, åñëè îïðåðàöèÿ ïðîøëà óñïåøíî
|
|
| - | 61 | ** Èíà÷å - âîçâðàùàåò false è ïîìåùàåò ïîÿñíåíèå ê ñëó÷èâøåéñÿ îøèáêå â ïåðåìåííóþ lastError
|
|
| - | 62 | **
|
|
| - | 63 | **
|
|
| - | 64 | ***************************************************************************************/
|
|
| - | 65 | ||
| - | 66 | ||
| - | 67 | ||
| - | 68 | bool SqlTable::setPrimaryKey(QString fieldName){ |
|
| - | 69 | ||
| - | 70 | if (tableFields.isEmpty() | |