old_contents: from sqlalchemy.ext.declarative import declarative_base
  from sqlalchemy import Integer, Unicode, Text, DateTime, ForeignKey, Column, Boolean
  from sqlalchemy.orm import scoped_session, sessionmaker, relationship
  from datetime import datetime
  
  
  _Base = declarative_base()
  DBSession = scoped_session(sessionmaker())
  
  
  class User(_Base):
      __tablename__ = "users"
  
      id = Column(Integer, primary_key=True)
      name = Column(Unicode(255))
      email = Column(Unicode(255))
      admin = Column(Boolean)
      created_at = Column(DateTime())
      password = Column(Unicode(255))
      repos = relationship("Repo")
      apikeys = relationship("APIKey")
  
  
  class APIKey(_Base):
      __tablename__ = "apikeys"
  
      id = Column(Integer, primary_key=True)
      create_at = Column(DateTime())
      apikey = Column(Unicode(255))
      owner_id = Column(Integer, ForeignKey('users.id'))
  
  
  class Repo(_Base):
      __tablename__ = "repos"
      __mapper_args__ = dict(order_by="created_at desc")
  
      id = Column(Integer, primary_key=True)
      owner_id = Column(Integer, ForeignKey('users.id'))
      name = Column(Unicode(255))
      created_at = Column(DateTime())
      last_updated = Column(DateTime())
      source_url = Column(Text())
      github_url = Column(Text())
      path = Column(Text())
  
      def to_dict(self):
          return dict(
              owner_id=self.owner_id,
              name=self.name,
              created_at=self.created_at,
              last_updated=self.last_updated,
              source_url=self.source_url,
              github_url=self.github_url,
              path=self.path
          )
  
      @classmethod
      def from_dict(cls, new):
          r = Repo()
          r.owner_id = new.get('owner_id')
          r.name = new.get('name')
          r.created_at = datetime.now()
          r.last_updated = datetime.now()
          r.source_url = new.get('source_url')
          r.github_url = new.get('github_url')
          r.path = new.get('pat')
          return r
  
  
  def initialize_sql(engine):
      DBSession.configure(bind=engine)
      _Base.metadata.bind = engine
      _Base.metadata.drop_all()
      _Base.metadata.create_all(engine, checkfirst=False)
      DBSession.add(User(name="admin", password="password", admin=True, email="admin@spacehub.com"))
  
new_contents: from sqlalchemy.ext.declarative import declarative_base
  from sqlalchemy import Integer, Unicode, Text, DateTime, ForeignKey, Column, Boolean
  from sqlalchemy.orm import scoped_session, sessionmaker, relationship
  from datetime import datetime
  
  
  _Base = declarative_base()
  DBSession = scoped_session(sessionmaker())
  
  
  class User(_Base):
      __tablename__ = "users"
  
      id = Column(Integer, primary_key=True)
      name = Column(Unicode(255))
      email = Column(Unicode(255))
      admin = Column(Boolean)
      created_at = Column(DateTime())
      password = Column(Unicode(255))
      repos = relationship("Repo")
      apikeys = relationship("APIKey")
  
  
  class APIKey(_Base):
      __tablename__ = "apikeys"
  
      id = Column(Integer, primary_key=True)
      create_at = Column(DateTime())
      apikey = Column(Unicode(255))
      owner_id = Column(Integer, ForeignKey('users.id'))
  
  
  class Repo(_Base):
      __tablename__ = "repos"
      __mapper_args__ = dict(order_by="created_at desc")
  
      id = Column(Integer, primary_key=True)
      owner_id = Column(Integer, ForeignKey('users.id'))
      name = Column(Unicode(255))
      created_at = Column(DateTime())
      last_updated = Column(DateTime())
      source_url = Column(Text())
      github_url = Column(Text())
      path = Column(Text())
  
      def to_dict(self):
          return dict(
              owner_id=self.owner_id,
              name=self.name,
              created_at=self.created_at.strftime("%D %H:%M"),
              last_updated=self.last_updated.strftime("%D %H:%M"),
              source_url=self.source_url,
              github_url=self.github_url,
              path=self.path
          )
  
      @classmethod
      def from_dict(cls, new):
          r = Repo()
          r.owner_id = new.get('owner_id')
          r.name = new.get('name')
          r.created_at = datetime.now()
          r.last_updated = datetime.now()
          r.source_url = new.get('source_url')
          r.github_url = new.get('github_url')
          r.path = new.get('pat')
          return r
  
  
  def initialize_sql(engine):
      DBSession.configure(bind=engine)
      _Base.metadata.bind = engine
      _Base.metadata.drop_all()
      _Base.metadata.create_all(engine, checkfirst=False)
      DBSession.add(User(name="admin", password="password", admin=True, email="admin@spacehub.com"))
  
subject: fix to_dict function