2. PHPRunner General questions
  3. Dynamic permissions
This topic is locked

Dynamic permissions

 		3/8/2009 4:31:53 PM
PHPRunner General questions
J
 Jepsen author

I need help on this:
I have a large project with many tables and pages and I have a dynamic permission system (the standard PHPR 5.0 one) That works wonderful.
I have currently 340 users in a table X.
I am now integrating 2 systems. The new system have a table Y containing 1800 users. The 340 users in table X are all in table Y, username, password, and e-mail fields have the same names and I have made a program to transfer values from table X to Table Y.
What will happen if I redefine project X to dynamic permission system to get usernames, passwords etc from table Y ?
Will it work smoothly without problems, or will I end up in a major modification exercise?
The system is in production, and I really no not want to interrupt production very month as I have approx 150.000 transactions per months.
Anyone know?
D
 		Denton 3/9/2009

Since system X is working, why not simply import all the data from tqable Y into table X?
Denton
J
 		Jepsen author 3/9/2009

Since system X is working, why not simply import all the data from tqable Y into table X?

Denton


That is a possibility. However, Table X contains only, username, email and password. Yable Y is a complete uder database with names, adresses, accounting info etc etc.
If I do that, I have to add several fields to my X table. What will happen then.
Also, table Y is used in a big system in production and if I lift all data to table X i have to update a lot of PHP to use table X instead of Y in that project, where table X was only used to log people on in my X project.
I gues this is a usual nightmate every time someone want to migrate 2 projects.
D
 		Denton 3/10/2009



That is a possibility. However, Table X contains only, username, email and password. Yable Y is a complete uder database with names, adresses, accounting info etc etc.
If I do that, I have to add several fields to my X table. What will happen then.
Also, table Y is used in a big system in production and if I lift all data to table X i have to update a lot of PHP to use table X instead of Y in that project, where table X was only used to log people on in my X project.
I gues this is a usual nightmate every time someone want to migrate 2 projects.


Seems like you need a overhaul, anyhow. Try making a user table (similar to x), with user name and rights etc. This is easy to do in phpR.
J
 		Jepsen author 3/17/2009

I have tried it and here is the result
Have a project which have been running for a while. 11 tables wirt associated PHPR generated pages and all controlled via dynamic permissions. Table X contained 330 members, their user names and their passwords. Everything playing ok.
Then I generated a table Y containing 2500 users, among them my original 330 users in table X. Table Y have more fields like bank, subscriptions, shipping etc etc. And field names are not identical.
I then changed the table name for the user definition table from X yo Y in PHPR 5.0 and selected the appropriate fields for username, password and e-mail.
Generated the application and upload .... VOILA .... everything worked in the first try. I am impressed.