From 6043b1e054be92d4282d886b0d53c8403e8eddc1 Mon Sep 17 00:00:00 2001
From: Guillaume Horel <guillaume.horel@gmail.com>
Date: Tue, 17 Sep 2013 22:48:31 -0400
Subject: python models of the sql tables

---
 tables.py | 64 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 64 insertions(+)
 create mode 100644 tables.py

diff --git a/tables.py b/tables.py
new file mode 100644
index 0000000..84624f2
--- /dev/null
+++ b/tables.py
@@ -0,0 +1,64 @@
+from flask import Flask
+from flask.ext.sqlalchemy import SQLAlchemy
+
+app = Flask(__name__)
+app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////tmp/test.db'
+db = SQLAlchemy(app)
+
+
+class User(db.Model):
+    id = db.Column(db.Integer, primary_key=True)
+    user_name = db.Column(db.String, nullable=False)
+    password = db.Column(db.String, nullable=False)
+    last_seen = db.Column(db.TIMESTAMP, default=db.func.current_timestamp())
+    birthday = db.Column(db.String)
+    nameday = db.Column(db.String)
+    notify = db.Column(db.Boolean, default=True)
+    email = db.Column(db.String)
+    phone = db.Column(db.String)
+    address_line1 = db.Column(db.String)
+    address_line2 = db.Column(db.String)
+    address_city_line = db.Column(db.String)
+    timezone = db.Column(db.String)
+    kado = db.Column(db.String)
+
+    def __init__(self, user_name, passowrd):
+        self.user_name = user_name
+        self.password = password
+
+    def __repr__(self):
+        return '<User {0}>'.format(self.username)
+
+class News(db.Model):
+    id = db.Column(db.Integer, primary_key=True)
+    title = db.Column(db.String, nullable=False)
+    date = db.Column(db.TIMESTAMP, default=db.func.current_timestamp())
+    content = db.Column(db.String, nullable=False)
+    content_cache = db.Column(db.String)
+    user_id = db.Column(db.Integer, db.Foreignkey('user.id'))
+    comments = relationship("Comments")
+    user = relationship("Users", backref)
+
+    def __init__(self, user_id, title, content):
+        self.user_id = user.id
+        self.title = title
+        self.content = content
+
+    def __repr__(self):
+        return '<News {0}>'.format(self.title)
+
+class Comments(db.Model):
+    id = db.Column(db.Integer, primary_key=True)
+    date = db.Column(db.TIMESTAMP, default=db.func.current_timestamp())
+    content = db.Column(db.String)
+    content_cache = db.Column(db.String)
+    user_id = db.Column(db.Integer, db.Foreignkey('user.id'))
+    news_id = db.Column(db.Integer, db.Foreignkey('news.id'))
+
+    def __init__(self, user_id, news_id, content):
+        self.user_id = user_id
+        self.news_id = news_id
+        self.content = content
+
+    def __repr__(self):
+        return '<Comments {0}>'.format(self.content)
-- 
cgit v1.2.3-70-g09d2