Changes between Version 79 and Version 80 of members/GRIP-UQAM

Timestamp:

Apr 2, 2016, 2:42:33 PM (9 years ago)

Author:

Grip Uqam

Comment:

--

members/GRIP-UQAM

@@ -59 +59 @@
     * #!js
     * #!text/javascript ...
-    * #!sql
+    * **#!sql**
     * #!text/x-sql
     * #!text/x-sqlite3-console
@@ -82 +82 @@
 === Reported by us ===
 [[TicketQuery(reporter=https://id.mayfirst.org/gripuqam|https://id.mayfirst.org/gripuqamweb|https://id.mayfirst.org/essais)]]
-=== Drupal requirements ===
-* Drupal 8.0.5 needs Postgresql >= 9.1.2 instead of 8.4.20 #11587, #11522
 === Taged with GRIP-UQAM with description ===
 [[TicketQuery(max=1,keywords~=GRIP-UQAM,format=table,col=changetime|resolution|owner|summary,rows=description)]]
@@ -96 +94 @@
 * [wiki:support-team]
 == Some PostgreSQL commands ==
-* $ psql postgres --command="\l" # do see DB on server and parameters
-* postgres:~$ createuser -D -R -S <UNIX user>
-* postgres:~$ createdb -O <postgres user> <database name>
-* $ pg_dump -Fc --verbose --file=<file name (.data)> <database name>
-* $ pg_restore --verbose --no-owner --no-privileges --dbname=<database name> <file name (.data)> # restore the data base as a different user eg. to clone a Drupal website
+* List of DB with parameters
+{{{#!sh
+$ psql postgres --command="\l"
+}}}
+* Create user
+{{{#!sh
+postgres:~$ createuser -D -R -S <UNIX user>
+}}}
+* Create DB
+{{{#!sh
+postgres:~$ createdb -O <postgres user> <database name>
+}}}
+* Backup
+{{{#!sh
+$ pg_dump -Fc --verbose --file=<file name (.data)> <database name>
+}}}
+* Restore the data base as a different user eg. to clone a Drupal website (bad idea to clone a drupal website)
+{{{#!sh
+$ pg_restore --verbose --no-owner --no-privileges --dbname=<database name> <file name (.data)>
+}}}
+* Drop all tables in a database
+ * keywords: drop all tables from postgres database
+ * This can be copyed into psql
+{{{#!sql
+DROP FUNCTION IF EXISTS remove_all();
+
+CREATE FUNCTION remove_all() RETURNS void AS $$
+DECLARE
+    rec RECORD;
+    cmd text;
+BEGIN
+    cmd := '';
+
+    FOR rec IN SELECT
+            'DROP SEQUENCE ' || quote_ident(n.nspname) || '.'
+                || quote_ident(c.relname) || ' CASCADE;' AS name
+        FROM
+            pg_catalog.pg_class AS c
+        LEFT JOIN
+            pg_catalog.pg_namespace AS n
+        ON
+            n.oid = c.relnamespace
+        WHERE
+            relkind = 'S' AND
+            n.nspname NOT IN ('pg_catalog', 'pg_toast') AND
+            pg_catalog.pg_table_is_visible(c.oid)
+    LOOP
+        cmd := cmd || rec.name;
+    END LOOP;
+
+    FOR rec IN SELECT
+            'DROP TABLE ' || quote_ident(n.nspname) || '.'
+                || quote_ident(c.relname) || ' CASCADE;' AS name
+        FROM
+            pg_catalog.pg_class AS c
+        LEFT JOIN
+            pg_catalog.pg_namespace AS n
+        ON
+            n.oid = c.relnamespace WHERE relkind = 'r' AND
+            n.nspname NOT IN ('pg_catalog', 'pg_toast') AND
+            pg_catalog.pg_table_is_visible(c.oid)
+    LOOP
+        cmd := cmd || rec.name;
+    END LOOP;
+
+    FOR rec IN SELECT
+            'DROP FUNCTION ' || quote_ident(ns.nspname) || '.'
+                || quote_ident(proname) || '(' || oidvectortypes(proargtypes)
+                || ');' AS name
+        FROM
+            pg_proc
+        INNER JOIN
+            pg_namespace ns
+        ON
+            (pg_proc.pronamespace = ns.oid)
+        WHERE
+            ns.nspname =
+            'public'
+        ORDER BY
+            proname
+    LOOP
+        cmd := cmd || rec.name;
+    END LOOP;
+
+    EXECUTE cmd;
+    RETURN;
+END;
+$$ LANGUAGE plpgsql;
+
+SELECT remove_all();
+}}}
+http://stackoverflow.com/questions/3327312/drop-all-tables-in-postgresql
+ * http://stackoverflow.com/questions/20017552/delete-all-table-without-droping-database-in-postgres-in-django-dbshell-in-one-c
 == Javascript: from npm to bower ==
 * $ nice -n 127 ionice --class=idle npm install bower --save
@@ -283 +369 @@
  * [https://www.drupal.org/node/1314752 Versioned dependencies and Git]
 * [https://git-scm.com/book/tr/v2/Git-Internals-Git-References 10.3 Git Internals - Git References]
+== Drupal 8 requirements and particularities ==
+* Drupal 8.0.5 needs Postgresql >= 9.1.2 instead of 8.4.20 #11587, #11522
+* Drupal 8.0.4-or-5 does not work with Postgres
+ * keywords: drupal 8 postgresql
+ * [https://www.drupal.org/node/2157455 Make Drupal 8 work with PostgreSQL or remove support from core before release]
+ * [https://www.drupal.org/node/1060476 Multiple issues when PostgreSQL is used with non-public schema]
 == CKEditor for Drupal 7 ==
 Lets'use wysiwyg module