#!/usr/bin/env python
# coding: utf-8

# In[2]:


import sys
get_ipython().system('"{sys.executable}" -m pip install sqlalchemy')


# In[3]:


from sqlalchemy import create_engine


# In[5]:


engine = create_engine('sqlite:///db.sqlite', echo=True)


# In[6]:


from sqlalchemy.ext.declarative import declarative_base


# In[7]:


Base = declarative_base()


# In[9]:


from sqlalchemy import Column, Integer, String
class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    fullname = Column(String)
    nickname = Column(String)
    def __repr__(self):
       return "<User(name='%s', fullname='%s', nickname='%s')>" % (
                            self.name, self.fullname, self.nickname)


# In[10]:


User.__table__


# In[11]:


Base.metadata.create_all(engine)


# In[12]:


ed_user = User(name='ed', fullname='Ed Jones', nickname='edsnickname')


# In[13]:


from sqlalchemy.orm import sessionmaker


# In[14]:


Session = sessionmaker(bind=engine)


# In[15]:


session = Session()


# In[16]:


session.add(ed_user)


# In[17]:


ed_user.id


# In[21]:


session.query(User).first()


# In[22]:


ed_user.id


# In[ ]: