def get_mysql_connection():
env = os.getenv('SERVER_SOFTWARE')
db_settings = secret_settings.get('DATABASE')['default']
db = None
ssl = None
if 'OPTIONS' in db_settings and 'ssl' in db_settings['OPTIONS']:
ssl = db_settings['OPTIONS']['ssl']
if env and env.startswith(
'Google App Engine/'): # or os.getenv('SETTINGS_MODE') == 'prod':
# Connecting from App Engine
db = connect(
unix_socket='/cloudsql/<YOUR-APP-ID>:<CLOUDSQL-INSTANCE>',
db='',
user='',
)
else:
db = connect(host=db_settings['HOST'],
port=db_settings['PORT'],
db=db_settings['NAME'],
user=db_settings['USER'],
passwd=db_settings['PASSWORD'],
ssl=ssl)
return db
def get_mysql_connection():
db_settings = secret_settings.get(
'DATABASE'
)['default'] if settings.IS_DEV else settings.DATABASES['default']
db = None
ssl = None
if 'OPTIONS' in db_settings and 'ssl' in db_settings['OPTIONS']:
ssl = db_settings['OPTIONS']['ssl']
if settings.IS_APP_ENGINE_FLEX:
# Connecting from App Engine
db = connect(host='localhost',
unix_socket=settings.DB_SOCKET,
db=db_settings['NAME'],
user=db_settings['USER'],
password=db_settings['PASSWORD'])
else:
db = connect(host=db_settings['HOST'],
port=db_settings['PORT'],
db=db_settings['NAME'],
user=db_settings['USER'],
passwd=db_settings['PASSWORD'],
ssl=ssl)
return db
def get_mysql_connection():
env = os.getenv('SERVER_SOFTWARE')
db_settings = secret_settings.get('DATABASE')['default']
db = None
ssl = None
if 'OPTIONS' in db_settings and 'ssl' in db_settings['OPTIONS']:
ssl = db_settings['OPTIONS']['ssl']
if env and env.startswith('Google App Engine/'): # or os.getenv('SETTINGS_MODE') == 'prod':
# Connecting from App Engine
db = connect(
unix_socket='/cloudsql/<YOUR-APP-ID>:<CLOUDSQL-INSTANCE>',
db='',
user='',
)
else:
db = connect(host=db_settings['HOST'], port=db_settings['PORT'], db=db_settings['NAME'], user=db_settings['USER'], passwd=db_settings['PASSWORD'], ssl=ssl)
return db
import os
import MySQLdb
import logging
import traceback
import sys
from GenespotRE import secret_settings
logging.basicConfig(level=logging.INFO)
db = None
cursor = None
try:
db_settings = secret_settings.get('DATABASE')['default']
ssl = None
if 'OPTIONS' in db_settings and 'ssl' in db_settings['OPTIONS']:
ssl = db_settings['OPTIONS']['ssl']
db = MySQLdb.connect(host=db_settings['HOST'],
port=db_settings['PORT'],
db=db_settings['NAME'],
user=db_settings['USER'],
passwd=db_settings['PASSWORD'],
ssl=ssl)
delete_str = 'DELETE FROM django_site WHERE id in (2, 3, 4, 5);'
insert_str = 'INSERT INTO django_site (id, domain, name) VALUES (%s, %s, %s), (%s, %s, %s), (%s, %s, %s), (%s, %s, %s);'
insert_tuple = ('2', 'localhost:8000', 'localhost:8000')
insert_tuple += ('3', 'localhost:8080', 'localhost:8080')
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
"""
import os
import MySQLdb
import logging
from GenespotRE import secret_settings
logging.basicConfig(level=logging.INFO)
db_settings = secret_settings.get('DATABASE')['default']
ssl = None
if 'OPTIONS' in db_settings and 'ssl' in db_settings['OPTIONS']:
ssl = db_settings['OPTIONS']['ssl']
db = MySQLdb.connect(host=db_settings['HOST'], port=db_settings['PORT'], db=db_settings['NAME'], user=db_settings['USER'], passwd=db_settings['PASSWORD'], ssl=ssl)
delete_str = 'DELETE FROM django_site WHERE id in (2, 3, 4, 5);'
insert_str = 'INSERT INTO django_site (id, domain, name) VALUES (%s, %s, %s), (%s, %s, %s), (%s, %s, %s), (%s, %s, %s);'
insert_tuple = ('2', 'localhost:8000', 'localhost:8000')
insert_tuple += ('3', 'localhost:8080', 'localhost:8080')
#these should be moved to the env file
insert_tuple += ('4', 'mvm-dot-lsdf-cgc.appspot.com', 'mvm-dot-lsdf-cgc.appspot.com')
insert_tuple += ('5', 'avance.bio', 'avance.bio')
