3-Factor-Algorithm-based-on-Team-Performance/DatabaseView.py at master · dhairyya/3-Factor-Algorithm-based-on-Team-Performance · GitHub

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
55
56
57
58
59
60
61
62
63
64
65
66
# -*- coding: utf-8 -*-
"""
Created on Sun Apr 08 14:04:16 2018

@author: Dhairyya
"""

import sqlite3
import time

connection=sqlite3.connect("myTable.db")

crsr=connection.cursor()

crsr.execute("SELECT * from fieldValue where year=2017")


data=crsr.fetchall()

for row in data:
    print row
    time.sleep(1)


"""
Table schema:

    IPLBatValue2018:
        entry_number PRIMARY KEY INTEGER AUTOINCREMENT
        name VARCHAR(50)
        battingValue REAL
        matchImp REAL

    IPLBowlValue2018:
        entry_number PRIMARY KEY INTEGER AUTOINCREMENT
        name VARCHAR(50)
        bowlingValue REAL
        matchImp REAL

    IPLFieldValue2018:
        entry_number PRIMARY KEY INTEGER AUTOINCREMENT
        name VARCHAR(50)
        fieldingValue REAL
        matchImp REAL

    batValue:
        entry_number PRIMARY KEY INTEGER AUTOINCREMENT
        name VARCHAR(50)
        value REAL
        year INT
        matchImp REAL

    bowlValue:
        entry_number PRIMARY KEY INTEGER AUTOINCREMENT
        name VARCHAR(50)
        value REAL
        year INT
        matchImp REAL

    fieldValue:
        entry_number PRIMARY KEY INTEGER AUTOINCREMENT
        name VARCHAR(50)
        value REAL
        year INT
        matchImp REAL
"""