• ca_certs Char
  help='Path to CA Certs file on server.'
• client_cert Text
• client_key Text
• company_id Many2one → res.company
  comodel_name='res.company' default=<expr> string='Company'
• conn_string Text
  help="\n Sample connection strings:\n - Microsoft SQL Server:\n mssql+pymssql://username:%s@server:port/dbname?charset=utf8\n - MySQL: mysql://user:%s@server:port/dbname\n - ODBC: DRIVER={FreeTDS};SERVER=server.address;Database=mydb;UID=sa\n - ORACLE: username/%s@//server.address:port/instance\n - PostgreSQL:\n dbname='template1' user='dbuser' host='localhost' port='5432' password=%s\n - SQLite: sqlite:///test.db\n - Elasticsearch: https://user:%s@localhost:9200\n " args: 'Connection string'
• conn_string_full Text
  compute='_compute_conn_string_full' readonly=True
• connector Selection
  help='If a connector is missing from the list, check the server log to confirm that the required components were detected.' required=True args: CONNECTORS
• name Char
  required=True args: 'Datasource name'
• password Char

• change_table(self, name)
  Change the table that is used for CRUD operations
• conn_open(self)
  It opens and returns a connection to the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Deprecate: This method has been replaced with ``connection_open``.
• connection_close(self, connection)
  It closes the connection to the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_close_postgresql(self, connection)
• connection_open(self)
  @contextmanager
  It provides a context manager for the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_open_postgresql(self)
• connection_test(self)
  It tests the connection Raises: Validation message with the result of the connection (fail or success)
• execute(self, query=None, execute_params=None, metadata=False, **kwargs)
  Executes a query and returns a list of rows. "execute_params" can be a dict of values, that can be referenced in the SQL statement using "%(key)s" or, in the case of Oracle, ":key". Example: query = "SELECT * FROM mytable WHERE city = %(city)s AND date > %(dt)s" execute_params = { 'city': 'Lisbon', 'dt': datetime.datetime(2000, 12, 31), } If metadata=True, it will instead return a dict containing the rows list and the columns list, in the format: { 'cols': [ 'col_a', 'col_b', ...] , 'rows': [ (a0, b0, ...), (a1, b1, ...), ...] }
• execute_postgresql(self, query, params, metadata)
• remote_browse(self, record_ids, *args, **kwargs)
  It browses for and returns the records from remote by ID This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to browse. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match the ID.
• remote_create(self, vals, *args, **kwargs)
  It creates a record on the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Args: vals: (dict) Values to use for creation. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (mapping) A mapping of the record that was created.
• remote_delete(self, record_ids, *args, **kwargs)
  It deletes records by ID on remote This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of bools indicating delete status.
• remote_search(self, query, *args, **kwargs)
  It searches the remote for the query. This method calls adapter method of this same name, suffixed with the adapter type. Args: query: (mixed) Query domain as required by the adapter. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match query.
• remote_update(self, record_ids, vals, *args, **kwargs)
  It updates the remote records with the vals This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that were updated.

• ca_certs Char
  help='Path to CA Certs file on server.'
• client_cert Text
• client_key Text
• company_id Many2one → res.company
  comodel_name='res.company' default=<expr> string='Company'
• conn_string Text
  help="\n Sample connection strings:\n - Microsoft SQL Server:\n mssql+pymssql://username:%s@server:port/dbname?charset=utf8\n - MySQL: mysql://user:%s@server:port/dbname\n - ODBC: DRIVER={FreeTDS};SERVER=server.address;Database=mydb;UID=sa\n - ORACLE: username/%s@//server.address:port/instance\n - PostgreSQL:\n dbname='template1' user='dbuser' host='localhost' port='5432' password=%s\n - SQLite: sqlite:///test.db\n - Elasticsearch: https://user:%s@localhost:9200\n " args: 'Connection string'
• conn_string_full Text
  compute='_compute_conn_string_full' readonly=True
• connector Selection
  help='If a connector is missing from the list, check the server log to confirm that the required components were detected.' required=True args: CONNECTORS
• name Char
  required=True args: 'Datasource name'
• password Char

• change_table(self, name)
  Change the table that is used for CRUD operations
• conn_open(self)
  It opens and returns a connection to the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Deprecate: This method has been replaced with ``connection_open``.
• connection_close(self, connection)
  It closes the connection to the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_close_postgresql(self, connection)
• connection_open(self)
  @contextmanager
  It provides a context manager for the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_open_postgresql(self)
• connection_test(self)
  It tests the connection Raises: Validation message with the result of the connection (fail or success)
• execute(self, query=None, execute_params=None, metadata=False, **kwargs)
  Executes a query and returns a list of rows. "execute_params" can be a dict of values, that can be referenced in the SQL statement using "%(key)s" or, in the case of Oracle, ":key". Example: query = "SELECT * FROM mytable WHERE city = %(city)s AND date > %(dt)s" execute_params = { 'city': 'Lisbon', 'dt': datetime.datetime(2000, 12, 31), } If metadata=True, it will instead return a dict containing the rows list and the columns list, in the format: { 'cols': [ 'col_a', 'col_b', ...] , 'rows': [ (a0, b0, ...), (a1, b1, ...), ...] }
• execute_postgresql(self, query, params, metadata)
• remote_browse(self, record_ids, *args, **kwargs)
  It browses for and returns the records from remote by ID This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to browse. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match the ID.
• remote_create(self, vals, *args, **kwargs)
  It creates a record on the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Args: vals: (dict) Values to use for creation. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (mapping) A mapping of the record that was created.
• remote_delete(self, record_ids, *args, **kwargs)
  It deletes records by ID on remote This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of bools indicating delete status.
• remote_search(self, query, *args, **kwargs)
  It searches the remote for the query. This method calls adapter method of this same name, suffixed with the adapter type. Args: query: (mixed) Query domain as required by the adapter. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match query.
• remote_update(self, record_ids, vals, *args, **kwargs)
  It updates the remote records with the vals This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that were updated.

• ca_certs Char
  help='Path to CA Certs file on server.'
• client_cert Text
• client_key Text
• company_id Many2one → res.company
  comodel_name='res.company' default=<expr> string='Company'
• conn_string Text
  help="\n Sample connection strings:\n - Microsoft SQL Server:\n mssql+pymssql://username:%s@server:port/dbname?charset=utf8\n - MySQL: mysql://user:%s@server:port/dbname\n - ODBC: DRIVER={FreeTDS};SERVER=server.address;Database=mydb;UID=sa\n - ORACLE: username/%s@//server.address:port/instance\n - PostgreSQL:\n dbname='template1' user='dbuser' host='localhost' port='5432' password=%s\n - SQLite: sqlite:///test.db\n - Elasticsearch: https://user:%s@localhost:9200\n " args: 'Connection string'
• conn_string_full Text
  compute='_compute_conn_string_full' readonly=True
• connector Selection
  help='If a connector is missing from the list, check the server log to confirm that the required components were detected.' required=True args: CONNECTORS
• name Char
  required=True args: 'Datasource name'
• password Char

• change_table(self, name)
  Change the table that is used for CRUD operations
• conn_open(self)
  It opens and returns a connection to the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Deprecate: This method has been replaced with ``connection_open``.
• connection_close(self, connection)
  It closes the connection to the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_close_postgresql(self, connection)
• connection_open(self)
  @contextmanager
  It provides a context manager for the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_open_postgresql(self)
• connection_test(self)
  It tests the connection Raises: Validation message with the result of the connection (fail or success)
• execute(self, query=None, execute_params=None, metadata=False, **kwargs)
  Executes a query and returns a list of rows. "execute_params" can be a dict of values, that can be referenced in the SQL statement using "%(key)s" or, in the case of Oracle, ":key". Example: query = "SELECT * FROM mytable WHERE city = %(city)s AND date > %(dt)s" execute_params = { 'city': 'Lisbon', 'dt': datetime.datetime(2000, 12, 31), } If metadata=True, it will instead return a dict containing the rows list and the columns list, in the format: { 'cols': [ 'col_a', 'col_b', ...] , 'rows': [ (a0, b0, ...), (a1, b1, ...), ...] }
• execute_postgresql(self, query, params, metadata)
• remote_browse(self, record_ids, *args, **kwargs)
  It browses for and returns the records from remote by ID This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to browse. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match the ID.
• remote_create(self, vals, *args, **kwargs)
  It creates a record on the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Args: vals: (dict) Values to use for creation. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (mapping) A mapping of the record that was created.
• remote_delete(self, record_ids, *args, **kwargs)
  It deletes records by ID on remote This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of bools indicating delete status.
• remote_search(self, query, *args, **kwargs)
  It searches the remote for the query. This method calls adapter method of this same name, suffixed with the adapter type. Args: query: (mixed) Query domain as required by the adapter. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match query.
• remote_update(self, record_ids, vals, *args, **kwargs)
  It updates the remote records with the vals This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that were updated.

• ca_certs Char
  help='Path to CA Certs file on server.'
• client_cert Text
• client_key Text
• company_id Many2one → res.company
  comodel_name='res.company' default=<expr> string='Company'
• conn_string Text
  help="\n Sample connection strings:\n - Microsoft SQL Server:\n mssql+pymssql://username:%s@server:port/dbname?charset=utf8\n - MySQL: mysql://user:%s@server:port/dbname\n - ODBC: DRIVER={FreeTDS};SERVER=server.address;Database=mydb;UID=sa\n - ORACLE: username/%s@//server.address:port/instance\n - PostgreSQL:\n dbname='template1' user='dbuser' host='localhost' port='5432' password=%s\n - SQLite: sqlite:///test.db\n - Elasticsearch: https://user:%s@localhost:9200\n " args: 'Connection string'
• conn_string_full Text
  compute='_compute_conn_string_full' readonly=True
• connector Selection
  help='If a connector is missing from the list, check the server log to confirm that the required components were detected.' required=True args: CONNECTORS
• name Char
  required=True args: 'Datasource name'
• password Char

• change_table(self, name)
  Change the table that is used for CRUD operations
• conn_open(self)
  It opens and returns a connection to the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Deprecate: This method has been replaced with ``connection_open``.
• connection_close(self, connection)
  It closes the connection to the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_close_postgresql(self, connection)
• connection_open(self)
  @contextmanager
  It provides a context manager for the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_open_postgresql(self)
• connection_test(self)
  It tests the connection Raises: Validation message with the result of the connection (fail or success)
• execute(self, query=None, execute_params=None, metadata=False, **kwargs)
  Executes a query and returns a list of rows. "execute_params" can be a dict of values, that can be referenced in the SQL statement using "%(key)s" or, in the case of Oracle, ":key". Example: query = "SELECT * FROM mytable WHERE city = %(city)s AND date > %(dt)s" execute_params = { 'city': 'Lisbon', 'dt': datetime.datetime(2000, 12, 31), } If metadata=True, it will instead return a dict containing the rows list and the columns list, in the format: { 'cols': [ 'col_a', 'col_b', ...] , 'rows': [ (a0, b0, ...), (a1, b1, ...), ...] }
• execute_postgresql(self, query, params, metadata)
• remote_browse(self, record_ids, *args, **kwargs)
  It browses for and returns the records from remote by ID This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to browse. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match the ID.
• remote_create(self, vals, *args, **kwargs)
  It creates a record on the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Args: vals: (dict) Values to use for creation. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (mapping) A mapping of the record that was created.
• remote_delete(self, record_ids, *args, **kwargs)
  It deletes records by ID on remote This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of bools indicating delete status.
• remote_search(self, query, *args, **kwargs)
  It searches the remote for the query. This method calls adapter method of this same name, suffixed with the adapter type. Args: query: (mixed) Query domain as required by the adapter. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match query.
• remote_update(self, record_ids, vals, *args, **kwargs)
  It updates the remote records with the vals This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that were updated.

• ca_certs Char
  help='Path to CA Certs file on server.'
• client_cert Text
• client_key Text
• company_id Many2one → res.company
  comodel_name='res.company' default=<expr> string='Company'
• conn_string Text
  help="\n Sample connection strings:\n - Microsoft SQL Server:\n mssql+pymssql://username:%s@server:port/dbname?charset=utf8\n - MySQL: mysql://user:%s@server:port/dbname\n - ODBC: DRIVER={FreeTDS};SERVER=server.address;Database=mydb;UID=sa\n - ORACLE: username/%s@//server.address:port/instance\n - PostgreSQL:\n dbname='template1' user='dbuser' host='localhost' port='5432' password=%s\n - SQLite: sqlite:///test.db\n - Elasticsearch: https://user:%s@localhost:9200\n " args: 'Connection string'
• conn_string_full Text
  compute='_compute_conn_string_full' readonly=True
• connector Selection
  help='If a connector is missing from the list, check the server log to confirm that the required components were detected.' required=True args: CONNECTORS, 'Connector'
• name Char
  required=True args: 'Datasource name'
• password Char
  args: 'Password'

• change_table(self, name)
  Change the table that is used for CRUD operations
• conn_open(self)
  It opens and returns a connection to the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Deprecate: This method has been replaced with ``connection_open``.
• connection_close(self, connection)
  It closes the connection to the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_close_postgresql(self, connection)
• connection_open(self)
  @contextmanager
  It provides a context manager for the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_open_postgresql(self)
• connection_test(self)
  It tests the connection Raises: Validation message with the result of the connection (fail or success)
• execute(self, query=None, execute_params=None, metadata=False, **kwargs)
  Executes a query and returns a list of rows. "execute_params" can be a dict of values, that can be referenced in the SQL statement using "%(key)s" or, in the case of Oracle, ":key". Example: query = "SELECT * FROM mytable WHERE city = %(city)s AND date > %(dt)s" execute_params = { 'city': 'Lisbon', 'dt': datetime.datetime(2000, 12, 31), } If metadata=True, it will instead return a dict containing the rows list and the columns list, in the format: { 'cols': [ 'col_a', 'col_b', ...] , 'rows': [ (a0, b0, ...), (a1, b1, ...), ...] }
• execute_postgresql(self, query, params, metadata)
• remote_browse(self, record_ids, *args, **kwargs)
  It browses for and returns the records from remote by ID This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to browse. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match the ID.
• remote_create(self, vals, *args, **kwargs)
  It creates a record on the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Args: vals: (dict) Values to use for creation. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (mapping) A mapping of the record that was created.
• remote_delete(self, record_ids, *args, **kwargs)
  It deletes records by ID on remote This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of bools indicating delete status.
• remote_search(self, query, *args, **kwargs)
  It searches the remote for the query. This method calls adapter method of this same name, suffixed with the adapter type. Args: query: (mixed) Query domain as required by the adapter. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match query.
• remote_update(self, record_ids, vals, *args, **kwargs)
  It updates the remote records with the vals This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that were updated.

• ca_certs Char
  help='Path to CA Certs file on server.'
• client_cert Text
• client_key Text
• company_id Many2one → res.company
  comodel_name='res.company' default=<expr> string='Company'
• conn_string Text
  help="\n Sample connection strings:\n - Microsoft SQL Server:\n mssql+pymssql://username:%s@server:port/dbname?charset=utf8\n - MySQL: mysql://user:%s@server:port/dbname\n - ODBC: DRIVER={FreeTDS};SERVER=server.address;Database=mydb;UID=sa\n - ORACLE: username/%s@//server.address:port/instance\n - PostgreSQL:\n dbname='template1' user='dbuser' host='localhost' port='5432' password=%s\n - SQLite: sqlite:///test.db\n - Elasticsearch: https://user:%s@localhost:9200\n " args: 'Connection string'
• conn_string_full Text
  compute='_compute_conn_string_full' readonly=True
• connector Selection
  help='If a connector is missing from the list, check the server log to confirm that the required components were detected.' required=True args: CONNECTORS, 'Connector'
• name Char
  required=True size=64 args: 'Datasource name'
• password Char
  size=40 args: 'Password'

• change_table(self, name)
  Change the table that is used for CRUD operations
• conn_open(self)
  It opens and returns a connection to the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Deprecate: This method has been replaced with ``connection_open``.
• connection_close(self, connection)
  It closes the connection to the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_close_postgresql(self, connection)
• connection_open(self)
  @contextmanager
  It provides a context manager for the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_open_postgresql(self)
• connection_test(self)
  It tests the connection Raises: ConnectionSuccessError: On connection success ConnectionFailedError: On connection failed
• execute(self, query=None, execute_params=None, metadata=False, **kwargs)
  Executes a query and returns a list of rows. "execute_params" can be a dict of values, that can be referenced in the SQL statement using "%(key)s" or, in the case of Oracle, ":key". Example: query = "SELECT * FROM mytable WHERE city = %(city)s AND date > %(dt)s" execute_params = { 'city': 'Lisbon', 'dt': datetime.datetime(2000, 12, 31), } If metadata=True, it will instead return a dict containing the rows list and the columns list, in the format: { 'cols': [ 'col_a', 'col_b', ...] , 'rows': [ (a0, b0, ...), (a1, b1, ...), ...] }
• execute_postgresql(self, query, params, metadata)
• remote_browse(self, record_ids, *args, **kwargs)
  It browses for and returns the records from remote by ID This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to browse. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match the ID.
• remote_create(self, vals, *args, **kwargs)
  It creates a record on the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Args: vals: (dict) Values to use for creation. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (mapping) A mapping of the record that was created.
• remote_delete(self, record_ids, *args, **kwargs)
  It deletes records by ID on remote This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of bools indicating delete status.
• remote_search(self, query, *args, **kwargs)
  It searches the remote for the query. This method calls adapter method of this same name, suffixed with the adapter type. Args: query: (mixed) Query domain as required by the adapter. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match query.
• remote_update(self, record_ids, vals, *args, **kwargs)
  It updates the remote records with the vals This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that were updated.

• ca_certs Char
  help='Path to CA Certs file on server.'
• client_cert Text
• client_key Text
• company_id Many2one → res.company
  comodel_name='res.company' default=<expr> string='Company'
• conn_string Text
  help="\n Sample connection strings:\n - Microsoft SQL Server:\n mssql+pymssql://username:%s@server:port/dbname?charset=utf8\n - MySQL: mysql://user:%s@server:port/dbname\n - ODBC: DRIVER={FreeTDS};SERVER=server.address;Database=mydb;UID=sa\n - ORACLE: username/%s@//server.address:port/instance\n - PostgreSQL:\n dbname='template1' user='dbuser' host='localhost' port='5432' password=%s\n - SQLite: sqlite:///test.db\n - Elasticsearch: https://user:%s@localhost:9200\n " args: 'Connection string'
• conn_string_full Text
  compute='_compute_conn_string_full' readonly=True
• connector Selection
  help='If a connector is missing from the list, check the server log to confirm that the required components were detected.' required=True args: CONNECTORS, 'Connector'
• name Char
  required=True size=64 args: 'Datasource name'
• password Char
  size=40 args: 'Password'

• change_table(self, name)
  @api.multi
  Change the table that is used for CRUD operations
• conn_open(self)
  @api.multi
  It opens and returns a connection to the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Deprecate: This method has been replaced with ``connection_open``.
• connection_close(self, connection)
  @api.multi
  It closes the connection to the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_close_postgresql(self, connection)
• connection_open(self)
  @api.multi@contextmanager
  It provides a context manager for the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_open_postgresql(self)
• connection_test(self)
  @api.multi
  It tests the connection Raises: ConnectionSuccessError: On connection success ConnectionFailedError: On connection failed
• execute(self, query=None, execute_params=None, metadata=False, **kwargs)
  @api.multi
  Executes a query and returns a list of rows. "execute_params" can be a dict of values, that can be referenced in the SQL statement using "%(key)s" or, in the case of Oracle, ":key". Example: query = "SELECT * FROM mytable WHERE city = %(city)s AND date > %(dt)s" execute_params = { 'city': 'Lisbon', 'dt': datetime.datetime(2000, 12, 31), } If metadata=True, it will instead return a dict containing the rows list and the columns list, in the format: { 'cols': [ 'col_a', 'col_b', ...] , 'rows': [ (a0, b0, ...), (a1, b1, ...), ...] }
• execute_postgresql(self, query, params, metadata)
• remote_browse(self, record_ids, *args, **kwargs)
  @api.multi
  It browses for and returns the records from remote by ID This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to browse. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match the ID.
• remote_create(self, vals, *args, **kwargs)
  @api.multi
  It creates a record on the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Args: vals: (dict) Values to use for creation. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (mapping) A mapping of the record that was created.
• remote_delete(self, record_ids, *args, **kwargs)
  @api.multi
  It deletes records by ID on remote This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of bools indicating delete status.
• remote_search(self, query, *args, **kwargs)
  @api.multi
  It searches the remote for the query. This method calls adapter method of this same name, suffixed with the adapter type. Args: query: (mixed) Query domain as required by the adapter. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match query.
• remote_update(self, record_ids, vals, *args, **kwargs)
  @api.multi
  It updates the remote records with the vals This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that were updated.

• ca_certs Char
  help='Path to CA Certs file on server.'
• client_cert Text
• client_key Text
• company_id Many2one → res.company
  comodel_name='res.company' default=<expr> string='Company'
• conn_string Text
  help="\n Sample connection strings:\n - Microsoft SQL Server:\n mssql+pymssql://username:%s@server:port/dbname?charset=utf8\n - MySQL: mysql://user:%s@server:port/dbname\n - ODBC: DRIVER={FreeTDS};SERVER=server.address;Database=mydb;UID=sa\n - ORACLE: username/%s@//server.address:port/instance\n - PostgreSQL:\n dbname='template1' user='dbuser' host='localhost' port='5432' password=%s\n - SQLite: sqlite:///test.db\n - Elasticsearch: https://user:%s@localhost:9200\n " args: 'Connection string'
• conn_string_full Text
  compute='_compute_conn_string_full' readonly=True
• connector Selection
  help='If a connector is missing from the list, check the server log to confirm that the required components were detected.' required=True args: CONNECTORS, 'Connector'
• name Char
  required=True size=64 args: 'Datasource name'
• password Char
  size=40 args: 'Password'

• change_table(self, name)
  @api.multi
  Change the table that is used for CRUD operations
• conn_open(self)
  @api.multi
  It opens and returns a connection to the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Deprecate: This method has been replaced with ``connection_open``.
• connection_close(self, connection)
  @api.multi
  It closes the connection to the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_close_postgresql(self, connection)
• connection_open(self)
  @api.multi@contextmanager
  It provides a context manager for the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_open_postgresql(self)
• connection_test(self)
  @api.multi
  It tests the connection Raises: ConnectionSuccessError: On connection success ConnectionFailedError: On connection failed
• execute(self, query=None, execute_params=None, metadata=False, **kwargs)
  @api.multi
  Executes a query and returns a list of rows. "execute_params" can be a dict of values, that can be referenced in the SQL statement using "%(key)s" or, in the case of Oracle, ":key". Example: query = "SELECT * FROM mytable WHERE city = %(city)s AND date > %(dt)s" execute_params = { 'city': 'Lisbon', 'dt': datetime.datetime(2000, 12, 31), } If metadata=True, it will instead return a dict containing the rows list and the columns list, in the format: { 'cols': [ 'col_a', 'col_b', ...] , 'rows': [ (a0, b0, ...), (a1, b1, ...), ...] }
• execute_postgresql(self, query, params, metadata)
• remote_browse(self, record_ids, *args, **kwargs)
  @api.multi
  It browses for and returns the records from remote by ID This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to browse. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match the ID.
• remote_create(self, vals, *args, **kwargs)
  @api.multi
  It creates a record on the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Args: vals: (dict) Values to use for creation. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (mapping) A mapping of the record that was created.
• remote_delete(self, record_ids, *args, **kwargs)
  @api.multi
  It deletes records by ID on remote This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of bools indicating delete status.
• remote_search(self, query, *args, **kwargs)
  @api.multi
  It searches the remote for the query. This method calls adapter method of this same name, suffixed with the adapter type. Args: query: (mixed) Query domain as required by the adapter. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match query.
• remote_update(self, record_ids, vals, *args, **kwargs)
  @api.multi
  It updates the remote records with the vals This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that were updated.

• ca_certs Char
  help='Path to CA Certs file on server.'
• client_cert Text
• client_key Text
• conn_string Text
  help="\n Sample connection strings:\n - Microsoft SQL Server:\n mssql+pymssql://username:%s@server:port/dbname?charset=utf8\n - MySQL: mysql://user:%s@server:port/dbname\n - ODBC: DRIVER={FreeTDS};SERVER=server.address;Database=mydb;UID=sa\n - ORACLE: username/%s@//server.address:port/instance\n - PostgreSQL:\n dbname='template1' user='dbuser' host='localhost' port='5432' password=%s\n - SQLite: sqlite:///test.db\n - Elasticsearch: https://user:%s@localhost:9200\n " args: 'Connection string'
• conn_string_full Text
  compute='_compute_conn_string_full' readonly=True
• connector Selection
  help='If a connector is missing from the list, check the server log to confirm that the required components were detected.' required=True args: CONNECTORS, 'Connector'
• name Char
  required=True size=64 args: 'Datasource name'
• password Char
  size=40 args: 'Password'

• change_table(self, name)
  @api.multi
  Change the table that is used for CRUD operations
• conn_open(self)
  @api.multi
  It opens and returns a connection to the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Deprecate: This method has been replaced with ``connection_open``.
• connection_close(self, connection)
  @api.multi
  It closes the connection to the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_close_postgresql(self, connection)
• connection_open(self)
  @api.multi@contextmanager
  It provides a context manager for the data source. This method calls adapter method of this same name, suffixed with the adapter type.
• connection_open_postgresql(self)
• connection_test(self)
  @api.multi
  It tests the connection Raises: ConnectionSuccessError: On connection success ConnectionFailedError: On connection failed
• execute(self, query=None, execute_params=None, metadata=False, **kwargs)
  @api.multi
  Executes a query and returns a list of rows. "execute_params" can be a dict of values, that can be referenced in the SQL statement using "%(key)s" or, in the case of Oracle, ":key". Example: query = "SELECT * FROM mytable WHERE city = %(city)s AND date > %(dt)s" execute_params = { 'city': 'Lisbon', 'dt': datetime.datetime(2000, 12, 31), } If metadata=True, it will instead return a dict containing the rows list and the columns list, in the format: { 'cols': [ 'col_a', 'col_b', ...] , 'rows': [ (a0, b0, ...), (a1, b1, ...), ...] }
• execute_postgresql(self, query, params, metadata)
• remote_browse(self, record_ids, *args, **kwargs)
  @api.multi
  It browses for and returns the records from remote by ID This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to browse. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match the ID.
• remote_create(self, vals, *args, **kwargs)
  @api.multi
  It creates a record on the remote data source. This method calls adapter method of this same name, suffixed with the adapter type. Args: vals: (dict) Values to use for creation. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (mapping) A mapping of the record that was created.
• remote_delete(self, record_ids, *args, **kwargs)
  @api.multi
  It deletes records by ID on remote This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of bools indicating delete status.
• remote_search(self, query, *args, **kwargs)
  @api.multi
  It searches the remote for the query. This method calls adapter method of this same name, suffixed with the adapter type. Args: query: (mixed) Query domain as required by the adapter. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that match query.
• remote_update(self, record_ids, vals, *args, **kwargs)
  @api.multi
  It updates the remote records with the vals This method calls adapter method of this same name, suffixed with the adapter type. Args: record_ids: (list) List of remote IDs to delete. *args: Positional arguments to be passed to adapter method. **kwargs: Keyword arguments to be passed to adapter method. Returns: (iter) Iterator of record mappings that were updated.

• conn_string Text
  help="\n Sample connection strings:\n - Microsoft SQL Server:\n mssql+pymssql://username:%s@server:port/dbname?charset=utf8\n - MySQL: mysql://user:%s@server:port/dbname\n - ODBC: DRIVER={FreeTDS};SERVER=server.address;Database=mydb;UID=sa\n - ORACLE: username/%s@//server.address:port/instance\n - PostgreSQL:\n dbname='template1' user='dbuser' host='localhost' port='5432' password=%s\n - SQLite: sqlite:///test.db\n " args: 'Connection string'
• connector Selection
  help='If a connector is missing from the list, check the server log to confirm that the required components were detected.' required=True args: CONNECTORS, 'Connector'
• name Char
  required=True size=64 args: 'Datasource name'
• password Char
  size=40 args: 'Password'

• conn_open(self)
  @api.multi
  The connection is open here.
• connection_test(self)
  @api.multi
  Test of connection.
• execute(self, sqlquery, sqlparams=None, metadata=False, context=None)
  @api.multi
  Executes SQL and returns a list of rows. "sqlparams" can be a dict of values, that can be referenced in the SQL statement using "%(key)s" or, in the case of Oracle, ":key". Example: sqlquery = "select * from mytable where city = %(city)s and date > %(dt)s" params = {'city': 'Lisbon', 'dt': datetime.datetime(2000, 12, 31)} If metadata=True, it will instead return a dict containing the rows list and the columns list, in the format: { 'cols': [ 'col_a', 'col_b', ...] , 'rows': [ (a0, b0, ...), (a1, b1, ...), ...] }

No new fields.

• conn_open(self, cr, uid, id1)
• connection_test(self, cr, uid, ids, context=None)
• execute(self, cr, uid, ids, sqlquery, sqlparams=None, metadata=False, context=None)
  Executes SQL and returns a list of rows. "sqlparams" can be a dict of values, that can be referenced in the SQL statement using "%(key)s" or, in the case of Oracle, ":key". Example: sqlquery = "select * from mytable where city = %(city)s and date > %(dt)s" params = {'city': 'Lisbon', 'dt': datetime.datetime(2000, 12, 31)} If metadata=True, it will instead return a dict containing the rows list and the columns list, in the format: { 'cols': [ 'col_a', 'col_b', ...] , 'rows': [ (a0, b0, ...), (a1, b1, ...), ...] }

No new fields.

• conn_open(self, cr, uid, id1)
• connection_test(self, cr, uid, ids, context=None)
• execute(self, cr, uid, ids, sqlquery, sqlparams=None, metadata=False, context=None)
  Executes SQL and returns a list of rows. "sqlparams" can be a dict of values, that can be referenced in the SQL statement using "%(key)s" or, in the case of Oracle, ":key". Example: sqlquery = "select * from mytable where city = %(city)s and date > %(dt)s" params = {'city': 'Lisbon', 'dt': datetime.datetime(2000, 12, 31)} If metadata=True, it will instead return a dict containing the rows list and the columns list, in the format: { 'cols': [ 'col_a', 'col_b', ...] , 'rows': [ (a0, b0, ...), (a1, b1, ...), ...] }