Public Member Functions | |
| def | ReviewServiceArgs (cls, filename='', registrationname='', readonly=True, user='', password='') |
| def | CloseDatabase (self) |
| def | DAvg (self, expression, tablename, criteria='') |
| def | DCount (self, expression, tablename, criteria='') |
| def | DLookup (self, expression, tablename, criteria='', orderclause='') |
| def | DMax (self, expression, tablename, criteria='') |
| def | DMin (self, expression, tablename, criteria='') |
| def | DSum (self, expression, tablename, criteria='') |
| def | GetRows (self, sqlcommand, directsql=False, header=False, maxrows=0) |
| def | OpenFormDocument (self, formdocument) |
| def | OpenQuery (self, queryname) |
| def | OpenSql (self, sql, directsql=False) |
| def | OpenTable (self, tablename) |
| def | RunSql (self, sqlcommand, directsql=False) |
 Public Member Functions inherited from scriptforge.SFServices | |
| def | __init__ (self, reference=-1, objtype=None, classmodule=0, name='') |
| def | __getattr__ (self, name) |
| def | __setattr__ (self, name, value) |
| def | __repr__ (self) |
| def | Dispose (self) |
| def | ExecMethod (self, flags=0, methodname='', *args) |
| def | GetProperty (self, propertyname, arg=None) |
| def | Properties (self) |
| def | basicmethods (self) |
| def | basicproperties (self) |
| def | SetProperty (self, propertyname, value) |
Static Public Attributes | |
| string | serviceimplementation = 'basic' |
| string | servicename = 'SFDatabases.Database' |
| tuple | servicesynonyms = ('database', 'sfdatabases.database') |
| serviceproperties = dict(Queries = False, Tables = False, XConnection = False, XMetaData = False) | |
| Static Public Attributes inherited from scriptforge.SFServices | |
| vbGet | |
| vbLet | |
| vbMethod | |
| vbSet | |
| int | flgPost = 32 |
| int | flgDateArg = 64 |
| int | flgDateRet = 128 |
| int | flgArrayArg = 512 |
| int | flgArrayRet = 1024 |
| int | flgUno = 256 |
| int | flgObject = 2048 |
| int | flgHardCode = 4096 |
| moduleClass | |
| moduleStandard | |
| bool | forceGetProperty = False |
| dictionary | propertysynonyms = {} |
| tuple | internal_attributes |
| SIMPLEEXEC = ScriptForge.InvokeSimpleScript | |
| EXEC = ScriptForge.InvokeBasicService | |
Additional Inherited Members | |
| Public Attributes inherited from scriptforge.SFServices | |
| objectreference | |
| objecttype | |
| classmodule | |
| name | |
| internal | |
| localProperties | |
| serviceimplementation | |
Detailed Description
Each instance of the current class represents a single database, with essentially its tables, queries
and data
The exchanges with the database are done in SQL only.
To make them more readable, use optionally square brackets to surround table/query/field names
instead of the (RDBMS-dependent) normal surrounding character.
SQL statements may be run in direct or indirect mode. In direct mode the statement is transferred literally
without syntax checking nor review to the database engine.
Definition at line 1717 of file scriptforge.py.
Member Function Documentation
◆ CloseDatabase()
| def scriptforge.SFDatabases.SF_Database.CloseDatabase | ( | self | ) |
Definition at line 1740 of file scriptforge.py.
References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.
◆ DAvg()
| def scriptforge.SFDatabases.SF_Database.DAvg | ( | self, | |
| expression, | |||
| tablename, | |||
criteria = '' |
|||
| ) |
Definition at line 1743 of file scriptforge.py.
References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.
◆ DCount()
| def scriptforge.SFDatabases.SF_Database.DCount | ( | self, | |
| expression, | |||
| tablename, | |||
criteria = '' |
|||
| ) |
Definition at line 1746 of file scriptforge.py.
References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.
◆ DLookup()
| def scriptforge.SFDatabases.SF_Database.DLookup | ( | self, | |
| expression, | |||
| tablename, | |||
criteria = '', |
|||
orderclause = '' |
|||
| ) |
Definition at line 1749 of file scriptforge.py.
References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.
◆ DMax()
| def scriptforge.SFDatabases.SF_Database.DMax | ( | self, | |
| expression, | |||
| tablename, | |||
criteria = '' |
|||
| ) |
Definition at line 1752 of file scriptforge.py.
References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.
◆ DMin()
| def scriptforge.SFDatabases.SF_Database.DMin | ( | self, | |
| expression, | |||
| tablename, | |||
criteria = '' |
|||
| ) |
Definition at line 1755 of file scriptforge.py.
References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.
◆ DSum()
| def scriptforge.SFDatabases.SF_Database.DSum | ( | self, | |
| expression, | |||
| tablename, | |||
criteria = '' |
|||
| ) |
Definition at line 1758 of file scriptforge.py.
References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.
◆ GetRows()
| def scriptforge.SFDatabases.SF_Database.GetRows | ( | self, | |
| sqlcommand, | |||
directsql = False, |
|||
header = False, |
|||
maxrows = 0 |
|||
| ) |
Definition at line 1761 of file scriptforge.py.
References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgArrayRet, and scriptforge.SFServices.vbMethod.
◆ OpenFormDocument()
| def scriptforge.SFDatabases.SF_Database.OpenFormDocument | ( | self, | |
| formdocument | |||
| ) |
Definition at line 1764 of file scriptforge.py.
References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.
◆ OpenQuery()
| def scriptforge.SFDatabases.SF_Database.OpenQuery | ( | self, | |
| queryname | |||
| ) |
Definition at line 1767 of file scriptforge.py.
References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.
◆ OpenSql()
| def scriptforge.SFDatabases.SF_Database.OpenSql | ( | self, | |
| sql, | |||
directsql = False |
|||
| ) |
Definition at line 1770 of file scriptforge.py.
References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.
◆ OpenTable()
| def scriptforge.SFDatabases.SF_Database.OpenTable | ( | self, | |
| tablename | |||
| ) |
Definition at line 1773 of file scriptforge.py.
References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.
◆ ReviewServiceArgs()
| def scriptforge.SFDatabases.SF_Database.ReviewServiceArgs | ( | cls, | |
filename = '', |
|||
registrationname = '', |
|||
readonly = True, |
|||
user = '', |
|||
password = '' |
|||
| ) |
Transform positional and keyword arguments into positional only
Definition at line 1734 of file scriptforge.py.
◆ RunSql()
| def scriptforge.SFDatabases.SF_Database.RunSql | ( | self, | |
| sqlcommand, | |||
directsql = False |
|||
| ) |
Definition at line 1776 of file scriptforge.py.
References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.
Member Data Documentation
◆ serviceimplementation
|
static |
Definition at line 1728 of file scriptforge.py.
Referenced by scriptforge.SFServices.__repr__(), scriptforge.SFServices.__setattr__(), scriptforge.SFServices.basicmethods(), scriptforge.SFServices.basicproperties(), scriptforge.SFServices.Dispose(), scriptforge.SFServices.GetProperty(), and scriptforge.SFServices.SetProperty().
◆ servicename
|
static |
Definition at line 1729 of file scriptforge.py.
Referenced by scriptforge.ScriptForge.__init__(), and scriptforge.SFServices.__repr__().
◆ serviceproperties
|
static |
Definition at line 1731 of file scriptforge.py.
Referenced by scriptforge.SFServices.__setattr__(), and scriptforge.SFServices.Properties().
◆ servicesynonyms
|
static |
Definition at line 1730 of file scriptforge.py.
The documentation for this class was generated from the following file:
