#pragma once

#include <QVariantList>
class OrderMap
{
public:
    QList<QVariantPair> list;
public:
    QVariant& operator[](QVariant key) {
        auto i = find(key);
        if(i==list.end()) {
            QVariantPair t;
            t.first = key;
            list << t;
            return list.last().second;
        } else {
            return i->second;
        }
    }

    QList<QVariantPair>::iterator find(QVariant key) {
        for (auto i = list.begin(); i!=list.end(); ++i) {
            if(i->first==key)
                return i;
        }
        return list.end();
    }
};
//---------使用 demo ----------
    // 建表数据
    OrderMap map;
    // map["user_id"] = "integer NOT NULL PRIMARY KEY AUTOINCREMENT";
    map["user_id"] = "integer NOT NULL PRIMARY KEY";
    map["user_name"] = "varchar";
    map["pass_word"] = "varchar";
    map["create_time"] = "varchar";
    map["dept_id"] = "integer";

    // 定义 SqlService
    SqlService sql;

    // 打开数据库
    sql.open(DataBaseName);

    return sql.createTable(tablename, map);