text: """
  credits to @mrconfused and @sandy1709
  """
  #    Copyright (C) 2020  sandeep.n(π.$)
  #    This program is free software: you can redistribute it and/or modify
  #    it under the terms of the GNU Affero General Public License as
  #    published by the Free Software Foundation, either version 3 of the
  #    License, or (at your option) any later version.
  #    This program is distributed in the hope that it will be useful,
  #    but WITHOUT ANY WARRANTY; without even the implied warranty of
  #    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  #    GNU Affero General Public License for more details.
  #   You should have received a copy of the GNU Affero General Public License
  #   along with this program.  If not, see <http://www.gnu.org/licenses/>.
  from sqlalchemy import Column, String
  
  from . import BASE, SESSION
  
  
  class Gdrive(BASE):
      __tablename__ = "drggdrive"
      cat = Column(String(50), primary_key=True)
  
      def __init__(self, drg):
          self.drg = drg
  
  
  Gdrive.__table__.create(checkfirst=True)
  
  
  def is_folder(folder_id):
      try:
          return SESSION.query(Gdrive).filter(Gdrive.drg == str(folder_id))
      except BaseException:
          return None
      finally:
          SESSION.close()
  
  
  def gparent_id(folder_id):
      adder = SESSION.query(Gdrive).get(folder_id)
      if not adder:
          adder = Gdrive(folder_id)
      SESSION.add(adder)
      SESSION.commit()
  
  
  def get_parent_id():
      try:
          return SESSION.query(Gdrive).all()
      except BaseException:
          return None
      finally:
          SESSION.close()
  
  
  def rmparent_id(folder_id):
      note = SESSION.query(Gdrive).filter(Gdrive.drg == folder_id)
      if note:
          note.delete()
          SESSION.commit()
  