Added bulk acceptance and progress bar in review org applications view. In the list of organization applications for reviewing, if you click the button "click here" the whole first text line will fade out and the progress bar will fade in while starting to contact the server for the list of orgs to accept and then make synchronous calls for acceptance, while updating the progress bar, the name of the organization currently accepting and the number of orgs already accepted against the total. Inside the script, what's inside the parenthesis is converted due to regexp (in this case (link_id)) and then read the json_object.applications[index].link_id. By doing this with an eval(), you can use other names as well and the script will be reading for example json_object.applications[index].attribute_name if you insert "(attribute_name)" inside the link returned by {{ bulk_accept_link }}. Notes by Lennard: -Put Done outside the for-loop so that it also shows when there are 0 pre-accepted organizations. -Made some minor style fixes Patch by: Mario Ferraro Reviewed by: Lennard de Rijk

     1

from django.db.backends.postgresql.introspection import DatabaseIntrospection as PostgresDatabaseIntrospection

     2

     3

class DatabaseIntrospection(PostgresDatabaseIntrospection):

     4

     5

    def get_relations(self, cursor, table_name):

     6

        """

     7

        Returns a dictionary of {field_index: (field_index_other_table, other_table)}

     8

        representing all relationships to the given table. Indexes are 0-based.

     9

        """

    10

        cursor.execute("""

    11

            SELECT con.conkey, con.confkey, c2.relname

    12

            FROM pg_constraint con, pg_class c1, pg_class c2

    13

            WHERE c1.oid = con.conrelid

    14

                AND c2.oid = con.confrelid

    15

                AND c1.relname = %s

    16

                AND con.contype = 'f'""", [table_name])

    17

        relations = {}

    18

        for row in cursor.fetchall():

    19

            # row[0] and row[1] are single-item lists, so grab the single item.

    20

            relations[row[0][0] - 1] = (row[1][0] - 1, row[2])

    21

        return relations