Mercurial > hg > ltpda
annotate m-toolbox/classes/+utils/@repository/updateObjMetadata.m @ 13:e05504b18072 database-connection-manager
Move more functions to utils.repository
| author | Daniele Nicolodi <nicolodi@science.unitn.it> |
|---|---|
| date | Mon, 05 Dec 2011 16:20:06 +0100 |
| parents | m-toolbox/classes/+utils/@jmysql/updateObjMetadata.m@f0afece42f48 |
| children |
| rev | line source |
|---|---|
| 0 | 1 function updateObjMetadata(conn, obj, objid) |
|
13
e05504b18072
Move more functions to utils.repository
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
0
diff
changeset
|
2 % an utility to update entries for various object metadata in the |
|
e05504b18072
Move more functions to utils.repository
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
0
diff
changeset
|
3 % corresponding tables. differs from insertObjMetadataV1() by |
|
e05504b18072
Move more functions to utils.repository
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
0
diff
changeset
|
4 % the use of the new v3.0 database structure |
|
e05504b18072
Move more functions to utils.repository
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
0
diff
changeset
|
5 % |
|
e05504b18072
Move more functions to utils.repository
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
0
diff
changeset
|
6 % MUST BE KEPT IN SYNC WITH insertObjMetadata() |
|
e05504b18072
Move more functions to utils.repository
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
0
diff
changeset
|
7 % |
|
e05504b18072
Move more functions to utils.repository
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
0
diff
changeset
|
8 % conn - Java database connection object |
|
e05504b18072
Move more functions to utils.repository
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
0
diff
changeset
|
9 % obj - object |
|
e05504b18072
Move more functions to utils.repository
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
0
diff
changeset
|
10 % objid - unique ID of the object in the database |
|
e05504b18072
Move more functions to utils.repository
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
0
diff
changeset
|
11 % |
|
e05504b18072
Move more functions to utils.repository
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
0
diff
changeset
|
12 % VERSION: $Id: updateObjMetadata.m,v 1.7 2011/11/09 18:47:04 mauro Exp $ |
|
e05504b18072
Move more functions to utils.repository
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
0
diff
changeset
|
13 % |
| 0 | 14 |
| 15 import utils.const.* | |
| 16 | |
| 17 if nargin < 3 | |
| 18 error('### incorrect usage'); | |
| 19 end | |
| 20 if ~isjava(conn) | |
| 21 error('### incorrect usage'); | |
| 22 end | |
| 23 | |
| 24 % class of object | |
| 25 cl = class(obj); | |
| 26 utils.helper.msg(msg.PROC2, 'making meta data entry for %s object', cl); | |
| 27 | |
| 28 switch cl | |
| 29 case 'ao' | |
| 30 | |
| 31 % call recursively to insert the data object info | |
|
13
e05504b18072
Move more functions to utils.repository
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
0
diff
changeset
|
32 utils.repository.updateObjMetadata(conn, obj.data, objid); |
| 0 | 33 |
| 34 % insert the AO info | |
| 35 stmt = conn.prepareStatement(... | |
| 36 'UPDATE ao SET data_type=?, description=? WHERE obj_id = ?'); | |
| 37 stmt.setObject(1, java.lang.String(class(obj.data))); | |
| 38 desc = obj.description; | |
| 39 if length(desc)>65535 | |
| 40 warning('Object description length exceeded. Truncating to 65535 characters'); | |
| 41 desc = desc(1:65535); | |
| 42 end | |
| 43 stmt.setObject(2, java.lang.String(desc)); | |
| 44 stmt.setObject(3, objid); | |
| 45 stmt.executeUpdate(); | |
| 46 stmt.close(); | |
| 47 | |
| 48 case 'cdata' | |
| 49 | |
| 50 stmt = conn.prepareStatement(... | |
| 51 'UPDATE cdata SET yunits=? WHERE obj_id = ?'); | |
| 52 stmt.setObject(1, java.lang.String(char(obj.yunits))); | |
| 53 stmt.setObject(2, objid); | |
| 54 stmt.executeUpdate(); | |
| 55 stmt.close(); | |
| 56 | |
| 57 case 'fsdata' | |
| 58 | |
| 59 % possible bad entries | |
| 60 fs = obj.fs; | |
| 61 if ~isfinite(fs) | |
| 62 fs = []; | |
| 63 end | |
| 64 | |
| 65 stmt = conn.prepareStatement(... | |
| 66 'UPDATE fsdata SET xunits=?, yunits=?, fs=? WHERE obj_id = ?'); | |
| 67 stmt.setObject(1, java.lang.String(char(obj.xunits))); | |
| 68 stmt.setObject(2, java.lang.String(char(obj.yunits))); | |
| 69 stmt.setObject(3, fs); | |
| 70 stmt.setObject(4, objid); | |
| 71 stmt.executeUpdate(); | |
| 72 stmt.close(); | |
| 73 | |
| 74 case 'tsdata' | |
| 75 | |
| 76 stmt = conn.prepareStatement(... | |
| 77 'UPDATE tsdata SET xunits=?, yunits=?, fs=?, t0=?, nsecs=?, toffset=? WHERE obj_id = ?'); | |
| 78 stmt.setObject(1, java.lang.String(char(obj.xunits))); | |
| 79 stmt.setObject(2, java.lang.String(char(obj.yunits))); | |
| 80 stmt.setObject(3, obj.fs); | |
| 81 stmt.setObject(4, java.lang.String(format(obj.t0 + obj.toffset/1000, 'yyyy-mm-dd HH:MM:SS', 'UTC'))); | |
| 82 stmt.setObject(5, obj.nsecs); | |
| 83 stmt.setObject(6, obj.toffset); | |
| 84 stmt.setObject(7, objid); | |
| 85 stmt.execute(); | |
| 86 stmt.close(); | |
| 87 | |
| 88 case 'xydata' | |
| 89 | |
| 90 stmt = conn.prepareStatement(... | |
| 91 'UPDATE xydata SET xunits=?, yunits=? WHERE obj_id = ?'); | |
| 92 stmt.setObject(1, java.lang.String(char(obj.xunits))); | |
| 93 stmt.setObject(2, java.lang.String(char(obj.yunits))); | |
| 94 stmt.setObject(3, objid); | |
| 95 stmt.execute(); | |
| 96 stmt.close(); | |
| 97 | |
| 98 case 'mfir' | |
| 99 | |
| 100 stmt = conn.prepareStatement(... | |
| 101 'UPDATE mfir SET in_file=?, fs=? WHERE obj_id = ?'); | |
| 102 stmt.setObject(1, java.lang.String(obj.infile)); | |
| 103 stmt.setObject(2, obj.fs); | |
| 104 stmt.setObject(3, objid); | |
| 105 stmt.execute(); | |
| 106 stmt.close(); | |
| 107 | |
| 108 case 'miir' | |
| 109 | |
| 110 stmt = conn.prepareStatement(... | |
| 111 'UPDATE miir SET in_file=?, fs=? WHERE obj_id = ?'); | |
| 112 stmt.setObject(1, java.lang.String(obj.infile)); | |
| 113 stmt.setObject(2, obj.fs); | |
| 114 stmt.setObject(3, objid); | |
| 115 stmt.execute(); | |
| 116 stmt.close(); | |
| 117 | |
| 118 otherwise | |
| 119 utils.helper.msg(msg.PROC2, 'no meta data table for %s object', cl); | |
| 120 | |
| 121 end | |
| 122 | |
| 123 end |