We have been collecting data for more than a year from Sreality. We have 3 tables(flats, grounds, houses) in the Mysql Seznam database. compare.py compares and calculates the decrease and increase of house, apartment, land prices. If the price increases by 20 percent it sends an email.
This out table:
+———+————————–+————————+———+————+————+———–+———–+———————+——+——+——-+
| id | name | locality | price | hash_id | meters | gps_lat | gps_lon | timestamp | tel | tel2 |
+———+————————–+————————+———+————+————+———–+———–+———————+——+——+——-+
login to database is in code