MainWindow::MainWindow(QWidget *parent) : QMainWindow(parent) { //Setup database ConecToDb(db_, "tareas"); db_.exec("CREATE TABLE IF NOT EXISTS tareas (" "id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," "name TEXT," "description TEXT" "date TEXT," "category_id INT," ");"); db_.exec("CREATE TABLE IF NOT EXISTS categories (" "id INTEGER," "name TEXT," "description TEXT" ");"); db_.exec("CREATE TABLE IF NOT EXISTS tag (" "id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," "name TEXT" ");"); db_.exec("CREATE TABLE IF NOT EXISTS tag_tareas (" "tag_id INT," "tareas_id INT" ");"); dbList_ = new dblist(db_); setCentralWidget(dbList_); }
MainWindow::MainWindow(QWidget *parent) : QMainWindow(parent), ui(new Ui::MainWindow) { ui->setupUi(this); //Setup database ConecToDb(db_, "tareas"); db_.exec("CREATE TABLE IF NOT EXISTS tareas (" "id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," "name TEXT," "descripcion TEXT," "date TEXT," "done INTEGER," "id_categ INTEGER" ");"); db_.exec("CREATE TABLE IF NOT EXISTS categorias (" "id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," "name TEXT," "descripcion TEXT" ");"); db_.exec("CREATE TABLE IF NOT EXISTS etiquetas (" "id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," "name TEXT" ");"); db_.exec("CREATE TABLE IF NOT EXISTS tareas_etiq (" "id_tarea INTEGER," "id_etiq INTEGER" ");"); connect(ui->actionNuevaTarea, SIGNAL(triggered()), this, SLOT(onAddTarea())); //Obtenemos las categorias QSqlQuery q = db_.exec("SELECT * " "FROM categorias;"); while (q.next()) { ui->comboCategoria->addItem(GetField(q,"name").toString()); int rowNumber = ui->tblCateg->rowCount(); ui->tblCateg->insertRow(rowNumber); QTableWidgetItem* item = new QTableWidgetItem(GetField(q, "name").toString()); ui->tblCateg->setItem(rowNumber, 0, item); } ui->tblCateg->setSortingEnabled(true); }
MainWindow::MainWindow(QWidget *parent) : QMainWindow(parent), ui(new Ui::MainWindow) { ui->setupUi(this); //Setup database if (!ConecToDb(db_, "tareas")) { exit(0); } else { // Crea las tablas createTables(); // Llena los datos mediante script (no implementado) populateTables(); // Tareas connect(ui->actionNuevaTarea, SIGNAL(triggered()), this, SLOT(onAddTarea())); connect(ui->tblTareas, SIGNAL(cellChanged(int,int)), this, SLOT(onTareasCellChanged(int,int))); connect(ui->comboCategoria, SIGNAL(currentIndexChanged(int)), this, SLOT(onLoadTareas())); // Etiquetas connect(ui->actionNuevaEtiq, SIGNAL(triggered()), this, SLOT(onAddEtiqueta())); connect(ui->tblEtiq, SIGNAL(cellChanged(int,int)), this, SLOT(onEtiquetasCellChanged(int,int))); // Categorías connect(ui->actionNuevaCateg, SIGNAL(triggered()), this, SLOT(onAddCategoria())); connect(ui->tblCateg, SIGNAL(cellChanged(int,int)), this, SLOT(onCategoriasCellChanged(int,int))); addingTarea_ = false; addingEtiqueta_ = false; addingCategoria_ = false; obtenerCategorias(); obtenerEtiquetas(); obtenerTareas(); } }