package app.insti.data;

import android.arch.persistence.room.Dao;
import android.arch.persistence.room.Delete;
import android.arch.persistence.room.Insert;
import android.arch.persistence.room.Query;
import android.arch.persistence.room.Update;

import java.util.List;

@Dao
public interface DbDao {
    @Query("SELECT * FROM events")
    List<Event> getAllEvents();

    @Query("SELECT * FROM events WHERE user_ues <> 0")
    List<Event> getFollowingEvents();

    @Query("SELECT * FROM bodies")
    List<Body> getAllBodies();

    @Query("SELECT * FROM venues")
    List<Venue> getAllVenues();

    @Query("SELECT * FROM users")
    List<User> getAllUsers();

    @Query("SELECT * FROM roles")
    List<Role> getAllRoles();

    @Query("SELECT * FROM placementBlogPosts")
    List<PlacementBlogPost> getAllPlacementBlogPosts();

    @Query("SELECT * FROM placementBlogPosts WHERE title LIKE :query OR content LIKE :query")
    List<PlacementBlogPost> searchPlacementBlogPosts(String query);

    @Query("SELECT * FROM trainingBlogPosts")
    List<TrainingBlogPost> getAllTrainingBlogPosts();

    @Query("SELECT * FROM hostelMessMenus")
    List<HostelMessMenu> getAllHostelMessMenus();

    @Query("SELECT * FROM news")
    List<NewsArticle> getAllNewsArticles();

    @Query("SELECT COUNT(*) from events")
    int countEvents();

    @Query("SELECT * FROM bodies WHERE id == :id")
    public Body[] getBody(String id);

    @Query("SELECT COUNT(*) from venues")
    int countVenues();

    @Query("SELECT COUNT(*) from bodies")
    int countBodies();

    @Query("SELECT COUNT(*) from users")
    int countUsers();

    @Query("SELECT COUNT(*) from roles")
    int countRoles();

    @Query("SELECT COUNT(*) from hostelMessMenus")
    int countHostelMessMenus();

    @Insert
    void insertEvents(List<Event> events);

    @Insert
    void insertEvent(Event event);

    @Update
    void updateEvent(Event event);

    @Insert
    void insertBodies(List<Body> bodies);

    @Insert
    void insertBody(Body body);

    @Update
    void updateBody(Body body);

    @Insert
    void insertVenues(List<Venue> venues);

    @Insert
    void insertVenue(Venue venue);

    @Insert
    void insertUsers(List<User> users);

    @Insert
    void insertUser(User user);

    @Insert
    void insertRoles(List<Role> roles);

    @Insert
    void insertRole(Role role);

    @Insert
    void insertPlacementBlogPost(PlacementBlogPost post);

    @Insert
    void insertPlacementBlogPosts(List<PlacementBlogPost> posts);

    @Insert
    void insertTrainingBlogPost(TrainingBlogPost post);

    @Insert
    void insertTrainingBlogPosts(List<TrainingBlogPost> posts);

    @Insert
    void insertHostelMessMenu(HostelMessMenu hostelMessMenu);

    @Insert
    void insertHostelMessMenus(List<HostelMessMenu> hostelMessMenus);

    @Insert
    void insertNewsArticle(NewsArticle newsArticle);

    @Insert
    void insertNewsArticles(List<NewsArticle> newsArticles);

    @Delete
    void deleteEvent(Event event);

    @Delete
    void deleteVenue(Venue venue);

    @Delete
    void deleteBody(Body body);

    @Delete
    void deleteUser(User user);

    @Delete
    void deleteRole(Role role);

    @Query("DELETE from events")
    void deleteEvents();

    @Query("DELETE from venues")
    void deleteVenues();

    @Query("DELETE from bodies")
    void deleteBodies();

    @Query("DELETE from users")
    void deleteUsers();

    @Query("DELETE from roles")
    void deleteRoles();

    @Query("DELETE from placementBlogPosts")
    void deletePlacementBlogPosts();

    @Query("DELETE from trainingBlogPosts")
    void deleteTrainingBlogPosts();

    @Query("DELETE from hostelMessMenus")
    void deleteHostelMessMenus();

    @Query("DELETE from news")
    void deleteNewsArticles();
}
