#ifndef DAL_H
#define DAL_H

#include <QSharedPointer>
#include <QMap>
#include <QString>
#include <QSqlDatabase>

class Folder
{
    int _folderID ;
    QString _title ;
    QString _accessName ;
    QString _type ;
    bool _isVisible ;

    int _baseFolderID ;
    int _baseFolderTimeStamp ;
    int _modifiedTimeStamp ;
    int _creationTimeStamp ;
    int _imagesFolderPath ;

public:
    Q_PROPERTY(int folderID READ folderID WRITE setFolderID)
    Q_PROPERTY(QString title READ title WRITE setTitle)
    Q_PROPERTY(QString accessName READ accessName WRITE setAccessName)
    Q_PROPERTY(QString type READ type WRITE setType)
    Q_PROPERTY(bool isVisible READ isVisible WRITE setIsVisible)

    Q_PROPERTY(int baseFolderID READ baseFolderID WRITE setBaseFolderID)
    Q_PROPERTY(int baseFolderTimeStamp READ baseFolderTimeStamp WRITE setBaseFolderTimeStamp)
    Q_PROPERTY(int modifiedTimeStamp READ modifiedTimeStamp WRITE setModifiedTimeStamp)
    Q_PROPERTY(int creationTimeStamp READ creationTimeStamp WRITE setCreationTimeStamp)
    Q_PROPERTY(int imagesFolderPath READ imagesFolderPath WRITE setImagesFolderPath)

    int folderID() { return _folderID ; }
    int setFolderID(int v) { _folderID = v ; }

    bool isVisible() { return _isVisible ; }
    bool setIsVisible(bool v) { _isVisible = v ; }


    int baseFolderID() { return _baseFolderID ; }
    int setBaseFolderID(int v) { _baseFolderID = v ; }

    int baseFolderTimeStamp() { return _baseFolderTimeStamp ; }
    int setBaseFolderTimeStamp(int v) { _baseFolderTimeStamp = v ; }

    int modifiedTimeStamp() { return _modifiedTimeStamp ; }
    int setModifiedTimeStamp(int v) { _modifiedTimeStamp = v ; }

    int creationTimeStamp() { return _creationTimeStamp ; }
    int setCreationTimeStamp(int v) { _creationTimeStamp = v ; }

    int imagesFolderPath() { return _imagesFolderPath ; }
    int setImagesFolderPath(int v) { _imagesFolderPath = v ; }


    QString title() { return _title ; }
    QString setTitle(QString v) { _title = v ; }

    QString accessName() { return _accessName ; }
    QString setAccessName(QString v) { _accessName = v ; }

    QString type() { return _type ; }
    QString setType(QString v) { _type = v ; }
} ;

class File
{
    int _folderID ;
    int _fileID ;
    QString _title ;
    int _version ;
    int _creationTimeStamp ;
    QString _data ;

    bool _isData ;
public:

    Q_PROPERTY(int folderID READ folderID WRITE setFolderID)
    Q_PROPERTY(int fileID READ fileID WRITE setFileID)
    Q_PROPERTY(QString title READ title WRITE setTitle)
    Q_PROPERTY(int version READ version WRITE setVersion)
    Q_PROPERTY(int creationTimeStamp READ creationTimeStamp WRITE setCreationTimeStamp)
    Q_PROPERTY(QString data READ data WRITE setData)

    int folderID() { return _folderID ;}
    int setFolderID(int v) { _folderID = v ; }

    int fileID() { return _fileID ;}
    int setFileID(int v) { _fileID = v ; }

    QString title() { return _title ;}
    QString setTitle(QString v) { _title = v ; }

    int version() { return _version ;}
    int setVersion(int v) { _version = v ; }

    int creationTimeStamp() { return _creationTimeStamp ;}
    int setCreationTimeStamp(int v) { _creationTimeStamp = v ; }

    QString data() { return isData ? _data : "" ;}
    QString setData(QString v) { _data = v ; _isData = true ;}

    void resetData() { _isData = false ; }
    bool isData() { return _isData ; }
};

class DAL
{
    QMap<QString, QString> _settings ;

    bool _isInit ;
    QString _source ;
    bool _isReadOnly ;
    QSqlDatabase db ;

    Dal() ;
    bool openSqlServer(const QString& connectionString) ;
    bool openSqlite(const QString& path) ;

public:
    static QSharedPointer<DAL> create(const QMap<QString, QString>& settings);

    bool createFolder(int& fid, const QString& accessName, const QString& title, const QString& type, const QString& imagesFolderPath, bool isVisible) ;

    QList<Folder> getFolders(const QString& type) ;
    File getFile(int folderID, const QString& title) ;
    QList<File> getFiles(int folderID) ;
    QList<File> getFilesWithData(int folderID) ;
    bool saveFile(File& file) ;
    bool setFolderProps(bool isSetVisible, bool isVisible, bool isSetTitle, const QString& title, bool isSetImagePath)
};

#endif // DAL_H