def test_import_catagory_data(self):
load_local_data(self.Donkey, {"__table": u"sub_sub_category",
"category.category_name": u"a",
"category.category_description": u"this is a",
"category.category_type": u"wee",
"sub_category.sub_category_name": u"ab",
"sub_category.sub_category_description": u"this is ab",
"sub_sub_category.sub_sub_category_name": u"abc",
"sub_sub_category.sub_sub_category_description": u"this is abc"}
)
results = self.session.query(self.Donkey.get_class("sub_sub_category")).all()
print [get_all_local_data(a) for a in results]
def test_create_local_data(self):
result = self.session.query(self.Donkey.tables["donkey_sponsership"].sa_class).first()
print get_all_local_data(result, internal = True)
assert get_all_local_data(result, internal = True) == {'contact_summary.people_id': 1, 'giving_date': None, 'contact_summary.transaction_count': 0, 'people.name': u'david', '__table': 'donkey_sponsership', 'primary_entity._core_entity.summary': u'name: david -- address_line_1: 43 union street -- postcode: es388', 'people.address_line_1': u'43 union street', 'people.town': None, 'people_id': 1, 'people.postcode': u'es388', 'people.country': None, 'people.address_line_2': None, 'people.over_18_id': None, 'people.address_line_3': None, 'primary_entity._core_entity.title': u'david', 'contact_summary.total_amount': Decimal('0'), 'amount': Decimal('50'), 'donkey_id': 1, 'people.gender_id': None, 'donkey.donkey_type': None, 'primary_entity._core_entity.table': u'people', 'donkey.age': 13, 'primary_entity._core_entity.thumb': None, 'donkey.name': u'jim'}
print get_all_local_data(result, fields = ["donkey_id", "contact_summary.total_amount", "donkey.name"])
assert get_all_local_data(result, fields = ["donkey_id", "contact_summary.total_amount", "donkey.name"]) == {'contact_summary.total_amount': '0.00', '__table': 'donkey_sponsership', 'donkey.name': u'jim', 'donkey_id': 1, 'id': 1}
assert str(e.error_dict["donkey.age"]) == "[Invalid(u'Please enter an integer value',), Invalid(u'Please enter an integer value',)]"
load_local_data(self.Donkey, {"__table": u"donkey_sponsership",
"donkey_sponsership.amount" : 711110,
"donkey.age" : 12,
"people.name" : u"fred",
"people.postcode" : u"fred",
"people.address_line_1" : u"poo1010101",
"people.address_line_2" : u"poop"})
a = self.session.query(self.Donkey.get_class("donkey_sponsership")).filter_by(amount = 711110).one()
print get_all_local_data(a, internal = True)
assert get_all_local_data(a, internal = True) == {'contact_summary.people_id': 2, 'giving_date': None, 'contact_summary.transaction_count': 0, 'people.name': u'fred', '__table': 'donkey_sponsership', 'primary_entity._core_entity.summary': u'name: fred -- address_line_1: poo1010101 -- postcode: fred', 'people.address_line_1': u'poo1010101', 'people.town': None, 'people_id': 2, 'people.postcode': u'fred', 'people.country': None, 'people.address_line_2': u'poop', 'people.over_18_id': None, 'people.address_line_3': None, 'primary_entity._core_entity.title': u'fred', 'contact_summary.total_amount': Decimal('0'), 'amount': Decimal('711110'), 'donkey_id': 12, 'people.gender_id': None, 'donkey.donkey_type': None, 'primary_entity._core_entity.table': u'people', 'donkey.age': 12, 'primary_entity._core_entity.thumb': None, 'donkey.name': None}
def test_import_catagory_data(self):
load_local_data(self.Donkey, {"__table": u"sub_sub_category",
"category.category_name": u"a",
"category.category_description": u"this is a",
"category.category_type": u"wee",
"sub_category.sub_category_name": u"ab",
"sub_category.sub_category_description": u"this is ab",
"sub_sub_category.sub_sub_category_name": u"abc",
"sub_sub_category.sub_sub_category_description": u"this is abc"}
)
results = self.session.query(self.Donkey.get_class("sub_sub_category")).all()
