[Catalyst] HTML encoding parameters

2014-06-28 Thread bill hauck
Hi.

Please forgive me if this is an easy one.  It's late and I haven't found any 
mention of it.

I'd like to encode form fields so that only the standard bold, italic, 
underline, list, etc. are allowed and and script, style, etc. tags are encoded. 
 Also, I'd like to only let the base tags through and no attributes so setting 
an onmouseover in a paragraph is encoded.  Basically I'm trying to avoid XSS 
and other nastiness.

Is there a module that does this to all parameters at once?  Do i simply need 
to do it to each paramter I accept?  For now I've been adding the html filter 
in my Template Toolkit templates, but that's a pain and relies on each output 
field filtering.  I'd like to encode before storing the data in the database so 
it's safe no matter how it's presented.

Any help is appreciated.

Thanks,

bill___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


[Catalyst] Using git to manage VERSION and Changes

2014-04-11 Thread bill hauck
Trying again since I didn't see it come through...

Hi.

Anyone out there using git with a Catalyst app have git managing the updates to 
Changes or the VERSION variable in MyApp/lib/MyApp.pm ?

If so, can you share your method?

Thanks,

bill (wbhauck.com)
http://www.projecttasktodo.org
___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


[Catalyst] Using git to manage VERSION and Changes

2014-04-10 Thread bill hauck
Hi.

Anyone out there using git with a Catalyst app have git managing the updates to 
Changes or the VERSION variable in MyApp/lib/MyApp.pm ?

If so, can you share your method?

Thanks,

bill (wbhauck.com)
http://www.projecttasktodo.org
___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


Re: [Catalyst] ProjectTaskToDo: open source project management system

2014-02-16 Thread bill hauck
John,
Not at all.  In fact, the more mentioning of it the better.  It won't be useful 
to people if they don't know about it.

Cheers,

bill
 









On Sunday, February 16, 2014 8:31 PM, John Napiorkowski jjn1...@yahoo.com 
wrote:
 
Bill,


Looks great, mind if I mention it on my blog?


John



On Saturday, February 15, 2014 3:30 PM, bill hauck wbha...@yahoo.com wrote:
 
Hi.


So I've finally gotten enough time to put out a version of my project 
management system, ProjectTaskToDo.


I've put the code out on GitHub at 
https://github.com/wbhauck/ProjectTaskToDo.git


I'm releasing it under the Affero GPL.  


It's beta software and some things don't work well, others don't work at all.  
I'm fixing bugs and cleaning code as quickly as possible.  But I wanted to 
post this now in the hopes that some folks might take a peek at it and give 
some suggestions and general feedback.


This is my first open source project so please be kind.  Be honest, but 
gentle. :)


Cheers,


bill
___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/




___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


[Catalyst] ProjectTaskToDo: open source project management system

2014-02-15 Thread bill hauck
Hi.

So I've finally gotten enough time to put out a version of my project 
management system, ProjectTaskToDo.

I've put the code out on GitHub at 
https://github.com/wbhauck/ProjectTaskToDo.git

I'm releasing it under the Affero GPL.  

It's beta software and some things don't work well, others don't work at all.  
I'm fixing bugs and cleaning code as quickly as possible.  But I wanted to post 
this now in the hopes that some folks might take a peek at it and give some 
suggestions and general feedback.

This is my first open source project so please be kind.  Be honest, but gentle. 
:)

Cheers,

bill___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


[Catalyst] Calling controller/action based on parameter

2013-10-03 Thread bill hauck


 Hi.

I've been struggling with the best way to accomplish a somewhat simple task: 
direct to a specific controller/action based on a code in the uri.

My site is (going to be) a comprehensive entertainment database covering 
movies, tv shows, books, comics, graphic novels, and even games and posters.  
Each media type has it's own code...

+-++-+
| id  | name               | description |
+-++-+
| mov | Movie              | NULL        |
| tvs | TV Series          | NULL        |
| hbo | HBO                | NULL        |
| mgz | Magazine           | NULL        |
| bok | Book               | NULL        |
| bbd | Billboard          | NULL        |
| gcd | Greeting Card      | NULL        |
| ptr | Poster             | NULL        |
| pcd | Post Card          | NULL        |
| web | Website            | NULL        |
| tvm | TV Movie           | NULL        |
| stv | Straight to Video  | NULL        |
| tms | TV Miniseries      | NULL        |
| tve | TV Episode         | NULL        |

and so on.  While not a media type I also code persons as prn.

So my url's currently look like /media_type/id ...
Movies ...
Tron:  http://www.pausetosee.com/mov/movez9zbefv1fzaq
Event Horizon:  http://www.pausetosee.com/mov/mov1ufub4zg1mp2j

TV Episodes ...
Sons of Anarchy : The Pull:  http://www.pausetosee.com/tve/tve28or7cin210v3
Chicago Fire : A Problem House:  http://www.pausetosee.com/tve/tveeoz58rafdccn5

Persons ...
Robert Downey Jr.:  http://www.pausetosee.com/person/prniffqosbaj0h2n
Ron Perlman:  http://www.pausetosee.com/person/prnn7ivdbdq8808p


What I'd like to do is have the system direct to the proper controller and 
action based on the 3 character code in the ID ...

Tron:  http://www.pausetosee.com/movez9zbefv1fzaq
Event Horizon:  http://www.pausetosee.com/mov1ufub4zg1mp2j

TV Episodes ...
Sons of Anarchy : The Pull:  http://www.pausetosee.com/tve28or7cin210v3
Chicago Fire : A Problem House:  http://www.pausetosee.com/tveeoz58rafdccn5

Persons ...
Robert Downey Jr.:  http://www.pausetosee.com/prniffqosbaj0h2n
Ron Perlman:  http://www.pausetosee.com/prnn7ivdbdq8808p


Any suggestions on how to do this?  I'm toying with a large switch statement in 
the root controller and visiting the appropriate controller/action based on the 
parameter.  Is this right?  Does Catalyst provide a way to accomplish this 
either easier or cleaner?

Any help is appreciated.

Thanks,

bill
http://wbhauck.com
___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


Re: [Catalyst] Name suggestions for a project management system

2013-09-08 Thread bill hauck
Stupid Yahoo only lets me top-post ...

Would you believe there's already a Taskcat iPhone app ...

https://itunes.apple.com/us/app/taskcat/id519986368?mt=8


And guess what the mascot is!  Yep, it's a cat.  :(

But thanks for the suggestion.

It's one reason I was thinking of just going with TaskMaster; since every other 
name I can think of is taken and there are already a few TaskMaster's what's 
one more?

Again, suggestions are appreciated.





 From: Kamen Naydenov pa...@kamennn.eu
To: bill hauck wbha...@yahoo.com; The elegant MVC web framework 
catalyst@lists.scsys.co.uk 
Sent: Sunday, September 8, 2013 3:53 AM
Subject: Re: [Catalyst] Name suggestions for a project management system
 

On Sun, Sep 8, 2013 at 4:10 AM, bill hauck wbha...@yahoo.com wrote:
 Hi.

 Not exactly a Catalyst question ...

 I'm building a Catalyst-based project management system and I'd like to
 release it as open source under the AGPL.  However, originally I named it
 MCP after Master Control in Tron.  I noticed it's also an operating system
 name from Burroughs (http://en.wikipedia.org/wiki/Burroughs_MCP).  Naming it
 MCP is probably not a good idea.

 So I was thinking of using TaskMaster.  Google shows there's dozens of
 Task Master programs out there ranging from to-do lists and full project
 management systems.

 So, any suggestions?
TaskCat - Task (catalyst|cat)
And you can use cat for mascot for free ;-)

best regards
Kamen


___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


Re: [Catalyst] Name suggestions for a project management system

2013-09-08 Thread bill hauck


I do like that, but I don't think it'd go well with some folks.  Heck, my 
co-workers at my last job said they'd rather quit than use a project management 
system.

Anyhow, lame as it might be, I think i've decided on using Project Task Todo 
since it names the functions as well as the domains being open:
projecttasktodo.com (eventually will be hosted site)
projecttasktodo.org will be the project site

Thanks all

Cheers,
bill




 From: John SJ Anderson geneh...@genehack.org
To: The elegant MVC web framework catalyst@lists.scsys.co.uk 
Sent: Monday, September 9, 2013 12:35 AM
Subject: Re: [Catalyst] Name suggestions for a project management system
 

On Sat, Sep 7, 2013 at 6:10 PM, bill hauck wbha...@yahoo.com wrote:

 So, any suggestions?

I always thought Sisyphus would be a nice name for a task management system...

___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


[Catalyst] Name suggestions for a project management system

2013-09-07 Thread bill hauck
Hi.

Not exactly a Catalyst question ...

I'm building a Catalyst-based project management system and I'd like to release 
it as open source under the AGPL.  However, originally I named it MCP after 
Master Control in Tron.  I noticed it's also an operating system name from 
Burroughs (http://en.wikipedia.org/wiki/Burroughs_MCP).  Naming it MCP is 
probably not a good idea.

So I was thinking of using TaskMaster.  Google shows there's dozens of Task 
Master programs out there ranging from to-do lists and full project management 
systems.

So, any suggestions?

Thanks

bill___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


Re: [Catalyst] New design

2013-07-23 Thread bill hauck
I like it overall.

I'd replace the dancing astronauts with something more catalyst-y like maybe 
test tubes or beakers and a bunsen burner with a nice flame on top.




 From: Mark Keating m.keat...@shadowcat.co.uk
To: catalyst@lists.scsys.co.uk 
Sent: Tuesday, July 23, 2013 4:48 AM
Subject: [Catalyst] New design
 

The nice chaps at Evozon have recently been making design mocks for a 
bunch of Perl sites and they have come up with a fresh look for 
Catalyst. Take a look and let me know what you guys think.

http://www.mdk.me.uk/community/mocks/Catalyst.jpg

Kind regards

Mark

-- 
Mark Keating BA (Hons), Writer, Photographer, Cat-Herder.
Managing Director: http://www.shadow.cat
For more that I do visit: http://www.mdk.me


___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


[Catalyst] How to change default LICENSE in app and files

2013-07-01 Thread bill hauck
Hi

I was wondering if there's a way to change the default LICENSE that is added to 
each Controller through myapp_create.pl.  I'd like to use GNU Affero GPL 
(http://www.gnu.org/licenses/agpl.html)  for a project.

I didn't see anything on the wiki or email archive.

Any help is appreciated.

Thanks,

bill___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


[Catalyst] List of Applications using Catalyst

2013-06-07 Thread bill hauck
Hi.

Does anyone know of a list of applications that are using Catalyst?  I saw the 
sites using Catalyst on http://www.catalystframework.org/#sites but I'm 
wondering if there's a list of applications.

For instance, MojoMojo is a Catalyst-based web app, but I only know that 
because the catalystframework website uses it and links to MojoMojo's site, 
which details the Catalyst involvment.

If there's no existing list I think it would be a great addition to the 
framework's wiki.  This could help people use all Catalyst-based software, 
making maintenance easier as well as sticking with a single language and web 
framework concept.

If there is a list maybe we can mirror it on the wiki.  I'll add it if someone 
can point me to it.

Thanks,

bill___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


Re: [Catalyst] many to many join with multicolumn primary key

2012-08-23 Thread bill hauck
Hi, Jon.

I tried that and it worked perfectly.

I'll make a small, simple but fully functional example and add it to the wiki 
this weekend.

Thanks!

Cheers,

bill




 From: jmo mlists jmo.mli...@gmail.com
To: The elegant MVC web framework catalyst@lists.scsys.co.uk 
Sent: Wednesday, August 22, 2012 1:12 PM
Subject: Re: [Catalyst] many to many join with multicolumn primary key
 

Hi,


On Tue, Aug 21, 2012 at 5:10 PM, bill hauck wbha...@yahoo.com wrote:

Hi.

Posted this to the DBIx::Class maillist, but not getting an traction there.  
Perhaps someone else has run into this issue on a Catalyst app.


I need to connect two tables through a relation table for a many_to_many.  
The issue I'm running into is that one of the tables has a composite primary 
key.  I'm using this in a Catalyst application through a Template Toolkit 
template.

So, before going through the whole thing, is it possible to have a composite 
primary key used in many to many?  If not, any suggestions on a workaround?

If it is possible, here's my setup.  The user will submit issues into 
complexity_submission.  A trigger will create a duplicate entry in table 
complexity giving the unique post id and then a version of the post.

Tables, trigger, Schema::Result relations listed, and template below.



Did you try the way suggested here? 
http://grokbase.com/t/sc/dbix-class/071g80741a/multi-column-primary-foreign-key
 

/Jon


___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


[Catalyst] many to many join with multicolumn primary key

2012-08-21 Thread bill hauck
Hi.

Posted this to the DBIx::Class maillist, but not getting an traction there.  
Perhaps someone else has run into this issue on a Catalyst app.


I need to connect two tables through a relation table for a many_to_many.  The 
issue I'm running into is that one of the tables has a composite primary key.  
I'm using this in a Catalyst application through a Template Toolkit template.

So, before going through the whole thing, is it possible to have a composite 
primary key used in many to many?  If not, any suggestions on a workaround?

If it is possible, here's my setup.  The user will submit issues into 
complexity_submission.  A trigger will create a duplicate entry in table 
complexity giving the unique post id and then a version of the post.

Tables, trigger, Schema::Result relations listed, and template below.

Thanks in advance,

bill

Version Info:
Catalyst 5.80029

DBIx::Class $VERSION = '0.08124';
perl 5, version 12, subversion 2 (v5.12.2) built for i686-linux


mysql describe complexity_submission;

+---+--+--+-+---+-+
| Field         | Type             | Null | Key | Default           | Extra     
                  |
+---+--+--+-+---+-+
| id            | int(10) unsigned | NO   | PRI | NULL              | 
auto_increment              |
| creator_email | varchar(255)     | YES  |     | NULL              |           
                  |
| opt_in        | int(1) unsigned  | NO   |     | 0                 |           
                  |
| recorded      | timestamp        | NO   |     | CURRENT_TIMESTAMP | on update 
CURRENT_TIMESTAMP |
| body          | text             | YES  |     | NULL              |           
                  |
+---+--+--+-+---+-+
5 rows in set (0.01 sec)

mysql describe complexity;
++--+--+-+---+-+
| Field          | Type             | Null | Key | Default           | Extra    
                   |
++--+--+-+---+-+
| post_id        | int(10) unsigned | NO   | PRI | 0                 |          
                   |
| version        | int(10) unsigned | NO   | PRI | NULL              | 
auto_increment              |
| published      | tinyint(1)       | YES  |     | 0                 |          
                   |
| curator_status | int(1)           | NO   |     | 0                 |          
                   |
| prc_status     | int(1)           | NO   |     | 0                 |          
                   |
| creator_email  | varchar(255)     | YES  |     | NULL              |          
                   |
| opt_in         | int(1) unsigned  | NO   |     | 0                 |          
                   |
| recorded       | timestamp        | NO   |     | CURRENT_TIMESTAMP | on 
update CURRENT_TIMESTAMP |
| body           | text             | YES  |     | NULL              |          
                   |
| prc_note       | text             | YES  |     | NULL              |          
                   |
++--+--+-+---+-+
10 rows in set (0.00 sec)

mysql describe tag;
+-+--+--+-+-++
| Field       | Type             | Null | Key | Default | Extra          |
+-+--+--+-+-++
| id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| name        | varchar(255)     | YES  |     | NULL    |                |
| description | text             | YES  |     | NULL    |                |
+-+--+--+-+-++
3 rows in set (0.01 sec)

mysql describe complexity_tag;
+-+--+--+-+-+---+
| Field   | Type             | Null | Key | Default | Extra |
+-+--+--+-+-+---+
| post_id | int(10) unsigned | NO   | PRI | NULL    |       |
| version | int(10) unsigned | NO   | PRI | NULL    |       |
| tag_id  | int(10) unsigned | NO   | PRI | NULL    |       |
+-+--+--+-+-+---+
3 rows in set (0.00 sec)


mysql show triggers\G
*** 1. row ***
             Trigger: bi_complexity_submission_trigger
               Event: INSERT
               Table: complexity_submission
           Statement: begin
insert into complexity (post_id, creator_email, opt_in, recorded, body)
values
(new.id, new.creator_email, new.opt_in, new.recorded, new.body);
end
              Timing: AFTER
             Created: NULL
            sql_mode:
             Definer: 

[Catalyst] post-deployment custom fields in application

2011-12-22 Thread bill hauck
Hi.

I'm building an application--project management system--that I'd like to have 
the application administrators to be able to create custom fields for various 
tables after deployment.

For instance, instead of including a hard-coded field for every possible IM or 
chat system out there, I'd like the admins to be able to decide they only care 
about AIM and Skype, so they'd add aim_name and skype_name fields.  Other 
installations and admins might decide they only care about gtalk and facebook 
so they'd add those fields.

The other issue is that I don't want to simply add 10 extra fields and give the 
admins control of the display name.  I'd like to essentially have a secondary 
table that holds the custom fields for that table's primary table. So ...

The person table has a person_custom table to hold the custom fields and data.
The project table has a project_custom table to hold the custom fields and data.
Etc.

So my question really is what's the best approach?  A secondary table for every 
table I want custom fields for?  Or a set of static tables where the first 
holds the field information and the second holds the data related to those 
fields?  or is there a completely different way I'm not thinking of?

For the first way, custom table per table, how do I make DBIx::Class work with 
that?  I don't want to have to run the model creation script after adding or 
modifying a custom field; I'd like to have the field available on the fly.  Do 
I have to give up DBIC for the custom tables?

Any info is greatly appreciated.

Thanks,

bill


___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


Re: [Catalyst] post-deployment custom fields in application

2011-12-22 Thread bill hauck
Alexander, thanks for the reply.  However, I should have been more specific in 
my need.

I'd like the custom fields to be available for calculations.  For instance, 
custom fields for the project table might include dates for reviews or expected 
and actual delivery dates from a supplier.  They could be used to calculate the 
difference between the promise and delivery.  I'd like the database to perform 
the calculations instead of the application.


Also, I'm currently limited to using MySQL 5.1 or 5.5.  PostgreSQL will be an 
option but in the future.  No Oracle.  No NoSQL systems either.

And, finally, I forgot to mention that the admins are the application 
administrators, not system admins or programmers.  They will be creating these 
custom fields through the application itself, not directly in the database.


Again, thanks for any help.



- Original Message -
 From: Alexander Hartmaier alexander.hartma...@t-systems.at
 To: catalyst@lists.scsys.co.uk
 Cc: 
 Sent: Thursday, December 22, 2011 2:08 PM
 Subject: Re: [Catalyst] post-deployment custom fields in application
 
 I'd use a nosql database or the xml feature of PostgreSQL/Oracle/... or
 just have a large column that takes JSON.
 
 Am 2011-12-22 20:01, schrieb bill hauck:
  Hi.
 
  I'm building an application--project management system--that I'd 
 like to have the application administrators to be able to create custom 
 fields 
 for various tables after deployment.
 
  For instance, instead of including a hard-coded field for every possible IM 
 or chat system out there, I'd like the admins to be able to decide they only 
 care about AIM and Skype, so they'd add aim_name and 
 skype_name fields.  Other installations and admins might decide they 
 only care about gtalk and facebook so they'd add those fields.
 
  The other issue is that I don't want to simply add 10 extra fields and 
 give the admins control of the display name.  I'd like to essentially have a 
 secondary table that holds the custom fields for that table's primary table. 
 So ...
 
  The person table has a person_custom table to hold the custom fields and 
 data.
  The project table has a project_custom table to hold the custom fields and 
 data.
  Etc.
 
  So my question really is what's the best approach?  A secondary table 
 for every table I want custom fields for?  Or a set of static tables where 
 the 
 first holds the field information and the second holds the data related to 
 those 
 fields?  or is there a completely different way I'm not thinking of?
 
  For the first way, custom table per table, how do I make DBIx::Class work 
 with that?  I don't want to have to run the model creation script after 
 adding or modifying a custom field; I'd like to have the field available on 
 the fly.  Do I have to give up DBIC for the custom tables?
 
  Any info is greatly appreciated.
 
  Thanks,
 
  bill
 
 
  ___
  List: Catalyst@lists.scsys.co.uk
  Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
  Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
  Dev site: http://dev.catalyst.perl.org/
 
 
 ***
 T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
 Handelsgericht Wien, FN 79340b
 ***
 Notice: This e-mail contains information that is confidential and may be 
 privileged.
 If you are not the intended recipient, please notify the sender and then
 delete this e-mail immediately.
 ***
 
 ___
 List: Catalyst@lists.scsys.co.uk
 Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
 Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
 Dev site: http://dev.catalyst.perl.org/


___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


Re: [Catalyst] how to authenticate using database users

2009-03-18 Thread bill hauck

--- On Wed, 3/18/09, Adam Witney awit...@sgul.ac.uk wrote:

 From: Adam Witney awit...@sgul.ac.uk
 Subject: Re: [Catalyst] how to authenticate using database users
 To: The elegant MVC web framework catalyst@lists.scsys.co.uk
 Date: Wednesday, March 18, 2009, 4:33 PM
 On 18 Mar 2009, at 16:24, Michael Reddick wrote:
 
  
  
  On Wed, Mar 18, 2009 at 10:51 AM, Adam Witney
 awit...@sgul.ac.uk wrote:
  
  Hi,
  
  Our database uses actual database users rather than a
 table containing usernames and password.
  
  
  Why are you doing that?
 
 
 The database has a row level security model implemented
 such that row access is controlled by the database login.
 This is because several applications can be used to interact
 with it.
 
 thanks
 
 adam

Adam, can you tell us what database you're using?  Also, what other types of 
apps (web, fat client, etc.)?  I don't have any solution, but I'm facing a 
somewhat similar issue ...

I'm looking to replace a custom application written in FileMaker, which allows 
you to create permission levels down to the field level.  I'll need to 
replicate this in whatever replaces the original application.

Anyone have any hints on how to track what users (or roles) are able to edit 
what fields?  I'm thinking of implementing it similar to the way MySQL's 
permission tables are setup.  A permission table for each data table with a 
column for each column in the data table and a column for the user / role.  The 
values would be similar to Unix's permissions (1,2,4) to indicate if they could 
read, write, modify.

Anyone want to tell me it's crap and offer a better way?  Please ...

Thanks,

bill



  

___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


Re: [Catalyst] RFC: The paradox of choice in web development

2009-02-18 Thread bill hauck



--- On Wed, 2/18/09, Kieren Diment dim...@gmail.com wrote:

 From: Kieren Diment dim...@gmail.com
 Subject: Re: [Catalyst] RFC: The paradox of choice in web development
 To: The elegant MVC web framework catalyst@lists.scsys.co.uk
 Date: Wednesday, February 18, 2009, 7:41 AM
 On 18/02/2009, at 5:55 PM, Dave Rolsky wrote:
 
  
  This is hardly unreasonable.
  
  I've worked at a number of smaller shops where we
 were developing a Perl-based app. If a developer had decided
 that they wanted to throw together some important tool in
 Java (or Python or Haskell or Smalltalk or ...), that would
 have been problem.
  
  The investment in a language is bigger than just the
 programmers, even. You have build  deployment tools,
 automated testing setups (you do, don't you? ;),
 sysadmin knowledge, packaging infrastructure, and so on.
  
  Some of that may be language-agnostic, but often a lot
 of it ties into the language and its tools.
  
  Once you've made that investment, it makes sense
 to stick with it. Just because Catalyst and Perl are great
 tools for webapps doesn't mean that they're the
 _right_ tool at your job.
 
 Yes indeed.  To balance that, management also need to work
 with the idea that rules are not dogmatic but designed for
 practical purpose.  In my (academic - research and
 practical) experience, the larger the organisation, the more
 likely they are to believe dogma is more important than
 pragmatism, especially if you go through the official IT
 channels.  If you go through the unofficial channels this
 may change, depending on the structure of the organisation,
 and the quality of your unofficial channels.
 

No, I totally understand that.  If the company is using Java, PHP, Python, etc. 
then the other projects should use the same language if possible.

Um, if by automated testing you mean sending an email to the crew and saying, 
Ok, give it a try ... then, yeah, we've got automated testing.

However, we don't really have Java developers for this project.  Sure, the 
company has lots of Java developers but none that are funded by us (corporate 
communications) and available.  We don't really have any funding for the 
project, either, so a contractor is out as well.  I proposed that we write the 
application in Perl using Catalyst since I know Perl pretty well and my system 
administrator needs to learn it since many utilities have been / will be 
written in Perl.  I guess I could learn Java, Servlets, and JSPs, but it'll 
take me a lot longer to write than in Perl.  And it'll be a whole lot less fun.

Cheers

bill


  

___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


Re: [Catalyst] Beginner Question: Controller Layout

2008-12-09 Thread bill hauck

This dovetails nicely with my question ([Catalyst] Example app showing user to 
item authorization?).

For this site how would you control which user/band edits which scheduled 
events, uploads pictures, etc.?  Do you have each function check the database?  
Do you write one function for each type of item and simply call it?

Any examples / guidance is greatly appreciated.

Thanks

--- On Tue, 12/9/08, David Schmidt [EMAIL PROTECTED] wrote:

 From: David Schmidt [EMAIL PROTECTED]
 Subject: [Catalyst] Beginner Question: Controller Layout
 To: The elegant MVC web framework catalyst@lists.scsys.co.uk
 Date: Tuesday, December 9, 2008, 3:17 PM
 Hello list,
 
 I am at the point of starting a new project and have yet to
 choose a
 controller layout.
 
 my application is a site where:
 
 music bands can
 -   register
 -   fill out (and later edit) a profile
 -   upload pictures and songs
 -   schedule events which will be displayed on a calendar
 
 visitors can
 -   browse all of the above information
 -   register to a newsletter
 
 admins can
 -   edit all of the above stuff
 
 Well, I suppose you get the picture. I am hoping to get
 some guidance
 here from someone who has experience
 
 One solution that comes to my mind would be to make a
 controlller for
 each role (admin, band, visitor)
 another one would be to make a controller for each type of
 media
 (songs, pictures, band, ...)
 
 Either way I am not able to tell which one is most suitable
 beforehand.
 
 thanks in advance
 
 david
 
 ___
 List: Catalyst@lists.scsys.co.uk
 Listinfo:
 http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
 Searchable archive:
 http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
 Dev site: http://dev.catalyst.perl.org/


  

___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/


[Catalyst] Example app showing user to item authorization?

2008-12-08 Thread bill hauck
Hi.

I'm relatively new to Catalyst.  Also, since I'm not a programmer by trade I 
only get to spend a few hours a week on code so I'm a bit rusty on some stuff.

I've built a basic project / task system.  User creates project then creates 
tasks for that project.  The tasks can be assigned to other users for 
completion.  However, the next bit of logic I need to build is to only allow 
users assigned to the task to edit that task.  I've setup two tables in the 
database (MySQL) to store the relationships:
project_user (project_id, user_id)
task_user (task_id, user_id)

I've code written for authenticating users against MySQL so only people who 
register can access the system, but right now any authenticated user can access 
any project or task.  I've found the Authorization::Roles  Authorization::ACL 
modules, but they seem to only be for higher level access.  Perhaps I'm missing 
something.

So my question: is there an example application or best practice on how to 
implement a check on all calls to see if the user should be accessing a 
specific item?  I guess this would apply to any type of system: blog, auction, 
cms, etc. -- they all require checking if a specific user can edit a specific 
item.

Thanks!

Cheers,

chunk


  

___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/