December 2001 - Zope

Re: [Zope] delete multiple records sql python etc
by H.de.Wit＠SFK.NL 06 Dec '01

06 Dec '01

I hope i understand your question correctly: How do i delete records from a database, based on a form where i use checkboxes to indicate which records have to be deleted. I did this with a list converter (table html is left out) <form action=throw_away_script method=post> <dtml-in expr="SQL_from_useraccount(user_id=REQUEST['user_id'])"> <input type="checkbox" name="throw_away_list:list" value="<dtml-var user_id>"> </dtml-in> </form> throw_away_script is a python script that looks like this: request = container.REQUEST throw_away_list=request.throw_away_list for i in throw_away_list: context.SQL_throw_away_onerecord(user_id=i) The SQL_throw_away_onerecord query is probably not the problem, just deletes 1 record. Met vriendelijke groeten, Hans de Wit Stichting Farmaceutische Kengetallen Postbus 30460 2500 GL DEN HAAG Tel. 070-3737448 Fax 070-3737445 "Todd Graham" <tgraham@spea To: <zope(a)zope.org> keasy.net> cc: Sent by: Subject: [Zope] delete multiple records sql python etc zope-admin@zo pe.org 06-12-01 07:49 AM I've looked through the archives and seen similar posts but none of the replies seem to solve my problem. Here goes... I've got a table called user_accounts that has user_id, application, username that make up the primary key, this is a child table to the user_info table which has user_id as the primary key. As part of the application I want my users to be able to delete multiple rows from the user_accounts table that are displayed in a form via a zsql method that looks like : select * from user_accounts where user_id = <dtml-sqlvar user_id> Based on the result sets of the sql method I build a form that lists the username, user_id, application etc, with one checkbox for each record. My question is how do I pass the all the values from one or more rows to a python script based on whether or not the box is checked. I've tried several combinations of using record(s) converters and list converters but at this point I'm stumped. Thanks in advance, Todd _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

1 0

RE: [Zope] Zope News For December 3
by Huston, Virgil H. 06 Dec '01

06 Dec '01

Great newsletter! I went to thr PeopleWhoCanContribute page and for the life of me can't figure out how to volunteer. Anyone know? Virgil Huston

3 2

Help with Coding
by Todd Loomis 05 Dec '01

05 Dec '01

Hi All: I'm using the below code to get the year and month of the current date. With that I would like to insert them into my with statement. Can and if so how. <dtml-call "REQUEST.set('year', ZopeTime().strftime('%Y'))"> <dtml-call "REQUEST.set('month', ZopeTime().strftime('%m'))"> <dtml-with "pao.stories.y_("year").m_("month")"> Thanks, Todd

3 2

Python script/security help
by Keith Alperin 05 Dec '01

05 Dec '01

Greetings Zopistas! Currently, I'm having problems with a python script. Let me describe the situation. I have a product (Member) which has a number of properties. These properties are themselves instances of a Property class. The Property class only has getValue() and setValue() methods. Thus, in order to get the member's first name, I can use the following syntax: myMember.fname.getValue() The getValue() method is declared as public with the following syntax: security = ClassSecurityInfo() security.declarePublic('getValue') def getValue(self): """returns the value of this property""" return self.value I can call the fname.getValue() method from another method of my member object. The problem is that when I attempt to call the fname.getValue() method from a python script, I am prompted for my password and then am given an error: "Unauthorized: getValue" I think that I'm missing something important related to python script security, but haven't been able to determine what it is. Any help would be MOST appreciated. Thanks in advance, Keith R. Alperin

3 2

Again: searching booleans
by Pablo Ziliani 05 Dec '01

05 Dec '01

Please, let me know if i'm not being clear ... or something. Dear all, Even though it seems so basic, I could't find a single reference to this problem. I'm trying to list some objects of a given meta_type based on some booleans they *might* have. For example: <dtml-in "Catalog.searchResults({'meta_type':'whatever','published':'1'})"> While a missing boolean property (always?) means "off", there's often arbitrary values when in "on" state, mainly depending on how the input was set in the form. So the question is: how should the query be set to bring only those items that DO have a certain property? Thanx, Pablo

1 0

Re: [Zope] CoreSessions object deletion
by Frank Tegtmeyer 05 Dec '01

05 Dec '01

"Chris McDonough" <chrism(a)zope.com> writes: > The delete method is part of the interface, AFAICT, isn't it? Or is > that not what you mean? The "Core Session Tracking Release 0.9 Documentation" doesn't mention 'delete' at all. "Modifying A Session Data Object" does handle set(), get() and has_key(), but no way to delete anything. The sentence "A session data object has essentially the same restrictions as a Python dictionary." gives an idea what's going on but can't qualify as an exact interface description. And it's about restricions, not about the possibilities :) Regards, Frank -- CTO fte(a)Lightwerk.com http://www.Lightwerk.com/ Fax: +49-2434-80 07 94 Phone: +49-2434-80 07 81 Lightwerk GmbH * An der Kull 11 * 41844 Wegberg * Germany

2 1

Search
by Todd Loomis 05 Dec '01

05 Dec '01

Hi All: How can I use one input field to search both PrincipiaSearchSource and title? I'm only doing PrincipiaSearchSource and would like to add title. Thanks, Todd ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Todd Loomis SAIC - DMSO Support 1901 N. Beauregard Street, Suite 500 Alexandria, VA 22311 Office: 703.824.3407 Fax: 703.379.3778 tloomis(a)dmso.mil

2 1

RE: [Zope] Python script/security help
by Keith Alperin 05 Dec '01

05 Dec '01

Evan, that document told me everything I needed to know. Thank you for pointing it out. My problem was that my Property class did not inherit from Acquisition.Implicit, thus rendering the security infrastructure unusable. Thanks again! Keith -----Original Message----- From: Evan Simpson [mailto:evan@4-am.com] Sent: Wednesday, December 05, 2001 10:19 AM To: Keith Alperin Cc: zope(a)zope.org Subject: Re: [Zope] Python script/security help Keith Alperin wrote: > security = ClassSecurityInfo() > security.declarePublic('getValue') > def getValue(self): > """returns the value of this property""" > return self.value If you haven't already, read http://dev.zope.org/Wikis/DevSite/Projects/DeclarativeSecurity/ZopeSecur ityForDevelopers, in particular the example right before the paragraph that starts with: "Note the last line in the example. In order for security assertions to be correctly applied to your class, you must call the global class initializer for all classes that have security information." Hopefully this will solve your problem. Cheers, Evan @ Zope

1 0

Re: [Zope] CoreSessions object deletion
by Frank Tegtmeyer 05 Dec '01

05 Dec '01

"Chris McDonough" <chrism(a)zope.com> writes: > session.delete is the right way to delete something from a session > data object. Thanks Chris. Perhaps your mail should be included in the documentation :) Regards, Frank -- CTO fte(a)Lightwerk.com http://www.Lightwerk.com/ Fax: +49-2434-80 07 94 Phone: +49-2434-80 07 81 Lightwerk GmbH * An der Kull 11 * 41844 Wegberg * Germany

2 1

CoreSessions object deletion
by Frank Tegtmeyer 05 Dec '01

05 Dec '01

A short question: is it safe to use session.delete(key)? I saw it somewhere and because the interface doesn't include any description for deletion of objects in the container it may be the standard way. Are there any problems to expect if another Datamanager implementation (besides the RAM based one) is used? Regards Frank -- CTO fte(a)Lightwerk.com http://www.Lightwerk.com/ Fax: +49-2434-80 07 94 Phone: +49-2434-80 07 81 Lightwerk GmbH * An der Kull 11 * 41844 Wegberg * Germany

2 1