make and tar the postbooks updater package

diff --git a/scripts/build_basic_database_workproducts.sh b/scripts/build_basic_database_workproducts.sh
old mode 100644 (file)
new mode 100755 (executable)
index 6a37a33..efb5ab6
--- a/scripts/build_basic_database_workproducts.sh
+++ b/scripts/build_basic_database_workproducts.sh
@@ -1,19 +1,27 @@
-git fetch XTUPLE
-git checkout XTUPLE/4_4_x
-rm -rf scripts/output
-npm run-script build-basic-postbooks-package-sql
-npm run-script build-basic-empty
-npm run-script build-basic-postbooks-demo
-npm run-script build-basic-quickstart
+#git fetch XTUPLE
+#git checkout XTUPLE/4_4_x
+
+
+#rm -rf scripts/output
+#npm run-script build-basic-postbooks-package-sql
+#npm run-script build-basic-empty
+#npm run-script build-basic-postbooks-demo
+#npm run-script build-basic-quickstart
+#cd ../private-extensions
+
+#git fetch XTUPLE
+#git checkout XTUPLE/4_4_x
+
+#npm run-script build-basic-manufacturing-package-sql
+#npm run-script build-basic-distribution-package-sql
+#npm run-script build-basic-manufacturing-empty
+#npm run-script build-basic-manufacturing-quickstart
+#npm run-script build-basic-distribution-empty
+#npm run-script build-basic-distribution-quickstart
+
+mkdir scripts/output/pb440to441
+cp scripts/xml/postbooks_package.xml scripts/output/pb440to441
+cp scripts/output/toolkit.sql scripts/output/pb440to441
+cp scripts/output/updates.sql scripts/output/pb440to441
+tar -zcvf scripts/output/pb440to441.gz scripts/output/pb440to441
 
-../private-extensions
-git fetch XTUPLE
-git checkout XTUPLE/4_4_x
-npm run-script build-basic-manufacturing-package-sql
-npm run-script build-basic-distribution-package-sql
-npm run-script build-basic-manufacturing-empty
-npm run-script build-basic-manufacturing-quickstart
-npm run-script build-basic-manufacturing-demo
-npm run-script build-basic-distribution-empty
-npm run-script build-basic-distribution-quickstart
-npm run-script build-basic-distribution-demo

diff --git a/scripts/xml/postbooks_package.xml b/scripts/xml/postbooks_package.xml
new file mode 100644 (file)
index 0000000..49af122
--- /dev/null
+++ b/scripts/xml/postbooks_package.xml
@@ -0,0 +1,24 @@
+<package id        = "dbscripts"
+         version   = "4.4.1"
+         developer = "xTuple"
+         descrip   = "load PostBooks resources"
+         updater   = "2.2.4" >
+
+  <prerequisite type = "query"
+                name = "Checking xTuple Edition" >
+    <query>SELECT fetchMetricText('Application') = 'PostBooks';</query>
+    <message>This package must be applied to a PostBooks database.</message>
+  </prerequisite>
+
+  <prerequisite type = "query"
+                name = "Checking xTuple ERP database version" >
+    <query>SELECT fetchMetricText('ServerVersion') = '.4.1.x-4.2.0'
+               OR fetchMetricText('ServerVersion') ~ '^4.1.';</query>
+    <message>This package must be applied to a 4.1.X PostBooks database.
+    </message>
+  </prerequisite>
+
+  <script file="toolkit.sql" />
+  <script file="updates.sql" />
+
+</package>