Ruslan Polupan
Ruslan PolupanJuly 10, 2019, 8:29 a.m.

IMpos project. Part 001. Statement of the problem

Small introduction.

For me, programming is a hobby in order to keep my thought processes in good shape. Therefore, for sure there will be not quite professional approaches to solving a particular problem. Therefore, I will always be glad to any advice and criticism. I decided to participate in filling the Development Diaries section in order to structure and discipline my own development process.

The project was conceived as a set of tools for changing the settings of the M-Pos filling station operator's software. This set should allow technical support staff to quickly change system settings simultaneously on several (up to 200) objects without using manual execution of SQL queries. This will also allow non-IT employees to change settings, freeing up technical support time to solve more pressing problems.


The databases used are Firebird of the current version 3.0.4.

iMpos (MPos Instruments) assumes the use of the following database drivers:

  • QIBASE to work with the central database and gas station databases. Driver assembly is described here .
  • QSQLLITE for storing current program settings, user base and logging of performed operations, etc. Driver assembly is not required.

The current task is to change the name of the types of fuel (Summer/Winter) in the database of filling stations and on the fiscal receipt of the cash register. To do this, you need to make changes to the settings in the MIGRATEOPTIONS table in the gas station database. After that, in the process of closing the shift at the gas station and removing the Z-report, changes will occur in the fiscal memory of the cash register.

The general algorithm of the program:

  • Connect to the SQLite settings database. If it is missing create;
  • Get connection parameters to the Central Bank (central database). If missing, create a new entry and connect;
  • If user identification is required, call up the identification window. Carry out logging about the entrance;
  • Launching the main window of the application;
  • Calling the dialog box Names of fuel;
  • display a list of operating gas stations with the ability for the user to select individual gas stations, a separate region, all gas stations;
  • get a list of selected gas stations;
  • get the connection parameters to the database of each gas station;
  • ask the user for further actions View names or Set names ;
  • Connect in a separate thread to each gas station, depending on the task, either get data from the gas station (SELECT) or install (UPDATE). In progress, display the current state of the request, as well as the status of its execution.
  • upon successful receipt of the list of titles, display it and provide the ability to print information or save it to a *.xlsx file.
  • when setting parameters, display the process and completion status. log into the SQLite database;
We recommend hosting TIMEWEB
We recommend hosting TIMEWEB
Stable hosting, on which the social network EVILEG is located. For projects on Django we recommend VDS hosting.

Do you like it? Share on social networks!

Дмитрий
  • July 10, 2019, 9:25 a.m.

Исправьте опечатку:
"iMpos (MPos Instruments) предполагает использование слКдующий драйверов баз данных:"

Ruslan Polupan
  • July 10, 2019, 10:45 a.m.

Спасибо, исправил.

Evgenii Legotckoi
  • July 11, 2019, 3:35 a.m.

Вопрос есть. Базы пользователей в SQLite. Там хранятся логины и пароли поьлзователей? Или просто какая-то общая информация с настройками под конкретного пользователя?

Ruslan Polupan
  • July 11, 2019, 3:47 a.m.

Пароль пользователя программы. Для отслеживания кто и когда сделал изменения и все. Пароли к базам хранятся самих базах и в зашифрованном виде. Ну и настройки системы хранятся там. а также логи действия и сформированные скрипты.

Evgenii Legotckoi
  • July 11, 2019, 3:50 a.m.

Понятно, а просто шифруете одни пароли, или сразу всю базу данных SQLite? Насколько знаю, есть плагин для шифрования SQLite базы данных.

Ruslan Polupan
  • July 11, 2019, 3:56 a.m.

Задумывался над этим, но в свете текщих задач в этом нет особой необходимости.

Comments

Only authorized users can post comments.
Please, Log in or Sign up
AD

C ++ - Test 004. Pointers, Arrays and Loops

  • Result:50points,
  • Rating points-4
m

C ++ - Test 004. Pointers, Arrays and Loops

  • Result:80points,
  • Rating points4
m

C ++ - Test 004. Pointers, Arrays and Loops

  • Result:20points,
  • Rating points-10
Last comments
i
innorwallNov. 14, 2024, 8:09 p.m.
Qt/C++ - Tutorial 068. Hello World using the CMAKE build system in CLion ditropan pristiq dosing With the Yankees leading, 4 3, Rivera jogged in from the bullpen to a standing ovation as he prepared for his final appearance in Chicago buy priligy pakistan
i
innorwallNov. 14, 2024, 3:05 p.m.
EVILEG-CORE. Using Google reCAPTCHA 2001; 98 29 34 priligy buy
i
innorwallNov. 14, 2024, 3 p.m.
PyQt5 - Lesson 007. Works with QML QtQuick (Signals and slots) priligy 30mg Am J Obstet Gynecol 171 1488 505
i
innorwallNov. 14, 2024, 1:54 p.m.
Django - Tutorial 003. Model, Template, View on Django Hair follicles are believed to produce approximately 20 individual hair shafts over the life of the follicle as the follicle progresses through cycles of hair production, shedding ejection, invo…
i
innorwallNov. 14, 2024, 10:03 a.m.
How to make game using Qt - Lesson 3. Interaction with other objects what is priligy tablets What happens during the LASIK surgery process
Now discuss on the forum
i
innorwallNov. 14, 2024, 2:39 p.m.
добавить qlineseries в функции priligy amazon canada 93 GREB1 protein GREB1 AB011147 6
i
innorwallNov. 11, 2024, 9:55 p.m.
Всё ещё разбираюсь с кешем. priligy walgreens levitra dulcolax carbs The third ring was found to be made up of ultra relativistic electrons, which are also present in both the outer and inner rings
9
9AnonimOct. 25, 2024, 7:10 p.m.
Машина тьюринга // Начальное состояние 0 0, ,<,1 // Переход в состояние 1 при пустом символе 0,0,>,0 // Остаемся в состоянии 0, двигаясь вправо при встрече 0 0,1,>…

Follow us in social networks