30
30
engine = create_engine('sqlite:///poi.db')
31
31
session = create_session(bind=engine)
32
32
metadata = MetaData('sqlite://')
35
Column('idmd5', Integer, primary_key=True),
36
Column('lat', Integer),
37
Column('lon', Integer),
38
Column('visibility', Integer),
39
Column('cat', Integer),
40
Column('subcat', Integer),
41
Column('keywords', String),
42
Column('desc', String),
43
Column('price_range',Integer),
44
Column('extended_open', Integer),
45
Column('creator', String),
46
Column('bookmarked', String),
47
Column('user_rating', String),
48
Column('rating', String),
49
Column('user_comment', String),
33
poi_table = Table("poi",metadata,
34
Column('idmd5', Integer, primary_key=True),
35
Column('lat', Integer),
36
Column('lon', Integer),
37
Column('visibility', Integer),
38
Column('cat', Integer),
39
Column('subcat', Integer),
40
Column('keywords', String),
41
Column('desc', String),
42
Column('price_range',Integer),
43
Column('extended_open', Integer),
44
Column('creator', String),
45
Column('bookmarked', String),
46
Column('user_rating', String),
47
Column('rating', String),
48
Column('user_comment', String),
51
50
mapper(Poi, poi_table)
53
52
print("<osm version=\"0.5\">")