コード例 #1
0
    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
コード例 #2
0
ファイル: plugin.py プロジェクト: jaysw/ipydb
    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
コード例 #3
0
ファイル: completion.py プロジェクト: printsclub/ipydb
 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
コード例 #4
0
ファイル: completion.py プロジェクト: jaysw/ipydb
 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
コード例 #5
0
    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)
コード例 #6
0
ファイル: plugin.py プロジェクト: jaysw/ipydb
    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)