add script to extract preference translations from the schema; update translations

2 files changed, 30 insertions, 0 deletions

diff --git a/utils/localized_schema.txt b/utils/localized_schema.txt
new file mode 100644
index 000000000..f140d0bc2
--- /dev/null
+++ b/utils/localized_schema.txt
@@ -0,0 +1,12 @@
+__("Title");
+__("Title or Content");
+__("Link");
+__("Content");
+__("Article Date");
+
+__("Filter article");
+__("Mark as read");
+__("Set starred");
+__("Publish article");
+__("Assign tags");
+__("Assign label");
diff --git a/utils/update-schema-translations.sh b/utils/update-schema-translations.sh
new file mode 100755
index 000000000..dff446506
--- /dev/null
+++ b/utils/update-schema-translations.sh
@@ -0,0 +1,18 @@
+#!/bin/sh
+
+BASENAME=`basename $0`
+TMPFILE="/tmp/$BASENAME-$$.tmp"
+
+cat schema/ttrss_schema_pgsql.sql | grep 'insert.*pref_name' | awk -F\' '{ print $8 }' > $TMPFILE
+cat schema/ttrss_schema_pgsql.sql | grep 'insert.*pref_name' | awk -F\' '{ print $6 }' >> $TMPFILE
+
+echo "<?php # This file has been generated at: " `date` > localized_schema.php
+echo >> localized_schema.php
+cat utils/localized_schema.txt >> localized_schema.php
+echo >> localized_schema.php
+
+cat $TMPFILE | grep -v '^$' | sed "s/.*/__('&');/" >> localized_schema.php
+
+echo "?>" >> localized_schema.php
+
+rm $TMPFILE