243 def test_known_values(self): |
243 def test_known_values(self): |
244 dbhelper = get_db_helper('postgres') |
244 dbhelper = get_db_helper('postgres') |
245 output = list(schema2sql.schema2sql(dbhelper, schema, skip_relations=('works_for',))) |
245 output = list(schema2sql.schema2sql(dbhelper, schema, skip_relations=('works_for',))) |
246 self.assertEqual(output, EXPECTED_DATA_NO_DROP) |
246 self.assertEqual(output, EXPECTED_DATA_NO_DROP) |
247 |
247 |
|
248 def test_eschema_sql_def_attributes(self): |
|
249 dbhelper = get_db_helper('postgres') |
|
250 attr_defs = schema2sql.eschema_sql_def(dbhelper, schema['Person']) |
|
251 self.assertEqual(attr_defs, |
|
252 [('nom', 'varchar(64)'), |
|
253 ('prenom', 'varchar(64)'), |
|
254 ('sexe', "varchar(1) DEFAULT 'M'"), |
|
255 ('promo', 'varchar(22)'), |
|
256 ('titre', 'varchar(128)'), |
|
257 ('adel', 'varchar(128)'), |
|
258 ('ass', 'varchar(128)'), |
|
259 ('web', 'varchar(128)'), |
|
260 ('tel', 'integer'), |
|
261 ('fax', 'integer'), |
|
262 ('datenaiss', 'date'), |
|
263 ('test', 'boolean'), |
|
264 ('salary', 'float')]) |
|
265 |
|
266 def test_eschema_sql_def_inlined_rel(self): |
|
267 dbhelper = get_db_helper('postgres') |
|
268 attr_defs = schema2sql.eschema_sql_def(dbhelper, schema['Affaire']) |
|
269 self.assertEqual(attr_defs, |
|
270 [('sujet', 'varchar(128)'), |
|
271 ('ref', 'varchar(12)'), |
|
272 ('inline_rel', 'integer')]) |
|
273 |
248 |
274 |
249 if __name__ == '__main__': |
275 if __name__ == '__main__': |
250 unittest_main() |
276 unittest_main() |