net2dbxs
index
c:\projects\net2scripting\src\net2dbxs\__init__.py

The module that offers direct access to the Paxton Net2 database,
not using the SDK.

 
Package Contents
       

 
Classes
       
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