Adrian Schmutzler
bc3460f2e0
Global: Change MAC address storage to use BIGINT
...
This requires changes to the MySQL database!
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2018-11-23 13:14:41 +01:00
Adrian Schmutzler
c77e04ee7f
api/alfred: Evaluate utcnow() only once for the whole alfred dataset
...
Since the time is used as key in MySQL, this might help to solve key
race conditions where new_router_stats is entered at the same time.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2018-04-16 12:49:23 +02:00
Adrian Schmutzler
a994ec114a
MySQL stats: Convert from datetime to int
...
DB scripts still need to be updated.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2017-12-10 19:49:46 +01:00
Adrian Schmutzler
8d8436c7f7
mysqltools: Use UTF8 in mysqldb module
...
The MySQLdb python module needs this explicitly, otherwise it
defaults to latin-1.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2017-12-10 19:45:03 +01:00
Adrian Schmutzler
39bf2032f4
routertools: Aggregate INSERT commands using executemany
...
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2017-11-16 20:37:26 +01:00
Adrian Schmutzler
e3fe995407
MySQL: alpha3
...
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2017-11-16 00:00:07 +01:00