...
| Code Block |
|---|
|
create table blob_test (
pid integer not null,
content bytea not null
);
create index blob_test_idx on blob_test(prupi); |
| Code Block |
|---|
|
<data:blob id="example" acl="private">
<datasource>postgres</datasource>
<table>blob_test</table>
<key>pid</key>
<column>content</column>
<contentType>image/jpg</contentType>
</data:blob> |
The images can then be references using the URL http://weave.hostname/weave/data/blob/example/1234 (assuming there is a row that has the value 1234 in the pid column)
For a data definition you could then reference the column in a parameter with something like:
| Code Block |
|---|
| breakoutMode | wide |
|---|
| language | xml |
|---|
|
<parameter type="url" name="image" label="Image" text="Show" column="{fn concat('data/blob/example/', pid)}"/> |