Revision 3b5d8beb
Von Christian Ehringfeld vor mehr als 8 Jahren hinzugefügt
| src/schema.h | ||
|---|---|---|
|
const QString TYPE_BOOLEAN = "boolean";
|
||
|
const QString TYPE_MONEY = "money";
|
||
|
|
||
|
// QString primaryKey(int length = 0) const;
|
||
|
// QString bigPrimaryKey(int length = 0) const;
|
||
|
// QString string(int length = 0, bool notNull = false,
|
||
|
// QString defaultValue = "", bool unique = false,
|
||
|
// QString checkConstraint = "") const;
|
||
|
// QString text(bool notNull = false, QString defaultValue = "",
|
||
|
// bool unique = false, QString checkConstraint = "") const;
|
||
|
// QString smallInteger(int length = 0, bool notNull = false,
|
||
|
// QString defaultValue = "", bool unique = false,
|
||
|
// QString checkConstraint = "") const;
|
||
|
// QString integer(int length = 0, bool notNull = false,
|
||
|
// QString defaultValue = "", bool unique = false,
|
||
|
// QString checkConstraint = "") const;
|
||
|
// QString bigInteger(int length = 0, bool notNull = false,
|
||
|
// QString defaultValue = "", bool unique = false,
|
||
|
// QString checkConstraint = "") const;
|
||
|
// QString floatColumn(int precision = 0, bool notNull = false,
|
||
|
// QString defaultValue = "", bool unique = false,
|
||
|
// QString checkConstraint = "") const;
|
||
|
// QString doubleColumn(int precision = 0, bool notNull = false,
|
||
|
// QString defaultValue = "", bool unique = false,
|
||
|
// QString checkConstraint = "") const;
|
||
|
// QString decimal(int precision = 0, int scale = 0, bool notNull = false,
|
||
|
// QString defaultValue = "", bool unique = false,
|
||
|
// QString checkConstraint = "") const;
|
||
|
// QString dateTime(int precision = 0, bool notNull = false,
|
||
|
// QString defaultValue = "", bool unique = false,
|
||
|
// QString checkConstraint = "") const;
|
||
|
// QString timestamp(int precision = 0, bool notNull = false,
|
||
|
// QString defaultValue = "", bool unique = false,
|
||
|
// QString checkConstraint = "") const;
|
||
|
// QString time(int precision = 0, bool notNull = false,
|
||
|
// QString defaultValue = "", bool unique = false,
|
||
|
// QString checkConstraint = "") const;
|
||
|
// QString date( bool notNull = false, QString defaultValue = "") const;
|
||
|
// QString binary(int length = 0, bool notNull = false, bool unique = false,
|
||
|
// QString checkConstraint = "") const;
|
||
|
// QString boolean(bool defaultValue = 0) const;
|
||
|
// QString money(int precision = 0, int scale = 0, bool notNull = false,
|
||
|
// QString defaultValue = "", bool unique = false,
|
||
|
// QString checkConstraint = "") const;
|
||
|
QString primaryKey(int length = 0) const;
|
||
|
QString bigPrimaryKey(int length = 0) const;
|
||
|
QString string(int length = 0, bool notNull = false,
|
||
|
QString defaultValue = "", bool unique = false,
|
||
|
QString checkConstraint = "") const;
|
||
|
QString text(bool notNull = false, QString defaultValue = "",
|
||
|
bool unique = false, QString checkConstraint = "") const;
|
||
|
QString smallInteger(int length = 0, bool notNull = false,
|
||
|
QString defaultValue = "", bool unique = false,
|
||
|
QString checkConstraint = "") const;
|
||
|
QString integer(int length = 0, bool notNull = false,
|
||
|
QString defaultValue = "", bool unique = false,
|
||
|
QString checkConstraint = "") const;
|
||
|
QString bigInteger(int length = 0, bool notNull = false,
|
||
|
QString defaultValue = "", bool unique = false,
|
||
|
QString checkConstraint = "") const;
|
||
|
QString floatColumn(int precision = 0, bool notNull = false,
|
||
|
QString defaultValue = "", bool unique = false,
|
||
|
QString checkConstraint = "") const;
|
||
|
QString doubleColumn(int precision = 0, bool notNull = false,
|
||
|
QString defaultValue = "", bool unique = false,
|
||
|
QString checkConstraint = "") const;
|
||
|
QString decimal(int precision = 0, int scale = 0, bool notNull = false,
|
||
|
QString defaultValue = "", bool unique = false,
|
||
|
QString checkConstraint = "") const;
|
||
|
QString dateTime(int precision = 0, bool notNull = false,
|
||
|
QString defaultValue = "", bool unique = false,
|
||
|
QString checkConstraint = "") const;
|
||
|
QString timestamp(int precision = 0, bool notNull = false,
|
||
|
QString defaultValue = "", bool unique = false,
|
||
|
QString checkConstraint = "") const;
|
||
|
QString time(int precision = 0, bool notNull = false,
|
||
|
QString defaultValue = "", bool unique = false,
|
||
|
QString checkConstraint = "") const;
|
||
|
QString date( bool notNull = false, QString defaultValue = "") const;
|
||
|
QString binary(int length = 0, bool notNull = false, bool unique = false,
|
||
|
QString checkConstraint = "") const;
|
||
|
QString boolean(QString defaultValue = "", bool notNull = false) const;
|
||
|
QString money(int precision = 0, int scale = 0, bool notNull = false,
|
||
|
QString defaultValue = "", bool unique = false,
|
||
|
QString checkConstraint = "") const;
|
||
|
|
||
|
|
||
|
|
||
| ... | ... | |
|
void setAbstractTypeMap(const QSharedPointer<QHash<QString, QString> > &value);
|
||
|
|
||
|
protected:
|
||
|
virtual QString buildColumnSchema(QString type, QString length, bool notNull = false, QString defaultValue = "",
|
||
|
bool unique = false, QString checkConstraint = "") const;
|
||
|
virtual QString buildColumnSchema(QString type, QString length,
|
||
|
bool notNull = false, QString defaultValue = "",
|
||
|
bool unique = false, QString checkConstraint = "") const;
|
||
|
virtual QString buildLengthString(QString length) const;
|
||
|
virtual QString buildNotNullString(bool notNull) const;
|
||
|
virtual QString buildUniqueString(bool unique) const;
|
||
|
virtual QString buildDefaultString(QString def) const;
|
||
|
virtual QString buildCheckString(QString check) const;
|
||
|
|
||
|
virtual QString lengthToString(int length) const;
|
||
|
virtual QString combineScaleAndPrecision(int precision, int scale) const;
|
||
|
|
||
|
|
||
|
virtual QStringList findTableNames(QString schema = "") = 0;
|
||
Auch abrufbar als: Unified diff
building column schema