This is a QT5 widget that creates a QTreeView with sorting and filtering functionality with a sqlite3 backend.
Connect to your database:
sqlite3 *dbPtr = nullptr;
sqlite3_open(":memory:", &dbPtr);
// Using shared pointers when possible
std::shared_ptr<sqlite3> database(nullptr);
database.reset(dbPtr, sqlite3_close);Create the tree widget and set the database data
// Create View and Model
std::shared_ptr<bookfiler::widget::TreeView> treeViewPtr =
std::make_shared<bookfiler::widget::TreeView>();
std::shared_ptr<bookfiler::widget::TreeModel> treeModelPtr =
std::make_shared<bookfiler::widget::TreeModel>();
qtMainWindow.setCentralWidget(treeViewPtr.get());
qtMainWindow.show();
// Setup Model
treeModelPtr->setData(database, "testTable", "guid", "parent_guid");
treeModelPtr->setRoot("*");
// Setup View
treeViewPtr->setModel(treeModelPtr.get());
treeViewPtr->update();This widget will work with any sqlite3 table as long as there is a guid and parent_guid column. The guid is a unique id for the row and the parent_guid will be the parent id that the row will be a child of.
columns: guid, parent_guid, Subject, Important, Attachment, From, Date, Size
Install MSYS2
Then, install GCC, cmake, git and dependencies. Confirmed working with Windows 10 as of 11/19/2020.
pacman -Syu
pacman -S mingw-w64-x86_64-gcc git make mingw-w64-x86_64-cmake
pacman -Rns cmake
# restart MSYS2 so that we use the mingw cmake
pacman -S mingw-w64-x86_64-boost mingw-w64-x86_64-sqlite3Build:
git clone https://github.com/bradosia/BookFiler-Lib-Sort-Filter-Tree-Widget
cd BookFiler-Module-HTTP
mkdir build
cd build
cmake -G "MSYS Makefiles" ../
makeInstall GCC, cmake, git and dependencies. Confirmed working with Ubuntu 20.04 as of 11/8/2020.
sudo apt-get update
sudo apt install build-essential gcc-multilib g++-multilib cmake git
sudo apt install libboost-all-dev mingw-w64-x86_64-sqlite3Build:
git clone https://github.com/bradosia/BookFiler-Lib-Sort-Filter-Tree-Widget
cd BookFiler-Module-HTTP
mkdir build
cd build
cmake ../
make
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent