db

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://root:[password]@157.230.61.38:5432/davetiyem_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)