r = Session().query(Hotel.id).order_by(Hotel.id)[0][0] print r return r #This function returns the last 5 hotels stored in the system def get_last_hotels(): return Session().query(Hotel).all()[-5:] #Hotel's FieldSet HotelFieldSet = FieldSet(Hotel) HotelFieldSet.append(Field(name='imagem').with_renderer(FileFieldRenderer)) HotelFieldSet.configure( exclude=[HotelFieldSet.latitude,HotelFieldSet.longitude], options=[HotelFieldSet.regiao.dropdown(options=HotelRegiao().get_values()), HotelFieldSet.finalidade.dropdown(options=HotelFim().get_values()), HotelFieldSet.tipo.dropdown(options=HotelTipo().get_values())]) #User's FieldSet UserFieldSet = FieldSet(User) UserFieldSet.insert_after(UserFieldSet.password, Field(name='password2').with_renderer(PasswordFieldRenderer)) UserFieldSet.append(Field(name='password').with_renderer(PasswordFieldRenderer)) UserFieldSet.append(Field('hotel_fim').dropdown(options=HotelFim().get_values())) UserFieldSet.configure(exclude=[UserFieldSet.creation_date]) #TouristicSite's FieldSet TouristicSiteFieldSet = FieldSet(TouristicSite) TouristicSiteFieldSet.configure(exclude=[TouristicSiteFieldSet.latitude,TouristicSiteFieldSet.longitude]) #Service's FieldSet ServiceFieldSet = FieldSet(Service) ServiceFieldSet.configure(exclude=[ServiceFieldSet.latitude,ServiceFieldSet.longitude])