old_contents: from database.queries.insert_queries import INSERT_MOVIE
  from database.queries.select_queries import SELECT_MOVIES_ORDERED_BY_RATING,\
                                              SELECT_PROJECTION_FOR_MOVIE
  
  from settings.SharedVariables import SharedVariables
  from prettytable import PrettyTable
  
  
  class Movies:
  
      def __init__(self):
          try:
              db_wrapper = SharedVariables.database
              c = db_wrapper.get_cursor()
              self.data = c.execute(SELECT_MOVIES_ORDERED_BY_RATING)
          except Exception:
              print("Database not initilized or connected")
  
      def __str__(self):
          t = PrettyTable(SharedVariables.movie_col)
          for row in self.data:
              t.add_row([row[0], row[1], row[2]])
          return str(t)
  
      @staticmethod
      def add_movie(name, rating):
          try:
              db_wrapper = SharedVariables.database
              c = db_wrapper.get_cursor()
              c.execute(INSERT_MOVIE, [name, rating, ])
              db_wrapper.get_db().commit()
          except Exception:
              print("Database not initilized or connected")
  
      @staticmethod
      def movie_projections(id):
          try:
              db_wrapper = SharedVariables.database
              c = db_wrapper.get_cursor()
              data = c.execute(SELECT_PROJECTION_FOR_MOVIE, [id, ])
              db_wrapper.get_db().commit()
  
              t = PrettyTable(SharedVariables.projection_col)
              for row in data:
                  t.add_row([row[0], row[1], row[2], row[3], (100 - row[4])])
              return str(t)
          except Exception:
              print("Database not initilized or connected")
  
  
  if __name__ == '__main__':
      from database.connection.database_connection import Database
      SharedVariables.database = Database()
      Movies.add_movie("Baywatch", 10)
      print(Movies())
      print(Movies.movie_projections(1))
  
new_contents: from database.queries.insert_queries import INSERT_MOVIE
  from database.queries.update_queries import UPDATE_MOVIE
  from database.queries.select_queries import SELECT_MOVIES_ORDERED_BY_RATING,\
                                              SELECT_PROJECTION_FOR_MOVIE
  
  from settings.SharedVariables import SharedVariables
  from prettytable import PrettyTable
  
  
  class Movies:
  
      def __init__(self):
          try:
              db_wrapper = SharedVariables.database
              c = db_wrapper.get_cursor()
              self.data = c.execute(SELECT_MOVIES_ORDERED_BY_RATING)
          except Exception:
              print("Database not initilized or connected")
  
      def __str__(self):
          t = PrettyTable(SharedVariables.movie_col)
          for row in self.data:
              t.add_row([row[0], row[1], row[2]])
          return str(t)
  
      @staticmethod
      def add_movie(name, rating):
          try:
              db_wrapper = SharedVariables.database
              c = db_wrapper.get_cursor()
              c.execute(INSERT_MOVIE, [name, rating, ])
              db_wrapper.get_db().commit()
          except Exception:
              print("Database not initilized or connected")
  
      @staticmethod
      def update_movie(id, name, rating):
          try:
              db_wrapper = SharedVariables.database
              c = db_wrapper.get_cursor()
              c.execute(UPDATE_MOVIE, [name, rating, id, ])
              db_wrapper.get_db().commit()
          except Exception:
              print("Database not initilized or connected")
  
      @staticmethod
      def movie_projections(id):
          try:
              db_wrapper = SharedVariables.database
              c = db_wrapper.get_cursor()
              data = c.execute(SELECT_PROJECTION_FOR_MOVIE, [id, ])
              db_wrapper.get_db().commit()
  
              t = PrettyTable(SharedVariables.projection_col)
              for row in data:
                  t.add_row([row[0], row[1], row[2], row[3], (100 - row[4])])
              return str(t)
          except Exception:
              print("Database not initilized or connected")
  
  
  if __name__ == '__main__':
      from database.connection.database_connection import Database
      SharedVariables.database = Database()
      Movies.add_movie("Baywatch", 10)
      print(Movies())
      Movies.update_movie(1, "Baywatch(1)", 8.7)
      print(Movies())
  
subject: Update functionality on Movie added