database.py
Anmolkalia (Anmol Kalia)
Actions

Authored By

	Anmolkalia
	Oct 11 2015, 9:30 AM

Size

869 B

Referenced Files

None

Subscribers

None

database.py
View Options

	from sqlalchemy.ext.declarative import declarative_base
	from datetime import datetime
	from sqlalchemy import Table, Column, Integer, String, MetaData, DateTime, Text, SmallInteger


	Base = declarative_base()

	class wiki_pages_revs(Base):

	__tablename__ = 'Wiki_pages_revs'

	id = Column(Integer, nullable = False, primary_key = True)
	rev_id = Column(Integer)
	user = Column(String(255), nullable = False)
	date = Column(DateTime, nullable = False)
	comment = Column(Text)



	class wiki_pages (Base):

	__tablename__ = 'Wiki_pages'

	page_id = Column(Integer, primary_key = True, autoincrement = False)
	namespace = Column(SmallInteger)
	title = Column(String(255), nullable = False)



	class people(Base):

	__tablename__ = 'People'

	id = Column(Integer, nullable = False, primary_key = True)
	name = Column(String(255), nullable = False)