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