FilesExpand file tree

 master

/

sqlite_check.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

54 lines (40 loc) · 1.03 KB

 master

/

sqlite_check.py

Copy path

Top

File metadata and controls

• Code
• Blame

54 lines (40 loc) · 1.03 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

45

46

47

48

49

50

51

52

53

54

# Script Name : sqlite_check.py

# Author : Craig Richards

# Created : 20 May 2013

# Last Modified :

# Version : 1.0

# Modifications :

# Description : Runs checks to check my SQLITE database

import sqlite3 as lite

import sys

import os

dropbox= os.getenv("dropbox")

dbfile=("Databases\jarvis.db")

master_db=os.path.join(dropbox, dbfile)

con = None

try:

con = lite.connect(master_db)

cur = con.cursor()

cur.execute('SELECT SQLITE_VERSION()')

data = cur.fetchone()

print "SQLite version: %s" % data

except lite.Error, e:

print "Error %s:" % e.args[0]

sys.exit(1)

finally:

if con:

con.close()

con = lite.connect(master_db)

cur=con.cursor()

cur.execute("SELECT name FROM sqlite_master WHERE type='table'")

rows = cur.fetchall()

for row in rows:

print row

con = lite.connect(master_db)

cur=con.cursor()

cur.execute("SELECT name FROM sqlite_master WHERE type='table'")

while True:

row = cur.fetchone()

if row == None:

break

print row[0]