Re: [Catalyst] User Generated Content (project collaboration)
Thomas Hartman wrote: I'm just in the prototyping stage of writing something very similar and would be more than willing to contribute. Jason something like this would be really helpful to me. 2006/8/14, John Napiorkowski [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]: BTW, to respond directly to your thoughts on creating a registration system, I have a good start on this as well, with a system that sends an email for verification and all, however it's quite messy and am thinking of fixing it up. One other peice that is often needed is management of your friends circle. So you need invite a friend to join functionality as well as a way to see if your friends are online and quick links to their personal in system homepage. --john - Original Message From: John Napiorkowski [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] To: The elegant MVC web framework catalyst@lists.rawmode.org mailto:catalyst@lists.rawmode.org Sent: Monday, August 14, 2006 10:28:42 AM Subject: Re: [Catalyst] User Generated Content (project collaboration) I'm working on something right now for a client with this. He is okay with me returning code to the community that is not part of his core business, so stuff like wiki's, forums, moderation (voting and karma), tagging, lightweight CMS, etc he is cool with. However I've already been working on this for a bit and may not be taking the direction you might vision. What I am doing is building a portal type framework and a group of custom controllers for each of the basic content types. I've already done a lot of html/css javascript for this and am using the dojo library. Let me know what you think. You are in canada, right? I'm in Beijing now but will be in the USA NYC time zone next week. If We have a few interested participants maybe we can setup a brainstorming session on IRC or something like that. --john - Original Message From: Roman [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] To: catalyst@lists.rawmode.org mailto:catalyst@lists.rawmode.org Sent: Monday, August 14, 2006 1:01:25 AM Subject: [Catalyst] User Generated Content (project collaboration) I have an idea for a great Catalyst based project that can really show the power of Catalyst and spawn some extra projects from this and give Catalyst some coverage. The idea is to build a framework for User Generated Content type of websites. All of those website usually have many features in common. Usually the only difference is the type of content users generate (pictures, texts, links, etc...). The flow usually goes somewhat like this: 1. Register 2. Login 3. Participate in content generation 4. Modify profile 5. User interaction 6. Content votes, comments But there are also a few background tasks such as: * Content administration * Moderation * User management * Website administration The framework would have most of the features ready to go out-of-the-box, and abstract the content part that can be expanded and adopted to specific projects. Anyone interested? ___ List: Catalyst@lists.rawmode.org mailto:Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/ ___ List: Catalyst@lists.rawmode.org mailto:Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/ ___ List: Catalyst@lists.rawmode.org mailto:Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/ http://dev.catalyst.perl.org/ ___ List: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/ ___ List: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site:
Re: [Catalyst] Oracle as model
Cheers mark that's done the trick. Jason mark davies wrote: Hi, I encountered a similar problem which i was able to stop happening by starting the catalyst server with the -f (fork) option. Hope this is of help Mark On 14/08/06, *Jason Crummack* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi, I've just begun playing with catalyst and I'm currently talking to oracle, but I'm seeing a strange side effect. After the first access to the model i can no longer ctrl-c the xxx_server.pl script. Ctrl-c works fine until the first access to the database, if I switch the model to mysql all seems fine, just thought I'd ask here if anyone had seen anything similar before I post this to the dbd::oracle list? Many thanks Jason Crummack ___ List: Catalyst@lists.rawmode.org mailto:Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/ ___ List: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/ ___ List: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/
Re: [Catalyst] Error while going through tutorial using Oracle
Alex Boster wrote:
Hi Alex,
For oracle I think you need to set the sequence name for auto-increments
e.g.
__PACKAGE__-load_components (qw/PK::Auto Core/);
__PACKAGE__-sequence ('{NAME OF YOUR SEQUENCE HERE}');
I think that's right
Jason
I am part way through the tutorial using Oracle and have gotten stuck.
I have create sequences and before insert triggers to replace mySQL's
autoincrements. However, I now get:
|Caught exception in MyApp::Controller::Books-url_create Can't use an
undefined value as a HASH reference at
/u01/glue/share/perl5/lib/site_perl/5.8.8/DBIx/Class/ResultSource.pm line
197.||
|when I try out the formless submission example. On a suggestion, I removed
the PK::Auto from the load_components bit of the table modules (i.e., from:
__PACKAGE__-load_components(qw/PK::Auto Core/);
). This had no affect.
Any pointers? Server output and error page follows.
Thanks,
AB
Server stderr/stdout:
[Template::Provider] creating cache of unlimited slots for [
CODE(0x9f829a4) ]
[debug] Debug messages enabled
[debug] Loaded plugins:
..
| Catalyst::Plugin::ConfigLoader
0.12 |
| Catalyst::Plugin::StackTrace
0.06 |
| Catalyst::Plugin::Static::Simple
0.14 |
''
[debug] Loaded dispatcher Catalyst::Dispatcher
[debug] Loaded engine Catalyst::Engine::HTTP
[debug] Found home /home/aboster/dev/catalyst/MyApp
[debug] Loaded Config /home/aboster/dev/catalyst/MyApp/myapp.yml
[debug] Loaded components:
.-+--.
| Class |
Type |
+-+--+
| MyApp::Controller::Books|
instance |
| MyApp::Controller::Root |
instance |
| MyApp::Model::MyAppDB |
instance |
| MyApp::Model::MyAppDB::Author |
class|
| MyApp::Model::MyAppDB::Book |
class|
| MyApp::Model::MyAppDB::BookAuthor |
class|
| MyApp::View::TT |
instance |
'-+--'
[debug] Loaded Private actions:
.--+--+--.
| Private | Class|
Method |
+--+--+--+
| /default | MyApp::Controller::Root |
default |
| /end | MyApp::Controller::Root |
end |
| /books/url_create| MyApp::Controller::Books |
url_create |
| /books/index | MyApp::Controller::Books |
index|
| /books/list | MyApp::Controller::Books |
list |
'--+--+--'
[debug] Loaded Path actions:
.-+--.
| Path|
Private |
+-+--+
| /books/list |
/books/list |
| /books/url_create |
/books/url_create|
'-+--'
[info] MyApp powered by Catalyst 5.7001
You can connect to your server at http://darkwind003.989studios.com:3000
[info] *** Request 1 (0.200/s) [1065] [Thu Aug 17 10:32:58 2006] ***
[debug] GET request for books/url_create/TCPIP_Illustrated_Vol-2/5/4
from 172.31.30.76
[debug] Path is books/url_create
[debug] Arguments are TCPIP_Illustrated_Vol-2/5/4
[error] Caught exception in MyApp::Controller::Books-url_create Can't
use an undefined value as a HASH reference at
/u01/glue/share/perl5/lib/site_perl/5.8.8/DBIx/Class/ResultSource.pm
line 197.
[info] Request took 1.681834s (0.595/s)
.+---.
| Action |
Time |
++---+
| /books/url_create |
1.656821s |
| /end |
0.000262s |
Re: [Catalyst] Error while going through tutorial using Oracle
Jason Crummack wrote:
Sorry Alex I also forgot to mention that the underlying column_info call
that happens (assuming your using DBD::Oracle) is case sensitive, so
you'll probably also need to upper case the table name (don't think its
necessary with the actual column names).
e.g. __PACKAGE__-table('BOOKS');
If you created the table unquoted in oracle it will have automatically
uppercased the table and column names, this caused me a few problems
with a reserved word table name i've been dealing with where i've had to
define the quote and seperator characters on connect and use exact case
for table and column names.
Jason
Alex Boster wrote:
Hi Alex,
For oracle I think you need to set the sequence name for auto-increments
e.g.
__PACKAGE__-load_components (qw/PK::Auto Core/);
__PACKAGE__-sequence ('{NAME OF YOUR SEQUENCE HERE}');
I think that's right
Jason
I am part way through the tutorial using Oracle and have gotten stuck.
I have create sequences and before insert triggers to replace mySQL's
autoincrements. However, I now get:
|Caught exception in MyApp::Controller::Books-url_create Can't use an
undefined value as a HASH reference at
/u01/glue/share/perl5/lib/site_perl/5.8.8/DBIx/Class/ResultSource.pm line
197.||
|when I try out the formless submission example. On a suggestion, I removed
the PK::Auto from the load_components bit of the table modules (i.e., from:
__PACKAGE__-load_components(qw/PK::Auto Core/);
). This had no affect.
Any pointers? Server output and error page follows.
Thanks,
AB
Server stderr/stdout:
[Template::Provider] creating cache of unlimited slots for [
CODE(0x9f829a4) ]
[debug] Debug messages enabled
[debug] Loaded plugins:
..
| Catalyst::Plugin::ConfigLoader
0.12 |
| Catalyst::Plugin::StackTrace
0.06 |
| Catalyst::Plugin::Static::Simple
0.14 |
''
[debug] Loaded dispatcher Catalyst::Dispatcher
[debug] Loaded engine Catalyst::Engine::HTTP
[debug] Found home /home/aboster/dev/catalyst/MyApp
[debug] Loaded Config /home/aboster/dev/catalyst/MyApp/myapp.yml
[debug] Loaded components:
.-+--.
| Class |
Type |
+-+--+
| MyApp::Controller::Books|
instance |
| MyApp::Controller::Root |
instance |
| MyApp::Model::MyAppDB |
instance |
| MyApp::Model::MyAppDB::Author |
class|
| MyApp::Model::MyAppDB::Book |
class|
| MyApp::Model::MyAppDB::BookAuthor |
class|
| MyApp::View::TT |
instance |
'-+--'
[debug] Loaded Private actions:
.--+--+--.
| Private | Class|
Method |
+--+--+--+
| /default | MyApp::Controller::Root |
default |
| /end | MyApp::Controller::Root |
end |
| /books/url_create| MyApp::Controller::Books |
url_create |
| /books/index | MyApp::Controller::Books |
index|
| /books/list | MyApp::Controller::Books |
list |
'--+--+--'
[debug] Loaded Path actions:
.-+--.
| Path|
Private |
+-+--+
| /books/list |
/books/list |
| /books/url_create |
/books/url_create|
'-+--'
[info] MyApp powered by Catalyst 5.7001
You can connect to your server at http://darkwind003.989studios.com:3000
[info] *** Request 1 (0.200/s) [1065] [Thu Aug 17 10:32:58 2006] ***
[debug] GET request for books/url_create/TCPIP_Illustrated_Vol-2/5/4
from 172.31.30.76
[debug] Path is books/url_create
[debug] Arguments are TCPIP_Illustrated_Vol-2/5/4
[error] Caught exception in MyApp::Controller::Books-url_create
Re: [Catalyst] Error while going through tutorial using Oracle
Hi Hartmaier
Thats going to cause me problems when the next release hits the streets,
if you're automatically uppercasing table names how will it then handle
reserved word table names where case is important? (e.g user).
Jason
Hartmaier Alexander wrote:
Hi!
Use the current svn version which will become 0.07001 soon, it has my
Storage::Oracle patch for uppercasing the table names which wasn't included
in 0.07.
It's best you specify the sequence names for each auto-inc pk yourself, so
you avoid the magic on startup which saves you some time.
-Alex
-Original Message-
From: [EMAIL PROTECTED] [mailto:catalyst-
[EMAIL PROTECTED] On Behalf Of Jason Crummack
Sent: Friday, August 18, 2006 1:38 AM
To: The elegant MVC web framework
Subject: Re: [Catalyst] Error while going through tutorial using Oracle
Jason Crummack wrote:
Sorry Alex I also forgot to mention that the underlying column_info call
that happens (assuming your using DBD::Oracle) is case sensitive, so
you'll probably also need to upper case the table name (don't think its
necessary with the actual column names).
e.g. __PACKAGE__-table('BOOKS');
If you created the table unquoted in oracle it will have automatically
uppercased the table and column names, this caused me a few problems
with a reserved word table name i've been dealing with where i've had to
define the quote and seperator characters on connect and use exact case
for table and column names.
Jason
Alex Boster wrote:
Hi Alex,
For oracle I think you need to set the sequence name for auto-
increments
e.g.
__PACKAGE__-load_components (qw/PK::Auto Core/);
__PACKAGE__-sequence ('{NAME OF YOUR SEQUENCE HERE}');
I think that's right
Jason
I am part way through the tutorial using Oracle and have gotten
stuck.
I have create sequences and before insert triggers to replace mySQL's
autoincrements. However, I now get:
|Caught exception in MyApp::Controller::Books-url_create Can't use
an undefined value as a HASH reference at
/u01/glue/share/perl5/lib/site_perl/5.8.8/DBIx/Class/ResultSource.pm
line 197.||
|when I try out the formless submission example. On a suggestion, I
removed the PK::Auto from the load_components bit of the table modules
(i.e., from:
__PACKAGE__-load_components(qw/PK::Auto Core/);
). This had no affect.
Any pointers? Server output and error page follows.
Thanks,
AB
Server stderr/stdout:
[Template::Provider] creating cache of unlimited slots for [
CODE(0x9f829a4) ]
[debug] Debug messages enabled
[debug] Loaded plugins:
.
.
| Catalyst::Plugin::ConfigLoader
0.12 |
| Catalyst::Plugin::StackTrace
0.06 |
| Catalyst::Plugin::Static::Simple
0.14 |
'
'
[debug] Loaded dispatcher Catalyst::Dispatcher
[debug] Loaded engine Catalyst::Engine::HTTP
[debug] Found home /home/aboster/dev/catalyst/MyApp
[debug] Loaded Config /home/aboster/dev/catalyst/MyApp/myapp.yml
[debug] Loaded components:
.-+--
.
| Class |
Type |
+-+--
+
| MyApp::Controller::Books|
instance |
| MyApp::Controller::Root |
instance |
| MyApp::Model::MyAppDB |
instance |
| MyApp::Model::MyAppDB::Author |
class|
| MyApp::Model::MyAppDB::Book |
class|
| MyApp::Model::MyAppDB::BookAuthor |
class|
| MyApp::View::TT |
instance |
'-+--
'
[debug] Loaded Private actions:
.--+--+--
.
| Private | Class|
Method |
+--+--+--
+
| /default | MyApp::Controller::Root |
default |
| /end | MyApp::Controller::Root |
end |
| /books/url_create| MyApp::Controller::Books |
url_create |
| /books/index | MyApp::Controller::Books |
index|
| /books/list | MyApp::Controller::Books |
list
Re: [Catalyst] [***SPAM*** Score/Req: 11.00/6.0] Re: Error while going through tutorial using Oracle
I beg to differ, have you actually read the DBD::Oracle page link I sent
you?
try the following
create table fred (p1 integer primary key);
insert into fred values (1);
select p1 from fred;
returns 1
create table fred (p1 integer primary key);
insert into fred values (2);
select * from fred;
returns 2
Two tables exist one case-insensitive the other case-sensitive, I can
also create table Fred etc Based on uppercasing the table name in
the column_info call I would never be able to access table fred.
It's all down to how the table is initially created, if the table was
created quoted and the table name is not all uppercase then the table
name is case sensitive.
Please see the bold section below.
Jason Crummack
Easysoft Limited
|table_info()|
http://search.cpan.org/%7Epythian/DBD-Oracle-1.18a/Oracle.pm#___top
DBD::Oracle supports attributes for |table_info()|.
In Oracle, the concept of /user/ and /schema/ is (currently) the same.
Because database objects are owned by an user, the owner names in the
data dictionary views correspond to schema names. Oracle does not
support catalogs so TABLE_CAT is ignored as selection criterion.
Search patterns are supported for TABLE_SCHEM and TABLE_NAME.
TABLE_TYPE may contain a comma-separated list of table types. The
following table types are supported:
TABLE
VIEW
SYNONYM
SEQUENCE
The result set is ordered by TABLE_TYPE, TABLE_SCHEM, TABLE_NAME.
The special enumerations of catalogs, schemas and table types are
supported. However, TABLE_CAT is always NULL.
An identifier is passed /as is/, i.e. as the user provides or Oracle
returns it. |table_info()| performs a case-sensitive search. So, a
selection criterion should respect upper and lower case. Normally, an
identifier is case-insensitive. Oracle stores and returns it in upper
case. *Sometimes, database objects are created with quoted identifiers
(for reserved words, mixed case, special characters, ...). Such an
identifier is case-sensitive (if not all upper case). Oracle stores and
returns it as given. |table_info()| has no special quote handling,
neither adds nor removes quotes.*
Hartmaier Alexander wrote:
1. Oracle isn't case sensitive for table names
2. column_info on Oracle only works if the table name passed is uppercase.
-Alex
-Original Message-
From: [EMAIL PROTECTED] [mailto:catalyst-
[EMAIL PROTECTED] On Behalf Of Jason Crummack
Sent: Friday, August 18, 2006 10:52 AM
To: The elegant MVC web framework
Subject: [***SPAM*** Score/Req: 11.00/6.0] Re: [Catalyst] Error while
going through tutorial using Oracle
That's my point for the column_info call in DBD::Oracle to work the case
has to matched the stored case
http://search.cpan.org/~pythian/DBD-Oracle-1.18a/Oracle.pm#column_info()
i.e.
create table user (p1 integer )
To retrieve column_info for that table the table name must be lowercase
in the column_info call.
Jason
Hartmaier Alexander wrote:
The table names aren't uppercased when defining the table class but
just for the column_info DBI call.
-Alex
-Original Message-
From: [EMAIL PROTECTED] [mailto:catalyst-
[EMAIL PROTECTED] On Behalf Of Jason Crummack
Sent: Friday, August 18, 2006 10:15 AM
To: The elegant MVC web framework
Subject: [***SPAM*** Score/Req: 11.00/6.0] Re: [Catalyst] Error while
going through tutorial using Oracle
Hi Hartmaier
Thats going to cause me problems when the next release hits the
streets,
if you're automatically uppercasing table names how will it then
handle
reserved word table names where case is important? (e.g user).
Jason
Hartmaier Alexander wrote:
Hi!
Use the current svn version which will become 0.07001 soon, it has
my
Storage::Oracle patch for uppercasing the table names which wasn't
included in 0.07.
It's best you specify the sequence names for each auto-inc pk
yourself, so you avoid the magic on startup which saves you some
time.
-Alex
-Original Message-
From: [EMAIL PROTECTED] [mailto:catalyst-
[EMAIL PROTECTED] On Behalf Of Jason Crummack
Sent: Friday, August 18, 2006 1:38 AM
To: The elegant MVC web framework
Subject: Re: [Catalyst] Error while going through tutorial using
Oracle
Jason Crummack wrote:
Sorry Alex I also forgot to mention that the underlying column_info
call
that happens (assuming your using DBD::Oracle) is case sensitive,
so
you'll probably also need to upper case the table name (don't think
its
necessary with the actual column names).
e.g. __PACKAGE__-table('BOOKS');
If you created the table unquoted in oracle it will have
automatically
uppercased the table and column names, this caused me a few
Re: [Catalyst] [***SPAM*** Score/Req: 11.00/6.0] Re: [***SPAM*** Score/Req: 11.00/6.0] Re: Error while going through tutorial using Oracle
Alex, If I could predict what new reserved words may appear in future Oracle / SQL versions I would, that's the reason they give you a quote character to allow future changes to reserved words. I agree that if I was creating new tables, I wouldn't at this point in time use a currently known reserved word but when accessing existing tables I have no choice. I've been involved writing ODBC/JDBC drivers (and the unixODBC project) for the last 10 years +, trust me new reserved words happen every few years, and different database backends have different reserved word lists. Some of the legacy systems i have to attach to can't have the table names changed. When approaching database related issues I afraid I can't take the approach of it works alright for me, the specifications are there for good reason, many knowledgeable people have initially contributed to produce such specifications, I think it's important for Storage::DBI::Oracle module to follow that specification. I don't necessarily agree with reversing out your patch, I'd like to discuss it with one of my colleagues who's a DBD::Oracle maintainer as to the best approach. Jason P.S. Sorry I hit send plain text by mistake (matter of habit) I was trying to draw you're attentions to the following paragraph An identifier is passed /as is/, i.e. as the user provides or Oracle returns it. |table_info()| performs a case-sensitive search. So, a selection criterion should respect upper and lower case. Normally, an identifier is case-insensitive. Oracle stores and returns it in upper case. *Sometimes, database objects are created with quoted identifiers (for reserved words, mixed case, special characters, ...). Such an identifier is case-sensitive (if not all upper case). Oracle stores and returns it as given. |table_info()| has no special quote handling, neither adds nor removes quotes.* Hartmaier Alexander wrote: Hi Jason! I haven't quoted my tablenames on creation (whatfor?) so all my tables are case insensitive and I didn't bother with quotes. Reserved words are reserved for a good reason, I don't see the point of using a reserved word as table name. Fell free to send a patch for Storage::DBI::Oracle to the list which fixes those cases. Bold in a plaintext mail is a good joke, which one do you mean? -Alex -Original Message- From: [EMAIL PROTECTED] [mailto:catalyst- [EMAIL PROTECTED] On Behalf Of Jason Crummack Sent: Friday, August 18, 2006 11:16 AM To: The elegant MVC web framework Subject: [***SPAM*** Score/Req: 11.00/6.0] Re: [Catalyst] [***SPAM*** Score/Req: 11.00/6.0] Re: Error while going through tutorial using Oracle I beg to differ, have you actually read the DBD::Oracle page link I sent you? try the following create table fred (p1 integer primary key); insert into fred values (1); select p1 from fred; returns 1 create table fred (p1 integer primary key); insert into fred values (2); select * from fred; returns 2 Two tables exist one case-insensitive the other case-sensitive, I can also create table Fred etc Based on uppercasing the table name in the column_info call I would never be able to access table fred. It's all down to how the table is initially created, if the table was created quoted and the table name is not all uppercase then the table name is case sensitive. Please see the bold section below. Jason Crummack Easysoft Limited |table_info()| http://search.cpan.org/%7Epythian/DBD-Oracle- 1.18a/Oracle.pm#___top DBD::Oracle supports attributes for |table_info()|. In Oracle, the concept of /user/ and /schema/ is (currently) the same. Because database objects are owned by an user, the owner names in the data dictionary views correspond to schema names. Oracle does not support catalogs so TABLE_CAT is ignored as selection criterion. Search patterns are supported for TABLE_SCHEM and TABLE_NAME. TABLE_TYPE may contain a comma-separated list of table types. The following table types are supported: TABLE VIEW SYNONYM SEQUENCE The result set is ordered by TABLE_TYPE, TABLE_SCHEM, TABLE_NAME. The special enumerations of catalogs, schemas and table types are supported. However, TABLE_CAT is always NULL. An identifier is passed /as is/, i.e. as the user provides or Oracle returns it. |table_info()| performs a case-sensitive search. So, a selection criterion should respect upper and lower case. Normally, an identifier is case-insensitive. Oracle stores and returns it in upper case. *Sometimes, database objects are created with quoted identifiers (for reserved words, mixed case, special characters, ...). Such an identifier is case-sensitive (if not all upper case). Oracle stores and returns it as given. |table_info()| has no special quote handling, neither adds nor removes quotes.* Hartmaier Alexander wrote: 1. Oracle isn't case sensitive for table names 2. column_info on Oracle only works
[Catalyst] Best practises for wizard style web based forms
Hi All, I just thought I'd ask what people's thoughts are on how they are handling state based form submission processes using catalyst, using mod_perl in the past I would have simply stored the state in a server side sessions and controlled the state by querying / adjusting this state on route. Also as part of this process i would have always reposted back to the same url (after initial entry page). Thanks Jason Crummack Easysoft Limited ___ List: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/
Re: [Catalyst] FormValidator::Simple Sillyness
I currently use $c-localize in my templates to allow foreign language labels / messages, I struggled a little with HTML::Widget to do this where as with CGI::FormBuilder it was relatively straight forward, so at the moment ;-) I'm also a fan of CGI::FormBuilder. It can also (don't want to start a flame war) generate simple javascript based client validation code, which could help on heavily loaded servers, client performs validation before post, but server also performs same validation. Your probably right about being able to get the same level of control in HTML::Widget but for me it wasn't as straight forward as CGI::FormBuilder. Jason Crummack Easysoft Limited A. Pagaltzis wrote: * [EMAIL PROTECTED] [EMAIL PROTECTED] [2006-08-30 10:05]: I switched from HTML::Widget to CGI::FormBuilder as I found to have not enough control over the the rendering of my forms in HTML::Widget. You can use a custom container class if the default rendering is close to what you want, or you can build the form entirely by hand in the template if you need to do something very specific. That’s all the control over rendering that I need. Regards, ___ List: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/
[Catalyst] Redirect and Firefox / Safari
Hi all, I'm using c$-response-redirect in the auto handler of my controller as part of an authentication process but I'm seeing ~ 7 second delays on the redirect in Firefox / Safari browsers, IE works fine for once :-). After further investigation I've found out it only seems to happen when the debug server is run with keepalives enabled, which if I disable makes IE no longer work. Thanks Jason Crummack ___ List: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/
[Catalyst] Is anyone using Catalyst::Plugin::Session::Store::DBIC successfully with Oracle?
Hi,
I'm trying to get the Session::Store::DBIC plugin working with oracle
but with no success, i believe i've got everything configured correctly
and new session rows are being written to the database but I'm getting
an exception in the Delegate.pm module.
Anyone seen anything similar?
Thanks
Jason
SELECT me.SESSION_ID, me.SESSION_DATA, me.EXPIRES FROM
SESSIONS me WHERE ( ( me.SESSION_ID = ? ) ):
'session:229bb8dfca4194b7039378ab177df64aa1f3ddc4'
INSERT INTO SESSIONS (SESSION_ID) VALUES (?):
'session:229bb8dfca4194b7039378ab177df64aa1f3ddc4'
UPDATE SESSIONS SET EXPIRES = ?, SESSION_DATA = ? WHERE (
SESSION_ID = ? ): '1161001443',
'BQcDAwoNMTkyLjE2OC4wLjEwMQlfX2FkZHJlc3MJRTNdwwlfX2NyZWF0ZWQJRTNd
wwlfX3VwZGF0ZWQ=
', 'session:229bb8dfca4194b7039378ab177df64aa1f3ddc4'
[debug] Body Parameters are:
.-+--.
| Parameter |
Value|
+-+--+
| pwd |
Password |
| uid |
Username |
'-+--'
[debug] POST request for users/login from 192.168.0.101
[debug] Path is users/login
[debug] Created session 229bb8dfca4194b7039378ab177df64aa1f3ddc4
[debug] session cookie $VAR1 = {
'__address' = '192.168.0.101',
'__created' = 1160994243,
'__updated' = 1160994243
};
[error] Caught exception in engine
DBIx::Class::InflateColumn::update(): Can't update
MyApp::Model::MyDB::Sessions=HASH(0x9104174): row not found at
/usr/local/lib/perl5/site_perl/5.8.8/Catalyst/Plugin/Session/Store/DBIC/Delegate.pm
line 85
___
List: Catalyst@lists.rawmode.org
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
Dev site: http://dev.catalyst.perl.org/
Re: [Catalyst] Is anyone using Catalyst::Plugin::Session::Store::DBIC successfully with Oracle?
Couldn't try with that particular session id (removed and recreated table several times since) but i've tried with another and record was successfully returned. As you say the update isn't firing as the expires field and data fields don't have values in them? I've tried various table definitions but the current one is (thought id could be dbi's handling of blob's / clobs's initially) create table sessions ( session_id char(72) primary key, session_data varchar2(4000), expires int ); I've mapped the field names accordingly in the config, but i'm assuming they are working ok due to the fact that the records are being inserted initially, although as previously mentioned only the session_id has been set. I'll have a poke around in DBD::Oracle (one of my colleagues is a maintainer) and i'll return any findings. Thanks for the prompt reply :-) Jason Daniel Westermann-Clark wrote: On 2006-10-16 12:23:28 +0100, Jason Crummack wrote: I'm trying to get the Session::Store::DBIC plugin working with oracle but with no success, i believe i've got everything configured correctly and new session rows are being written to the database but I'm getting an exception in the Delegate.pm module. [error] Caught exception in engine DBIx::Class::InflateColumn::update(): Can't update MyApp::Model::MyDB::Sessions=HASH(0x9104174): row not found at /usr/local/lib/perl5/site_perl/5.8.8/Catalyst/Plugin/Session/Store/DBIC/Delegate.pm line 85 There's something fishy going on with the database interaction. Either the rows aren't landing the in the sessions table correctly or DBI isn't returning the correct number of rows from $sth-execute on UPDATE. First check that you get a result back in the Oracle shell: SELECT * FROM SESSIONS WHERE SESSION_ID = 'session:229bb8dfca4194b7039378ab177df64aa1f3ddc4' Could you also provide the CREATE TABLE statement you used for your sessions table? Thanks, ___ List: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/
