def test_paste_to_for_cut_different_sheet(self):
self.user = User()
self.user.save()
c2 = Cell()
c2.formula = 'foo'
c2.formatted_value = 'fv'
d2 = Cell()
d2.formula = 'fv to become formula'
d2.formatted_value = d2.formula
c3 = Cell()
d3 = Cell()
c5 = Cell()
c5.formula = 'a safe source cell'
dest_cells = {
(3, 4): c2,
(3, 5): c3,
(4, 4): d2,
(4, 5): d3,
}
source_sheet = Sheet()
source_sheet.owner = self.user
source_sheet.save()
clipboard = Clipboard()
clipboard.to_cells = Mock()
clipboard.to_cells.return_value = dest_cells.iteritems()
clipboard.is_cut = True
clipboard.source_sheet = source_sheet
clipboard.source_left = 3
clipboard.source_top = 2
clipboard.source_right = 4
clipboard.source_bottom = 3
destination_sheet = Sheet()
destination_sheet.owner = self.user
destination_worksheet = Worksheet()
destination_worksheet.C4.formula = 'i am in danger!'
destination_worksheet.A1.formula = 'i am safe :-)'
destination_sheet.jsonify_worksheet(destination_worksheet)
destination_sheet.save()
clipboard.paste_to(destination_sheet, (3, 4), (3, 4))
updated_worksheet = destination_sheet.unjsonify_worksheet()
self.assertEquals(updated_worksheet.A1.formula, 'i am safe :-)')
self.assertEquals(updated_worksheet.C4.formula, c2.formula)
self.assertEquals(updated_worksheet.D4.formula, d2.formula)
self.assertEquals(updated_worksheet.C5.formula, c3.formula)
self.assertEquals(updated_worksheet.d5.formula, d3.formula)
# paste should reset the clipboard so that future pastes act as
# though they came from a copy
self.assertEquals(clipboard.source_left, 3)
self.assertEquals(clipboard.source_top, 4)
self.assertEquals(clipboard.source_right, 4)
self.assertEquals(clipboard.source_bottom, 5)
self.assertEquals(clipboard.is_cut, False)
self.assertEquals(clipboard.source_sheet, None)
def test_cut_calls_copy_then_cuts_and_remembers_some_stuff(self):
clipboard = Clipboard()
sheet = Sheet()
user = User()
user.username = '******'
user.save()
sheet.owner = user
clipboard.copy = Mock(wraps=clipboard.copy)
worksheet = Worksheet()
worksheet.A1.formula = 'outside'
worksheet.A2.formula = 'inside'
sheet.jsonify_worksheet(worksheet)
sheet.save()
clipboard.cut(sheet, (1, 2), (3, 4))
self.assertCalledOnce(clipboard.copy, sheet, (1, 2), (3, 4))
worksheet = sheet.unjsonify_worksheet()
self.assertEquals(worksheet.A1.formula, 'outside')
self.assertEquals(worksheet.A2, Cell())
self.assertEquals(clipboard.source_left, 1)
self.assertEquals(clipboard.source_top, 2)
self.assertEquals(clipboard.source_right, 3)
self.assertEquals(clipboard.source_bottom, 4)
self.assertEquals(clipboard.is_cut, True)
self.assertEquals(clipboard.source_sheet, sheet)
def test_sheet_name_not_set_on_save_if_name_is_not_default(self):
user = User(username='******')
user.save()
sheet = Sheet(owner=user)
sheet.name = 'new sheet name'
sheet.save()
self.assertEquals(sheet.name, 'new sheet name')
def test_uuid_stays_constant_between_reads(self):
sheet = Sheet()
user = User(username='******')
user.save()
sheet.owner = user
sheet.save()
sheet2 = Sheet.objects.get(pk=sheet.id)
self.assertEquals(sheet.api_key, sheet2.api_key)
def test_unicode(self):
user = User(username='******')
user.save()
sheet = Sheet(owner=user, name='sheet to feature')
sheet.save()
description = 'twas brillig and the slithy toves'
more_info_url = 'http://far.away/'
fs = FeaturedSheet(sheet=sheet, description=description, more_info_url=more_info_url)
fs.save()
self.assertEquals(unicode(fs), u'Feature: %s' % (sheet.name,))
def edit_sheet(request, sheet_id=None):
"""
If sheet_id != None it edit the sheet otherwise it create a new one.
"""
c = {}
if sheet_id:
if request.method == "GET":
form = SheetForm(request.GET)
if form.is_valid():
this_sheet = Sheet.objects.get(id=sheet_id)
this_sheet.title = form.cleaned_data['title']
this_sheet.description = form.cleaned_data['description']
this_sheet.s_public = form.cleaned_data['is_public']
this_sheet.save()
if int(request.GET.get('show', False)):
return HttpResponseRedirect('../{0}'.format(sheet_id))
else:
return HttpResponseRedirect('../res')
else:
c['sheet_id'] = sheet_id
this_sheet = Sheet.objects.get(id=sheet_id)
init = {}
init['title'] = this_sheet.title
init['description'] = this_sheet.description
init['is_public'] = this_sheet.is_public
form = SheetForm(initial=init)
c['form'] = form
c['show'] = int(request.GET.get('show', False))
else:
if request.method == "GET":
form = SheetForm(request.GET)
if form.is_valid():
this_sheet = Sheet(title=form.cleaned_data['title'], description=form.cleaned_data['description'], is_public=form.cleaned_data['is_public'])
this_sheet.save()
this_user = User.objects.get(username=request.user.username)
this_sheet.user.add(this_user)
this_sheet.save()
return HttpResponseRedirect(str(this_sheet.id))
else:
form = SheetForm()
c['form'] = form
c['show'] = int(request.GET.get('show', False))
if request.is_ajax():
t = 'edit.html'
else:
t = 'home.html'
try:
c['sm_user'] = request.session['sm_user']
except:
pass
c['content'] = 'edit.html'
return render_to_response(t, c)
def test_can_construct_without_more_info_url(self):
user = User(username='******')
user.save()
sheet = Sheet(owner=user, name='sheet to feature')
sheet.save()
description = 'twas brillig and the slithy toves'
fs = FeaturedSheet(sheet=sheet, description=description)
fs.save()
self.assertEquals(fs.sheet, sheet)
self.assertEquals(fs.description, description)
self.assertEquals(fs.more_info_url, '')
def test_can_construct_with_more_info_url(self):
user = User(username='******')
user.save()
sheet = Sheet(owner=user, name='sheet to feature')
sheet.save()
description = 'twas brillig and the slithy toves'
more_info_url = 'http://far.away/'
fs = FeaturedSheet(sheet=sheet, description=description, more_info_url=more_info_url)
fs.save()
self.assertEquals(fs.sheet, sheet)
self.assertEquals(fs.description, description)
self.assertEquals(fs.more_info_url, more_info_url)
def test_roundtrip_column_widths_to_db(self, mock_json):
COLUMN_WIDTHS = {'1': 11, '2': 22, '3': 33}
mock_json.loads.return_value = COLUMN_WIDTHS
mock_json.dumps.return_value = sentinel.json
user = User(username='******')
user.save()
sheet = Sheet(owner=user)
DEFAULT_COLUMN_WIDTHS_JSON = '{}'
self.assertEquals(
mock_json.loads.call_args,
((DEFAULT_COLUMN_WIDTHS_JSON,), {})
)
sheet.column_widths = COLUMN_WIDTHS
sheet.save()
self.assertEqual(
mock_json.dumps.call_args,
((COLUMN_WIDTHS,), {})
)
pk = sheet.id
sheet2 = Sheet.objects.get(pk=pk)
self.assertEquals(sheet2.column_widths, COLUMN_WIDTHS)
def test_copy_sheet_allows_other_users_to_copy_public_sheets(self):
user = User(username='******')
user.save()
worksheet = Worksheet()
worksheet.a1.value = 'some-cell-content'
sheet = Sheet()
sheet.owner = user
sheet.is_public = True
sheet.jsonify_worksheet(worksheet)
sheet.save()
original_sheet_id = sheet.id
other_user = User(username='******')
other_user.save()
retval = copy_sheet_to_user(sheet, other_user)
other_user_sheets = Sheet.objects.filter(owner=other_user)
self.assertEquals(len(other_user_sheets), 1)
copied_sheet = other_user_sheets[0]
self.assertFalse(copied_sheet.is_public)
copied_worksheet = copied_sheet.unjsonify_worksheet()
self.assertEquals(copied_worksheet.a1.value, 'some-cell-content')
self.assertEquals(copied_sheet.id, retval.id)
self.assertNotEquals(retval.id, original_sheet_id)
def test_unicode(self):
user = User(username='******')
user.save()
sheet = Sheet(owner=user, name='the new sheet name')
sheet.save()
self.assertEquals(unicode(sheet), 'Sheet %d: %s' % (sheet.id, sheet.name))
def test_sheet_name_set_on_save_if_name_is_default(self):
user = User(username='******')
user.save()
sheet = Sheet(owner=user)
sheet.save()
self.assertEquals(sheet.name, 'Sheet %d' % (sheet.id,))
