diff options
Diffstat (limited to 'user/Test/dml/data/migrate.htx')
| -rw-r--r-- | user/Test/dml/data/migrate.htx | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/user/Test/dml/data/migrate.htx b/user/Test/dml/data/migrate.htx new file mode 100644 index 0000000..a9270a3 --- /dev/null +++ b/user/Test/dml/data/migrate.htx | |||
| @@ -0,0 +1,28 @@ | |||
| 1 | #!/home/tfy2/rydberg/bin/htc | ||
| 2 | \create{dml}{ | ||
| 3 | INDEX TIME AUTHOR SUBJECT BROADCAST MIME PROTECT BODY ATTACH PARENT BREAK | ||
| 4 | }{INDEX}{<} | ||
| 5 | \def{add}{r}{ | ||
| 6 | \open{tmp}{\1} | ||
| 7 | \db{tmp}{ | ||
| 8 | \query{1}{ | ||
| 9 | [t.<-@]; | ||
| 10 | \db{dml}( | ||
| 11 | s.INDEX:=t.INDEX; | ||
| 12 | s.TIME:=t.TIME; | ||
| 13 | s.AUTHOR:=\getuser(t.USER); | ||
| 14 | s.SUBJECT:=t.SUBJECT; | ||
| 15 | s.BROADCAST:=(t.SENDTO eq "Broadcast"); | ||
| 16 | s.MIME:=\switch(t.TYPE){Text}{text/plain}{HTML}{text/html}{HTC}{text/x-htc}; | ||
| 17 | s.PROTECT:=(t.STATUS eq "Protected"); | ||
| 18 | s.BODY:=t.BODY; | ||
| 19 | s.ATTACH:=t.ATTACH; | ||
| 20 | s.PARENT:=t.PARENT; | ||
| 21 | s.BREAK:="";\forall{i}(t.BREAK)(s.BREAK=s.BREAK+++\getuser(i)); | ||
| 22 | @<-s.; | ||
| 23 | ) | ||
| 24 | } | ||
| 25 | } | ||
| 26 | } | ||
| 27 | \add{dml.hdb} | ||
| 28 | \save{dml2.hdb}{dml} | ||
