DZone Snippets: Morlandi's Code Snippets

Packing ZODB from command line

morlandi (Mario Orlandi) — Thu, 08 May 2008 14:13:51 GMT

Packing ZODB from command line



$wget.exe --delete-after --user=admin --password=***** "http://localhost:8090/Control_Panel/manage_pack?days:float=0"



"D:\services\support\curl-7.17.0\curl" -d -v -f -u admin:password http://localhost:8090/Control_Panel/manage_pack?days:float=0

send django queries to OutputDebugString (Win32)

morlandi (Mario Orlandi) — Thu, 08 May 2008 13:18:14 GMT

Modify django/db/backends/util.py as follows:



import win32api



class CursorDebugWrapper(object):

    def __init__(self, cursor, db):

        self.cursor = cursor

        self.db = db # Instance of a BaseDatabaseWrapper subclass



    def debug_trace(self,category,message):

        win32api.OutputDebugString('|django              |%s|%s\n' % (category,message))



    def trace_entry (self, sql, elapsed): 

        self.debug_trace('Q',sql)

        if elapsed >= 0.01:

            self.debug_trace(' ','elapsed: %.3f' % elapsed)



    def execute(self, sql, params=()):

        start = time()

        try:

            return self.cursor.execute(sql, params)

        finally:

            stop = time()

            sql = self.db.ops.last_executed_query(self.cursor, sql, params)

            self.db.queries.append({

                'sql': sql,

                'time': "%.3f" % (stop - start),

            })

            self.trace_entry(sql, stop - start) 



    def executemany(self, sql, param_list):

        start = time()

        try:

            return self.cursor.executemany(sql, param_list)

        finally:

            stop = time()

            self.db.queries.append({

                'sql': '%s times: %s' % (len(param_list), sql),

                'time': "%.3f" % (stop - start),

            })

            self.trace_entry(sql, stop - start)

Fill combobox with enum values

morlandi (Mario Orlandi) — Wed, 07 Feb 2007 18:21:28 GMT



public enum CardDataType

{

    Unknown,

    Raw,

    RowChp

}



ctlDataType.DataSource = Enum.GetValues(typeof(CardDataType));

ctlDataType.SelectedItem = CardDataType.Unknown;



...

...

string strType = ctlDataType.SelectedItem.ToString();



or



CardDataType dataType;

string strDataType = "Raw";

dataType = (CardDataType)Enum.Parse(typeof(CardDataType), strDataType, true);



and eventually



ctlDataType.SelectedItem = dataType;

// a volte da' problemi in fase di inizializzazione della UI;
// in questi casi si puo' ricorrere a Enum.GetNames()



foreach ( string name in Enum.GetNames(typeof(CardDataType)) ) 

{

    ctlDataType.Items.Add(name);

}



...



string strDataType = "Raw";

ctlDataType.SelectedItem = strDataType;

IPython shell

morlandi (Mario Orlandi) — Mon, 05 Feb 2007 20:57:17 GMT

// "%PYTHON%" -i -c ..."



from Zope2 import configure; 

import os; 

configure(os.environ['ZOPE_CONFIG_FILE']); 



import Zope2; 

app=Zope2.app(); 



ns={'__name__':'blah','app':app};



import IPython; 

IPython.Shell.IPShell(user_ns=ns).mainloop(sys_exit=1);

review_state

morlandi (Mario Orlandi) — Fri, 19 Jan 2007 14:52:57 GMT

// retrieve review state



from Products.CMFCore.utils import getToolByName

wtool = getToolByName(context, "portal_workflow")

wf_state = wtool.getInfoFor(obj,'review_state',None)

object_delete

morlandi (Mario Orlandi) — Sun, 14 Jan 2007 12:18:02 GMT

// object_delete



from AccessControl import Unauthorized

from Products.CMFPlone.utils import transaction_note

from Products.CMFPlone import PloneMessageFactory as _



REQUEST = context.REQUEST

if REQUEST.get('REQUEST_METHOD', 'GET').upper() == 'GET':

    raise Unauthorized, 'This method can not be accessed using a GET request'



parent = context.aq_inner.aq_parent

parent.manage_delObjects(context.getId())



message = _(u'${title} has been deleted.',

            mapping={u'title' : context.title_or_id()})

transaction_note('Deleted %s' % context.absolute_url())



context.plone_utils.addPortalMessage(message)

return state.set(status = 'success')

ArrayList

morlandi (Mario Orlandi) — Mon, 08 Jan 2007 12:39:50 GMT



using System.Collections;



ArrayList arrList = new ArrayList();



arrList.Add("one");

arrList.Add("two");

arrList.Add("three");



string[] strArray = arrList.ToArray(Type.GetType("System.String")) as string[];

return strArray;

autoscroll text

morlandi (Mario Orlandi) — Mon, 08 Jan 2007 12:34:45 GMT



    textBox1.SelectionStart = textBox1.Text.Length;

    textBox1.SelectionLength = 0;

    textBox1.ScrollToCaret();

Abilitazione accesso remoto per PostgreSQL

morlandi (Mario Orlandi) — Fri, 22 Dec 2006 15:51:26 GMT

// in "pg_hba.conf"



host    all         all         192.168.98.0/24       md5

// in "postgresql.conf"



listen_addresses = '*'		# what IP address(es) to listen on;

Result Object Methods

morlandi (Mario Orlandi) — Fri, 17 Nov 2006 17:11:13 GMT

// Assuming that we have set result to being a result object we can use the following methods:

len(result)



     this will show the number rows returned (which would be 3 in the example above).

result.names()



    a list of all the column headings, returning a list containing emp_id, first, last and salary

result.tuples()



    returns a list of tuples in our example:



    [(43, 'Bob', 'Roberts', 50000),

     (101, 'Cheeta', 'leCat', 100000),

     (99, 'Jane', 'Junglewoman', 100001)]

result.dictionaries()



    will return a list of dictionaries, with one dictionary for each row:



    [{'emp_id': 42, 'first': 'Bob','last': 'Roberts', 'salary': 50000},

     {'emp_id': 101, 'first: 'Cheeta', 'last': 'leCat', 'salary': 100000},

     {'emp_id': 99, 'first': 'Jane', 'last': 'Junglewoman', 'salary': 100001}]

result.data_dictionary()



    returns a dictionary describing the structure of the results table. 



The dictionary has the key name, type, null and width. 

Name and type are self explanatory, null is true if that field may contain a null value and width is the width in characters of the field. 

Note that null and width may not be set by some Database Adapters.

result.asRDB()



    displays the result in a similar way to a relational database. 



The DTML below displays the result below:

    
      

    



    ... displays ...



    emp_id first last salary

    42 Bob Roberts 50000

    101 Cheeta leCat 100000

    99 Jane Junglewoman 100001

result[0][1]



    return row 0, column 1 of the result, bob in this example. 



Be careful using this method as changes in the schema will cause unexpected results.