FilesExpand file tree

 master

/

readdb.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

18 lines (13 loc) · 418 Bytes

 master

/

readdb.py

Copy path

Top

File metadata and controls

• Code
• Blame

18 lines (13 loc) · 418 Bytes

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

#!/usr/bin/env python

# coding=utf-8

from db import *

def select_table(table, column, condition, value ):

sql = "select " + column + " from " + table + " where " + condition + "='" + value + "'"

cur.execute(sql)

lines = cur.fetchall()

return lines

def select_columns(table, column ):

sql = "select " + column + " from " + table

cur.execute(sql)

lines = cur.fetchall()

return lines