added helper scripts to create SQL scripts

2 files changed, 61 insertions, 0 deletions

diff --git a/scripts/bin2sql.c b/scripts/bin2sql.c
new file mode 100644
index 000000000..5c8176d90
--- /dev/null
+++ b/scripts/bin2sql.c
@@ -0,0 +1,25 @@
+
+#include <stdio.h>
+
+/**
+ * convert standard input to SQL hex binary
+ */
+int main(int argc, char *argv[])
+{
+	int i, end = 0;
+	unsigned char byte;
+
+	printf("X'");
+	while (1)
+	{
+		if (fread(&byte, 1, 1, stdin) != 1)
+		{
+			end = 1;
+			break;
+		}
+		printf("%02x", (unsigned int)byte);
+	}	
+	printf("'\n");
+	return 0;
+}
+
diff --git a/scripts/id2sql.c b/scripts/id2sql.c
new file mode 100644
index 000000000..3990e88da
--- /dev/null
+++ b/scripts/id2sql.c
@@ -0,0 +1,36 @@
+
+#include <stdio.h>
+#include <library.h>
+
+/**
+ * convert an identity to type and encoding
+ */
+int main(int argc, char *argv[])
+{
+	identification_t *id;
+	chunk_t enc;
+	int i;
+	
+	if (argc < 2)
+	{
+		return -1;
+	}
+
+	id = identification_create_from_string(argv[1]);
+	if (!id)
+	{
+		return -2;
+	}
+	printf("type\tencoding\n");
+	printf("%d,\t", id->get_type(id));
+	enc = id->get_encoding(id);
+
+	printf("X'");
+	for (i = 0; i < enc.len; i++)
+	{
+		printf("%02x", (unsigned int)enc.ptr[i]);
+	}	
+	printf("'\n");
+	return 0;
+}
+