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

# In[1]:


get_ipython().run_line_magic('load_ext', 'idb')


# In[2]:


get_ipython().run_line_magic('db_connect', 'sqlite:///Users/dongweiming/baseball-archive-2012.sqlite')


# In[3]:


get_ipython().run_line_magic('tables', '')


# In[4]:


get_ipython().run_line_magic('tables', 'allstarfull')


# In[5]:


get_ipython().run_line_magic('tables', 'allstarfull playerID')


# In[6]:


get_ipython().run_line_magic('tables', 'allstarfull playerID head')


# In[7]:


get_ipython().run_line_magic('tables', 'allstarfull playerID unique count')


# In[8]:


get_ipython().run_line_magic('find_column', '*player*')


# In[9]:


get_ipython().run_line_magic('find_column', 'HR INTEGER')


# In[11]:


get_ipython().run_line_magic('find_table', '*batting*')


# In[12]:


get_ipython().run_line_magic('save_credentials', 'baseball')


# In[13]:


get_ipython().run_line_magic('save_credentials', '')


# In[16]:


df1 = get_ipython().run_line_magic('query', 'select * from allstarfull limit 1;')


# In[17]:


df1


# In[ ]:


df = get_ipython().run_line_magic('query_from_file', 'myscript.sql')