forked from EN10/FlaskLogin
-
Notifications
You must be signed in to change notification settings - Fork 1
/
first_db.py
34 lines (30 loc) · 708 Bytes
/
first_db.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
from flask import Flask
import sqlite3
app = Flask(__name__)
@app.route('/create')
def create():
con = sqlite3.connect('login.db')
cur = con.cursor()
cur.execute( """ CREATE TABLE Users(
Username VARCHAR(20) NOT NULL PRIMARY KEY,
Password VARCHAR(20) NOT NULL
)
""")
con.commit()
return 'CREATE'
@app.route('/insert')
def insert():
con = sqlite3.connect('login.db')
cur = con.cursor()
cur.execute( """ INSERT INTO Users (Username, Password)
VALUES ("Bob", "123")
""")
con.commit()
return 'INSERT'
@app.route('/select')
def select():
con = sqlite3.connect('login.db')
cur = con.cursor()
cur.execute("SELECT * FROM Users")
rows = cur.fetchall()
return str(rows)