Skip to main content
.. contents::



Change history
**************

Changelog
=========

1.0 (xxxx-xx-xx)
----------------

- Created recipe with ZopeSkel
[""]

Detailed Documentation
**********************

Introduction
============

This is a full-blown functional test. The emphasis here is on testing what
the user may input and see, and the system is largely tested as a black box.
We use PloneTestCase to set up this test as well, so we have a full Plone site
to play with. We *can* inspect the state of the portal, e.g. using
self.portal and self.folder, but it is often frowned upon since you are not
treating the system as a black box. Also, if you, for example, log in or set
roles using calls like self.setRoles(), these are not reflected in the test
browser, which runs as a separate session.

Being a doctest, we can tell a story here.

First, we must perform some setup. We use the testbrowser that is shipped
with Five, as this provides proper Zope 2 integration. Most of the
documentation, though, is in the underlying zope.testbrower package.

>>> from Products.Five.testbrowser import Browser
>>> browser = Browser()
>>> portal_url = self.portal.absolute_url()

The following is useful when writing and debugging testbrowser tests. It lets
us see all error messages in the error_log.

>>> self.portal.error_log._ignored_exceptions = ()

With that in place, we can go to the portal front page and log in. We will
do this using the default user from PloneTestCase:

>>> from Products.PloneTestCase.setup import portal_owner, default_password

Because add-on themes or products may remove or hide the login portlet, this test will use the login form that comes with plone.

>>> browser.open(portal_url + '/login_form')
>>> browser.getControl(name='__ac_name').value = portal_owner
>>> browser.getControl(name='__ac_password').value = default_password
>>> browser.getControl(name='submit').click()

Here, we set the value of the fields on the login form and then simulate a
submit click. We then ensure that we get the friendly logged-in message:

>>> "You are now logged in" in browser.contents
True

Finally, let's return to the front page of our site before continuing

>>> browser.open(portal_url)

-*- extra stuff goes here -*-
The Encrypted SQL Adapter content type
===============================

In this section we are tesing the Encrypted SQL Adapter content type by performing
basic operations like adding, updadating and deleting Encrypted SQL Adapter content
items.

Adding a new Encrypted SQL Adapter content item
--------------------------------

We use the 'Add new' menu to add a new content item.

>>> browser.getLink('Add new').click()

Then we select the type of item we want to add. In this case we select
'Encrypted SQL Adapter' and click the 'Add' button to get to the add form.

>>> browser.getControl('Encrypted SQL Adapter').click()
>>> browser.getControl(name='form.button.Add').click()
>>> 'Encrypted SQL Adapter' in browser.contents
True

Now we fill the form and submit it.

>>> browser.getControl(name='title').value = 'Encrypted SQL Adapter Sample'
>>> browser.getControl('Save').click()
>>> 'Changes saved' in browser.contents
True

And we are done! We added a new 'Encrypted SQL Adapter' content item to the portal.

Updating an existing Encrypted SQL Adapter content item
---------------------------------------

Let's click on the 'edit' tab and update the object attribute values.

>>> browser.getLink('Edit').click()
>>> browser.getControl(name='title').value = 'New Encrypted SQL Adapter Sample'
>>> browser.getControl('Save').click()

We check that the changes were applied.

>>> 'Changes saved' in browser.contents
True
>>> 'New Encrypted SQL Adapter Sample' in browser.contents
True

Removing a/an Encrypted SQL Adapter content item
--------------------------------

If we go to the home page, we can see a tab with the 'New Encrypted SQL Adapter
Sample' title in the global navigation tabs.

>>> browser.open(portal_url)
>>> 'New Encrypted SQL Adapter Sample' in browser.contents
True

Now we are going to delete the 'New Encrypted SQL Adapter Sample' object. First we
go to the contents tab and select the 'New Encrypted SQL Adapter Sample' for
deletion.

>>> browser.getLink('Contents').click()
>>> browser.getControl('New Encrypted SQL Adapter Sample').click()

We click on the 'Delete' button.

>>> browser.getControl('Delete').click()
>>> 'Item(s) deleted' in browser.contents
True

So, if we go back to the home page, there is no longer a 'New Encrypted SQL Adapter
Sample' tab.

>>> browser.open(portal_url)
>>> 'New Encrypted SQL Adapter Sample' in browser.contents
False

Adding a new Encrypted SQL Adapter content item as contributor
------------------------------------------------

Not only site managers are allowed to add Encrypted SQL Adapter content items, but
also site contributors.

Let's logout and then login as 'contributor', a portal member that has the
contributor role assigned.

>>> browser.getLink('Log out').click()
>>> browser.open(portal_url + '/login_form')
>>> browser.getControl(name='__ac_name').value = 'contributor'
>>> browser.getControl(name='__ac_password').value = default_password
>>> browser.getControl(name='submit').click()
>>> browser.open(portal_url)

We use the 'Add new' menu to add a new content item.

>>> browser.getLink('Add new').click()

We select 'Encrypted SQL Adapter' and click the 'Add' button to get to the add form.

>>> browser.getControl('Encrypted SQL Adapter').click()
>>> browser.getControl(name='form.button.Add').click()
>>> 'Encrypted SQL Adapter' in browser.contents
True

Now we fill the form and submit it.

>>> browser.getControl(name='title').value = 'Encrypted SQL Adapter Sample'
>>> browser.getControl('Save').click()
>>> 'Changes saved' in browser.contents
True

Done! We added a new Encrypted SQL Adapter content item logged in as contributor.

Finally, let's login back as manager.

>>> browser.getLink('Log out').click()
>>> browser.open(portal_url + '/login_form')
>>> browser.getControl(name='__ac_name').value = portal_owner
>>> browser.getControl(name='__ac_password').value = default_password
>>> browser.getControl(name='submit').click()
>>> browser.open(portal_url)




Contributors
************

"", Author


Download
********

Release files for collective.pfg.sqlformadapter 1.0.3

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for collective.pfg.sqlformadapter 1.0.3
File Size Uploaded
collective.pfg.sqlformadapter-1.0.3.zip 34.3 kB Details

Release files / collective.pfg.sqlformadapter-1.0.3.zip

Download URL collective.pfg.sqlformadapter-1.0.3.zip
Size 34.3 kB
Tags Source
SHA-256 checksum
How to use checksums
0fb70ab25e6ef799d9d4657ff64436d889b4b82c0b0be60d51a39d22e56c4385
BLAKE2b-256 checksum
How to use checksums
75abc1d2648d954ca54c6392a49e46e1bb074f6d226b3ac1265b82e9aa9bd362
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Release history Release notifications | RSS feed

This release

1.0.3 This release

1 release file

1.0.2

1 release file

1.0.1

1 release file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page