def connect(self, configname=None):
"""Connect to a database based upon its `nickname`.
See ipydb.magic.connect() for details.
"""
default, configs = engine.getconfigs()
success = False
def available():
print(self.connect.__doc__)
print("Available connection nicknames: %s" %
(' '.join(sorted(configs.keys()))))
if not configname:
available()
elif configname not in configs:
print("Config `%s` not found. " % configname)
available()
else:
config = configs[configname]
connect_args = {}
success = self.connect_url(engine.make_connection_url(config),
connect_args)
if success:
self.nickname = configname
return success
def connect(self, configname=None):
"""Connect to a database based upon its `nickname`.
See ipydb.magic.connect() for details.
"""
default, configs = engine.getconfigs()
success = False
def available():
print(self.connect.__doc__)
print("Available connection nicknames: %s" % (
' '.join(sorted(configs.keys()))))
if not configname:
available()
elif configname not in configs:
print("Config `%s` not found. " % configname)
available()
else:
config = configs[configname]
connect_args = {}
success = self.connect_url(
engine.make_connection_url(config), connect_args)
if success:
self.nickname = configname
return success
def connection_nickname(self, ev):
"""Return completions for %connect."""
keys = sorted(getconfigs()[1].keys())
if not ev.symbol:
return keys
matches = match_lists([keys], ev.symbol)
matches.sort()
return matches
def connection_nickname(self, ev):
"""Return completions for %connect."""
keys = sorted(getconfigs()[1].keys())
if not ev.symbol:
return keys
matches = match_lists([keys], ev.symbol)
matches.sort()
return matches
def __init__(self, shell=None, config=None):
"""Constructor.
Args:
shell: An instance of IPython.core.InteractiveShell.
config: IPython's config object.
"""
super(SqlPlugin, self).__init__(shell=shell, config=config)
self.auto_magics = SqlMagics(self, shell)
shell.register_magics(self.auto_magics)
register_sql_aliases(shell.magics_manager, self.auto_magics)
self.sqlformat = 'table' # 'table' | 'csv'
self.do_reflection = True
self.connected = False
self.engine = None
self.nickname = None
self.autocommit = False
self.trans_ctx = None
self.debug = False
self.show_sql = False
default, configs = engine.getconfigs()
self.init_completer()
if default:
self.connect(default)
def __init__(self, shell=None, config=None):
"""Constructor.
Args:
shell: An instance of IPython.core.InteractiveShell.
config: IPython's config object.
"""
super(SqlPlugin, self).__init__(shell=shell, config=config)
self.auto_magics = SqlMagics(self, shell)
shell.register_magics(self.auto_magics)
register_sql_aliases(shell.magics_manager, self.auto_magics)
self.sqlformat = 'table' # 'table' | 'csv'
self.do_reflection = True
self.connected = False
self.engine = None
self.nickname = None
self.autocommit = False
self.trans_ctx = None
self.debug = False
self.show_sql = False
default, configs = engine.getconfigs()
self.init_completer()
if default:
self.connect(default)