Piles

Go to the documentation of this file.

#ifndef GUARD_DBCOLUMN_H_INCLUDE
#define GUARD_DBCOLUMN_H_INCLUDE

#include <dbstruct/dbstruct-config.h>
#include <dbstruct/dbobject.h>

#include <QString>
#include <QVariant>

QT_BEGIN_NAMESPACE
class QSqlTableModel;
class QSqlRecord;
QT_END_NAMESPACE

class DbTaew;

class DBSTRUCT_EXPORT DbColumn : public DbObject {

public:

    enum ForeignBehaviour {
        FB_CHOOSE, 
        FB_CHOOSE_ADD 
    };

    enum DataType {
        DTY_INVALID = -1, 
        DTY_BIGINT,
        DTY_BINARY,
        DTY_BIT,
        DTY_TRISTATE,
        DTY_CHAR,
        DTY_DATE,
        DTY_DATETIME,
        DTY_DATETIME2,
        DTY_DATETIMEOFFSET,
        DTY_DECIMAL,
        DTY_DECIMALSCALE,
        DTY_FLOAT,
        DTY_HIERARCHYID,
        DTY_IMAGE,
        DTY_INTEGER,
        DTY_MONEY,
        DTY_NCHAR,
        DTY_NTEXT,
        DTY_NUMERIC,
        DTY_NUMERICSCALE,
        DTY_NVARCHAR,
        DTY_REAL,
        DTY_ROWVERSION,
        DTY_SMALLDATETIME,
        DTY_SMALLINT,
        DTY_SMALLMONEY,
        DTY_SQL,
        DTY_TEXT,
        DTY_TIME,
        DTY_TINYINT,
        DTY_UNIQUEIDENTIFIER,
        DTY_VARBINARY,
        DTY_VARCHAR,
        DTY_XML,

        DTY_CALLBACK, 
        DTY_MAX 
    };

    enum BoolFormat {
        BF_Y_UPPER,
        BF_T_UPPER,

        BF_YES_CAMEL,
        BF_YES_LOWER,
        BF_YES_UPPER,

        BF_ON_CAMEL,
        BF_ON_LOWER,
        BF_ON_UPPER,

        BF_TRUE_CAMEL,
        BF_TRUE_LOWER,
        BF_TRUE_UPPER,

        BF_STRING_ON
    };

    typedef QVariant (*Callback) (
            const DbTaew & table,
            const DbColumn & colorig,
            const QSqlRecord & rec,
            int role,
            void * user_data);

    union ColFormat {
        BoolFormat bit_; 
        int width_; 
        Callback callback_; 
    };

    QString col_name_;
    int col_id_;
    int real_col_id_;
    int length_;
    QString col_label_;
    DataType datatype_;
    bool nulls_;
    bool autoincrement_;
    QString default_value_;
    bool read_only_;
    int virtrefcol_;
    QString foreign_table_; 
    QString foreign_key_; 
    QString foreign_ref_; 
    ForeignBehaviour foreign_behaviour_; 
    QString original_format_; 
    // following values are extracted from original_format_ in constructor
    ColFormat format_; 
    QChar fill_char_; 
    char nr_format_; 
    int precision_; 
    DbColumn ();

    DbColumn (
            const QString & col_name,
            int col_id,
            int real_col_id,
            int length,
            const QString & col_label,
            DataType datatype,
            bool nulls,
            bool autoincrement,
            const QString & default_value,
            const QString & format,
            bool read_only,
            int virtrefcol,
            const QString & foreign_table,
            const QString & foreign_key,
            const QString & foreign_ref,
            ForeignBehaviour foreign_behaviour) ;

    virtual ~DbColumn();

    virtual Type
    type () const {
        return DBO_COLUMN;
    }

    inline bool
    isForeignKey () const {
        return !foreign_table_.isEmpty();
    }

    inline bool
    isVirtual () const {
        return virtrefcol_ != -1;
    }

    inline bool
    isDynamic () const {
        return datatype_ == DTY_CALLBACK;
    }

    QVariant kbData (
            const DbTaew & table,
            const QSqlRecord & rec,
            int role = Qt::DisplayRole,
            void * user_data = NULL) const;

    QVariant
    formattedData (
        const QVariant &original_value) const;

protected:

private:

};

#endif // GUARD_DBCOLUMN_H_INCLUDE