def __purge(self):
db = Database()
cursor = db.cursor()
cursor.execute("""SELECT COUNT(*)
FROM changesets
JOIN customchangesets ON (customchangesets.changeset=changesets.id)
WHERE time < NOW() - INTERVAL '3 months'""")
npurged = cursor.fetchone()[0]
if npurged:
self.info("purging %d old custom changesets" % npurged)
cursor.execute("DELETE FROM changesets USING customchangesets WHERE id=changeset AND time < NOW() - INTERVAL '3 months'")
db.commit()
db.close()
def __purge(self):
db = Database()
cursor = db.cursor()
cursor.execute("""SELECT COUNT(*)
FROM changesets
JOIN customchangesets ON (customchangesets.changeset=changesets.id)
WHERE time < NOW() - INTERVAL '3 months'""")
npurged = cursor.fetchone()[0]
if npurged:
self.info("purging %d old custom changesets" % npurged)
cursor.execute(
"DELETE FROM changesets USING customchangesets WHERE id=changeset AND time < NOW() - INTERVAL '3 months'"
)
db.commit()
db.close()
NATIONALITIES[2]: lv_coordinates,
NATIONALITIES[3]: lt_coordinates,
NATIONALITIES[4]: ua_coordinates
}
uniq_names = get_uniq_names(NAMES_FILE)
logging.debug('by max_latitude: %s', by_coordinates.max_latitude())
logging.debug("by min_latitude: %s", by_coordinates.min_latitude())
logging.debug("by max_longitude: %s", by_coordinates.max_longitude())
logging.debug("by min_longitude: %s", by_coordinates.max_longitude())
logging.info('Creating the database connection')
try:
db = Database()
cursor = db.cursor()
db.create_tables()
except Exception as e:
logging.CRITICAL("Unable to create the database: %s", e)
for nationality in NATIONALITIES:
for i in range(1000):
name = random.choice(uniq_names)
random_lat = random.uniform(
NATIONAL_COORDINATES[nationality].min_latitude(),
NATIONAL_COORDINATES[nationality].max_latitude()
)
random_long = random.uniform(
NATIONAL_COORDINATES[nationality].min_longitude(),
NATIONAL_COORDINATES[nationality].max_longitude()
