Notes

from flask import Flask
from sqlalchemy import Table, Column, Integer, String, MetaData, ForeignKey
from flask_sqlalchemy import SQLAlchemy
from flask.ext.restless import APIManager
#from flask_restless import APIManager
from flask import jsonify,request
from flask_marshmallow import Marshmallow
from flask_cors import CORS
from datetime import datetime

app = Flask(__name__)
cors = CORS(app, resources={r"/api/*": {"origins": "*"}})
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root:root@localhost/MyBlog'
db = SQLAlchemy(app)
ma = Marshmallow(app)


class Katogoriler(db.Model):
__tablename__="katogoriler"
id = db.Column('id',db.Integer, primary_key = True)
katogori_ismi = db.Column("katogori_ismi",db.String(225))
yazilar=db.relationship('Yazilar', backref='kat')
class Kulanicilar(db.Model):
__tablename__="kulanicilar"
id=db.Column(db.Integer,primary_key=True)
kAdi=db.Column(db.String(225))
kSifre=db.Column(db.String(225))
kEposta=db.Column(db.String(225))
yazilar=db.relationship('Yazilar', backref='author')
class Yazilar(db.Model):
__tablename__="yazi_tablosu"
id=db.Column(db.Integer,primary_key=True)
yorumlar=db.relationship('Yorumlar', backref='yrum')
yazi_basligi=db.Column(db.String(225))
yazi_icerigi=db.Column(db.String)
yazi_yayin_tarihi=db.Column(db.Date, default=datetime.now())
katogori_id=db.Column(db.Integer, db.ForeignKey('katogoriler.id'))
yazar_id=db.Column(db.Integer, db.ForeignKey('kulanicilar.id'))
class Yorumlar(db.Model):
__tablename__="yorumlar"
id=db.Column(db.Integer,primary_key=True)
yazi_id=db.Column(db.Integer, db.ForeignKey('yazi_tablosu.id'))
yazar = db.Column(db.String(225))
yorum=db.Column(db.String)
isPublish=db.Column(db.Integer)
yTarihi=db.Column(db.Date, default=datetime.now())

manager=APIManager(app,flask_sqlalchemy_db=db)
#manager.create_api(Katogoriler)
#manager.create_api(Kulanicilar)
#manager.create_api(Yorumlar)
#manager.create_api(Yazilar)
class KatagoriSchema(ma.Schema):
class Meta:
# Fields to expose
fields = ('id', 'katogori_ismi')

katagori_schema = KatagoriSchema()
katagoriler_schema = KatagoriSchema(many=True)

class YazilarSchema(ma.Schema):
class Meta:
# Fields to expose
fields = ('id','yazi_basligi','yazi_icerigi','yazi_yayin_tarihi')

yazi_schema = YazilarSchema()
yazilar_schema = YazilarSchema(many=True)

class UserSchema(ma.Schema):
class Meta:
# Fields to expose
fields = ('id','kAdi','kEposta')

user_schema = UserSchema()


@app.after_request
def after_request(response):
response.headers.add('Access-Control-Allow-Origin', '*')
response.headers.add('Access-Control-Allow-Headers', 'Content-Type,Authorization')
response.headers.add('Access-Control-Allow-Methods', 'GET,PUT,POST,DELETE')
return response


@app.route("/katagoriler/")
def katagoriler():
katagoriler = Katogoriler.query.all()
result = katagoriler_schema.dump(katagoriler)
return jsonify(result.data)

@app.route("/yazilar/")
def yazilar():
yazilar = Yazilar.query.all()
result = yazilar_schema.dump(yazilar)
return jsonify(result.data)
@app.route("/login", methods=['GET', 'POST'])
def login():
content = request.json
print content
userr= Kulanicilar.query.filter_by(kEposta=content['email'],kSifre=content['password']).first()
r=user_schema.dump(userr).data
return jsonify(r)
@app.route("/newContent", methods=['POST'])
def insertContent():
content = request.json
print content
db.session.add(Yazilar(yazi_basligi=content['yazi_basligi'], yazi_icerigi=content['yazi_icerigi'], katogori_id=content['katogori_id'], yazar_id=content['yazar_id'] ))
db.session.commit()
return 'ok'

if __name__ == "__main__":
app.run(debug=True)