Bug #4116 » 0001-Remove-redundant-whitespace-from-INSERT-SQL-statemen.patch
| lib/mentat/services/eventstorage.py | ||
|---|---|---|
| 310 | 310 |
idea_pgsql = mentat.idea.sqldb.Idea(idea_event) |
| 311 | 311 |
record = idea_pgsql.get_record() |
| 312 | 312 |
self.cursor.execute( |
| 313 |
"INSERT INTO events (\ |
|
| 314 |
id, \
|
|
| 315 |
detecttime, \
|
|
| 316 |
category, \
|
|
| 317 |
description, \
|
|
| 318 |
source_ip, \
|
|
| 319 |
target_ip, \
|
|
| 320 |
source_port, \
|
|
| 321 |
target_port, \
|
|
| 322 |
source_type, \
|
|
| 323 |
target_type, \
|
|
| 324 |
protocol, \
|
|
| 325 |
node_name, \
|
|
| 326 |
node_type, \
|
|
| 327 |
cesnet_resolvedabuses, \
|
|
| 328 |
cesnet_storagetime, \
|
|
| 329 |
cesnet_eventclass, \
|
|
| 330 |
cesnet_eventseverity, \
|
|
| 331 |
cesnet_inspectionerrors, \
|
|
| 332 |
event) \
|
|
| 333 |
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", |
|
| 313 |
"INSERT INTO events ("\
|
|
| 314 |
"id, "\
|
|
| 315 |
"detecttime, "\
|
|
| 316 |
"category, "\
|
|
| 317 |
"description, "\
|
|
| 318 |
"source_ip, "\
|
|
| 319 |
"target_ip, "\
|
|
| 320 |
"source_port, "\
|
|
| 321 |
"target_port, "\
|
|
| 322 |
"source_type, "\
|
|
| 323 |
"target_type, "\
|
|
| 324 |
"protocol, "\
|
|
| 325 |
"node_name, "\
|
|
| 326 |
"node_type, "\
|
|
| 327 |
"cesnet_resolvedabuses, "\
|
|
| 328 |
"cesnet_storagetime, "\
|
|
| 329 |
"cesnet_eventclass, "\
|
|
| 330 |
"cesnet_eventseverity, "\
|
|
| 331 |
"cesnet_inspectionerrors, "\
|
|
| 332 |
"event) "\
|
|
| 333 |
"VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
|
|
| 334 | 334 |
record |
| 335 | 335 |
) |
| 336 | 336 | |