[2001] in Moira Commits
/svn/moira r4140 - trunk/moira/backup
daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Thu Sep 5 20:04:31 2013
Date: Thu, 5 Sep 2013 20:04:24 -0400
From: Garry Zacheiss <zacheiss@MIT.EDU>
Message-Id: <201309060004.r8604ObX012206@drugstore.mit.edu>
To: moira-commits@MIT.EDU
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Author: zacheiss
Date: 2013-09-05 20:04:24 -0400 (Thu, 05 Sep 2013)
New Revision: 4140
Modified:
trunk/moira/backup/db2bkup.awk
trunk/moira/backup/db2rest.awk
Log:
Treat TIMESTAMP columns like DATEs.
Modified: trunk/moira/backup/db2bkup.awk
===================================================================
--- trunk/moira/backup/db2bkup.awk 2013-09-03 14:35:45 UTC (rev 4139)
+++ trunk/moira/backup/db2bkup.awk 2013-09-06 00:04:24 UTC (rev 4140)
@@ -56,7 +56,7 @@
vtype[count]="str";
}
vsize[count] = temp2[1]+1;
- } else if ($2 ~ /DATE/) {
+ } else if ($2 ~ /DATE/ || $2 ~ /TIMESTAMP/) {
printf " char\tt_%s[26];\n", vname[count];
vtype[count]="date";
} else printf "Unknown data type %s\n", $2;
Modified: trunk/moira/backup/db2rest.awk
===================================================================
--- trunk/moira/backup/db2rest.awk 2013-09-03 14:35:45 UTC (rev 4139)
+++ trunk/moira/backup/db2rest.awk 2013-09-06 00:04:24 UTC (rev 4140)
@@ -55,7 +55,7 @@
printf " EXEC SQL VAR t_%s IS STRING(%d);\n", vname[count], temp2[1]+1;
} else vtype[count]="str";
vsize[count] = temp2[1]+1;
- } else if ($2 ~ /DATE/) {
+ } else if ($2 ~ /DATE/ || $2 ~ /TIMESTAMP/) {
printf " char\tt_%s[26];\n", vname[count];
vtype[count]="date";
} else printf "Unknown data type %s\n", $2;
