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')