from sqlalchemy import Column, Integer, String, Boolean
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship, sessionmaker
from sqlalchemy import create_engine

Base = declarative_base()

class Knowledge(Base):
   __tablename__ = 'viki_topics'
   topic_id = Column(Integer, primary_key=True)
   topic = Column(String)
   title = Column(String)
   rate = Column(Integer)



   def __repr__(self):
        return ("if you want to learn about {} "
                ", you should look at Wikipedia article called {}"
                ". We gave this article a rating of {} out of 10".format(
            self.topic,
            self.title,
            self.rate))



# k1 = Knowledge(topic="Farmercy", title="Banans", rate=8)
# print(k1)

   # finished_lab = Column(Boolean)

    # Create a table with 4 columns
    # The first column will be the primary key
    # The second column should be a string representing
    # the name of the Wiki article that you're referencing
    # The third column will be a string representing the 
    # topic of the article. The last column will be
    # an integer, representing your rating of the article.


from sqlalchemy import Column, Integer, String, Boolean
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship, sessionmaker
from sqlalchemy import create_engine

Base = declarative_base()

class Knowledge(Base):
   __tablename__ = 'viki_topics'
   topic_id = Column(Integer, primary_key=True)
   topic = Column(String)
   title = Column(String)
   rate = Column(Integer)



   def __repr__(self):
        return ("if you want to learn about {} "
                ", you should look at Wikipedia article called {}"
                ". We gave this article a rating of {} out of 10".format(
            self.topic,
            self.title,
            self.rate))



# k1 = Knowledge(topic="Farmercy", title="Banans", rate=8)
# print(k1)

   # finished_lab = Column(Boolean)

    # Create a table with 4 columns
    # The first column will be the primary key
    # The second column should be a string representing
    # the name of the Wiki article that you're referencing
    # The third column will be a string representing the 
    # topic of the article. The last column will be
    # an integer, representing your rating of the article.


# k1 = Knowledge(topic="Farmercy", title="Banans", rate=8) # print(k1) # finished_lab = Column(Boolean) # Create a table with 4 columns # The first column will be the primary key # The second column should be a string representing # the name of the Wiki article that you're referencing # The third column will be a string representing the # topic of the article. The last column will be # an integer, representing your rating of the article.