FilesExpand file tree

 master

/

model.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

28 lines (23 loc) · 775 Bytes

 master

/

model.py

Copy path

Top

File metadata and controls

• Code
• Blame

28 lines (23 loc) · 775 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

18

19

20

21

22

23

24

25

26

27

28

import os

import MySQLdb

class Storage(object):

def __init__(self):

self.db = MySQLdb.connect(

user = os.getenv('MYSQL_USERNAME'),

passwd = os.getenv('MYSQL_PASSWORD'),

db = os.getenv('MYSQL_INSTANCE_NAME'),

host = os.getenv('MYSQL_PORT_3306_TCP_ADDR'),

port = int(os.getenv('MYSQL_PORT_3306_TCP_PORT'))

)

cur = self.db.cursor()

cur.execute("CREATE TABLE IF NOT EXISTS scores(score INT)")

cur.execute("INSERT INTO scores(score) VALUES(1234)")

def score(self):

cur = self.db.cursor()

cur.execute("SELECT * FROM scores")

row = cur.fetchone()

return row[0]

def update_score(self, score):

cur = self.db.cursor()

cur.execute("UPDATE scores set score=%d" % score)

storage = Storage()