| |
- builtins.Exception(builtins.BaseException)
-
- Net2DBXSException
- builtins.object
-
- DBCommand
- net2base.Net2Base(builtins.object)
-
- Net2DBXS
class DBCommand(builtins.object) |
|
With wrapper for SqlCommand |
|
Methods defined here:
- __enter__(self)
- __exit__(self, type, value, traceback)
- __init__(self, query, con)
Data descriptors defined here:
- __dict__
- dictionary for instance variables (if defined)
- __weakref__
- list of weak references to the object (if defined)
|
class Net2DBXS(net2base.Net2Base) |
|
Net2 direct database access class |
|
- Method resolution order:
- Net2DBXS
- net2base.Net2Base
- builtins.object
Methods defined here:
- __enter__(self)
- With enter
- __exit__(self, type, value, traceback)
- With exit
- __init__(self)
- Class constructor
- connect(self, user_name='sdk_user', password='E56ABED4-2918-44F9-A110-71B61B47142A', db='Net2', server=None)
- Connect to database
If the server parameter is None, named pipes are user.
For remote connections, the server parameter should contain the
windows name.
- dispose(self)
- Dispose database connection
- get_all_tables(self)
- Convenience function to retrieve all known tables / views
Returns a dataset.
- query_db(self, query)
- Perform database query and return data in dataset
Returns a dataset.
- run_stored_procedure(self, sp_name, **params)
- Run stored procedured
Returns the stored procedure result value.
Class methods inherited from net2base.Net2Base:
- dataset_to_str(dataset) from builtins.type
- Convert dataset to string presentation
- safe_get_row_val(row, col) from builtins.type
- Null aware fetching of row data
Returns None if the database column is NULL
Data descriptors inherited from net2base.Net2Base:
- __dict__
- dictionary for instance variables (if defined)
- __weakref__
- list of weak references to the object (if defined)
|
class Net2DBXSException(builtins.Exception) |
|
Exception class for net2 database xs |
|
- Method resolution order:
- Net2DBXSException
- builtins.Exception
- builtins.BaseException
- builtins.object
Data descriptors defined here:
- __weakref__
- list of weak references to the object (if defined)
Methods inherited from builtins.Exception:
- __init__(self, /, *args, **kwargs)
- Initialize self. See help(type(self)) for accurate signature.
- __new__(*args, **kwargs) from builtins.type
- Create and return a new object. See help(type) for accurate signature.
Methods inherited from builtins.BaseException:
- __delattr__(self, name, /)
- Implement delattr(self, name).
- __getattribute__(self, name, /)
- Return getattr(self, name).
- __reduce__(...)
- __repr__(self, /)
- Return repr(self).
- __setattr__(self, name, value, /)
- Implement setattr(self, name, value).
- __setstate__(...)
- __str__(self, /)
- Return str(self).
- with_traceback(...)
- Exception.with_traceback(tb) --
set self.__traceback__ to tb and return self.
Data descriptors inherited from builtins.BaseException:
- __cause__
- exception cause
- __context__
- exception context
- __dict__
- __suppress_context__
- __traceback__
- args
| |