Project

General

Profile

0001-testdef-add-new-table-to-hold-form-tests-71296.patch

Valentin Deniaud, 29 November 2022 05:23 PM

Download (3.86 KB)

View differences: 

Subject: [PATCH 1/3] testdef: add new table to hold form tests (#71296)


 wcs/sql.py     | 44 +++++++++++++++++++++++++++++++++++++++++++-
 wcs/testdef.py | 28 ++++++++++++++++++++++++++++
 2 files changed, 71 insertions(+), 1 deletion(-)
 create mode 100644 wcs/testdef.py
wcs/sql.py
1636 1636 
    cur.close()
1637 1637 

  		




  1638
  1638
  
    

  		




  
  1639
  
    
def do_testdef_table():

  		




  
  1640
  
    
    conn, cur = get_connection_and_cursor()

  		




  
  1641
  
    
    table_name = 'testdef'

  		




  
  1642
  
    

  		




  
  1643
  
    
    cur.execute(

  		




  
  1644
  
    
        '''SELECT COUNT(*) FROM information_schema.tables

  		




  
  1645
  
    
                    WHERE table_schema = 'public'

  		




  
  1646
  
    
                      AND table_name = %s''',

  		




  
  1647
  
    
        (table_name,),

  		




  
  1648
  
    
    )

  		




  
  1649
  
    
    if cur.fetchone()[0] == 0:

  		




  
  1650
  
    
        cur.execute(

  		




  
  1651
  
    
            '''CREATE TABLE %s (id varchar PRIMARY KEY,

  		




  
  1652
  
    
                                        name varchar,

  		




  
  1653
  
    
                                        slug varchar,

  		




  
  1654
  
    
                                        object_type varchar,

  		




  
  1655
  
    
                                        object_id varchar,

  		




  
  1656
  
    
                                        data jsonb

  		




  
  1657
  
    
                                        )'''

  		




  
  1658
  
    
            % table_name

  		




  
  1659
  
    
        )

  		




  
  1660
  
    
    cur.execute(

  		




  
  1661
  
    
        '''SELECT column_name FROM information_schema.columns

  		




  
  1662
  
    
                    WHERE table_schema = 'public'

  		




  
  1663
  
    
                      AND table_name = %s''',

  		




  
  1664
  
    
        (table_name,),

  		




  
  1665
  
    
    )

  		




  
  1666
  
    
    existing_fields = {x[0] for x in cur.fetchall()}

  		




  
  1667
  
    

  		




  
  1668
  
    
    needed_fields = {x[0] for x in CustomView._table_static_fields}

  		




  
  1669
  
    

  		




  
  1670
  
    
    # delete obsolete fields

  		




  
  1671
  
    
    for field in existing_fields - needed_fields:

  		




  
  1672
  
    
        cur.execute('''ALTER TABLE %s DROP COLUMN %s''' % (table_name, field))

  		




  
  1673
  
    

  		




  
  1674
  
    
    conn.commit()

  		




  
  1675
  
    
    cur.close()

  		




  
  1676
  
    

  		




  
  1677
  
    

  		




  1639
  1678
  
    
def migrate_legacy_tokens():

  		




  1640
  1679
  
    
    # store old pickle tokens in SQL

  		




  1641
  1680
  
    
    for token_id in wcs.qommon.tokens.Token.keys():

  		




  ......




  4648
  4687
  
    
# latest migration, number + description (description is not used

  		




  4649
  4688
  
    
# programmaticaly but will make sure git conflicts if two migrations are

  		




  4650
  4689
  
    
# separately added with the same number)

  		




  4651
  
  
    
SQL_LEVEL = (69, 'add auto_geoloc field')

  		




  
  4690
  
    
SQL_LEVEL = (70, 'add testdef table')

  		




  4652
  4691
  
    

  		




  4653
  4692
  
    

  		




  4654
  4693
  
    
def migrate_global_views(conn, cur):

  		




  ......




  4830
  4869
  
    
    if sql_level < 68:

  		




  4831
  4870
  
    
        # 68: multilinguism

  		




  4832
  4871
  
    
        TranslatableMessage.do_table()

  		




  
  4872
  
    
    if sql_level < 70:

  		




  
  4873
  
    
        # 70: create testdef table

  		




  
  4874
  
    
        do_testdef_table()

  		




  4833
  4875
  
    
    if sql_level < 52:

  		




  4834
  4876
  
    
        # 2: introduction of formdef_id in views

  		




  4835
  4877
  
    
        # 5: add concerned_roles_array, is_at_endpoint and fts to views

  		












  

    
      wcs/testdef.py
    
  





  
  1
  
    
# w.c.s. - web application for online forms

  		




  
  2
  
    
# Copyright (C) 2005-2022  Entr'ouvert

  		




  
  3
  
    
#

  		




  
  4
  
    
# This program is free software; you can redistribute it and/or modify

  		




  
  5
  
    
# it under the terms of the GNU General Public License as published by

  		




  
  6
  
    
# the Free Software Foundation; either version 2 of the License, or

  		




  
  7
  
    
# (at your option) any later version.

  		




  
  8
  
    
#

  		




  
  9
  
    
# This program is distributed in the hope that it will be useful,

  		




  
  10
  
    
# but WITHOUT ANY WARRANTY; without even the implied warranty of

  		




  
  11
  
    
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

  		




  
  12
  
    
# GNU General Public License for more details.

  		




  
  13
  
    
#

  		




  
  14
  
    
# You should have received a copy of the GNU General Public License

  		




  
  15
  
    
# along with this program; if not, see <http://www.gnu.org/licenses/>.

  		




  
  16
  
    

  		




  
  17
  
    
from .qommon.storage import StorableObject

  		




  
  18
  
    

  		




  
  19
  
    

  		




  
  20
  
    
class TestDef(StorableObject):

  		




  
  21
  
    
    _names = 'testdef'

  		




  
  22
  
    

  		




  
  23
  
    
    name = ''

  		




  
  24
  
    
    slug = None

  		




  
  25
  
    
    object_type = None  # (formdef, carddef, etc.)

  		




  
  26
  
    
    object_id = None

  		




  
  27
  
    

  		




  
  28
  
    
    data = None  # (json export of formdata, carddata, etc.)

  		




  0
  
  
    
-