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 python
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
|
