is it possible to see whether any user is using a perticular zope object
hello , I am subrahmanyan. I am using zope for my project. Now I would like to know is it possible to know if any body is using the zope object. I mean , if one user is running one DTML method , I want to know that one user is using that object. Is there any DTML tag for that. thanks. bye yours, K.H.Subrahmanyan ( subrahmanyan.kalathur@wipro.com )
subrahmanyan kalathur writes:
Now I would like to know is it possible to know if any body is using the zope object.
I mean , if one user is running one DTML method , I want to know that one user is using that object.
Is there any DTML tag for that. No. The standard Zope objects do not support something like that.
You may implement that for your own objects. But it is quite difficult. You would need something like my "SharedResource" product (URL:http://www.dieter.handshake.de/pyprojects/zope/SharedResource.html). As you want to serialize access to your database, you might be interested in locking. Search the (searchable) list archive for "lock" and "locking" to find more information about it. For locking, too, my "SharedResource" can help you. *HOWEVER*, I follow other posters: it is probably much easier to switch to a different RDBMS. Dieter
As you want to serialize access to your database, you might be interested in locking. Search the (searchable) list archive for "lock" and "locking" to find more information about it. For locking, too, my "SharedResource" can help you.
*HOWEVER*, I follow other posters: it is probably much easier to switch to a different RDBMS.
hi, which RDBMS will u suggest. and for that what are the changes need to be done for my zope. and where can I get that. give the links please. thanks bye yours, K.H.Subrahmanyan ( subrahmanyan.kalathur@wipro.com )
subrahmanyan kalathur wrote:
As you want to serialize access to your database, you might be interested in locking. Search the (searchable) list archive for "lock" and "locking" to find more information about it. For locking, too, my "SharedResource" can help you.
*HOWEVER*, I follow other posters: it is probably much easier to switch to a different RDBMS.
hi,
which RDBMS will u suggest. and for that what are the changes need to be done for my zope. and where can I get that. give the links please.
Is it important to keep transaction logs? Just avoid RDBMS without row-leve locking. Typically, Sybase. I don't know about new one although there is a trick of increasing page size and enabling it. Undocumented feature. :-) Why not build out role-based architecture with tracking include?
thanks bye
yours,
K.H.Subrahmanyan
( subrahmanyan.kalathur@wipro.com )
_______________________________________________ Zope maillist - Zope@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 )
Hi, To run a DTML method is there any other method than using a browser. Or even if it is running in a browser, it should not be there in the task bar. I have an application which need to run for some times. So one DTML method will be running continuously , and it will refresh it self after some duration. And this will continue for some times. So Kindly suggest me what is better. thanks yours, K.H.Subrahmanyan ( subrahmanyan.kalathur@wipro.com )
Well, using HTTP to run an application is not the right way to go. It is because of the nature of HTTP or TCP/IP. There is such naggin thing as time out and a notion of transaction. Short answer is to break things into parts; initiation and completion. If a task takes longer than N minutes, it is reasonable to say it is a long-running task. So, a good way is to use HTTP to create an event or initiation. Then, use a daemon to complete. You can run Zope application from the command line. Use RPC? Perhaps install ZEO and use one server to work on ZODB and the others to serve HTTP requests? This way, you have a delivery machine and a report machine. I can ramble on about two things; message queue and guaranteed delivery. For enterprise (which just means stability and certainty among others), these are two features I think Zope needs but does not have. If you can be more specific, it would be helpful but anyway. subrahmanyan kalathur wrote:
Hi, To run a DTML method is there any other method than using a browser. Or even if it is running in a browser, it should not be there in the task bar.
I have an application which need to run for some times. So one DTML method will be running continuously , and it will refresh it self after some duration. And this will continue for some times.
So Kindly suggest me what is better.
thanks yours,
K.H.Subrahmanyan
( subrahmanyan.kalathur@wipro.com )
Use RPC? Perhaps install ZEO and use one server to work on ZODB and ?> the others to serve HTTP requests? This way, you have a delivery machine and a report machine.
hi, what is RPC ? , ZEO, ZODB. how to install it. where to install it. using that how to run my DTML method. thanks yours, K.H.Subrahmanyan ( subrahmanyan.kalathur@wipro.com )
subrahmanyan kalathur writes:
what is RPC ? , ZEO, ZODB. how to install it. where to install it. It seems to me that you have to do some homework.
A good start would be to read the upcoming Zope book. It will tell you what ZODB and ZEO is, how to install it and where to install it. It may tell you also something about RPC (Remote Procedure Calls), but not enough that you could use it directly. I am sure, you will find the book draft via "zope.org", something like URL:http://www.zope.org/members/michel/ZB (case in members may be wrong). I think, I am quite helpfull. But I expect, that people asking questions are ready to do something (beyond just asking) to find answers for themselves: looking for resources at zope.org, zdp.zope.org, in the Zope book and the list archives, for example. Dieter
hi, I would like to know the names of the created table in zsql method. Kindly give me the tag for displaying the table names.( if exists.) thanks bye yours, K.H.Subrahmanyan ( subrahmanyan.kalathur@wipro.com )
There isn't a SQL standard command to show the tables in the database. Thus evry database has a different command to do such job. For example: DBMaker: to show TABLES: select * from SYSTABLE to show COLUMNS: SELECT COLUMN_NAME,TYPE_NAME,PRECISION FROM SYSCOLUMN WHERE TABLE_NAME='<table_name>' MySQL: to show TABLES: SHOW TABLES to show COLUMNS: DESC <table_name> PostreSQL: to show TABLES: select tablename from pg_tables where tablename not like 'pg_%' to show COLUMNS: SELECT a.attname, t.typname, CASE WHEN a.attlen > 0 THEN attlen ELSE a.atttypmod END as length FROM pg_class c, pg_attribute a, pg_type t WHERE c.relname = '<table_name>' AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid I wrote a couple of ZSQL Methods to emulate a generic ISQL to query a database using the SQL language which shows the names of every table in the database and every column name, type and length of every table. If you want I can send you it. José subrahmanyan kalathur wrote:
hi,
I would like to know the names of the created table in zsql method. Kindly give me the tag for displaying the table names.( if exists.)
thanks bye yours,
K.H.Subrahmanyan
( subrahmanyan.kalathur@wipro.com )
_______________________________________________ Zope maillist - Zope@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 )
Hmm.. I think there is a method of a ZSQL result object called 'names'.. Here is a snippet from some working code: <dtml-let specificTypes="getTypes(ttid=type, name='', tttype='')" theNames="specificTypes.names()"> where 'getTypes' is a ZSQL Method and theNames is the list of column names returned from the query... -steve
"Jose" == Jose Soares <jose@sferacarta.com> writes:
Jose> There isn't a SQL standard command to show the tables in the Jose> database. Thus evry database has a different command to do Jose> such job. For example: Jose> DBMaker: to show TABLES: select * from SYSTABLE to show Jose> COLUMNS: SELECT COLUMN_NAME,TYPE_NAME,PRECISION FROM Jose> SYSCOLUMN WHERE TABLE_NAME='<table_name>' MySQL: to show Jose> TABLES: SHOW TABLES to show COLUMNS: DESC <table_name> Jose> PostreSQL: to show TABLES: select tablename from pg_tables Jose> where tablename not like 'pg_%' to show COLUMNS: SELECT Jose> a.attname, t.typname, CASE WHEN a.attlen > 0 THEN attlen Jose> ELSE a.atttypmod END as length FROM pg_class c, pg_attribute Jose> a, pg_type t WHERE c.relname = '<table_name>' AND a.attnum > Jose> 0 AND a.attrelid = c.oid AND a.atttypid = t.oid Jose> I wrote a couple of ZSQL Methods to emulate a generic ISQL Jose> to query a database using the SQL language which shows the Jose> names of every table in the database and every column name, Jose> type and length of every table. If you want I can send you Jose> it. Jose> José Jose> subrahmanyan kalathur wrote: >> hi, >> >> I would like to know the names of the created table in zsql >> method. Kindly give me the tag for displaying the table >> names.( if exists.) >> >> thanks bye yours, >> >> K.H.Subrahmanyan >> >> ( subrahmanyan.kalathur@wipro.com ) >> >> _______________________________________________ Zope maillist - >> Zope@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 ) Jose> _______________________________________________ Zope Jose> maillist - Zope@zope.org Jose> http://lists.zope.org/mailman/listinfo/zope ** No cross Jose> posts or HTML encoding! ** (Related lists - Jose> http://lists.zope.org/mailman/listinfo/zope-announce Jose> http://lists.zope.org/mailman/listinfo/zope-dev )
hi, I found that Single quote ( ' ) cannot be stored in gadfly database table. If I use that as a part of the string in any SQL variable I will get an error. If u have any idea please let me know. thanks bye yours, K.H.Subrahmanyan ( subrahmanyan.kalathur@wipro.com )
There is no tag that shows tables and there will be not be such tag. What you might want to look into ; ZnolkWizard.. This is a handy module which queries for tables in your database and build create/edit/delete forms. There is also a handy way to specify key-related data. This gets you half way to build UIs when you have many tables. Good luck. Jose Soares wrote:
There isn't a SQL standard command to show the tables in the database. Thus evry database has a different command to do such job. For example:
DBMaker: to show TABLES: select * from SYSTABLE to show COLUMNS: SELECT COLUMN_NAME,TYPE_NAME,PRECISION FROM SYSCOLUMN WHERE TABLE_NAME='<table_name>' MySQL: to show TABLES: SHOW TABLES to show COLUMNS: DESC <table_name> PostreSQL: to show TABLES: select tablename from pg_tables where tablename not like 'pg_%' to show COLUMNS: SELECT a.attname, t.typname, CASE WHEN a.attlen > 0 THEN attlen ELSE a.atttypmod END as length FROM pg_class c, pg_attribute a, pg_type t WHERE c.relname = '<table_name>' AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid
I wrote a couple of ZSQL Methods to emulate a generic ISQL to query a database using the SQL language which shows the names of every table in the database and every column name, type and length of every table. If you want I can send you it.
José
subrahmanyan kalathur wrote:
hi,
I would like to know the names of the created table in zsql method. Kindly give me the tag for displaying the table names.( if exists.)
thanks bye yours,
K.H.Subrahmanyan
( subrahmanyan.kalathur@wipro.com )
_______________________________________________ Zope maillist - Zope@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 )
subrahmanyan kalathur writes:
which RDBMS will u suggest. MySQL or Postgres and for that what are the changes need to be done for my zope. Install the RDBMS and the corresponding Zope database adapter. Replace your Zope Gadfly connection(s) by corresponding Zope XXX connection(s). Maybe, you need small adjustments to your SQL. and where can I get that. You know archives and search engines? give the links please. Am I your consultant? I do not think so. It would take me as long as you to find the links (in the searchable archive of this list and/or via search engines).
Dieter
participants (5)
-
Chalu Kim -
Dieter Maurer -
Jose Soares -
Steve Spicklemire -
subrahmanyan kalathur