FilesExpand file tree

 develop

/

sqlite.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

44 lines (31 loc) · 2.2 KB

 develop

/

sqlite.py

Copy path

Top

File metadata and controls

• Code
• Blame

44 lines (31 loc) · 2.2 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

35

36

37

38

39

40

41

42

43

44

import logging

import sys

sys.path.insert(0, "../src")

from cs50 import SQL

logging.getLogger("cs50").disabled = False

db = SQL("sqlite:///sqlite.db")

db.execute("SELECT 1")

# TODO

#db.execute("SELECT * FROM Employee WHERE FirstName = ?", b'\x00')

db.execute("SELECT * FROM Employee WHERE FirstName = ?", "' OR 1 = 1")

db.execute("SELECT * FROM Employee WHERE FirstName IN (?)", "Andrew")

db.execute("SELECT * FROM Employee WHERE FirstName IN (?)", ["Andrew"])

db.execute("SELECT * FROM Employee WHERE FirstName IN (?)", ("Andrew",))

db.execute("SELECT * FROM Employee WHERE FirstName IN (?)", ["Andrew", "Nancy"])

db.execute("SELECT * FROM Employee WHERE FirstName IN (?)", ("Andrew", "Nancy"))

db.execute("SELECT * FROM Employee WHERE FirstName IN (?)", [])

db.execute("SELECT * FROM Employee WHERE FirstName IN (?)", ())

db.execute("SELECT * FROM Employee WHERE FirstName = ? AND LastName = ?", "Andrew", "Adams")

db.execute("SELECT * FROM Employee WHERE FirstName = ? AND LastName = ?", ["Andrew", "Adams"])

db.execute("SELECT * FROM Employee WHERE FirstName = ? AND LastName = ?", ("Andrew", "Adams"))

db.execute("SELECT * FROM Employee WHERE FirstName = :1 AND LastName = :2", "Andrew", "Adams")

db.execute("SELECT * FROM Employee WHERE FirstName = :1 AND LastName = :2", ["Andrew", "Adams"])

db.execute("SELECT * FROM Employee WHERE FirstName = :1 AND LastName = :2", ("Andrew", "Adams"))

db.execute("SELECT * FROM Employee WHERE FirstName = ':Andrew :Adams'")

db.execute("SELECT * FROM Employee WHERE FirstName = :first AND LastName = :last", first="Andrew", last="Adams")

db.execute("SELECT * FROM Employee WHERE FirstName = :first AND LastName = :last", {"first": "Andrew", "last": "Adams"})

db.execute("SELECT * FROM Employee WHERE FirstName = %s AND LastName = %s", "Andrew", "Adams")

db.execute("SELECT * FROM Employee WHERE FirstName = %s AND LastName = %s", ["Andrew", "Adams"])

db.execute("SELECT * FROM Employee WHERE FirstName = %s AND LastName = %s", ("Andrew", "Adams"))

db.execute("SELECT * FROM Employee WHERE FirstName = %(first)s AND LastName = %(last)s", first="Andrew", last="Adams")

db.execute("SELECT * FROM Employee WHERE FirstName = %(first)s AND LastName = %(last)s", {"first": "Andrew", "last": "Adams"})