Упрощенный порядок вызова - с передачей координат вместо номера тайла.

[pyrungps.git] / render_tiles.py

diff --git a/render_tiles.py b/render_tiles.py
index 1c57b0b46d5ce9c976fbb373afb8abac683dd13c..3d95a8570c06738361ca04fd7cfb96239343ce7e 100644 (file)
--- a/render_tiles.py
+++ b/render_tiles.py
@@ -2,51 +2,101 @@
 # coding: UTF-8
 
 import sqlite3
-
 import math
+from pprint import pprint
 
-def queue_render(db,filename):
+def queue_render(db,filename,forced_max_zoom=None):
 
   conn = sqlite3.connect(db)
   cur = conn.cursor()
-    
+        
   cur.execute("select minlat,minlon,maxlat,maxlon from tracks where filename=?" , (filename.decode('UTF-8'),))
-  
-  minlat,minlon,maxlat,maxlon=cur.fetchone()  
+  minlat,minlon,maxlat,maxlon=cur.fetchone()
+  queue_tiles(db,minlat,minlon,maxlat,maxlon,forced_max_zoom)
+            
+def queue_tiles(db,minlat,minlon,maxlat,maxlon,forced_max_zoom=None):
+
+  conn = sqlite3.connect(db)
   
   # определяем примерный стартовый зум
   
-  minlatrad = math.radians(minlat)
-  maxlatrad = math.radians(maxlat)
+  minzoom=8
+  if forced_max_zoom:
+    maxzoom=forced_max_zoom
+  else:
+    maxzoom=16  
   
-  minx = (minlon + 180.0)/360.0
-  maxx = (maxlon + 180.0)/360.0
+  ins = conn.cursor()
+  print minlat,maxlat,minlon,maxlon,minzoom,maxzoom
+  ins.execute('insert into render_queue(minlat,maxlat,minlon,maxlon,minzoom,maxzoom) values(?,?,?,?,?,?)',(minlat,maxlat,minlon,maxlon,minzoom,maxzoom))
+
+  conn.commit()        
+
+def process_queue(db,map,force=False):
+
+  from os import system
+
+  conn = sqlite3.connect(db)
+  cur = conn.cursor()
+  cur.execute('select id,minlat,maxlat,minlon,maxlon,minzoom,maxzoom from render_queue')
+  list=cur.fetchall()
+
+  for rec in list:
   
-  miny = (1.0 - math.log(math.tan(minlatrad) + (1 / math.cos(minlatrad))) / math.pi) / 2.0
-  maxy = (1.0 - math.log(math.tan(maxlatrad) + (1 / math.cos(maxlatrad))) / math.pi) / 2.0
+    id,minlat,maxlat,minlon,maxlon,minzoom,maxzoom=rec
 
-  if minx>maxx:
-    minx,maxx = maxx,minx
+    command = 'map='+map+ \
+      ' z='+str(minzoom)+'-'+str(maxzoom)+ \
+      ' lat='+str(minlat)+','+str(maxlat)+ \
+      ' lon='+str(minlon)+','+str(maxlon)
+
+    if force:
+      command = 'tirex-batch -n 0 '+command
+    else:
+      command = 'tirex-batch -n 0 '+command+' -f not-exists'  
     
-  if miny>maxy:
-    miny,maxy = maxy,miny
+    print command  
+      
+    if system(command)==0:
+      dcur=conn.cursor()
+      dcur.execute('delete from render_queue where id=?',(id,))
+      conn.commit()
+
+def main():
+
+  from optparse import OptionParser
   
-  for zoom in range(9,16):
-    
-    n = 2 ** zoom
-    
-    minxt = int(minx * n)
-    minyt = int(miny * n)
-    maxxt = int(maxx * n)
-    maxyt = int(maxy * n)
-    
-    ins = conn.cursor()
-    print zoom,minxt,maxxt,minyt,maxyt
-    ins.execute('insert into render_queue(zoom,minx,maxx,miny,maxy) values(?,?,?,?,?)',(zoom,minxt,maxxt,minyt,maxyt))
+  parser = OptionParser()
+  parser.add_option("-d", "--data", dest="directory",
+    help="Data directory", metavar="DIR")
+  parser.add_option("-m", "--map", dest="map",
+    help="Map name", metavar="MAP")
+  parser.add_option("-z", "--zoom", dest="zoom",
+    help="Maximal zoom (forced), used with coordinates pairs (minlat minlon maxlat maxlon) or filename in arguments", metavar="MAP")
+  parser.add_option("-f", "--force", dest="force", 
+    help="Force tile regeneration (on/off), default off")
+  (options, args) = parser.parse_args()  
 
-    if (maxxt-minxt>16) or (maxyt-minyt>12):
-      conn.commit()
-      break
+  print options,args
 
-  conn.commit()        
+  db=options.directory+'/gpx.db'
+  map=options.map  
+  zoom=options.zoom
+  force=(options.force=='on')
+
+  if zoom:
+    if len(args)==1:
+      filename,=args
+      print "Rendering file: "+filename+"\n"
+      queue_render(db,filename)
+    else:
+      minlat,minlon,maxlat,maxlon=args
+      queue_tiles(db,float(minlat),float(minlon),float(maxlat),float(maxlon),int(zoom))
+
+  if map:
+    process_queue(db,map,force)
+  
+if __name__ == "__main__":
+
+  main()          
   
\ No newline at end of file