class User(db.Model):
	id = db.Column(db.Integer, primary_key=True)
	username = db.Column(db.String(80), unique=True)
	password = db.Column(db.String(80))
	email = db.Column(db.String(120))
	date_joined = db.Column(db.DateTime)
	submissions = db.relationship('Submission', backref='user', lazy='dynamic')
	comments = db.relationship('Comments', backref='user', lazy='dynamic')
	karma = db.Column(db.Integer)

	def __init__(self, username, password, email, date_joined=None, karma=0):
		self.username = username
		self.password = password
		self.email = email
		if date_joined = None:
			date_joined = datetime.utcnow()
		self.date_joined = date_joined
		self.karma = karma

	def __repr__(self):
		return '<User %r>' % self.username


class Submission(db.Model):
	id = db.Column(db.Integer, primary_key=True)
	user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
	date_submitted = db.Column(db.DateTime)
	title = db.Column(db.String(100), required=True)
	body = db.Column(db.Text)
	link = db.Column(db.Text)
	points = db.Column(db.Integer)
	comments = db.relationship('Comments', backref='user', lazy='dynamic')

	def __init__(self, user_id, date_submitted=None, title, body=None, link=None, points=1):
		self.user_id = user_id
		if date_submitted = None:
			date_submitted = datetime.utcnow()
		self.title = title
		self.body = body
		self.link = link
		self.points = points

	def __repr__(self):
		return '<Submission %r>' % self.title


class Comments(db.Model):
	id = db.Column(db.Integer, primary_key=True)
	user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
	submission_id = db.Column(db.Integer, db.ForeignKey('submission.id'))
	children = db.Column(db.Text)
	date_submitted = db.Column(db.DateTime)
	body = db.Column(db.Text)
	points = db.Column(db.Integer)

	def __init__(self, user_id, submission_id, children=None, date_submitted=None, body, points=1):
		self.user_id = user_id
		self.submission_id = submission_id
		self.children = children
		if date_submitted = None:
			date_submitted = datetime.utcnow()
		self.body = body
		points = points

	def get_children(self):
		if self.children not None:
			return children = self.children.split(" ")
		return None