[geeklog-devtalk] geeklog-devel digest, Vol 1 #468 - 7 msgs

[geeklog-devel-request at lists.geeklog.net]

Send geeklog-devel mailing list submissions to
	geeklog-devel at lists.geeklog.net

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.geeklog.net/listinfo/geeklog-devel
or, via email, send a message with subject or body 'help' to
	geeklog-devel-request at lists.geeklog.net

You can reach the person managing the list at
	geeklog-devel-admin at lists.geeklog.net

When replying, please edit your Subject line so it is more specific
than "Re: Contents of geeklog-devel digest..."


Today's Topics:

   1. Re: Custom user attributes in GL2 (Tony Bibbs)
   2. Re: GL2 Login works (Tony Bibbs)
   3. Re: Plugin layout (Tony Bibbs)
   4. Re: GL2 Login works (Tony Bibbs)
   5. Re: [Fwd: Re: [propel] Multiple DBMS's and date/time] (Blaine Lang)
   6. Re: [Fwd: Re: [propel] Multiple DBMS's and date/time] (Tony Bibbs)
   7. Re: [Fwd: Re: [propel] Multiple DBMS's and date/time] (Vincent Furia)

--__--__--

Message: 1
Date: Tue, 21 Dec 2004 23:05:37 -0600
From: Tony Bibbs <tony at tonybibbs.com>
To: geeklog-devel at lists.geeklog.net
Subject: Re: [geeklog-devel] Custom user attributes in GL2
Reply-To: geeklog-devel at lists.geeklog.net

Vincent Furia wrote:


>I just wanted to remark somewhere permanent that we need to keep in

>mind that a plugin selected for uninstall may be depended upon by

>other plugins.  Before an uninstall is begun, we need to determine the

>reverse dependencies for the plugin (what plugins, if any, rely on the

>availability of the plugin to be uninstalled) and deal with those

>appropriately.

>  

>

This is starting to beg the question if the plugin dependencies 
shouldn't be added to the datamodel.  I think you could do it without 
having it in the database but it might be easier searching there.  Just 
a thought.


>This also suggests that, like PEAR packages, we allow a plugin to

>specify requried dependencies, recommended dependencies, and optional

>dependencies.

>  

>

Agreed. 

--Tony

--__--__--

Message: 2
Date: Tue, 21 Dec 2004 23:06:43 -0600
From: Tony Bibbs <tony at tonybibbs.com>
To: geeklog-devel at lists.geeklog.net
Subject: Re: [geeklog-devel] GL2 Login works
Reply-To: geeklog-devel at lists.geeklog.net

Good question.  I think so, so far I've simply been using file-based 
sessions.  I should dust that code off...it's pretty small so I don't 
see a problem in using i.

--Tony

Vincent Furia wrote:


>Tony,

>

>Slightly off topic, but do we plan to still use the

>PEAR::HTTP_Session2 class(es) for session management?

>

>-Vinny

>

>

>On Mon, 20 Dec 2004 15:51:21 -0600, Tony Bibbs <tony at tonybibbs.com> wrote:

>  

>

>>Pretty soon here I will be checking in a version of Geeklog 2 which

>>successfully authenticates a user.  I have taken care to factor the code

>>in such a way that the means by which one manages a user account can be

>>changed by simply implementing one class and changing a setting in the

>>config file.

>>

>>Being that noone has looked into the code yet (hint, hint) I'll take

>>this time to discuss the basic design:

>>

>>The most basic part of the account management equation is the

>>Geeklog_AccountManager (in AccountManager.php).  It's job is to read the

>>Account Manager it needs to create from a value in the configuration

>>file ($glConf['account_manager']), and generate an instance of that

>>class which is responsible for doing the work.

>>

>>All account managers must implement the Geeklog_AccountManagerInterface

>>(AccountManagerInterface.php) which provides methods for creating

>>accounts, deleting accounts, authenticating users and changing

>>passwords.  Other method will probably be added to this interface (i.e.

>>update account, etc) but I won't bother with them until we establish the

>>need.

>>

>>As such, I have created default AccountManager...named

>>Geeklog_DefaultAccountManager in DefaultAccountManager.php (see the

>>pattern?).

>>

>>All this said, one could, for example, create a LDAPAccountManager,

>>IMAPAccountManager, etc to have GL2 authenticate to any datastore.  I'd

>>like to see LDAP and IMAP bundled in with GL2 (any takers?).

>>

>>So, have a look in CVS and let me know what you do/don't like about what

>>I have so far.

>>

>>--Tony

>>_______________________________________________

>>geeklog-devel mailing list

>>geeklog-devel at lists.geeklog.net

>>http://lists.geeklog.net/listinfo/geeklog-devel

>>

>>    

>>

>_______________________________________________

>geeklog-devel mailing list

>geeklog-devel at lists.geeklog.net

>http://lists.geeklog.net/listinfo/geeklog-devel

>  

>



--__--__--

Message: 3
Date: Tue, 21 Dec 2004 23:11:33 -0600
From: Tony Bibbs <tony at tonybibbs.com>
To: geeklog-devel at lists.geeklog.net
Subject: Re: [geeklog-devel] Plugin layout
Reply-To: geeklog-devel at lists.geeklog.net

Vincent Furia wrote:


>Basically I was thinking that only index.php have an "echo" statement.

> Everything else should pass around HTML strings.  That would allow us

>to do cool stuff like apply post-processing filters on all pages (or

>just some pages).

>  

>

It'll need to be slightly more complicated than that since I see 
index.php holding the MVCnPHP controller for the admin and basic kernel 
stuff.  We should be able to use a single MVCnPHP command for handling 
handing off control to both procedural and OO-based plugins.  
Essentially the same concept, though, as your getPage.


>URL rewriting should be easy, if we just let the plugins deal with it.

> Just so long as the first parameter in a rewritten URL is a plugin

>name so that index.php knows what to do.  Implementing something more

>complex would (obviously) require more effort and complexity.

>  

>

No, I think that would be fine.  Intuitive and simple.  Question is 
would it work with PHP5/IIS?  Last I check this sort of URL rewriting 
caused nasty errors.

--Tony

--__--__--

Message: 4
Date: Tue, 21 Dec 2004 23:20:41 -0600
From: Tony Bibbs <tony at tonybibbs.com>
To: geeklog-devel at lists.geeklog.net
Subject: Re: [geeklog-devel] GL2 Login works
Reply-To: geeklog-devel at lists.geeklog.net

Oh, yeah. Only other issue with this is I'll need to refactor the 
existing code so I can include Creole support.  Shouldn't be too hard 
but something I didn't want to forget.

--Tony

Vincent Furia wrote:


>Tony,

>

>Slightly off topic, but do we plan to still use the

>PEAR::HTTP_Session2 class(es) for session management?

>

>-Vinny

>

>

>On Mon, 20 Dec 2004 15:51:21 -0600, Tony Bibbs <tony at tonybibbs.com> wrote:

>  

>

>>Pretty soon here I will be checking in a version of Geeklog 2 which

>>successfully authenticates a user.  I have taken care to factor the code

>>in such a way that the means by which one manages a user account can be

>>changed by simply implementing one class and changing a setting in the

>>config file.

>>

>>Being that noone has looked into the code yet (hint, hint) I'll take

>>this time to discuss the basic design:

>>

>>The most basic part of the account management equation is the

>>Geeklog_AccountManager (in AccountManager.php).  It's job is to read the

>>Account Manager it needs to create from a value in the configuration

>>file ($glConf['account_manager']), and generate an instance of that

>>class which is responsible for doing the work.

>>

>>All account managers must implement the Geeklog_AccountManagerInterface

>>(AccountManagerInterface.php) which provides methods for creating

>>accounts, deleting accounts, authenticating users and changing

>>passwords.  Other method will probably be added to this interface (i.e.

>>update account, etc) but I won't bother with them until we establish the

>>need.

>>

>>As such, I have created default AccountManager...named

>>Geeklog_DefaultAccountManager in DefaultAccountManager.php (see the

>>pattern?).

>>

>>All this said, one could, for example, create a LDAPAccountManager,

>>IMAPAccountManager, etc to have GL2 authenticate to any datastore.  I'd

>>like to see LDAP and IMAP bundled in with GL2 (any takers?).

>>

>>So, have a look in CVS and let me know what you do/don't like about what

>>I have so far.

>>

>>--Tony

>>_______________________________________________

>>geeklog-devel mailing list

>>geeklog-devel at lists.geeklog.net

>>http://lists.geeklog.net/listinfo/geeklog-devel

>>

>>    

>>

>_______________________________________________

>geeklog-devel mailing list

>geeklog-devel at lists.geeklog.net

>http://lists.geeklog.net/listinfo/geeklog-devel

>  

>



--__--__--

Message: 5
From: "Blaine Lang" <geeklog at langfamily.ca>
To: <geeklog-devel at lists.geeklog.net>
Subject: Re: [geeklog-devel] [Fwd: Re: [propel] Multiple DBMS's and date/time]
Date: Wed, 22 Dec 2004 11:33:10 -0500
Reply-To: geeklog-devel at lists.geeklog.net

Will we still not need Library functions then to compare dates in code as I 
think you need to convert the YY-MM-DD HH:MM:SS Date/time format strings to 
UNIX Timestamps for comparison in code - correct?

Or did I read that you can request Propel to do this converstion when 
retrieving the field?

Blaine

----- Original Message ----- 
From: "Vincent Furia" <vfuria at gmail.com>
To: <geeklog-devel at lists.geeklog.net>
Sent: Friday, December 17, 2004 12:16 PM
Subject: Re: [geeklog-devel] [Fwd: Re: [propel] Multiple DBMS's and 
date/time]


TIMESTAMP in Propel == DATETIME in MySQL. So in mysql DDL you'd want
to use DATETIME.

-Vinny


On Fri, 17 Dec 2004 10:45:50 -0600, Tony Bibbs <tony at tonybibbs.com> wrote:

> Seems like we should go with the timestamp data type.  Read below.

>

> --Tony

>

> -------- Original Message --------

> Subject:        Re: [propel] Multiple DBMS's and date/time

> Date:   Fri, 17 Dec 2004 11:36:17 -0500 (EST)

> From:   Hans Lellelid <hans at velum.net>

> Reply-To:       users at propel.tigris.org

> To:     users at propel.tigris.org

> References:     <41C304F4.7020205 at tonybibbs.com>

> <15195.69.17.56.162.1103300475.spork at webmail.hozn.net>

> <41C308F8.2090905 at tonybibbs.com>

>

> Yeah, I'm quite sure you can set it at runtime, though you may need to set

> it before opening the connection.  I used to set it in Creole

> MSSQLConnection class, but there was some reason that this wasn't always a

> good idea.  ... perhaps it was breaking when using freetds instead of MS

> libs or something.

>

> -Hans

>

> > Cool.  Is the MSSQL option you refer to in php.ini something I can set

> > at runtime via ini_set()?

> >

> > --Tony

> >

> > Hans Lellelid wrote:

> >

> >>>I have a project that will be supported under multiple DBMS's (MySQL,

> >>>Postgres and MS SQL).  We are doing the general database design and we

> >>>are to the topic of how to formate date/time values.  All our values

> >>>will be after 1970 so timestamps are an options.  My question is 

> >>>whether

> >>>or not to use the native date/time types in the DBMS via Propel.  Does

> >>>Propel handle this well or am I better of using a timestamp datatype or

> >>>int?

> >>>

> >>>

> >>>

> >>

> >>Propel handles this well and I would advise you to use TIMESTAMP rather

> >>than INT.

> >>

> >>TIMESTAMP will be converted to the best representation (e.g. for MySQL 

> >>it

> >>will use DATETIME) for the RDBMS.  The only thing you'll probably want 

> >>to

> >>fix is the MSSQL ini option (in php.ini) to have it use standard ISO 

> >>date

> >>formats.

> >>

> >>The getter methods that are generated by Propel will actually allow you

> >> to

> >>specify date/time formatters:

> >>

> >>$myobj->getTimeCol("Y-m-d"); // date()-formatting

> >>

> >>or

> >>

> >>$myobj->getTimeCol("%c"); // strftime()-formatting

> >>

> >>or

> >>

> >>$myobj->getTimeCol(null); // native unix timestamp

> >>

> >>or

> >>

> >>$myobj->getTimeCol(); // default is ISO: Y-m-d H:i:s

> >>

> >>Hope that helps.

> >>

> >>-Hans

> >>

> >>---------------------------------------------------------------------

> >>To unsubscribe, e-mail: users-unsubscribe at propel.tigris.org

> >>For additional commands, e-mail: users-help at propel.tigris.org

> >>

> >>

> >

> >

> > ---------------------------------------------------------------------

> > To unsubscribe, e-mail: users-unsubscribe at propel.tigris.org

> > For additional commands, e-mail: users-help at propel.tigris.org

> >

> >

>

> ---------------------------------------------------------------------

> To unsubscribe, e-mail: users-unsubscribe at propel.tigris.org

> For additional commands, e-mail: users-help at propel.tigris.org

>

> _______________________________________________

> geeklog-devel mailing list

> geeklog-devel at lists.geeklog.net

> http://lists.geeklog.net/listinfo/geeklog-devel

>

_______________________________________________
geeklog-devel mailing list
geeklog-devel at lists.geeklog.net
http://lists.geeklog.net/listinfo/geeklog-devel 


--__--__--

Message: 6
Date: Wed, 22 Dec 2004 10:46:57 -0600
From: Tony Bibbs <tony at tonybibbs.com>
To: geeklog-devel at lists.geeklog.net
Subject: Re: [geeklog-devel] [Fwd: Re: [propel] Multiple DBMS's and date/time]
Reply-To: geeklog-devel at lists.geeklog.net

Blaine Lang wrote:


>Will we still not need Library functions then to compare dates in code as I 

>think you need to convert the YY-MM-DD HH:MM:SS Date/time format strings to 

>UNIX Timestamps for comparison in code - correct?

>

>Or did I read that you can request Propel to do this converstion when 

>retrieving the field?

>  

>

Right, when you pull a date out of a domain object you can do something 
like:

$myObj->getSomeDateMember('<date format');

I wouldn't assume, though, that you don't have to convert them to a 
date/time format when saving.  It'll take some testing.

--Tony

--__--__--

Message: 7
Date: Wed, 22 Dec 2004 12:46:24 -0500
From: Vincent Furia <vfuria at gmail.com>
To: geeklog-devel at lists.geeklog.net
Subject: Re: [geeklog-devel] [Fwd: Re: [propel] Multiple DBMS's and date/time]
Reply-To: geeklog-devel at lists.geeklog.net

Propel functions that set date/time columns can commutate common
string formats into dates.  It's actually pretty cool how flexible it
is.

-Vinny


On Wed, 22 Dec 2004 10:46:57 -0600, Tony Bibbs <tony at tonybibbs.com> wrote:

> Blaine Lang wrote:

> 

> >Will we still not need Library functions then to compare dates in code as I

> >think you need to convert the YY-MM-DD HH:MM:SS Date/time format strings to

> >UNIX Timestamps for comparison in code - correct?

> >

> >Or did I read that you can request Propel to do this converstion when

> >retrieving the field?

> >

> >

> Right, when you pull a date out of a domain object you can do something

> like:

> 

> $myObj->getSomeDateMember('<date format');

> 

> I wouldn't assume, though, that you don't have to convert them to a

> date/time format when saving.  It'll take some testing.

> 

> --Tony

> _______________________________________________

> geeklog-devel mailing list

> geeklog-devel at lists.geeklog.net

> http://lists.geeklog.net/listinfo/geeklog-devel

>



--__--__--

_______________________________________________
geeklog-devel mailing list
geeklog-devel at lists.geeklog.net
http://lists.geeklog.net/listinfo/geeklog-devel


End of geeklog-devel Digest