| 110 |
110 |
|
| 111 |
111 |
def test_sql_get_missing_ignore_errors():
|
| 112 |
112 |
data_class = formdef.data_class(mode='sql')
|
| 113 |
113 |
assert data_class.get(123456, ignore_errors=True) is None
|
| 114 |
114 |
assert data_class.get('xxx', ignore_errors=True) is None
|
| 115 |
115 |
assert data_class.get(None, ignore_errors=True) is None
|
| 116 |
116 |
|
| 117 |
117 |
|
| 118 |
|
def check_sql_field(no, value):
|
|
118 |
def check_sql_field(no, value, display=False):
|
| 119 |
119 |
data_class = formdef.data_class(mode='sql')
|
| 120 |
120 |
formdata = data_class()
|
| 121 |
121 |
formdata.data = {no: value}
|
|
122 |
if display:
|
|
123 |
formdata.data['%s_display' % no] = value
|
| 122 |
124 |
formdata.store()
|
| 123 |
125 |
id = formdata.id
|
| 124 |
126 |
|
| 125 |
127 |
formdata = data_class.get(id)
|
| 126 |
128 |
assert formdata.data.get(no) == value
|
| 127 |
129 |
|
| 128 |
130 |
|
| 129 |
131 |
def test_sql_field_string():
|
| ... | ... | |
| 142 |
144 |
|
| 143 |
145 |
|
| 144 |
146 |
def test_sql_field_bool():
|
| 145 |
147 |
check_sql_field('3', False)
|
| 146 |
148 |
check_sql_field('3', True)
|
| 147 |
149 |
|
| 148 |
150 |
|
| 149 |
151 |
def test_sql_field_item():
|
| 150 |
|
check_sql_field('4', 'apricot')
|
|
152 |
check_sql_field('4', 'apricot', display=True)
|
| 151 |
153 |
|
| 152 |
154 |
|
| 153 |
155 |
def test_sql_field_date():
|
| 154 |
156 |
check_sql_field('5', datetime.date.today().timetuple())
|
| 155 |
157 |
|
| 156 |
158 |
|
| 157 |
159 |
def test_sql_field_items():
|
| 158 |
|
check_sql_field('6', ['apricot'])
|
| 159 |
|
check_sql_field('6', ['apricot', 'pear'])
|
| 160 |
|
check_sql_field('6', ['pomme', 'poire', 'pêche'])
|
|
160 |
check_sql_field('6', ['apricot'], display=True)
|
|
161 |
check_sql_field('6', ['apricot', 'pear'], display=True)
|
|
162 |
check_sql_field('6', ['pomme', 'poire', 'pêche'], display=True)
|
| 161 |
163 |
|
| 162 |
164 |
|
| 163 |
165 |
def test_sql_geoloc():
|
| 164 |
166 |
test_formdef = FormDef()
|
| 165 |
167 |
test_formdef.name = 'geoloc'
|
| 166 |
168 |
test_formdef.fields = []
|
| 167 |
169 |
test_formdef.geolocations = {'base': 'Plop'}
|
| 168 |
170 |
test_formdef.store()
|
| 169 |
|
-
|