|
| DEFAULT_ARGS = dict(WRITE_OPTIONS={}, VERBOSE=False) |
| Constructor argument defaults. More...
|
|
tuple | FILE_EXTENSIONS = (".sql", ) |
| Auto-detection file extensions. More...
|
|
list | MESSAGE_TYPE_BASECOLS |
| Default columns for message type tables, as [(column name, ROS type)]. More...
|
|
| DEFAULT_ARGS = dict(META=False) |
| Constructor argument defaults. More...
|
|
tuple | FILE_EXTENSIONS = () |
| Auto-detection file extensions for subclasses, as (".ext", ) More...
|
|
| DEFAULT_ARGS = dict(META=False, WRITE_OPTIONS={}, MATCH_WRAPPER=None, VERBOSE=False) |
| Constructor argument defaults. More...
|
|
string | DEFAULT_DIALECT = "sqlite" |
| Default SQL dialect used if dialect not specified. More...
|
|
dictionary | DIALECTS |
| Supported SQL dialects and options. More...
|
|
list | KEYWORDS |
| Words that need quoting if in name context, like table name. More...
|
|
Writes SQL schema file for message type tables and topic views.
Output will have:
- table "pkg/MsgType" for each topic message type, with ordinary columns for
scalar fields, and structured columns for list fields;
plus underscore-prefixed fields for metadata, like `_topic` as the topic name.
If launched with nesting-option, tables will also be created for each
nested message type.
- view "/full/topic/name" for each topic, selecting from the message type table
Definition at line 30 of file sql.py.
def grepros.plugins.sql.SqlSink.__init__ |
( |
|
self, |
|
|
|
args = None , |
|
|
** |
kwargs |
|
) |
| |
@param args arguments as namespace or dictionary, case-insensitive;
or a single path as the file to write
@param args.write output file path
@param args.write_options ```
{"dialect": SQL dialect if not default,
"nesting": true|false to created nested type tables,
"overwrite": whether to overwrite existing file
(default false)}
```
@param args.meta whether to emit metainfo
@param args.verbose whether to emit debug information
@param kwargs any and all arguments as keyword overrides, case-insensitive
Reimplemented from grepros.outputs.Sink.
Definition at line 56 of file sql.py.