Advertisement
Guest User

login sqlachemy

a guest
Dec 18th, 2022
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.98 KB | Source Code | 0 0
  1. from flask import Flask, request,render_template,url_for
  2. from flask_sqlalchemy import SQLAlchemy
  3. from flask_login import UserMixin
  4. from sqlalchemy import create_engine
  5.  
  6.  
  7.  
  8. import psycopg2
  9. try:
  10.    conn = psycopg2.connect(host="localhost",
  11.                             user="postgres",
  12.                             password="haslo",
  13.                             database="Wypozyczalnia samochodow")
  14. except:
  15.     print("Show error")
  16. mycursor =conn.cursor()
  17.  
  18. engine = create_engine('postgresql+psycopg2://postgres:haslo@localhost/Wypozyczalnia samochodow')
  19.  
  20. app = Flask(__name__)
  21. db = SQLAlchemy(app)
  22. app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://postgres:haslo@localhost/Wypozyczalnia samochodow'
  23. app.config['SECRET_KEY'] ='sekretnyklucz'
  24.  
  25. class User(db.Model,UserMixin):
  26.     _tablename_ = 'uzytkownicy'
  27.     id = db.Column(db.Integer,primary_key=True)
  28.     username = db.Column(db.String(20),unique=True,nullable=False)
  29.     password = db.Column(db.String(80),nullable=False)
  30.  
  31.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement