connected all views to database