FilesExpand file tree

 rm-gitcommit

/

dbconnect.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

24 lines (17 loc) · 571 Bytes

 rm-gitcommit

/

dbconnect.py

Copy path

Top

File metadata and controls

• Code
• Blame

24 lines (17 loc) · 571 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

#!/usr/bin/env python2.7

import MySQLdb

try: from db_private import DB_USER

except: DB_USER = "root" # customise for your install

try: from db_private import DB_PASS

except: DB_PASS = "root" # customise

try: from db_private import DB_NAME

except: DB_NAME = "observatory_api"

TEST_DB_NAME = "tmp_TESTDB1"

def dbconnect():

db = MySQLdb.connect(user=DB_USER, passwd=DB_PASS, db=DB_NAME)

dbc = db.cursor()

return db,dbc

def dbconnecttest():

db = MySQLdb.connect(user=DB_USER, passwd=DB_PASS, db=TEST_DB_NAME)

dbc = db.cursor()

return db,dbc