dojo.io.bind

YES !
Actualy, I tried to submit a form to our server, but it has to go through AJAX protocol. I wish I could do it on mochikit library, but in order to mr.Bob Ipolito said, "there no plan to add a POST mechanism on mochi library". So I'm stuck.

Lucky me , Dojo library support it, they support form submit via XMLHTTPRequest protocol. Its little be hard to find how to do it, since dojo still under heavy development, but thanks to mr.google, heres the way I did on my code :

This is part of my button action / signal

var my_url = this.ajax_url+"ajax/ajax.items.php?task=test";
dojo.io.bind({ url : my_url,
load: function(type, data, evt)
{
alert(type);
alert(data);
alert(evt);
var rows = data.rows;
var cols = data.columns;
alert(cols[0]);
alert(rows[0]);
the_object.value = data;
},
formNode: getElement("aoiForm"),
mimetype:'text/json' });

You may found in this part of javascript code, there's as simple as mochikit did. Thats why I'll stick my GET method with mochikit and do the POST method with dojo.

Twisted - adbapi example

this is a simple example of adbapi use pymssql module to connect to MSSQL server.

from twisted.internet import reactor
from twisted.enterprise import adbapi
def getSites():
return dbpool.runQuery("select * from m_site")

def printResult(l):
for item in l:
print item

dbpool = adbapi.ConnectionPool("pymssql", user="sa", password="bedjo", host="192.168.31.31", database="bedjo")
getSites().addCallback(printResult)
reactor.callLater(4, reactor.stop)
reactor.run()

Thats all ... cheers

pymssql - example script

This is a simple script to test a connection of pymssql.
It's easy, but I always forgot. It seems that I'm getting old. lol.

Python 2.4.1 (#65, Mar 30 2005, 09:13:57) [MSC v.1310 32 bit (Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import pymssql
>>> con = pymssql.connect(user="sa", password="bedjo", host="192.168.31.31", database="bedjo");
>>> cur = con.cursor();
>>> cur.execute("select * from m_site");
>>> print cur.rowcount;
>>> print cur.fetchall();
>>> cur.execute("insert into log_message values ('succes') ");
>>> con.commit();
>>> con.close();

Thats all, the simple things to do.

Twisted - A Network Framework

Its on my radar.
Fuih, so many application or framework come up on my radar. Why ? Its happend for my office purpose actually. We build our integration application on PHP front end application. But we did not decided yet our back end application. I tried to found a good platform for our back end.

Zope is still my first consideration, but yes, I still have some problem to implement it. Many things come up to things. One of the main reason is ZODB. It doesnt mean I dont like it, but Zope is depend on it and it hard to remove. Some people may say, "we can build application on zope without ZODB". But I thinks its hard.

Next, is Twisted. I got attract to twisted by reading many blog post on python daily. Then letter on, someone drop me a pdf file about twisted. Its interesting. It has a flexible DBConnection, it has a many network protocol. I might gonna use one of those protocol for my application, but not decided yet which one of them.

My application it work like this : It should be work as a robot application. It will start and monitor many transaction table. It can make transaction summarize, report and calculate many background process. It should made a history log on file or DB. It can make to daemon/service.
At advance, it can provide an XML-RPC or SOAP, to retrieve document generate or xml data.
It may run every 15 minutes or End of Day process.

I think twisted is suite enough.

But recently, Zope 3.2 come up with twisted 2.1 on it. I dont know the combination between these two, but if it does, it would be a great combination tools on hand. So what should I do ?
Take pure twisted or Zope 3.2 with twisted included ? give me a light.

Dojo Toolkit as my DHTML Library

A month ago, I was looking for various DHTML Library for my office project. I have define 3 DHTML groups which on my radar. Finally, none of them is fit with my requirements. Then, I saw on Mochikit mailinglist, many mochikit users take dojo toolkit as their DHTML Library.

Dojo is still on beta version, but please dont ignore it, even if this is beta version, it work quite good. You may take a look at TurboAJAX site, they provide many tools build on top of Dojo Toolkit. They are an awesome product.

So, After collecting many information from mochikit mailinglist, I can able to make dojo and mochikit work together. Heres the sample code on one of my page

< type="text/javascript" src="http://localhost/js/mochikit/MochiKit.js">< / script >
< type="text/javascript" src="http://localhost/js/dojo022/dojo.js">< / script >
< type="text/javascript" src="http://localhost/js/dojo022/src/widget/TabPane.js"> < / script >
< type="text/javascript" src="http://localhost/js/inventories.js">< / script >

< type="text/javascript">

//initialize dojo
dojo.require("dojo.widget.ContentPane");

function qc_search()
{ alert("masuk sini");
doc_manager = new DOCManager("order_response", "qc_search");
alert("initialize");


That all part of my code. As you can see, we have to load mochikit before dojo. If not then we have to mention mochikit function completly which was ugly to do.

Thick Client or Thin Client

While I'm surf the net, I found Brad Neuberg blog entry, speak about Thick Client and Thin Client architecture. He's clearly explain the difference between those two architecture. I believe, my current office project is Thin Client architecture, which its mean use a simple UI. On the other side, I feel that my office commarade project module is Thick Client architecture, which is heavy UI.

One of readers comment mention about Qooxdoo Library for Thick Client. I've check their website, and take alook at their example/demo page. Woaa Extremerly heavy UI. I dont think I wanna use this one for my project. But, Its interesting to learn it.

Other reader XFORMS, XHTML which belong to next generation of web application. He also deliver an introduction link, I should have to take alook at it and learn it little bit. Its W3C standard complient for web 2.0 application.

Desperately need for DHTML Effect Library

Currently, I'm joining our company developer teams to build our internal integrated system. It will build using some of open source project, such as PHP, MySQL, AJAX, MAMBO, and so on. The biggest challange we've found is The Rich GUI Web. Yes, we dont have any skill about this, but we will take this path.

So far for The AJAX toolkit is solve through Mochikit which provide JSON as their primary data exchange format, and we realy happy about it. It's work now with our application. But Mochikit is lag of visual effect or widget. I hope their script.aculo.us port version will be deliver as soon as posible.

We had many candidate for our DHTML Effect Library, and it hard to choose one of them, because it will need time to learn and the other limitation is our skill in javascript arena.
Here the list :
- BACKBASE Community Edition --> we had a problem with their licencing term.
- Script.aculo.us, Open RICO, Moo.fx which are base of Prototype AJAX Library --> Prototype doesnt support JSON right now.
- Yahoo UI Library provide by yahoo teams ---> just release in this week

So, while we waiting to choose the right one, we go directly by our self. We search and download available DHTML trick and try to run it on our application. We also had an idea to go get hire someone out there whos expert on javascript arena, but its hard to find around our city.

If you had any DHTML Effect Library candidate, please let me know.

PyMSSQL got broken

Woa, something goes wrong on my TG installation.

It said an error message "can't commit" when I tried to execute "DBNetLib ... bla bla bla ... server does not exist ... bla bla bla ... access denied". I dont know why it happend, but I guess it happend because I just re-install my operating system last time. So, I had to go to sqlobject site, pyMSSQL site, and turbogear site. Finaly, I found something on python ADO-DB site, Its about an extention of python on Windows. So, after I installed this extention, my pyMSSQL can connected to our SQL Server Machine.

Then here comes another error message ... "can't commit" when I execute "tg-admin sql create" which are create our model class. It contains 5 classes. I dont know why, but I'll solve it somehow.

Activate TG 0.9

A while back, I had a TG 0.88 installed on my machine, and then accidently I execute the setup.py intall from my TG trunk directory, and wollaa.... my TG broke down. I dont know why. Sorry, Im just a newbie on python world, so after long googling, I found that I execute TG 0.9 development source code to replace my TG 0.88.

So, in order to make my TG running again, I had to use TG 0.9, I dont mind about it, so here's the stuff that I had to execute first :

1. Install the pre-request. The RuleDispatch
easy_install -f http://peak.telecommunity.com/snapshots/ RuleDispatch

2. go to the TG 0.9 trunk directory and run this below command
python setup.py develop

3. go to on eachside of thirdparty directory which are cherrypy and sqlobject and run this below command on each of them
python -c "import setuptools; execfile('setup.py')" develop

4. Then the lasting is install the Nose for testing purpose
easy_install nose

and wollaa.... my TG is back
hehehehehehe

Mochikit on PHP

Hi there, hehehe, frankly enough huh ?
yes, I manage to run mochikit on my office project, built on top of php.
Here's the tips :
1. on your html file put a javascript like this one :


// define the DOCManager Object classes
DOCManager = function()
{ // define the property
this.target_div = getElement("response");
this.parameter = "&company_id="+ getElement("company_id").value +
"&grin_type="+ getElement("grin_type").value +
"&grin_no="+ getElement("grin_no").value +
"&ref_type="+ getElement("ref_type").value +
"&ref_no="+ getElement("ref_no").value +
"&order_no="+ getElement("order_no").value;
// bind the methods
bindMethods(this);
};

// define the DOCManager methods
DOCManager.prototype =
{
"loadDOC" : function()
{ alert( " will gonna define the JSON Doc" );
var doc = loadJSONDoc("{FRONTCOMPONENTURL}ajax/ajax.bedjo.php?task=search"+
this.parameter
);
alert( " define DOC, and we will proccess the doc" );
doc.addCallbacks(this.processDOC, this.errorDOC);
alert( "DOC process complete" );
},

"processDOC" : function(data)
{ alert("come to processDOC baby");
var rows = data.rows;
var cols = data.columns;
var newTable = TABLE({"id":"repeat_table", "name":"repeat_table",
"width":"100%", "border":"0", "cellpadding":"1",
"cellspacing":"0"},
THEAD(null, map(this.colDisplay, cols)
),
TFOOT(null, TR(null,
TD({"colspan":"3", "class":"sectiontableheader"}, " "),
TD({"colspan":"5", "class":"sectiontableheader"}, " ")
)
),
TBODY(null, map(this.rowDisplay, rows)
)
);
swapDOM('response', newTable);
},

"errorDOC" : function(data)
{
alert( data.message );
},

"rowDisplay" : function (data)
{
return TR({"class":"sectiontableentry2"}, map(partial(TD, null), data));
},

"colDisplay" : function (data)
{
return TR(null, map(partial(TD, {"class":"sectiontableheader"}), data));
}

};

function search_grin()
{ doc_manager = new DOCManager();
doc_manager.loadDOC();
};


Please remove the // sign in front of the tag, since It forbiden in here
and you have to made an on-click action on your submit-button, I'll bet you know what I meant.

2. Create the ajax file , I named it ajax.bedjo.php, and heres the sample code with a JSON and XML return doc :

$task = $_REQUEST["task"];

switch ( $task )
{
case 'create':
header("Content-type: text/xml");
echo "";
echo "";
echo "";
echo $action;
echo "";
echo "kembang jepun kembang krampung, aku mlembung kakean diambung ";
echo "";
break;
case 'find':
echo '[{';
echo '"id" : "8370",';
echo '"name" : "KANG BEDJO EMANG EMOY"';
echo '},';
echo '{';
echo '"id" : "8360",';
echo '"name" : "TESTING SODARA SODARA SEKALIAN"';
echo '}]';
break;
case 'list':
echo '{';
echo ' "columns": [[ "domain_name", "create_date", "expiry_date", "organization_name"]],';
echo ' "rows": [';
echo ' ["json.org", "2000-05-08", "2006-05-08", "Douglas Crockford"],';
echo ' ["mochibot.com", "2005-02-10", "2007-02-10", "Jameson Hsu"],';
echo ' ["pythonmac.org", "2003-09-24", "2006-09-24", "Bob Ippolito"],';
echo ' ["undefined.org", "2000-01-10", "2006-01-10", "Robert J Ippolito"],';
echo ' ["python.org", "1995-03-27", "2007-03-28", "Python Software Foundation"]';
echo ' ]';
echo '}';
break;
}

Ok thats all, now u can use it. Anyway this is a simple tutorial on using mochikit with php.

Ok, cu next

pymssql

After tried to run wiki20 demo, its time to try to connect to MS-SQL Server Database. The wiki20 demo used SQLITE db for their database backend. Its mean I have to modify the dev.conf file and change the SQLOBJECT db-URI from SQLITE configuration to MS-SQL configuration. But I remembered on my last visit to sqlobject, it seems they'd not yet support MS-SQL DB. So I take a chance to look at their website again and they said they on version 0.7, so I check my sqlobject package version, its older than the one in their website.

So, I go to dos-prompt and try to update our turbogears package with this command : "easy_install -f http://www.turbogears.org/download/index.html TurboGears", and its get all the latest package from TURBOGEARS website, such as cherrypy 2.1.1 and sqlobject 0.7. Then I had to download the pymssql, the python binding for MSSQL DB, I take the latest one, and installed onto my machine.

Then I take my dev.conf file on my project directory, and give the MSSQL DB-URI on it, and then I run "tg-admin sql create" on my dos-prompt. Woa, it says "Using database URI mssql://..." which mean I succesfully create all my object into MSSQL DB-URI.

Now, Its time to dig deep into SQLOBJECT.

Installed TurboGears

Hi there, This week I tried to give a look at turbogears.
I'd go to turbogears project homepage and start to took how to install the software on my Windowz machine with Python 2.4.1 engine.

Here's the step that I take :

1. download ez_setup.py
2. go to dos-prompt and run ez_setup.py, after it done then closed the dos-prompt.
3. after that... edit the environment variable and put ";C:\Python24;C:\Python24\Scripts" from My System Computer environtment variable edit box.
4. go to dos-prompt and go to your project directory and run easy_install -f http://www.turbogears.org/download/index.html TurboGears. It will imediatly download all the turbogears packages and install automaticaly into my windowz machine.
5. your packages should get download and install now.
6. If you wanna use the SQL Lite DB, then you have to download the python to sqlite binding. I take pysqlite. Run it and it will install on your windows machine.


Then, I download Wiki20 Demo Movies and try to run it on my machine.
So far so good. I'll see what I can do next. CU Next

Zope SIP Application

There was an anouncement on daily python about Simple Inventory Program, and I feel interest with this program. They said The SIP can run without ZODB instead they use Sybase and PostgreSQL as their Database backend.

If it is true, then the SIP wont store any metadata on ZODB, cause they dont use it. Then this is the feature that I've been looking for. This program run on top of Zope 3. On Zope 2.X, all our metadata should store at ZODB, now in Zope 3 it can be bypassed as The SIP claim. Another interesting one is SQLOS component which they use.

It would be good, since I like the Zope and their framework, but I dont like the way Zope 2.x store the metadata, that why I look on an other solution which Django and TurboGears offers. If I can make my application work like The SIP with Zope 3, I hope Twisted will join with Zope to give me an great power.

I'll check on this one later.

TG with CatWalk

Its bean a while since my last try on TurboGears, seem they move quite fast. They had a CatWalk right now and they set up on it. So right now you will have a administration backend features. It will similar to the one that Django had. It sound promissing.

Also, I'd check on Twisted, a python network application framework. One of TG User, said that it would posible for TG with their CheryyPy to run with Twisted. I dont know the teory behind it, but it might so. It realy interesting, since my office application would need some of Twisted Features. It would be good if we can utilize it with TG.

I'm quite busy right now with my php office application. I'll check TG again later.

TurboGear : Another Identified Python Web Framework.

For loast couple days, I watch a new python web framework come in out. It named TurboGear. This web framework based on CherryPy, combined with SQLObject ORM, Kid template engine, and Mochikit javascript library.

As you know before, theres already a new python web framework come in on a last couple months, I was Django. I had been dive in it, until now. So, What is the different between the TurboGear and Django ? The way they create the framework. Django had beed create from scracth. TurboGear is take available tools out there and combined it to work.

I dont know which one of this framework gonna be survive.
The most interesting part of TurboGear get my eyes is AJAX features.
I think I'm gonna take a look on it.

ActiveGrid

Today, Mr.Reza Pahlevi, point me to ActiveGrid Project. Its good to hear one of my friend had an eye on linux and python. Its a project which gonna bring linux further.

Here, you'll deploy all your application onto couple linux box worked as a grid computing. It will use Linux , Apache, MySQL, and P-Programming language capability. So, its mean you can bring all your linux box, set them up as a linux box and tranform them into grid computing readibly, then deploy your application in it.

Its good right ?, cause, it would be a good and cheap solution. Build an Grid Computing using an Intel based architecture with a no-cost Linux Operating System, and also Develop your application using LAMP.

I had to eye on it man. You too.

Multiple Column on Primary Key

Some People might known about this topic, specialy if you one of DBA or DB Architect.
Its common used on Client/Server Technology, or Datawarehouse.

The purpose of Multiple Column on Primary Key Definition is Referential Integrity.
We can adopt this integrity into many table through foreign key mechanism, and it is help alot.

But, when you decided to used a web based application, you might face unflexiblity if you try to use this method. Unflexible huh ? yes, because a web based application always mention every single record with one unique id, based on a single column primary key. Thats why its not flexible for web based developer view.

Lets assume, If we decided to use a single column primary key, we might have a de-normalize problem. The DB Design might "not good" enough. Next, when soft.developer try to create their own query, they might face an "unnecessary column" in join command, since the term of "single column" in this case is not a subtitute column rather than an added column.

On the other side, If we keep moving with a Multiple Column on Primary Key, it will put an extra effort on an application for web developer when they define the CRUD (Create, Replace, Update and Delete) page.

So, how to solve this problem ?

For now, I choose a Multiple Column on Primary Key Design. It still made me satisfy.

I cant wait with Zope3

Realy, I can not wait to play with Zope 3 within Plone environtment. The current Plone still use Zope 2.8 engine with Five technology in it. U know, I dont think it would be good for me to put my application on top of The current plone. Why ? because I want my application should run on top of Zope 3. Thats why I can not wait anymore. Any idea ?

WSGI

I like this one.

Yes, with a WSGI included, I can able to create an application without install a Web Server.
It suited for my notebook. It doesnt require much memory and cpu process, but It has all the basic feature.

Django support WSGI, thats why I like it.

I take Django

Its been a while since I started take a play with django web framework. I run their tutorial and take alook how to deal with it. At the moment, I compare django with plone. I like plone and I wish to used it as my production area, but I got stuck with their SQL Storage capability.

Plone allows you to store your data on any other RDBMS like MS-SQL, Oracle, PostgreSQL and etc. But, Plone required to store your object metadata at ZODB, and it must. This is it. This is the one that I dont want, Its mean, as my RDBMS data grows, then my metadata on ZODB will grows either. I dont want it. Thats why I keep delay my application to jump to Plone.

Then, I try to find other solution. I was take look at CherryPy, Webware, Quixote, and Ruby on Rail. I do like RoR and the features they have. It was amazing compare to Webware and Quixote. I want to have a python as my chosen language, I dont want to go to RoR. Then Django came. It made an explotion on Daily Python WebLog. Then I decided to take alook on it. It should be worted to test.

Now, I have a 2 nice web framework. Plone for Protoyping and Django for production area.