database.py
Anmolkalia (Anmol Kalia)
Actions

Authored By

	Anmolkalia
	Oct 17 2015, 12:51 PM

Size

1 KB

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)
	__table_args__ = { 'mysql_engine': 'MyISAM', 'mysql_charset': 'utf8', 'mysql_collate': 'utf8_general_ci' }



	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)
	__table_args__ = { 'mysql_engine': 'MyISAM', 'mysql_charset': 'utf8', 'mysql_collate': 'utf8_general_ci' }



	class people(Base):

	__tablename__ = 'People'

	id = Column(Integer, nullable = False, primary_key = True)
	name = Column(String(255), nullable = False)
	__table_args__ = { 'mysql_engine': 'MyISAM', 'mysql_charset': 'utf8', 'mysql_collate': 'utf8_general_ci' }