Technical assignment: Server setup and data import from SQLite database
Project goal:
1. Set up the server (preferably CentOS).
2. Configure access to the server via SSH.
3. Import data from the SQLite database of self-service terminals into the server database.
Requirements:
1. Server:
Operating system: CentOS or another at the discretion of the performer.
Set up SSH access and security (firewall, SSL).
2. Database:
Source database: SQLite (file terminals.db).
Server database: PostgreSQL or MySQL (by agreement).
3. Data for import:
Extract revenue amounts with breakdown:
Cash (Banknotes, Coins).
Cashless payment.
4. Automation:
Develop a script for regular data updates (via cron or similar).
Provide instructions for working with the server and the script.
Timeline: To be discussed
Budget: To be discussed
Expected results:
1. A working server with a configured database.
2. Correctly imported data from SQLite with separation by types of revenue.
3. Automated data update process.