Редакция 35 | Редакция 39 | К новейшей редакции | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
33 | pingvin | 1 | #include "tablefield.h" |
2 | |||
3 | /*TableField::TableField() |
||
4 | { |
||
5 | } |
||
6 | */ |
||
7 | |||
35 | pingvin | 8 | /*********************************************************************************************** |
9 | ** TableField - |
||
10 | ** : |
||
11 | ** *parent = 0 ( "" ) |
||
12 | ** ftype = CHAR(30) ( - 30 ) |
||
13 | ** fdefaultValue = NULL ( "" ) |
||
14 | ***********************************************************************************************/ |
||
33 | pingvin | 15 | |
35 | pingvin | 16 | TableField::TableField(QString fname, QObject *parent, QString ftype, QString fdefaultValue): |
37 | pingvin | 17 | QObject(parent) |
33 | pingvin | 18 | { |
35 | pingvin | 19 | fieldName = fname; |
20 | fieldType = ftype; |
||
21 | defaultValue = fdefaultValue; |
||
22 | notNull = false; // ( NULL) |
||
23 | characterSet = ""; // ( ) |
||
24 | createSqlString(); // Sql-, |
||
33 | pingvin | 25 | } |
26 | |||
27 | |||
28 | |||
35 | pingvin | 29 | /******************************************************************* |
30 | ** name ( ), |
||
33 | pingvin | 31 | ** |
35 | pingvin | 32 | *******************************************************************/ |
33 | pingvin | 33 | |
34 | |||
35 | |||
36 | void TableField::setName(QString name){ |
||
34 | pingvin | 37 | TableField::fieldName = name; |
35 | pingvin | 38 | TableField::createSqlString(); |
33 | pingvin | 39 | } |
34 | pingvin | 40 | |
41 | |||
42 | QString TableField::name(){ |
||
43 | return TableField::fieldName; |
||
44 | } |
||
45 | |||
46 | QString TableField::type(){ |
||
47 | return TableField::fieldType; |
||
48 | } |
||
49 | |||
50 | void TableField::setType(QString ftype){ |
||
51 | TableField::fieldType = ftype; |
||
35 | pingvin | 52 | TableField::createSqlString(); |
34 | pingvin | 53 | } |
54 | |||
35 | pingvin | 55 | /************************************************************************* |
56 | ** isNotNull() true, "NOT NULL" |
||
57 | ** - false |
||
58 | *************************************************************************/ |
||
59 | |||
60 | bool TableField::isNotNull(){ |
||
61 | return TableField::notNull; |
||
62 | } |
||
63 | |||
64 | /******************************************************************* |
||
65 | ** "NOT NULL" |
||
66 | ** |
||
67 | *******************************************************************/ |
||
68 | |||
69 | |||
70 | void TableField::setNotNull(bool fnotNull){ |
||
71 | if ((fnotNull) && (defaultValue == "NULL")) defaultValue = ""; // , , NULL, |
||
72 | TableField::notNull = fnotNull; |
||
73 | TableField::createSqlString(); // Sql- |
||
74 | } |
||
75 | |||
76 | |||
77 | /******************************************************************************************** |
||
78 | ** Sql-, |
||
79 | ** SqlString |
||
80 | ********************************************************************************************/ |
||
81 | |||
82 | void TableField::createSqlString(){ |
||
83 | QString str_tmp = ""; |
||
84 | str_tmp.append(tr("'")); |
||
85 | str_tmp.append(fieldName); |
||
86 | str_tmp.append(tr("' ")); |
||
87 | str_tmp.append(fieldType); |
||
88 | //str_tmp.append(tr(" ")); |
||
89 | if (characterSet !="") { |
||
90 | str_tmp.append(tr(" character set")); |
||
91 | str_tmp.append(characterSet); |
||
92 | } |
||
93 | if (notNull) { str_tmp.append(tr(" NOT NULL")); } |
||
94 | if (defaultValue !="") { |
||
95 | str_tmp.append(tr(" default '")); |
||
96 | str_tmp.append(defaultValue); |
||
97 | str_tmp.append(tr("'"));} |
||
98 | |||
99 | TableField::SqlString = str_tmp; |
||
100 | } |
||
101 | |||
102 | |||
103 | QString TableField::sqlString(){ |
||
104 | return TableField::SqlString; |
||
105 | } |
||
106 | |||
107 | |||
108 | void TableField::setDefaultValue(QString fdefaultValue){ |
||
109 | TableField::defaultValue = fdefaultValue; |
||
110 | TableField::createSqlString(); |
||
111 | } |
||
112 |