In [1]:

    

import sqlalchemy
from obit_scraper import db


    

In [2]:

    

db.initialize()


    

    




2014-09-21 15:31:57,079 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1






    




INFO:sqlalchemy.engine.base.Engine:SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1






    




2014-09-21 15:31:57,080 INFO sqlalchemy.engine.base.Engine ()






    




INFO:sqlalchemy.engine.base.Engine:()






    




2014-09-21 15:31:57,081 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1






    




INFO:sqlalchemy.engine.base.Engine:SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1






    




2014-09-21 15:31:57,082 INFO sqlalchemy.engine.base.Engine ()






    




INFO:sqlalchemy.engine.base.Engine:()






    




2014-09-21 15:31:57,083 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("obituaries")






    




INFO:sqlalchemy.engine.base.Engine:PRAGMA table_info("obituaries")






    




2014-09-21 15:31:57,083 INFO sqlalchemy.engine.base.Engine ()






    




INFO:sqlalchemy.engine.base.Engine:()






    




2014-09-21 15:31:57,084 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("images")






    




INFO:sqlalchemy.engine.base.Engine:PRAGMA table_info("images")






    




2014-09-21 15:31:57,084 INFO sqlalchemy.engine.base.Engine ()






    




INFO:sqlalchemy.engine.base.Engine:()






    




2014-09-21 15:31:57,084 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("services")






    




INFO:sqlalchemy.engine.base.Engine:PRAGMA table_info("services")






    




2014-09-21 15:31:57,085 INFO sqlalchemy.engine.base.Engine ()






    




INFO:sqlalchemy.engine.base.Engine:()






    




2014-09-21 15:31:57,085 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("guestbook_entries")






    




INFO:sqlalchemy.engine.base.Engine:PRAGMA table_info("guestbook_entries")






    




2014-09-21 15:31:57,086 INFO sqlalchemy.engine.base.Engine ()






    




INFO:sqlalchemy.engine.base.Engine:()






    




2014-09-21 15:31:57,086 INFO sqlalchemy.engine.base.Engine 
CREATE TABLE obituaries (
	id INTEGER NOT NULL, 
	name VARCHAR, 
	text VARCHAR, 
	birth_place VARCHAR, 
	residence VARCHAR, 
	birth_date DATE, 
	death_date DATE, 
	PRIMARY KEY (id)
)








    




INFO:sqlalchemy.engine.base.Engine:
CREATE TABLE obituaries (
	id INTEGER NOT NULL, 
	name VARCHAR, 
	text VARCHAR, 
	birth_place VARCHAR, 
	residence VARCHAR, 
	birth_date DATE, 
	death_date DATE, 
	PRIMARY KEY (id)
)








    




2014-09-21 15:31:57,087 INFO sqlalchemy.engine.base.Engine ()






    




INFO:sqlalchemy.engine.base.Engine:()






    




2014-09-21 15:31:57,087 INFO sqlalchemy.engine.base.Engine COMMIT






    




INFO:sqlalchemy.engine.base.Engine:COMMIT






    




2014-09-21 15:31:57,088 INFO sqlalchemy.engine.base.Engine 
CREATE TABLE images (
	id INTEGER NOT NULL, 
	obituary_id INTEGER, 
	url VARCHAR, 
	caption VARCHAR, 
	PRIMARY KEY (id), 
	FOREIGN KEY(obituary_id) REFERENCES obituaries (id)
)








    




INFO:sqlalchemy.engine.base.Engine:
CREATE TABLE images (
	id INTEGER NOT NULL, 
	obituary_id INTEGER, 
	url VARCHAR, 
	caption VARCHAR, 
	PRIMARY KEY (id), 
	FOREIGN KEY(obituary_id) REFERENCES obituaries (id)
)








    




2014-09-21 15:31:57,088 INFO sqlalchemy.engine.base.Engine ()






    




INFO:sqlalchemy.engine.base.Engine:()






    




2014-09-21 15:31:57,089 INFO sqlalchemy.engine.base.Engine COMMIT






    




INFO:sqlalchemy.engine.base.Engine:COMMIT






    




2014-09-21 15:31:57,089 INFO sqlalchemy.engine.base.Engine 
CREATE TABLE services (
	id INTEGER NOT NULL, 
	obituary_id INTEGER, 
	url VARCHAR, 
	title VARCHAR, 
	location VARCHAR, 
	PRIMARY KEY (id), 
	FOREIGN KEY(obituary_id) REFERENCES obituaries (id)
)








    




INFO:sqlalchemy.engine.base.Engine:
CREATE TABLE services (
	id INTEGER NOT NULL, 
	obituary_id INTEGER, 
	url VARCHAR, 
	title VARCHAR, 
	location VARCHAR, 
	PRIMARY KEY (id), 
	FOREIGN KEY(obituary_id) REFERENCES obituaries (id)
)








    




2014-09-21 15:31:57,090 INFO sqlalchemy.engine.base.Engine ()






    




INFO:sqlalchemy.engine.base.Engine:()






    




2014-09-21 15:31:57,090 INFO sqlalchemy.engine.base.Engine COMMIT






    




INFO:sqlalchemy.engine.base.Engine:COMMIT






    




2014-09-21 15:31:57,091 INFO sqlalchemy.engine.base.Engine 
CREATE TABLE guestbook_entries (
	id INTEGER NOT NULL, 
	obituary_id INTEGER, 
	message VARCHAR, 
	signature VARCHAR, 
	date DATE, 
	location VARCHAR, 
	PRIMARY KEY (id), 
	FOREIGN KEY(obituary_id) REFERENCES obituaries (id)
)








    




INFO:sqlalchemy.engine.base.Engine:
CREATE TABLE guestbook_entries (
	id INTEGER NOT NULL, 
	obituary_id INTEGER, 
	message VARCHAR, 
	signature VARCHAR, 
	date DATE, 
	location VARCHAR, 
	PRIMARY KEY (id), 
	FOREIGN KEY(obituary_id) REFERENCES obituaries (id)
)








    




2014-09-21 15:31:57,091 INFO sqlalchemy.engine.base.Engine ()






    




INFO:sqlalchemy.engine.base.Engine:()






    




2014-09-21 15:31:57,092 INFO sqlalchemy.engine.base.Engine COMMIT






    




INFO:sqlalchemy.engine.base.Engine:COMMIT

In [3]:

    

db.obituaries


    

    
Out[3]:





Table('obituaries', MetaData(bind=None), Column('id', Integer(), table=<obituaries>, primary_key=True, nullable=False), Column('name', String(), table=<obituaries>), Column('text', String(), table=<obituaries>), Column('birth_place', String(), table=<obituaries>), Column('residence', String(), table=<obituaries>), Column('birth_date', Date(), table=<obituaries>), Column('death_date', Date(), table=<obituaries>), schema=None)

In [ ]:

    




    

In [ ]: