Changeset 5833cf713f307ac2d3f46ab5e947c7731731ce16
- Timestamp:
- 03/21/08 20:52:08
(5 years ago)
- Author:
- Denish Patel <denish@omniti.com>
- git-committer:
- Denish Patel <denish@omniti.com> 1206132728 +0000
- git-parent:
[b9b5a612dc45fbaf19be9da90d69d61dc0491e1e]
- git-author:
- Denish Patel <denish@omniti.com> 1206132728 +0000
- Message:
change Insert Queries to point to new SID tables
-
Files:
-
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
| r0dee069 |
r5833cf7 |
|
| 37 | 37 | <statements> |
|---|
| 38 | 38 | <check><![CDATA[ |
|---|
| 39 | | INSERT INTO stratcon.loading_dock_check |
|---|
| 40 | | (remote_address, whence, |
|---|
| | 39 | INSERT INTO stratcon.loading_dock_check_s |
|---|
| | 40 | (remote_address, whence, sid, target, module, name) |
|---|
| 41 | 41 | VALUES ($1, 'epoch'::timestamptz + ($2 || ' seconds')::interval, |
|---|
| 42 | | $3, $4, $5, $6) |
|---|
| | 42 | stratcon.generate_sid_from_id($3), $4, $5, $6) |
|---|
| 43 | 43 | ]]></check> |
|---|
| 44 | 44 | <status><![CDATA[ |
|---|
| 45 | | INSERT INTO stratcon.loading_dock_status |
|---|
| 46 | | (remote_address, whence, id, state, availability, |
|---|
| | 45 | INSERT INTO stratcon.loading_dock_status_s |
|---|
| | 46 | ( whence,sid, state, availability, |
|---|
| 47 | 47 | duration, status) |
|---|
| 48 | | VALUES ($1, 'epoch'::timestamptz + ($2 || ' seconds')::interval, |
|---|
| 49 | | $3, $4, $5, $6, $7) |
|---|
| | 48 | VALUES ('epoch'::timestamptz + ($2 || ' seconds')::interval, |
|---|
| | 49 | stratcon.generate_sid_from_id($3), $4, $5, $6, $7) |
|---|
| 50 | 50 | ]]></status> |
|---|
| 51 | 51 | <metric_numeric><![CDATA[ |
|---|
| 52 | | INSERT INTO stratcon.loading_dock_metric_numeric |
|---|
| 53 | | (remote_address, whence, id, name, type, value) |
|---|
| 54 | | VALUES ($1, 'epoch'::timestamptz + ($2 || ' seconds')::interval, |
|---|
| 55 | | $3, $4, $5, $6) |
|---|
| | 52 | INSERT INTO stratcon.loading_dock_metric_numeric_s |
|---|
| | 53 | (whence, sid, name, value) |
|---|
| | 54 | VALUES ( 'epoch'::timestamptz + ($2 || ' seconds')::interval, |
|---|
| | 55 | stratcon.generate_sid_from_id($3), $4, $6) |
|---|
| 56 | 56 | ]]></metric_numeric> |
|---|
| 57 | 57 | <metric_text><![CDATA[ |
|---|
| 58 | | INSERT INTO stratcon.loading_dock_metric_text |
|---|
| 59 | | (remote_address, whence, id, name, type, value) |
|---|
| 60 | | VALUES ($1, 'epoch'::timestamptz + ($2 || ' seconds')::interval, |
|---|
| 61 | | $3, $4, $5, $6) |
|---|
| | 58 | INSERT INTO stratcon.loading_dock_metric_text_s |
|---|
| | 59 | ( whence, sid, name,value) |
|---|
| | 60 | VALUES ('epoch'::timestamptz + ($2 || ' seconds')::interval, |
|---|
| | 61 | stratcon.generate_sid_from_id($3), $4, $6) |
|---|
| 62 | 62 | ]]></metric_text> |
|---|
| 63 | 63 | </statements> |
|---|
