OpenM++ runtime library (libopenm)
dbMetaRow.h
Go to the documentation of this file.
1 
5 // Copyright (c) 2013-2015 OpenM++
6 // This code is licensed under the MIT license (see LICENSE.txt for details)
7 
8 #ifndef OM_DB_META_ROW_H
9 #define OM_DB_META_ROW_H
10 
11 #include <memory>
12 using namespace std;
13 
14 #include "libopenm/omLog.h"
15 #include "dbCommon.h"
16 
17 namespace openm
18 {
20  template<class TRow> struct IMetaRow : public IRowBase
21  {
23  static bool keyLess(const IRowBaseUptr & i_left, const IRowBaseUptr & i_right)
24  {
25  return TRow::isKeyLess(*dynamic_cast<TRow *>(i_left.get()), *dynamic_cast<TRow *>(i_right.get()));
26  }
27 
29  static bool keyEqual(const IRowBaseUptr & i_left, const IRowBaseUptr & i_right)
30  {
31  return TRow::isKeyEqual(*dynamic_cast<TRow *>(i_left.get()), *dynamic_cast<TRow *>(i_right.get()));
32  }
33  };
34 
36  struct LangLstRow : public IMetaRow<LangLstRow>
37  {
39  int langId;
40 
42  string code;
43 
45  string name;
46 
48  LangLstRow(int i_langId) :
49  langId(i_langId),
50  code(""),
51  name("")
52  { }
53 
55  LangLstRow(const string & i_code) :
56  langId(0),
57  code(i_code),
58  name("")
59  { }
60 
62  LangLstRow(void) : LangLstRow(0) { }
63 
64  ~LangLstRow(void) noexcept { }
65 
67  static bool isKeyLess(const LangLstRow & i_left, const LangLstRow & i_right);
68 
70  static bool isKeyEqual(const LangLstRow & i_left, const LangLstRow & i_right);
71 
73  static bool isCodeLess(const LangLstRow & i_left, const LangLstRow & i_right);
74 
76  static bool isCodeEqual(const LangLstRow & i_left, const LangLstRow & i_right);
77  };
78 
80  struct LangWordRow : public IMetaRow<LangWordRow>
81  {
83  int langId;
84 
86  string code;
87 
89  string value;
90 
92  LangWordRow(int i_langId, const string & i_code) :
93  langId(i_langId),
94  code(i_code),
95  value("")
96  { }
97 
99  LangWordRow(void) : LangWordRow(0, "") { }
100 
101  ~LangWordRow(void) noexcept { }
102 
104  static bool isKeyLess(const LangWordRow & i_left, const LangWordRow & i_right);
105 
107  static bool isKeyEqual(const LangWordRow & i_left, const LangWordRow & i_right);
108  };
109 
111  struct ModelDicRow : public IMetaRow<ModelDicRow>
112  {
114  int modelId;
115 
117  string name;
118 
120  string digest;
121 
123  int type;
124 
126  string version;
127 
130 
133 
134 
136  ModelDicRow(int i_modelId) :
137  modelId(i_modelId),
138  name(""),
139  digest(""),
140  type(0),
141  version(""),
142  createDateTime(""),
143  defaultLangId(0)
144  { }
145 
147  ModelDicRow(void) : ModelDicRow(0) { }
148 
149  ~ModelDicRow(void) noexcept { }
150 
152  static bool isKeyLess(const ModelDicRow & i_left, const ModelDicRow & i_right);
153 
155  static bool isKeyEqual(const ModelDicRow & i_left, const ModelDicRow & i_right);
156  };
157 
158 
160  struct ModelDicLangRow : public ModelDicRow
161  {
164  };
165 
167  struct ModelDicTxtRow : public IMetaRow<ModelDicTxtRow>
168  {
170  int modelId;
171 
173  int langId;
174 
176  string descr;
177 
179  string note;
180 
182  ModelDicTxtRow(int i_modelId, int i_langId) :
183  modelId(i_modelId),
184  langId(i_langId),
185  descr(""),
186  note("")
187  { }
188 
190  ModelDicTxtRow(void) : ModelDicTxtRow(0, 0) { }
191 
192  ~ModelDicTxtRow(void) noexcept { }
193 
195  static bool isKeyLess(const ModelDicTxtRow & i_left, const ModelDicTxtRow & i_right);
196 
198  static bool isKeyEqual(const ModelDicTxtRow & i_left, const ModelDicTxtRow & i_right);
199  };
200 
203  {
205  string langCode;
206 
208  static bool uniqueLangKeyLess(const ModelDicTxtLangRow & i_left, const ModelDicTxtLangRow & i_right);
209 
211  static bool uniqueLangKeyEqual(const ModelDicTxtLangRow & i_left, const ModelDicTxtLangRow & i_right);
212  };
213 
215  struct ModelWordRow : public IMetaRow<ModelWordRow>
216  {
218  int modelId;
219 
221  int langId;
222 
224  string code;
225 
227  string value;
228 
230  ModelWordRow(int i_modelId, int i_langId, const string & i_code) :
231  modelId(i_modelId),
232  langId(i_langId),
233  code(i_code),
234  value("")
235  { }
236 
238  ModelWordRow(void) : ModelWordRow(0, 0, "") { }
239 
240  ~ModelWordRow(void) noexcept { }
241 
243  static bool isKeyLess(const ModelWordRow & i_left, const ModelWordRow & i_right);
244 
246  static bool isKeyEqual(const ModelWordRow & i_left, const ModelWordRow & i_right);
247  };
248 
251  {
253  string langCode;
254 
256  static bool uniqueLangKeyLess(const ModelWordLangRow & i_left, const ModelWordLangRow & i_right);
257 
259  static bool uniqueLangKeyEqual(const ModelWordLangRow & i_left, const ModelWordLangRow & i_right);
260  };
261 
263  struct TypeDicRow : public IMetaRow<TypeDicRow>
264  {
266  int modelId;
267 
269  int typeId;
270 
272  string name;
273 
275  string digest;
276 
278  int dicId;
279 
282 
284  TypeDicRow(int i_modelId, int i_typeId) :
285  modelId(i_modelId),
286  typeId(i_typeId),
287  name(""),
288  dicId(0),
289  totalEnumId(0)
290  { }
291 
293  TypeDicRow(void) : TypeDicRow(0, 0) { }
294 
295  ~TypeDicRow(void) noexcept { }
296 
298  static bool isKeyLess(const TypeDicRow & i_left, const TypeDicRow & i_right);
299 
301  static bool isKeyEqual(const TypeDicRow & i_left, const TypeDicRow & i_right);
302 
304  static vector<TypeDicRow>::const_iterator byKey(int i_modelId, int i_typeId, const vector<TypeDicRow> & i_rowVec);
305 
307  bool isBool(void) const { return isBoolType(name.c_str()); };
308 
310  bool isString(void) const { return isStringType(name.c_str()); };
311 
313  bool isBigInt(void) const { return isBigIntType(name.c_str()); };
314 
316  bool isInt(void) const { return isIntType(name.c_str(), typeId); };
317 
319  bool isFloat(void) const { return isFloatType(name.c_str()); };
320 
322  bool isTime(void) const { return isTimeType(name.c_str()); };
323 
325  bool isBuiltIn(void) const { return isBuiltInType(typeId); }
326  };
327 
329  struct TypeDicTxtRow : public IMetaRow<TypeDicTxtRow>
330  {
332  int modelId;
333 
335  int typeId;
336 
338  int langId;
339 
341  string descr;
342 
344  string note;
345 
347  TypeDicTxtRow(int i_modelId, int i_typeId, int i_langId) :
348  modelId(i_modelId),
349  typeId(i_typeId),
350  langId(i_langId),
351  descr(""),
352  note("")
353  { }
354 
356  TypeDicTxtRow(void) : TypeDicTxtRow(0, 0, 0) { }
357 
358  ~TypeDicTxtRow(void) noexcept { }
359 
361  static bool isKeyLess(const TypeDicTxtRow & i_left, const TypeDicTxtRow & i_right);
362 
364  static bool isKeyEqual(const TypeDicTxtRow & i_left, const TypeDicTxtRow & i_right);
365  };
366 
369  {
371  string langCode;
372 
374  static bool uniqueLangKeyLess(const TypeDicTxtLangRow & i_left, const TypeDicTxtLangRow & i_right);
375 
377  static bool uniqueLangKeyEqual(const TypeDicTxtLangRow & i_left, const TypeDicTxtLangRow & i_right);
378  };
379 
381  struct TypeEnumLstRow : public IMetaRow<TypeEnumLstRow>
382  {
384  int modelId;
385 
387  int typeId;
388 
390  int enumId;
391 
393  string name;
394 
396  TypeEnumLstRow(int i_modelId, int i_typeId, int i_enumId) :
397  modelId(i_modelId),
398  typeId(i_typeId),
399  enumId(i_enumId),
400  name("")
401  { }
402 
404  TypeEnumLstRow(void) : TypeEnumLstRow(0, 0, 0) { }
405 
406  ~TypeEnumLstRow(void) noexcept { }
407 
409  static bool isKeyLess(const TypeEnumLstRow & i_left, const TypeEnumLstRow & i_right);
410 
412  static bool isKeyEqual(const TypeEnumLstRow & i_left, const TypeEnumLstRow & i_right);
413  };
414 
416  struct TypeEnumTxtRow : public IMetaRow<TypeEnumTxtRow>
417  {
419  int modelId;
420 
422  int typeId;
423 
425  int enumId;
426 
428  int langId;
429 
431  string descr;
432 
434  string note;
435 
437  TypeEnumTxtRow(int i_modelId, int i_typeId, int i_enumId, int i_langId) :
438  modelId(i_modelId),
439  typeId(i_typeId),
440  enumId(i_enumId),
441  langId(i_langId),
442  descr(""),
443  note("")
444  { }
445 
447  TypeEnumTxtRow(void) : TypeEnumTxtRow(0, 0, 0, 0) { }
448 
449  ~TypeEnumTxtRow(void) noexcept { }
450 
452  static bool isKeyLess(const TypeEnumTxtRow & i_left, const TypeEnumTxtRow & i_right);
453 
455  static bool isKeyEqual(const TypeEnumTxtRow & i_left, const TypeEnumTxtRow & i_right);
456  };
457 
460  {
462  string langCode;
463 
465  static bool uniqueLangKeyLess(const TypeEnumTxtLangRow & i_left, const TypeEnumTxtLangRow & i_right);
466 
468  static bool uniqueLangKeyEqual(const TypeEnumTxtLangRow & i_left, const TypeEnumTxtLangRow & i_right);
469  };
470 
472  struct ParamDicRow : public IMetaRow<ParamDicRow>
473  {
475  int modelId;
476 
478  int paramId;
479 
481  string paramName;
482 
484  int paramHid;
485 
487  string digest;
488 
490  int rank;
491 
493  int typeId;
494 
497 
499  bool isHidden;
500 
503 
505  string dbRunTable;
506 
508  string dbSetTable;
509 
511  string importDigest;
512 
514  ParamDicRow(int i_modelId, int i_paramId) :
515  modelId(i_modelId),
516  paramId(i_paramId),
517  paramName(""),
518  paramHid(0),
519  digest(""),
520  rank(0),
521  typeId(0),
522  isExtendable(false),
523  isHidden(false),
524  numCumulated(0),
525  dbRunTable(""),
526  dbSetTable(""),
527  importDigest("")
528  { }
529 
531  ParamDicRow(void) : ParamDicRow(0, 0) { }
532 
533  ~ParamDicRow(void) noexcept { }
534 
536  static bool isKeyLess(const ParamDicRow & i_left, const ParamDicRow & i_right);
537 
539  static bool isKeyEqual(const ParamDicRow & i_left, const ParamDicRow & i_right);
540 
542  static vector<ParamDicRow>::const_iterator byKey(int i_modelId, int i_paramId, const vector<ParamDicRow> & i_rowVec);
543  };
544 
546  struct ParamImportRow : public IMetaRow<ParamImportRow>
547  {
549  int modelId;
550 
552  int paramId;
553 
555  int paramHid;
556 
558  string fromName;
559 
561  string fromModel;
562 
565 
567  ParamImportRow(int i_modelId, int i_paramId) :
568  modelId(i_modelId),
569  paramId(i_paramId),
570  paramHid(0),
571  fromName(""),
572  fromModel(""),
573  isSampleDim(0)
574  { }
575 
577  ParamImportRow(void) : ParamImportRow(0, 0) { }
578 
579  ~ParamImportRow(void) noexcept { }
580 
582  static bool isKeyLess(const ParamImportRow & i_left, const ParamImportRow & i_right);
583 
585  static bool isKeyEqual(const ParamImportRow & i_left, const ParamImportRow & i_right);
586  };
587 
589  struct ParamDicTxtRow : public IMetaRow<ParamDicTxtRow>
590  {
592  int modelId;
593 
595  int paramId;
596 
598  int langId;
599 
601  string descr;
602 
604  string note;
605 
607  ParamDicTxtRow(int i_modelId, int i_paramId, int i_langId) :
608  modelId(i_modelId),
609  paramId(i_paramId),
610  langId(i_langId),
611  descr(""),
612  note("")
613  { }
614 
616  ParamDicTxtRow(void) : ParamDicTxtRow(0, 0, 0) { }
617 
618  ~ParamDicTxtRow(void) noexcept { }
619 
621  static bool isKeyLess(const ParamDicTxtRow & i_left, const ParamDicTxtRow & i_right);
622 
624  static bool isKeyEqual(const ParamDicTxtRow & i_left, const ParamDicTxtRow & i_right);
625  };
626 
629  {
631  string langCode;
632 
634  static bool uniqueLangKeyLess(const ParamDicTxtLangRow & i_left, const ParamDicTxtLangRow & i_right);
635 
637  static bool uniqueLangKeyEqual(const ParamDicTxtLangRow & i_left, const ParamDicTxtLangRow & i_right);
638  };
639 
641  struct ParamDimsRow : public IMetaRow<ParamDimsRow>
642  {
644  int modelId;
645 
647  int paramId;
648 
650  int dimId;
651 
653  string name;
654 
656  int typeId;
657 
659  ParamDimsRow(int i_modelId, int i_paramId, int i_dimId) :
660  modelId(i_modelId),
661  paramId(i_paramId),
662  dimId(i_dimId),
663  name(""),
664  typeId(0)
665  { }
666 
668  ParamDimsRow(void) : ParamDimsRow(0, 0, 0) { }
669 
670  ~ParamDimsRow(void) noexcept { }
671 
673  static bool isKeyLess(const ParamDimsRow & i_left, const ParamDimsRow & i_right);
674 
676  static bool isKeyEqual(const ParamDimsRow & i_left, const ParamDimsRow & i_right);
677 
679  const string columnName(void) const;
680  };
681 
682 
684  struct ParamDimsTxtRow : public IMetaRow<ParamDimsTxtRow>
685  {
687  int modelId;
688 
690  int paramId;
691 
693  int dimId;
694 
696  int langId;
697 
699  string descr;
700 
702  string note;
703 
705  ParamDimsTxtRow(int i_modelId, int i_paramId, int i_dimId, int i_langId) :
706  modelId(i_modelId),
707  paramId(i_paramId),
708  dimId(i_dimId),
709  langId(i_langId),
710  descr(""),
711  note("")
712  { }
713 
715  ParamDimsTxtRow(void) : ParamDimsTxtRow(0, 0, 0, 0) { }
716 
717  ~ParamDimsTxtRow(void) noexcept { }
718 
720  static bool isKeyLess(const ParamDimsTxtRow & i_left, const ParamDimsTxtRow & i_right);
721 
723  static bool isKeyEqual(const ParamDimsTxtRow & i_left, const ParamDimsTxtRow & i_right);
724  };
725 
728  {
730  string langCode;
731 
733  static bool uniqueLangKeyLess(const ParamDimsTxtLangRow & i_left, const ParamDimsTxtLangRow & i_right);
734 
736  static bool uniqueLangKeyEqual(const ParamDimsTxtLangRow & i_left, const ParamDimsTxtLangRow & i_right);
737  };
738 
740  struct TableDicRow : public IMetaRow<TableDicRow>
741  {
743  int modelId;
744 
746  int tableId;
747 
749  string tableName;
750 
752  int tableHid;
753 
755  string digest;
756 
758  bool isUser;
759 
761  int rank;
762 
764  bool isSparse;
765 
767  string dbExprTable;
768 
770  string dbAccTable;
771 
773  string dbAccAll;
774 
776  int exprPos;
777 
779  bool isHidden;
780 
782  string importDigest;
783 
785  TableDicRow(int i_modelId, int i_tableId) :
786  modelId(i_modelId),
787  tableId(i_tableId),
788  tableName(""),
789  tableHid(0),
790  digest(""),
791  isUser(false),
792  rank(1),
793  isSparse(false),
794  dbExprTable(""),
795  dbAccTable(""),
796  dbAccAll(""),
797  exprPos(-1),
798  isHidden(false),
799  importDigest("")
800  { }
801 
803  TableDicRow(void) : TableDicRow(0, 0) { }
804 
805  ~TableDicRow(void) noexcept { }
806 
808  static bool isKeyLess(const TableDicRow & i_left, const TableDicRow & i_right);
809 
811  static bool isKeyEqual(const TableDicRow & i_left, const TableDicRow & i_right);
812 
814  static vector<TableDicRow>::const_iterator byKey(int i_modelId, int i_tableId, const vector<TableDicRow> & i_rowVec);
815  };
816 
818  struct TableDicTxtRow : public IMetaRow<TableDicTxtRow>
819  {
821  int modelId;
822 
824  int tableId;
825 
827  int langId;
828 
830  string descr;
831 
833  string note;
834 
836  string exprDescr;
837 
839  string exprNote;
840 
842  TableDicTxtRow(int i_modelId, int i_tableId, int i_langId) :
843  modelId(i_modelId),
844  tableId(i_tableId),
845  langId(i_langId),
846  descr(""),
847  note(""),
848  exprDescr(""),
849  exprNote("")
850  { }
851 
853  TableDicTxtRow(void) : TableDicTxtRow(0, 0, 0) { }
854 
855  ~TableDicTxtRow(void) noexcept { }
856 
858  static bool isKeyLess(const TableDicTxtRow & i_left, const TableDicTxtRow & i_right);
859 
861  static bool isKeyEqual(const TableDicTxtRow & i_left, const TableDicTxtRow & i_right);
862  };
863 
866  {
868  string langCode;
869 
871  static bool uniqueLangKeyLess(const TableDicTxtLangRow & i_left, const TableDicTxtLangRow & i_right);
872 
874  static bool uniqueLangKeyEqual(const TableDicTxtLangRow & i_left, const TableDicTxtLangRow & i_right);
875  };
876 
878  struct TableDimsRow : public IMetaRow<TableDimsRow>
879  {
881  int modelId;
882 
884  int tableId;
885 
887  int dimId;
888 
890  string name;
891 
893  int typeId;
894 
896  bool isTotal;
897 
899  int dimSize;
900 
902  TableDimsRow(int i_modelId, int i_tableId, int i_dimId) :
903  modelId(i_modelId),
904  tableId(i_tableId),
905  dimId(i_dimId),
906  name(""),
907  typeId(0),
908  isTotal(false),
909  dimSize(1)
910  { }
911 
913  TableDimsRow(void) : TableDimsRow(0, 0, 0) { }
914 
915  ~TableDimsRow(void) noexcept { }
916 
918  static bool isKeyLess(const TableDimsRow & i_left, const TableDimsRow & i_right);
919 
921  static bool isKeyEqual(const TableDimsRow & i_left, const TableDimsRow & i_right);
922 
924  const string columnName(void) const;
925  };
926 
928  struct TableDimsTxtRow : public IMetaRow<TableDimsTxtRow>
929  {
931  int modelId;
932 
934  int tableId;
935 
937  int dimId;
938 
940  int langId;
941 
943  string descr;
944 
946  string note;
947 
949  TableDimsTxtRow(int i_modelId, int i_tableId, int i_dimId, int i_langId) :
950  modelId(i_modelId),
951  tableId(i_tableId),
952  dimId(i_dimId),
953  langId(i_langId),
954  descr(""),
955  note("")
956  { }
957 
959  TableDimsTxtRow(void) : TableDimsTxtRow(0, 0, 0, 0) { }
960 
961  ~TableDimsTxtRow(void) noexcept { }
962 
964  static bool isKeyLess(const TableDimsTxtRow & i_left, const TableDimsTxtRow & i_right);
965 
967  static bool isKeyEqual(const TableDimsTxtRow & i_left, const TableDimsTxtRow & i_right);
968  };
969 
972  {
974  string langCode;
975 
977  static bool uniqueLangKeyLess(const TableDimsTxtLangRow & i_left, const TableDimsTxtLangRow & i_right);
978 
980  static bool uniqueLangKeyEqual(const TableDimsTxtLangRow & i_left, const TableDimsTxtLangRow & i_right);
981  };
982 
984  struct TableAccRow : public IMetaRow<TableAccRow>
985  {
987  int modelId;
988 
990  int tableId;
991 
993  int accId;
994 
996  string name;
997 
999  bool isDerived;
1000 
1002  string accSrc;
1003 
1005  string accSql;
1006 
1008  TableAccRow(int i_modelId, int i_tableId, int i_accid) :
1009  modelId(i_modelId),
1010  tableId(i_tableId),
1011  accId(i_accid),
1012  name(""),
1013  isDerived(false),
1014  accSrc(""),
1015  accSql("")
1016  { }
1017 
1019  TableAccRow(void) : TableAccRow(0, 0, 0) { }
1020 
1021  ~TableAccRow(void) noexcept { }
1022 
1024  static bool isKeyLess(const TableAccRow & i_left, const TableAccRow & i_right);
1025 
1027  static bool isKeyEqual(const TableAccRow & i_left, const TableAccRow & i_right);
1028 
1030  static vector<TableAccRow>::const_iterator byKey(int i_modelId, int i_tableId, int i_accId, const vector<TableAccRow> & i_rowVec);
1031 
1033  const string columnName(void) const;
1034  };
1035 
1037  struct TableAccTxtRow : public IMetaRow<TableAccTxtRow>
1038  {
1040  int modelId;
1041 
1043  int tableId;
1044 
1046  int accId;
1047 
1049  int langId;
1050 
1052  string descr;
1053 
1055  string note;
1056 
1058  TableAccTxtRow(int i_modelId, int i_tableId, int i_accId, int i_langId) :
1059  modelId(i_modelId),
1060  tableId(i_tableId),
1061  accId(i_accId),
1062  langId(i_langId),
1063  descr(""),
1064  note("")
1065  { }
1066 
1068  TableAccTxtRow(void) : TableAccTxtRow(0, 0, 0, 0) { }
1069 
1070  ~TableAccTxtRow(void) noexcept { }
1071 
1073  static bool isKeyLess(const TableAccTxtRow & i_left, const TableAccTxtRow & i_right);
1074 
1076  static bool isKeyEqual(const TableAccTxtRow & i_left, const TableAccTxtRow & i_right);
1077  };
1078 
1081  {
1083  string langCode;
1084 
1086  static bool uniqueLangKeyLess(const TableAccTxtLangRow & i_left, const TableAccTxtLangRow & i_right);
1087 
1089  static bool uniqueLangKeyEqual(const TableAccTxtLangRow & i_left, const TableAccTxtLangRow & i_right);
1090  };
1091 
1093  struct TableExprRow : public IMetaRow<TableExprRow>
1094  {
1096  int modelId;
1097 
1099  int tableId;
1100 
1102  int exprId;
1103 
1105  string name;
1106 
1109 
1111  string srcExpr;
1112 
1114  string sqlExpr;
1115 
1117  TableExprRow(int i_modelId, int i_tableId, int i_exprId) :
1118  modelId(i_modelId),
1119  tableId(i_tableId),
1120  exprId(i_exprId),
1121  name(""),
1122  decimals(-1),
1123  srcExpr(""),
1124  sqlExpr("")
1125  { }
1126 
1128  TableExprRow(void) : TableExprRow(0, 0, 0) { }
1129 
1130  ~TableExprRow(void) noexcept { }
1131 
1133  static bool isKeyLess(const TableExprRow & i_left, const TableExprRow & i_right);
1134 
1136  static bool isKeyEqual(const TableExprRow & i_left, const TableExprRow & i_right);
1137 
1139  const string columnName(void) const;
1140  };
1141 
1143  struct TableExprTxtRow : public IMetaRow<TableExprTxtRow>
1144  {
1146  int modelId;
1147 
1149  int tableId;
1150 
1152  int exprId;
1153 
1155  int langId;
1156 
1158  string descr;
1159 
1161  string note;
1162 
1164  TableExprTxtRow(int i_modelId, int i_tableId, int i_exprId, int i_langId) :
1165  modelId(i_modelId),
1166  tableId(i_tableId),
1167  exprId(i_exprId),
1168  langId(i_langId),
1169  descr(""),
1170  note("")
1171  { }
1172 
1174  TableExprTxtRow(void) : TableExprTxtRow(0, 0, 0, 0) { }
1175 
1176  ~TableExprTxtRow(void) noexcept { }
1177 
1179  static bool isKeyLess(const TableExprTxtRow & i_left, const TableExprTxtRow & i_right);
1180 
1182  static bool isKeyEqual(const TableExprTxtRow & i_left, const TableExprTxtRow & i_right);
1183  };
1184 
1187  {
1189  string langCode;
1190 
1192  static bool uniqueLangKeyLess(const TableExprTxtLangRow & i_left, const TableExprTxtLangRow & i_right);
1193 
1195  static bool uniqueLangKeyEqual(const TableExprTxtLangRow & i_left, const TableExprTxtLangRow & i_right);
1196  };
1197 
1199  struct EntityDicRow : public IMetaRow<EntityDicRow>
1200  {
1202  int modelId;
1203 
1206 
1208  string entityName;
1209 
1212 
1214  string digest;
1215 
1217  EntityDicRow(int i_modelId, int i_entityId) :
1218  modelId(i_modelId),
1219  entityId(i_entityId),
1220  entityName(""),
1221  entityHid(0),
1222  digest("")
1223  { }
1224 
1226  EntityDicRow(void) : EntityDicRow(0, 0) { }
1227 
1228  ~EntityDicRow(void) noexcept { }
1229 
1231  static bool isKeyLess(const EntityDicRow & i_left, const EntityDicRow & i_right);
1232 
1234  static bool isKeyEqual(const EntityDicRow & i_left, const EntityDicRow & i_right);
1235 
1237  static vector<EntityDicRow>::const_iterator byKey(int i_modelId, int i_entityId, const vector<EntityDicRow> & i_rowVec);
1238  };
1239 
1241  struct EntityDicTxtRow : public IMetaRow<EntityDicTxtRow>
1242  {
1244  int modelId;
1245 
1248 
1250  int langId;
1251 
1253  string descr;
1254 
1256  string note;
1257 
1259  EntityDicTxtRow(int i_modelId, int i_entityId, int i_langId) :
1260  modelId(i_modelId),
1261  entityId(i_entityId),
1262  langId(i_langId),
1263  descr(""),
1264  note("")
1265  { }
1266 
1268  EntityDicTxtRow(void) : EntityDicTxtRow(0, 0, 0) { }
1269 
1270  ~EntityDicTxtRow(void) noexcept { }
1271 
1273  static bool isKeyLess(const EntityDicTxtRow & i_left, const EntityDicTxtRow & i_right);
1274 
1276  static bool isKeyEqual(const EntityDicTxtRow & i_left, const EntityDicTxtRow & i_right);
1277  };
1278 
1281  {
1283  string langCode;
1284 
1286  static bool uniqueLangKeyLess(const EntityDicTxtLangRow & i_left, const EntityDicTxtLangRow & i_right);
1287 
1289  static bool uniqueLangKeyEqual(const EntityDicTxtLangRow & i_left, const EntityDicTxtLangRow & i_right);
1290  };
1291 
1293  struct EntityAttrRow : public IMetaRow<EntityAttrRow>
1294  {
1296  int modelId;
1297 
1300 
1302  int attrId;
1303 
1305  string name;
1306 
1308  int typeId;
1309 
1312 
1314  EntityAttrRow(int i_modelId, int i_entityId, int i_attrId) :
1315  modelId(i_modelId),
1316  entityId(i_entityId),
1317  attrId(i_attrId),
1318  name(""),
1319  typeId(0),
1320  isInternal(false)
1321  { }
1322 
1324  EntityAttrRow(void) : EntityAttrRow(0, 0, 0) { }
1325 
1326  ~EntityAttrRow(void) noexcept { }
1327 
1329  static bool isKeyLess(const EntityAttrRow & i_left, const EntityAttrRow & i_right);
1330 
1332  static bool isKeyEqual(const EntityAttrRow & i_left, const EntityAttrRow & i_right);
1333 
1335  const string columnName(void) const;
1336  };
1337 
1339  struct EntityAttrTxtRow : public IMetaRow<EntityAttrTxtRow>
1340  {
1342  int modelId;
1343 
1346 
1348  int attrId;
1349 
1351  int langId;
1352 
1354  string descr;
1355 
1357  string note;
1358 
1360  EntityAttrTxtRow(int i_modelId, int i_entityId, int i_attrId, int i_langId) :
1361  modelId(i_modelId),
1362  entityId(i_entityId),
1363  attrId(i_attrId),
1364  langId(i_langId),
1365  descr(""),
1366  note("")
1367  { }
1368 
1370  EntityAttrTxtRow(void) : EntityAttrTxtRow(0, 0, 0, 0) { }
1371 
1372  ~EntityAttrTxtRow(void) noexcept { }
1373 
1375  static bool isKeyLess(const EntityAttrTxtRow & i_left, const EntityAttrTxtRow & i_right);
1376 
1378  static bool isKeyEqual(const EntityAttrTxtRow & i_left, const EntityAttrTxtRow & i_right);
1379  };
1380 
1383  {
1385  string langCode;
1386 
1388  static bool uniqueLangKeyLess(const EntityAttrTxtLangRow & i_left, const EntityAttrTxtLangRow & i_right);
1389 
1391  static bool uniqueLangKeyEqual(const EntityAttrTxtLangRow & i_left, const EntityAttrTxtLangRow & i_right);
1392  };
1393 
1395  struct GroupLstRow : public IMetaRow<GroupLstRow>
1396  {
1398  int modelId;
1399 
1401  int groupId;
1402 
1404  bool isParam;
1405 
1407  string name;
1408 
1410  bool isHidden;
1411 
1413  GroupLstRow(int i_modelId, int i_groupId) :
1414  modelId(i_modelId),
1415  groupId(i_groupId),
1416  isParam(false),
1417  name(""),
1418  isHidden(false)
1419  { }
1420 
1422  GroupLstRow(void) : GroupLstRow(0, 0) { }
1423 
1424  ~GroupLstRow(void) noexcept { }
1425 
1427  static bool isKeyLess(const GroupLstRow & i_left, const GroupLstRow & i_right);
1428 
1430  static bool isKeyEqual(const GroupLstRow & i_left, const GroupLstRow & i_right);
1431  };
1432 
1434  struct GroupTxtRow : public IMetaRow<GroupTxtRow>
1435  {
1437  int modelId;
1438 
1440  int groupId;
1441 
1443  int langId;
1444 
1446  string descr;
1447 
1449  string note;
1450 
1452  GroupTxtRow(int i_modelId, int i_groupId, int i_langId) :
1453  modelId(i_modelId),
1454  groupId(i_groupId),
1455  langId(i_langId),
1456  descr(""),
1457  note("")
1458  { }
1459 
1461  GroupTxtRow(void) : GroupTxtRow(0, 0, 0) { }
1462 
1463  ~GroupTxtRow(void) noexcept { }
1464 
1466  static bool isKeyLess(const GroupTxtRow & i_left, const GroupTxtRow & i_right);
1467 
1469  static bool isKeyEqual(const GroupTxtRow & i_left, const GroupTxtRow & i_right);
1470  };
1471 
1474  {
1476  string langCode;
1477 
1479  static bool uniqueLangKeyLess(const GroupTxtLangRow & i_left, const GroupTxtLangRow & i_right);
1480 
1482  static bool uniqueLangKeyEqual(const GroupTxtLangRow & i_left, const GroupTxtLangRow & i_right);
1483  };
1484 
1486  struct GroupPcRow : public IMetaRow<GroupPcRow>
1487  {
1489  int modelId;
1490 
1492  int groupId;
1493 
1496 
1499 
1501  int leafId;
1502 
1504  GroupPcRow(int i_modelId, int i_groupId, int i_childPos) :
1505  modelId(i_modelId),
1506  groupId(i_groupId),
1507  childPos(i_childPos),
1508  childGroupId(-1),
1509  leafId(-1)
1510  { }
1511 
1513  GroupPcRow(void) : GroupPcRow(0, 0, 0) { }
1514 
1515  ~GroupPcRow(void) noexcept { }
1516 
1518  static bool isKeyLess(const GroupPcRow & i_left, const GroupPcRow & i_right);
1519 
1521  static bool isKeyEqual(const GroupPcRow & i_left, const GroupPcRow & i_right);
1522  };
1523 
1525  struct ProfileLstRow : public IMetaRow<ProfileLstRow>
1526  {
1528  string name;
1529 
1531  ProfileLstRow(const string & i_name) : name(i_name) { }
1532 
1535 
1536  ~ProfileLstRow(void) noexcept { }
1537 
1539  static bool isKeyLess(const ProfileLstRow & i_left, const ProfileLstRow & i_right);
1540 
1542  static bool isKeyEqual(const ProfileLstRow & i_left, const ProfileLstRow & i_right);
1543  };
1544 
1546  struct ProfileOptionRow : public IMetaRow<ProfileOptionRow>
1547  {
1549  string name;
1550 
1552  string key;
1553 
1555  string value;
1556 
1558  ProfileOptionRow(const string & i_name, const string & i_key) :
1559  name(i_name),
1560  key(i_key),
1561  value("")
1562  { }
1563 
1566 
1567  ~ProfileOptionRow(void) noexcept { }
1568 
1570  static bool isKeyLess(const ProfileOptionRow & i_left, const ProfileOptionRow & i_right);
1571 
1573  static bool isKeyEqual(const ProfileOptionRow & i_left, const ProfileOptionRow & i_right);
1574  };
1575 
1577  struct RunLstRow : public IMetaRow<RunLstRow>
1578  {
1580  int runId;
1581 
1583  int modelId;
1584 
1586  string name;
1587 
1590 
1593 
1596 
1599 
1602 
1604  string status;
1605 
1608 
1610  string runStamp;
1611 
1613  RunLstRow(int i_runId) :
1614  runId(i_runId),
1615  modelId(0),
1616  name(""),
1617  subCount(0),
1618  subStarted(0),
1619  subCompleted(0),
1620  subRestart(0),
1621  createDateTime(""),
1622  status(""),
1623  updateDateTime(""),
1624  runStamp("")
1625  { }
1626 
1628  RunLstRow(void) : RunLstRow(0) { }
1629 
1630  ~RunLstRow(void) noexcept { }
1631 
1633  static bool isKeyLess(const RunLstRow & i_left, const RunLstRow & i_right);
1634 
1636  static bool isKeyEqual(const RunLstRow & i_left, const RunLstRow & i_right);
1637 
1639  static vector<RunLstRow>::const_iterator byKey(int i_runId, const vector<RunLstRow> & i_rowVec);
1640  };
1641 
1643  struct RunOptionRow : public IMetaRow<RunOptionRow>
1644  {
1646  int runId;
1647 
1649  string key;
1650 
1652  string value;
1653 
1655  RunOptionRow(int i_runId, const string & i_key) :
1656  runId(i_runId),
1657  key(i_key),
1658  value("")
1659  { }
1660 
1662  RunOptionRow(void) : RunOptionRow(0, "") { }
1663 
1664  ~RunOptionRow(void) noexcept { }
1665 
1667  static bool isKeyLess(const RunOptionRow & i_left, const RunOptionRow & i_right);
1668 
1670  static bool isKeyEqual(const RunOptionRow & i_left, const RunOptionRow & i_right);
1671  };
1673  struct WorksetLstRow : public IMetaRow<WorksetLstRow>
1674  {
1676  int setId;
1677 
1680 
1682  int modelId;
1683 
1685  string name;
1686 
1689 
1692 
1694  WorksetLstRow(int i_setId) :
1695  setId(i_setId),
1696  baseRunId(0),
1697  modelId(0),
1698  name(""),
1699  isReadonly(false),
1700  updateDateTime("")
1701  { }
1702 
1705 
1706  ~WorksetLstRow(void) noexcept { }
1707 
1709  static bool isKeyLess(const WorksetLstRow & i_left, const WorksetLstRow & i_right);
1710 
1712  static bool isKeyEqual(const WorksetLstRow & i_left, const WorksetLstRow & i_right);
1713 
1715  static vector<WorksetLstRow>::const_iterator byKey(int i_setId, const vector<WorksetLstRow> & i_rowVec);
1716  };
1717 
1719  struct WorksetTxtRow : public IMetaRow<WorksetTxtRow>
1720  {
1722  int setId;
1723 
1725  int langId;
1726 
1728  string descr;
1729 
1731  string note;
1732 
1734  WorksetTxtRow(int i_setId, int i_langId) :
1735  setId(i_setId),
1736  langId(i_langId),
1737  descr(""),
1738  note("")
1739  { }
1740 
1742  WorksetTxtRow(void) : WorksetTxtRow(0, 0) { }
1743 
1744  ~WorksetTxtRow(void) noexcept { }
1745 
1747  static bool isKeyLess(const WorksetTxtRow & i_left, const WorksetTxtRow & i_right);
1748 
1750  static bool isKeyEqual(const WorksetTxtRow & i_left, const WorksetTxtRow & i_right);
1751 
1753  static vector<WorksetTxtRow>::const_iterator byKey(int i_setId, int i_langId, const vector<WorksetTxtRow> & i_rowVec);
1754  };
1755 
1758  {
1760  string langCode;
1761 
1763  static bool uniqueLangKeyLess(const WorksetTxtLangRow & i_left, const WorksetTxtLangRow & i_right);
1764 
1766  static bool uniqueLangKeyEqual(const WorksetTxtLangRow & i_left, const WorksetTxtLangRow & i_right);
1767  };
1768 
1770  struct WorksetParamRow : public IMetaRow<WorksetParamRow>
1771  {
1773  int setId;
1774 
1776  int modelId;
1777 
1779  int paramId;
1780 
1783 
1786 
1788  WorksetParamRow(int i_setId, int i_paramId) :
1789  setId(i_setId),
1790  modelId(0),
1791  paramId(i_paramId),
1792  subCount(0),
1793  defaultSubId(0)
1794  { }
1795 
1798 
1799  ~WorksetParamRow(void) noexcept { }
1800 
1802  static bool isKeyLess(const WorksetParamRow & i_left, const WorksetParamRow & i_right);
1803 
1805  static bool isKeyEqual(const WorksetParamRow & i_left, const WorksetParamRow & i_right);
1806 
1808  static vector<WorksetParamRow>::const_iterator byKey(int i_setId, int i_paramId, const vector<WorksetParamRow> & i_rowVec);
1809  };
1810 
1812  struct WorksetParamTxtRow : public IMetaRow<WorksetParamTxtRow>
1813  {
1815  int setId;
1816 
1818  int modelId;
1819 
1821  int paramId;
1822 
1824  int langId;
1825 
1827  string note;
1828 
1830  WorksetParamTxtRow(int i_setId, int i_langId, int i_paramId) :
1831  setId(i_setId),
1832  modelId(0),
1833  paramId(i_paramId),
1834  langId(i_langId),
1835  note("")
1836  { }
1837 
1840 
1841  ~WorksetParamTxtRow(void) noexcept { }
1842 
1844  static bool isKeyLess(const WorksetParamTxtRow & i_left, const WorksetParamTxtRow & i_right);
1845 
1847  static bool isKeyEqual(const WorksetParamTxtRow & i_left, const WorksetParamTxtRow & i_right);
1848 
1850  static vector<WorksetParamTxtRow>::const_iterator byKey(
1851  int i_setId, int i_paramId, int i_langId, const vector<WorksetParamTxtRow> & i_rowVec
1852  );
1853  };
1854 
1857  {
1859  string langCode;
1860 
1862  static bool uniqueLangKeyLess(const WorksetParamTxtLangRow & i_left, const WorksetParamTxtLangRow & i_right);
1863 
1865  static bool uniqueLangKeyEqual(const WorksetParamTxtLangRow & i_left, const WorksetParamTxtLangRow & i_right);
1866  };
1867 
1869  struct TaskLstRow : public IMetaRow<TaskLstRow>
1870  {
1872  int taskId;
1873 
1875  int modelId;
1876 
1878  string name;
1879 
1881  TaskLstRow(int i_taskId) :
1882  taskId(i_taskId),
1883  modelId(0),
1884  name("")
1885  { }
1886 
1888  TaskLstRow(void) : TaskLstRow(0) { }
1889 
1890  ~TaskLstRow(void) noexcept { }
1891 
1893  static bool isKeyLess(const TaskLstRow & i_left, const TaskLstRow & i_right);
1894 
1896  static bool isKeyEqual(const TaskLstRow & i_left, const TaskLstRow & i_right);
1897 
1899  static vector<TaskLstRow>::const_iterator byKey(int i_taskId, const vector<TaskLstRow> & i_rowVec);
1900  };
1901 
1903  struct TaskTxtRow : public IMetaRow<TaskTxtRow>
1904  {
1906  int taskId;
1907 
1909  int langId;
1910 
1912  string descr;
1913 
1915  string note;
1916 
1918  TaskTxtRow(int i_taskId, int i_langId) :
1919  taskId(i_taskId),
1920  langId(i_langId),
1921  descr(""),
1922  note("")
1923  { }
1924 
1926  TaskTxtRow(void) : TaskTxtRow(0, 0) { }
1927 
1928  ~TaskTxtRow(void) noexcept { }
1929 
1931  static bool isKeyLess(const TaskTxtRow & i_left, const TaskTxtRow & i_right);
1932 
1934  static bool isKeyEqual(const TaskTxtRow & i_left, const TaskTxtRow & i_right);
1935 
1937  static vector<TaskTxtRow>::const_iterator byKey(int i_taskId, int i_langId, const vector<TaskTxtRow> & i_rowVec);
1938  };
1939 
1941  struct TaskTxtLangRow : public TaskTxtRow
1942  {
1944  string langCode;
1945 
1947  static bool uniqueLangKeyLess(const TaskTxtLangRow & i_left, const TaskTxtLangRow & i_right);
1948 
1950  static bool uniqueLangKeyEqual(const TaskTxtLangRow & i_left, const TaskTxtLangRow & i_right);
1951  };
1952 
1954  struct TaskSetRow : public IMetaRow<TaskSetRow>
1955  {
1957  int taskId;
1958 
1960  int setId;
1961 
1963  TaskSetRow(int i_taskId, int i_setId) :
1964  taskId(i_taskId),
1965  setId(i_setId)
1966  { }
1967 
1969  TaskSetRow(void) : TaskSetRow(0, 0) { }
1970 
1971  ~TaskSetRow(void) noexcept { }
1972 
1974  static bool isKeyLess(const TaskSetRow & i_left, const TaskSetRow & i_right);
1975 
1977  static bool isKeyEqual(const TaskSetRow & i_left, const TaskSetRow & i_right);
1978 
1980  static vector<TaskSetRow>::const_iterator byKey(int i_taskId, int i_setId, const vector<TaskSetRow> & i_rowVec);
1981  };
1982 
1984  struct TaskRunLstRow : public IMetaRow<TaskRunLstRow>
1985  {
1988 
1990  int taskId;
1991 
1993  string name;
1994 
1997 
2000 
2002  string status;
2003 
2006 
2008  string runStamp;
2009 
2011  TaskRunLstRow(int i_taskRunId) :
2012  taskRunId(i_taskRunId),
2013  taskId(0),
2014  name(""),
2015  subCount(0),
2016  createDateTime(""),
2017  status(""),
2018  updateDateTime(""),
2019  runStamp("")
2020  { }
2021 
2024 
2025  ~TaskRunLstRow(void) noexcept { }
2026 
2028  static bool isKeyLess(const TaskRunLstRow & i_left, const TaskRunLstRow & i_right);
2029 
2031  static bool isKeyEqual(const TaskRunLstRow & i_left, const TaskRunLstRow & i_right);
2032 
2034  static vector<TaskRunLstRow>::const_iterator byKey(int i_taskRunId, const vector<TaskRunLstRow> & i_rowVec);
2035  };
2036 
2038  struct TaskRunSetRow : public IMetaRow<TaskRunSetRow>
2039  {
2042 
2044  int runId;
2045 
2047  int setId;
2048 
2050  int taskId;
2051 
2053  TaskRunSetRow(int i_taskRunId, int i_runId) :
2054  taskRunId(i_taskRunId),
2055  runId(i_runId),
2056  setId(0),
2057  taskId(0)
2058  { }
2059 
2061  TaskRunSetRow(void) : TaskRunSetRow(0, 0) { }
2062 
2063  ~TaskRunSetRow(void) noexcept { }
2064 
2066  static bool isKeyLess(const TaskRunSetRow & i_left, const TaskRunSetRow & i_right);
2067 
2069  static bool isKeyEqual(const TaskRunSetRow & i_left, const TaskRunSetRow & i_right);
2070 
2072  static vector<TaskRunSetRow>::const_iterator byKey(int i_taskRunId, int i_runId, const vector<TaskRunSetRow> & i_rowVec);
2073  };
2074 
2076  struct CodeValueRow : public IMetaRow<CodeValueRow>
2077  {
2079  string code;
2080 
2082  string value;
2083 
2085  CodeValueRow(const string & i_code, const string i_value) :
2086  code(i_code),
2087  value(i_value)
2088  { }
2089 
2091  CodeValueRow(const string & i_code) : CodeValueRow(i_code, "") { }
2092 
2094  CodeValueRow(void) : CodeValueRow("", "") { }
2095 
2096  ~CodeValueRow(void) noexcept { }
2097 
2099  static bool isKeyLess(const CodeValueRow & i_left, const CodeValueRow & i_right);
2100 
2102  static bool isKeyEqual(const CodeValueRow & i_left, const CodeValueRow & i_right);
2103  };
2104 }
2105 
2106 #endif // OM_DB_META_ROW_H
OpenM++ data library: public interface for db common structures.
openM++ namespace
Definition: log.h:32
bool isStringType(const char *i_typeName)
return true if model type is string (varchar)
Definition: helper.cpp:266
bool isBigIntType(const char *i_typeName)
return true if model type is bigint (64 bit)
Definition: helper.cpp:272
std::unique_ptr< IRowBase > IRowBaseUptr
unique pointer to db row
Definition: omHelper.h:238
bool isIntType(const char *i_typeName, int i_typeId)
return true if model type is integer: not float, string, boolean, bigint (if type is not a built-in t...
Definition: helper.cpp:283
bool isFloatType(const char *i_typeName)
return true if model type is float (float, real, double or time)
Definition: helper.cpp:293
bool isBuiltInType(int i_typeId)
return true if model type id is built-in type id, ie: int, double, logical
Definition: helper.cpp:290
bool isTimeType(const char *i_typeName)
return true if model type is Time
Definition: helper.cpp:302
bool isBoolType(const char *i_typeName)
return true if model type is boolean (logical)
Definition: helper.cpp:260
OpenM++: public interface for log and trace support.
generic two string columns: (code, value) table row.
Definition: dbMetaRow.h:2077
CodeValueRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:2094
string value
value VARCHAR(...) NOT NULL
Definition: dbMetaRow.h:2082
CodeValueRow(const string &i_code)
create row with supplied primary key field values.
Definition: dbMetaRow.h:2091
string code
code VARCHAR(...) NOT NULL
Definition: dbMetaRow.h:2079
CodeValueRow(const string &i_code, const string i_value)
create row with supplied field values.
Definition: dbMetaRow.h:2085
entity_attr table row.
Definition: dbMetaRow.h:1294
string name
attr_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1305
int attrId
attr_id INT NOT NULL
Definition: dbMetaRow.h:1302
EntityAttrRow(int i_modelId, int i_entityId, int i_attrId)
create row with supplied key field values.
Definition: dbMetaRow.h:1314
int entityId
entity_id INT NOT NULL
Definition: dbMetaRow.h:1299
bool isInternal
is_internal SMALLINT NOT NULL
Definition: dbMetaRow.h:1311
EntityAttrRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1324
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1296
int typeId
mod_type_id INT NOT NULL
Definition: dbMetaRow.h:1308
entity_attr_txt table row and language code.
Definition: dbMetaRow.h:1383
string langCode
language code
Definition: dbMetaRow.h:1385
entity_attr_txt table row.
Definition: dbMetaRow.h:1340
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:1357
int entityId
entity_id INT NOT NULL
Definition: dbMetaRow.h:1345
int attrId
attr_id INT NOT NULL
Definition: dbMetaRow.h:1348
EntityAttrTxtRow(int i_modelId, int i_entityId, int i_attrId, int i_langId)
create row with supplied key field values.
Definition: dbMetaRow.h:1360
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:1351
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1342
EntityAttrTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1370
string descr
descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1354
entity_dic table row.
Definition: dbMetaRow.h:1200
int entityHid
entity_hid INT NOT NULL, – unique entity id
Definition: dbMetaRow.h:1211
int entityId
model_entity_id INT NOT NULL
Definition: dbMetaRow.h:1205
EntityDicRow(int i_modelId, int i_entityId)
create row with supplied key field values.
Definition: dbMetaRow.h:1217
EntityDicRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1226
string entityName
entity_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1208
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1202
string digest
entity_digest VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:1214
entity_dic_txt table row and language code.
Definition: dbMetaRow.h:1281
string langCode
language code
Definition: dbMetaRow.h:1283
entity_dic_txt table row.
Definition: dbMetaRow.h:1242
string descr
descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1253
EntityDicTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1268
int entityId
entity_id INT NOT NULL
Definition: dbMetaRow.h:1247
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:1250
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1244
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:1256
EntityDicTxtRow(int i_modelId, int i_entityId, int i_langId)
create row with supplied key field values.
Definition: dbMetaRow.h:1259
group_lst table row.
Definition: dbMetaRow.h:1396
GroupLstRow(int i_modelId, int i_groupId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:1413
int groupId
group_id INT NOT NULL
Definition: dbMetaRow.h:1401
bool isParam
is_parameter SMALLINT NOT NULL
Definition: dbMetaRow.h:1404
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1398
bool isHidden
is_hidden SMALLINT NOT NULL
Definition: dbMetaRow.h:1410
GroupLstRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1422
string name
group_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1407
group_pc table row.
Definition: dbMetaRow.h:1487
int groupId
group_id INT NOT NULL
Definition: dbMetaRow.h:1492
GroupPcRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1513
int leafId
leaf_id INT NULL
Definition: dbMetaRow.h:1501
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1489
int childGroupId
child_group_id INT NULL
Definition: dbMetaRow.h:1498
int childPos
child_pos INT NOT NULL
Definition: dbMetaRow.h:1495
GroupPcRow(int i_modelId, int i_groupId, int i_childPos)
create row with supplied primary key field values.
Definition: dbMetaRow.h:1504
group_txt table row and language code.
Definition: dbMetaRow.h:1474
string langCode
language code
Definition: dbMetaRow.h:1476
group_txt table row.
Definition: dbMetaRow.h:1435
string descr
descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1446
GroupTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1461
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:1443
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1437
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:1449
GroupTxtRow(int i_modelId, int i_groupId, int i_langId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:1452
int groupId
group_id INT NOT NULL
Definition: dbMetaRow.h:1440
base class for model metadata db-rows
Definition: dbMetaRow.h:21
static bool keyEqual(const IRowBaseUptr &i_left, const IRowBaseUptr &i_right)
equal comparator by row primary key.
Definition: dbMetaRow.h:29
static bool keyLess(const IRowBaseUptr &i_left, const IRowBaseUptr &i_right)
less comparator by row primary key.
Definition: dbMetaRow.h:23
db-row abstract base
Definition: omHelper.h:233
lang_lst table row.
Definition: dbMetaRow.h:37
LangLstRow(const string &i_code)
create row with supplied unique key: language code.
Definition: dbMetaRow.h:55
LangLstRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:62
string name
lang_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:45
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:39
LangLstRow(int i_langId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:48
string code
lang_code VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:42
lang_word table row.
Definition: dbMetaRow.h:81
string code
word_code VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:86
LangWordRow(int i_langId, const string &i_code)
create row with supplied primary key field values.
Definition: dbMetaRow.h:92
LangWordRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:99
string value
word_value VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:89
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:83
model_dic table row and default model language code.
Definition: dbMetaRow.h:161
string defaultLangCode
default model language code
Definition: dbMetaRow.h:163
model_dic table row.
Definition: dbMetaRow.h:112
string version
model_ver VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:126
string createDateTime
create_dt VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:129
int defaultLangId
default_lang_id INT NOT NULL
Definition: dbMetaRow.h:132
string name
model_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:117
int type
model_type INT NOT NULL
Definition: dbMetaRow.h:123
ModelDicRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:147
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:114
ModelDicRow(int i_modelId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:136
string digest
model_digest VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:120
model_dic_txt table row and language code.
Definition: dbMetaRow.h:203
string langCode
language code
Definition: dbMetaRow.h:205
model_dic_txt table row.
Definition: dbMetaRow.h:168
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:179
string descr
descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:176
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:173
ModelDicTxtRow(int i_modelId, int i_langId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:182
ModelDicTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:190
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:170
model_word table row and language code.
Definition: dbMetaRow.h:251
string langCode
language code
Definition: dbMetaRow.h:253
model_word table row.
Definition: dbMetaRow.h:216
ModelWordRow(int i_modelId, int i_langId, const string &i_code)
create row with supplied primary key field values.
Definition: dbMetaRow.h:230
string code
word_code VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:224
ModelWordRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:238
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:221
string value
word_value VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:227
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:218
parameter_dic join to model_parameter_dic table row.
Definition: dbMetaRow.h:473
bool isHidden
is_hidden SMALLINT NOT NULL
Definition: dbMetaRow.h:499
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:475
ParamDicRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:531
ParamDicRow(int i_modelId, int i_paramId)
create row with supplied unique key field values.
Definition: dbMetaRow.h:514
int typeId
model_type_id INT NOT NULL
Definition: dbMetaRow.h:493
int paramId
model_parameter_id INT NOT NULL
Definition: dbMetaRow.h:478
string digest
parameter_digest VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:487
string dbRunTable
db_run_table VARCHAR(64) NOT NULL
Definition: dbMetaRow.h:505
string importDigest
import_digest VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:511
bool isExtendable
is_extendable SMALLINT NOT NULL
Definition: dbMetaRow.h:496
string dbSetTable
db_set_table VARCHAR(64) NOT NULL
Definition: dbMetaRow.h:508
int paramHid
parameter_hid INT NOT NULL, – unique parameter id
Definition: dbMetaRow.h:484
int rank
parameter_rank INT NOT NULL
Definition: dbMetaRow.h:490
string paramName
parameter_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:481
int numCumulated
num_cumulated INT NOT NULL
Definition: dbMetaRow.h:502
parameter_dic_txt join to model_parameter_dic table row and language code.
Definition: dbMetaRow.h:629
string langCode
language code
Definition: dbMetaRow.h:631
parameter_dic_txt join to model_parameter_dic table row.
Definition: dbMetaRow.h:590
string descr
descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:601
ParamDicTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:616
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:592
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:598
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:604
ParamDicTxtRow(int i_modelId, int i_paramId, int i_langId)
create row with supplied unique key field values.
Definition: dbMetaRow.h:607
int paramId
model_parameter_id INT NOT NULL
Definition: dbMetaRow.h:595
parameter_dims join to model_parameter_dic table row.
Definition: dbMetaRow.h:642
ParamDimsRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:668
int dimId
dim_id INT NOT NULL
Definition: dbMetaRow.h:650
ParamDimsRow(int i_modelId, int i_paramId, int i_dimId)
create row with supplied key field values.
Definition: dbMetaRow.h:659
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:644
int paramId
model_parameter_id INT NOT NULL
Definition: dbMetaRow.h:647
int typeId
model_type_id INT NOT NULL
Definition: dbMetaRow.h:656
string name
dim_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:653
parameter_dims_txt table row and language code.
Definition: dbMetaRow.h:728
string langCode
language code
Definition: dbMetaRow.h:730
parameter_dims_txt join to model_parameter_dic table row.
Definition: dbMetaRow.h:685
int paramId
model_parameter_id INT NOT NULL
Definition: dbMetaRow.h:690
string descr
descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:699
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:696
ParamDimsTxtRow(int i_modelId, int i_paramId, int i_dimId, int i_langId)
create row with supplied key field values.
Definition: dbMetaRow.h:705
ParamDimsTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:715
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:687
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:702
int dimId
dim_id INT NOT NULL
Definition: dbMetaRow.h:693
parameter_dic join to model_parameter_import table row.
Definition: dbMetaRow.h:547
bool isSampleDim
is_sample_dim SMALLINT NOT NULL
Definition: dbMetaRow.h:564
ParamImportRow(int i_modelId, int i_paramId)
create row with supplied unique key field values.
Definition: dbMetaRow.h:567
int paramId
model_parameter_id INT NOT NULL
Definition: dbMetaRow.h:552
ParamImportRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:577
string fromName
from_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:558
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:549
string fromModel
from_model_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:561
int paramHid
parameter_hid INT NOT NULL, – unique parameter id
Definition: dbMetaRow.h:555
profile_lst table row.
Definition: dbMetaRow.h:1526
ProfileLstRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1534
ProfileLstRow(const string &i_name)
create row with supplied primary key field values.
Definition: dbMetaRow.h:1531
string name
profile_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1528
profile_option table row.
Definition: dbMetaRow.h:1547
ProfileOptionRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1565
string value
option_value VARCHAR(2048) NOT NULL
Definition: dbMetaRow.h:1555
string key
option_key VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1552
ProfileOptionRow(const string &i_name, const string &i_key)
create row with supplied primary key field values.
Definition: dbMetaRow.h:1558
string name
profile_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1549
run_lst table row.
Definition: dbMetaRow.h:1578
string updateDateTime
update_dt VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:1607
RunLstRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1628
int subCompleted
sub_completed INT NOT NULL
Definition: dbMetaRow.h:1595
int subRestart
sub_restart INT NOT NULL
Definition: dbMetaRow.h:1598
string status
run status: i=init p=progress s=success e=error(failed)
Definition: dbMetaRow.h:1604
string createDateTime
create_dt VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:1601
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1583
int runId
run_id INT NOT NULL
Definition: dbMetaRow.h:1580
int subStarted
sub_started INT NOT NULL
Definition: dbMetaRow.h:1592
int subCount
sub_count INT NOT NULL
Definition: dbMetaRow.h:1589
string runStamp
run_stamp VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:1610
RunLstRow(int i_runId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:1613
string name
run_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1586
run_option table row.
Definition: dbMetaRow.h:1644
int runId
run_id INT NOT NULL
Definition: dbMetaRow.h:1646
string value
option_value VARCHAR(2048) NOT NULL
Definition: dbMetaRow.h:1652
RunOptionRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1662
string key
option_key VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1649
RunOptionRow(int i_runId, const string &i_key)
create row with supplied primary key field values.
Definition: dbMetaRow.h:1655
table_acc table row.
Definition: dbMetaRow.h:985
int tableId
table_id INT NOT NULL
Definition: dbMetaRow.h:990
string name
acc_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:996
string accSrc
acc_src VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1002
int accId
acc_id INT NOT NULL
Definition: dbMetaRow.h:993
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:987
TableAccRow(int i_modelId, int i_tableId, int i_accid)
create row with supplied key field values.
Definition: dbMetaRow.h:1008
bool isDerived
is_derived SMALLINT NOT NULL
Definition: dbMetaRow.h:999
TableAccRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1019
string accSql
acc_sql VARCHAR(2048) NOT NULL
Definition: dbMetaRow.h:1005
table_acc_txt table row and language code.
Definition: dbMetaRow.h:1081
string langCode
language code
Definition: dbMetaRow.h:1083
table_acc_txt table row.
Definition: dbMetaRow.h:1038
TableAccTxtRow(int i_modelId, int i_tableId, int i_accId, int i_langId)
create row with supplied key field values.
Definition: dbMetaRow.h:1058
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:1055
int accId
acc_id INT NOT NULL
Definition: dbMetaRow.h:1046
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:1049
TableAccTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1068
int tableId
table_id INT NOT NULL
Definition: dbMetaRow.h:1043
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1040
string descr
descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1052
table_dic table row.
Definition: dbMetaRow.h:741
string dbAccAll
db_acc_all_view VARCHAR(64) NOT NULL
Definition: dbMetaRow.h:773
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:743
int tableHid
table_hid INT NOT NULL, – unique table id
Definition: dbMetaRow.h:752
string tableName
table_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:749
string importDigest
import_digest VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:782
string digest
table_digest VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:755
string dbAccTable
db_acc_table VARCHAR(64) NOT NULL
Definition: dbMetaRow.h:770
int rank
table_rank INT NOT NULL
Definition: dbMetaRow.h:761
TableDicRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:803
int tableId
table_id INT NOT NULL
Definition: dbMetaRow.h:746
bool isHidden
is_hidden SMALLINT NOT NULL
Definition: dbMetaRow.h:779
int exprPos
expr_dim_pos INT NOT NULL
Definition: dbMetaRow.h:776
bool isSparse
is_sparse SMALLINT NOT NULL
Definition: dbMetaRow.h:764
string dbExprTable
db_expr_table VARCHAR(64) NOT NULL
Definition: dbMetaRow.h:767
TableDicRow(int i_modelId, int i_tableId)
create row with supplied key field values.
Definition: dbMetaRow.h:785
bool isUser
is_user SMALLINT NOT NULL
Definition: dbMetaRow.h:758
table_dic_txt table row and language code.
Definition: dbMetaRow.h:866
string langCode
language code
Definition: dbMetaRow.h:868
table_dic_txt table row.
Definition: dbMetaRow.h:819
TableDicTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:853
int tableId
table_id INT NOT NULL
Definition: dbMetaRow.h:824
string descr
descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:830
string exprDescr
expr_descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:836
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:821
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:827
string exprNote
expr_note VARCHAR(32000)
Definition: dbMetaRow.h:839
TableDicTxtRow(int i_modelId, int i_tableId, int i_langId)
create row with supplied key field values.
Definition: dbMetaRow.h:842
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:833
table_dims table row.
Definition: dbMetaRow.h:879
TableDimsRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:913
string name
dim_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:890
int dimId
dim_id INT NOT NULL
Definition: dbMetaRow.h:887
TableDimsRow(int i_modelId, int i_tableId, int i_dimId)
create row with supplied key field values.
Definition: dbMetaRow.h:902
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:881
int dimSize
dim_size INT NOT NULL
Definition: dbMetaRow.h:899
int typeId
mod_type_id INT NOT NULL
Definition: dbMetaRow.h:893
int tableId
table_id INT NOT NULL
Definition: dbMetaRow.h:884
bool isTotal
is_total SMALLINT NOT NULL
Definition: dbMetaRow.h:896
table_dims_txt table row and language code.
Definition: dbMetaRow.h:972
string langCode
language code
Definition: dbMetaRow.h:974
table_dims_txt table row.
Definition: dbMetaRow.h:929
int dimId
dim_id INT NOT NULL
Definition: dbMetaRow.h:937
string descr
descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:943
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:946
int tableId
table_id INT NOT NULL
Definition: dbMetaRow.h:934
TableDimsTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:959
TableDimsTxtRow(int i_modelId, int i_tableId, int i_dimId, int i_langId)
create row with supplied key field values.
Definition: dbMetaRow.h:949
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:940
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:931
table_expr table row.
Definition: dbMetaRow.h:1094
string name
expr_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1105
TableExprRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1128
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1096
string sqlExpr
expr_sql VARCHAR(2048) NOT NULL
Definition: dbMetaRow.h:1114
int decimals
expr_decimals INT NOT NULL
Definition: dbMetaRow.h:1108
int exprId
expr_id INT NOT NULL
Definition: dbMetaRow.h:1102
TableExprRow(int i_modelId, int i_tableId, int i_exprId)
create row with supplied key field values.
Definition: dbMetaRow.h:1117
string srcExpr
expr_src VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1111
int tableId
table_id INT NOT NULL
Definition: dbMetaRow.h:1099
table_expr_txt table row and language code.
Definition: dbMetaRow.h:1187
string langCode
language code
Definition: dbMetaRow.h:1189
table_expr_txt table row.
Definition: dbMetaRow.h:1144
TableExprTxtRow(int i_modelId, int i_tableId, int i_exprId, int i_langId)
create row with supplied key field values.
Definition: dbMetaRow.h:1164
int tableId
TableID INT NOT NULL.
Definition: dbMetaRow.h:1149
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:1155
string descr
descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1158
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:1161
TableExprTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1174
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1146
int exprId
expr_id INT NOT NULL
Definition: dbMetaRow.h:1152
task_lst table row.
Definition: dbMetaRow.h:1870
int taskId
task_id INT NOT NULL
Definition: dbMetaRow.h:1872
TaskLstRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1888
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1875
string name
task_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1878
TaskLstRow(int i_taskId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:1881
task_run_lst table row.
Definition: dbMetaRow.h:1985
TaskRunLstRow(int i_taskRunId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:2011
TaskRunLstRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:2023
int subCount
sub_count INT NOT NULL
Definition: dbMetaRow.h:1996
int taskRunId
task_run_id INT NOT NULL
Definition: dbMetaRow.h:1987
string updateDateTime
update_dt VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:2005
string status
task status: i=init p=progress w=wait s=success x=exit e=error(failed)
Definition: dbMetaRow.h:2002
string runStamp
run_stamp VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:2008
string createDateTime
create_dt VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:1999
string name
run_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1993
int taskId
task_id INT NOT NULL
Definition: dbMetaRow.h:1990
task_run_set table row.
Definition: dbMetaRow.h:2039
int taskId
task_id INT NOT NULL
Definition: dbMetaRow.h:2050
int taskRunId
task_run_id INT NOT NULL
Definition: dbMetaRow.h:2041
int setId
set_id INT NOT NULL
Definition: dbMetaRow.h:2047
int runId
run_id INT NOT NULL
Definition: dbMetaRow.h:2044
TaskRunSetRow(int i_taskRunId, int i_runId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:2053
TaskRunSetRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:2061
task_set table row.
Definition: dbMetaRow.h:1955
int taskId
task_id INT NOT NULL
Definition: dbMetaRow.h:1957
int setId
set_id INT NOT NULL
Definition: dbMetaRow.h:1960
TaskSetRow(int i_taskId, int i_setId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:1963
TaskSetRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1969
task_txt table row and language code.
Definition: dbMetaRow.h:1942
string langCode
language code
Definition: dbMetaRow.h:1944
task_txt table row.
Definition: dbMetaRow.h:1904
string descr
descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1912
TaskTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1926
TaskTxtRow(int i_taskId, int i_langId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:1918
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:1909
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:1915
int taskId
task_id INT NOT NULL
Definition: dbMetaRow.h:1906
type_dic join to model_type_dic table row.
Definition: dbMetaRow.h:264
bool isString(void) const
return true if model type is string (varchar)
Definition: dbMetaRow.h:310
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:266
string digest
type_digest VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:275
int totalEnumId
total_enum_id INT NOT NULL, – if total enabled this is enum_value of total item =max+1
Definition: dbMetaRow.h:281
bool isBuiltIn(void) const
return true if model type is built-in, ie: int, double, logical
Definition: dbMetaRow.h:325
bool isBigInt(void) const
return true if model type is bigint (64 bit)
Definition: dbMetaRow.h:313
TypeDicRow(int i_modelId, int i_typeId)
create row with supplied unique key field values.
Definition: dbMetaRow.h:284
string name
type_name VARCHAR(255) NOT NULL, – type name: int, double, etc.
Definition: dbMetaRow.h:272
bool isInt(void) const
return true if model type is integer (not float, string, boolean or bigint)
Definition: dbMetaRow.h:316
bool isBool(void) const
return true if model type is boolean (logical)
Definition: dbMetaRow.h:307
bool isFloat(void) const
return true if model type is float (float, real, double or time)
Definition: dbMetaRow.h:319
int typeId
model_type_id INT NOT NULL
Definition: dbMetaRow.h:269
TypeDicRow(void)
create row with default empty key values.
Definition: dbMetaRow.h:293
int dicId
dic_id INT NOT NULL, – dictionary id: 0=simple 1=logical 2=classification 3=range 4=partition 5=link
Definition: dbMetaRow.h:278
bool isTime(void) const
return true if model type is Time
Definition: dbMetaRow.h:322
type_dic_txt join to model_type_dic table row and language code.
Definition: dbMetaRow.h:369
string langCode
language code
Definition: dbMetaRow.h:371
type_dic_txt join to model_type_dic table row.
Definition: dbMetaRow.h:330
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:344
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:338
int typeId
model_type_id INT NOT NULL
Definition: dbMetaRow.h:335
TypeDicTxtRow(int i_modelId, int i_typeId, int i_langId)
create row with supplied unique key field values.
Definition: dbMetaRow.h:347
TypeDicTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:356
string descr
descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:341
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:332
type_enum_lst join to model_type_dic table row.
Definition: dbMetaRow.h:382
int typeId
model_type_id INT NOT NULL
Definition: dbMetaRow.h:387
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:384
TypeEnumLstRow(int i_modelId, int i_typeId, int i_enumId)
create row with supplied unique key field values.
Definition: dbMetaRow.h:396
TypeEnumLstRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:404
string name
enum_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:393
int enumId
enum_id INT NOT NULL
Definition: dbMetaRow.h:390
type_enum_txt join to model_type_dic table row and language code.
Definition: dbMetaRow.h:460
string langCode
language code
Definition: dbMetaRow.h:462
type_enum_txt join to model_type_dic table row.
Definition: dbMetaRow.h:417
TypeEnumTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:447
int enumId
enum_id INT NOT NULL
Definition: dbMetaRow.h:425
string descr
descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:431
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:434
TypeEnumTxtRow(int i_modelId, int i_typeId, int i_enumId, int i_langId)
create row with supplied unique key field values.
Definition: dbMetaRow.h:437
int typeId
model_type_id INT NOT NULL
Definition: dbMetaRow.h:422
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:428
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:419
workset_lst table row.
Definition: dbMetaRow.h:1674
WorksetLstRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1704
WorksetLstRow(int i_setId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:1694
string updateDateTime
update_dt VARCHAR(32) NOT NULL
Definition: dbMetaRow.h:1691
int baseRunId
base_run_id INT NULL
Definition: dbMetaRow.h:1679
bool isReadonly
is_readonly SMALLINT NOT NULL
Definition: dbMetaRow.h:1688
int setId
set_id INT NOT NULL
Definition: dbMetaRow.h:1676
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1682
string name
set_name VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1685
workset_parameter join to model_parameter_dic table row.
Definition: dbMetaRow.h:1771
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1776
WorksetParamRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1797
int subCount
sub_count INT NOT NULL
Definition: dbMetaRow.h:1782
int defaultSubId
default_sub_id INT NOT NULL
Definition: dbMetaRow.h:1785
int setId
set_id INT NOT NULL
Definition: dbMetaRow.h:1773
int paramId
parameter_id INT NOT NULL
Definition: dbMetaRow.h:1779
WorksetParamRow(int i_setId, int i_paramId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:1788
workset_parameter_txt table row and language code.
Definition: dbMetaRow.h:1857
string langCode
language code
Definition: dbMetaRow.h:1859
workset_parameter_txt join to model_parameter_dic table row.
Definition: dbMetaRow.h:1813
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:1827
int paramId
parameter_id INT NOT NULL
Definition: dbMetaRow.h:1821
WorksetParamTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1839
int setId
set_id INT NOT NULL
Definition: dbMetaRow.h:1815
int modelId
model_id INT NOT NULL
Definition: dbMetaRow.h:1818
WorksetParamTxtRow(int i_setId, int i_langId, int i_paramId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:1830
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:1824
workset_txt table row and language code.
Definition: dbMetaRow.h:1758
string langCode
language code
Definition: dbMetaRow.h:1760
workset_txt table row.
Definition: dbMetaRow.h:1720
int langId
lang_id INT NOT NULL
Definition: dbMetaRow.h:1725
string descr
descr VARCHAR(255) NOT NULL
Definition: dbMetaRow.h:1728
string note
note VARCHAR(32000)
Definition: dbMetaRow.h:1731
int setId
set_id INT NOT NULL
Definition: dbMetaRow.h:1722
WorksetTxtRow(int i_setId, int i_langId)
create row with supplied primary key field values.
Definition: dbMetaRow.h:1734
WorksetTxtRow(void)
create row with default empty field values.
Definition: dbMetaRow.h:1742