Skip to content

Instantly share code, notes, and snippets.

@berat
Last active January 13, 2019 15:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save berat/3abaa37fa80689a8e3ed7ec08faee471 to your computer and use it in GitHub Desktop.
Save berat/3abaa37fa80689a8e3ed7ec08faee471 to your computer and use it in GitHub Desktop.
from flask_sqlalchemy import SQLAlchemy
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////Users/bozkurt/Desktop/veritabani.db'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True
db = SQLAlchemy(app)
class users(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80))
email = db.Column(db.String(120))
password = db.Column(db.String(80))
class bilgi(db.Model):
id = db.Column(db.Integer, primary_key=True)
siteAdi = db.Column(db.String(80))
Aciklama = db.Column(db.String(80))
#query
user = users.query.filter_by(username=usernmae).first()
#add
ekle = bilgi(id = id,aciklama=text)
db.session.add(ekle)
db.session.commit()
if __name__ == "__main__":
db.create_all()
app.run(debug=False)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment