Differences

This shows you the differences between two versions of the page.

--- projects:crawler [2023/03/18 14:40] – created maxfx
+++ projects:crawler [2023/03/18 15:09] (current) – maxfx
@@ Line 1: / Line 1: @@
 ====== Sreality crawler ======
+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 | email |
++---------+--------------------------+------------------------+---------+------------+------------+-----------+-----------+---------------------+------+------+-------+
+login to database is in code