[symfony-users] Re: dynamic tables/forms/models with symfony
Do you mean forms that are connected with those tables? If answer is yes... this is not the way. Instead, You can store your form data in well designed tables. Create your own sfFormVisual that will manage saving, editing and building visual representation of the form based on database data and of course some kind of frontend tool for users (Javascript w/ Ajax?). This will take some time, but it's doable. On Mon, Aug 3, 2009 at 12:29 PM, cosmy wrote: > > Hi all, > I need to realize an application that let the possibility to make > dynamic forms and tables determinated by an admin in the backend > interface of the site (not by command-line, it should be fool proof). > Does symfony is able to do it or is it an hard and long hack? > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: dynamic tables/forms/models with symfony
Yes the forms must be connected because they are the interface for filling the db tables. The matter is that my admin users, through an admin panel of course, should define on their own some tables (very simple tables, not related each other) of the database. So i don't know the structure at the beginning. I've thought that through the admin panel the user should compile a yml file and than the system could create the tables, the form ( i want all the created tables editable ) and the model. But i don't know if it's possibile, if it could be done dynamically without overwriting anything, and if it's easy. Have i been more clear? On 3 Ago, 16:07, Alan Bem wrote: > Do you mean forms that are connected with those tables? > > If answer is yes... this is not the way. Instead, You can store your form > data in well designed tables. > Create your own sfFormVisual that will manage saving, editing and building > visual representation of the form based on database data and of course some > kind of frontend tool for users (Javascript w/ Ajax?). > > This will take some time, but it's doable. > > > > On Mon, Aug 3, 2009 at 12:29 PM, cosmy wrote: > > > Hi all, > > I need to realize an application that let the possibility to make > > dynamic forms and tables determinated by an admin in the backend > > interface of the site (not by command-line, it should be fool proof). > > Does symfony is able to do it or is it an hard and long hack? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: dynamic tables/forms/models with symfony
Hi, I don't tried, it is only an idea, create and run the sfPropelGenerateAdminTask class ou some similar thing. PS Sorry my bad english 2009/8/3 cosmy > > Hi all, > I need to realize an application that let the possibility to make > dynamic forms and tables determinated by an admin in the backend > interface of the site (not by command-line, it should be fool proof). > Does symfony is able to do it or is it an hard and long hack? > > > > -- [:>} Alan Cândido ><> --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: dynamic tables/forms/models with symfony
You shouldn't change database schema on "livin' thing". Don't tread forms only as objects related with existing tables. Take my previous advise into consideration and create tables that could store your form schema and user inputs along with some module for visual designing those forms. Cheers, Alan On Fri, Aug 7, 2009 at 5:50 AM, Alan Candido wrote: > Hi, > > I don't tried, it is only an idea, create and run the > sfPropelGenerateAdminTask class ou some similar thing. > > PS Sorry my bad english > > 2009/8/3 cosmy > >> >> Hi all, >> I need to realize an application that let the possibility to make >> dynamic forms and tables determinated by an admin in the backend >> interface of the site (not by command-line, it should be fool proof). >> Does symfony is able to do it or is it an hard and long hack? >> >> >> > > > -- > [:>} Alan Cândido ><> > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: dynamic tables/forms/models with symfony
Ok, i think it could be a solution but.. how do i manage the persistence of this data? In other words, how do i save the data of these forms in the database? Maybe as an unique string in a specific table ( in example: [attribute: value | attribute2: value2] ) ? but how do i manage the queries? i have to use LIKE or regexp and it will be very slow to get out data of a specific type of entry, won't it? Is there an api of symfony to manage this kind of things? On 7 Ago, 08:22, Alan Bem wrote: > You shouldn't change database schema on "livin' thing". > > Don't tread forms only as objects related with existing tables. Take my > previous advise into consideration and create tables that could store your > form schema and user inputs along with some module for visual designing > those forms. > > Cheers, Alan > > > > On Fri, Aug 7, 2009 at 5:50 AM, Alan Candido wrote: > > Hi, > > > I don't tried, it is only an idea, create and run the > > sfPropelGenerateAdminTask class ou some similar thing. > > > PS Sorry my bad english > > > 2009/8/3 cosmy > > >> Hi all, > >> I need to realize an application that let the possibility to make > >> dynamic forms and tables determinated by an admin in the backend > >> interface of the site (not by command-line, it should be fool proof). > >> Does symfony is able to do it or is it an hard and long hack? > > > -- > > [:>} Alan Cândido ><> --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: dynamic tables/forms/models with symfony
Hi, In my opinion you should really create a virtual schema as the previous poster mentioned. Create one table "Table" that stores the custom tables, one table "Field" for the field definitions (like display name, type, default value etc.), one table "TableEntry" for the virtual objects and one table "FieldValue" for the values of the virtual fields. A colleague of mine did this in his open-source project "Ullright" which is a available at http://ull.at. I suggest to look at its source if you want to know more. Bernhard -- Sent from my HTC Hero 7. Aug 2009 11:56 vorm. schrieb am "cosmy" : Ok, i think it could be a solution but.. how do i manage the persistence of this data? In other words, how do i save the data of these forms in the database? Maybe as an unique string in a specific table ( in example: [attribute: value | attribute2: value2] ) ? but how do i manage the queries? i have to use LIKE or regexp and it will be very slow to get out data of a specific type of entry, won't it? Is there an api of symfony to manage this kind of things? On 7 Ago, 08:22, Alan Bem wrote: > You shouldn't change database schema on "li... > On Fri, Aug 7, 2009 at 5:50 AM, Alan Candido wrote: > > Hi, > > > I don't tried... > > 2009/8/3 cosmy > > >> Hi all, > >> I need to realize an application that let the possibility to make > >> dynamic ... --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: dynamic tables/forms/models with symfony
Hi cosmy, Bernhard pointed out that we did something similar in ullright. The actual project site is http://www.ullright.org. We use such virtual tables especially for our workflow module "ullFlow". Have a look at the database structure: http://trac.ullright.org/browser/trunk/plugins/ullFlowPlugin/doc/schema/ullFlowSchema.png The main points of interest are the definition of "virtual tables" in "UllFlowApp" and the definition of the virtual tables's columns in "UllFlowColumnConfig". The equivalent to rows is then stored in "UllFlowDoc", and the column's values in "UllFlowValue". You are also kindly invited to visit the backend of our demo installation: http://demo.ullright.org/ullAdmin (login with admin/test) In the section "Workflow" you'll find "Manage applications" and "Manage columns". >From a technical point of view much logic resides in the "UllFlowDoc" model: http://trac.ullright.org/browser/trunk/plugins/ullFlowPlugin/lib/model/doctrine/PluginUllFlowDoc.class.php We also have a powerful generator which dynamically builds a sfForm. Here's an frontend example of a form of such virtual table: http://demo.ullright.org/ullFlow/create/app/purchase_request Klemens On Aug 9, 10:35 am, Bernhard Schussek wrote: > Hi, > > In my opinion you should really create a virtual schema as the previous > poster mentioned. Create one table "Table" that stores the custom tables, > one table "Field" for the field definitions (like display name, type, > default value etc.), one table "TableEntry" for the virtual objects and one > table "FieldValue" for the values of the virtual fields. > > A colleague of mine did this in his open-source project "Ullright" which is > a available athttp://ull.at. I suggest to look at its source if you want to > know more. > > Bernhard > -- > Sent from my HTC Hero > > 7. Aug 2009 11:56 vorm. schrieb am "cosmy" : > > Ok, i think it could be a solution but.. how do i manage the > persistence of this data? > In other words, how do i save the data of these forms in the database? > Maybe as an unique string in a specific table ( in example: > [attribute: value | attribute2: value2] ) ? > but how do i manage the queries? i have to use LIKE or regexp and it > will be very slow to get out data of a specific type of entry, won't > it? > > Is there an api of symfony to manage this kind of things? > > On 7 Ago, 08:22, Alan Bem wrote: > You shouldn't change > database schema on "li... > > > On Fri, Aug 7, 2009 at 5:50 AM, Alan Candido wrote: > > > > Hi, > > > I don't tried... > > > > 2009/8/3 cosmy > > > >> Hi all, > >> I need to realize an application that let the > > possibility to make > >> dynamic ... --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: dynamic tables/forms/models with symfony
Very very interesting. Thank you very much, this is what i want. One thing I don't understand: should UllFlowDoc and UllFlowValue be the same table? why are they separated? On 9 Ago, 23:15, klemens_u wrote: > Hi cosmy, > > Bernhard pointed out that we did something similar in ullright. > > The actual project site ishttp://www.ullright.org. > > We use such virtual tables especially for our workflow module > "ullFlow". > > Have a look at the database > structure:http://trac.ullright.org/browser/trunk/plugins/ullFlowPlugin/doc/sche... > > The main points of interest are the definition of "virtual tables" in > "UllFlowApp" > and the definition of the virtual tables's columns in > "UllFlowColumnConfig". > The equivalent to rows is then stored in "UllFlowDoc", and the > column's values in "UllFlowValue". > > You are also kindly invited to visit the backend of our demo > installation:http://demo.ullright.org/ullAdmin(login with admin/test) > In the section "Workflow" you'll find "Manage applications" and > "Manage columns". > > From a technical point of view much logic resides in the "UllFlowDoc" > model:http://trac.ullright.org/browser/trunk/plugins/ullFlowPlugin/lib/mode... > > We also have a powerful generator which dynamically builds a sfForm. > Here's an frontend example of a form of such virtual > table:http://demo.ullright.org/ullFlow/create/app/purchase_request > > Klemens > > On Aug 9, 10:35 am, Bernhard Schussek wrote: > > > > > Hi, > > > In my opinion you should really create a virtual schema as the previous > > poster mentioned. Create one table "Table" that stores the custom tables, > > one table "Field" for the field definitions (like display name, type, > > default value etc.), one table "TableEntry" for the virtual objects and one > > table "FieldValue" for the values of the virtual fields. > > > A colleague of mine did this in his open-source project "Ullright" which is > > a available athttp://ull.at. I suggest to look at its source if you want to > > know more. > > > Bernhard > > -- > > Sent from my HTC Hero > > > 7. Aug 2009 11:56 vorm. schrieb am "cosmy" : > > > Ok, i think it could be a solution but.. how do i manage the > > persistence of this data? > > In other words, how do i save the data of these forms in the database? > > Maybe as an unique string in a specific table ( in example: > > [attribute: value | attribute2: value2] ) ? > > but how do i manage the queries? i have to use LIKE or regexp and it > > will be very slow to get out data of a specific type of entry, won't > > it? > > > Is there an api of symfony to manage this kind of things? > > > On 7 Ago, 08:22, Alan Bem wrote: > You shouldn't change > > database schema on "li... > > > > On Fri, Aug 7, 2009 at 5:50 AM, Alan Candido wrote: > > > > > Hi, > > > I don't tried... > > > > > 2009/8/3 cosmy > > > > >> Hi all, > >> I need to realize an application that let the > > > possibility to make > >> dynamic ... --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: dynamic tables/forms/models with symfony
Hi Cosmy, sorry for the late answer - I've been on vacation. UllFlowDoc stores basic information similar to a normal row like id, created_at, etc. whereas UllFlowValue stores the actual value of a "virtual" column. :-) Klemens On 14 Aug., 15:17, cosmy wrote: > Very very interesting. Thank you very much, this is what i want. > One thing I don't understand: should UllFlowDoc and UllFlowValue be > the same table? why are they separated? > > On 9 Ago, 23:15,klemens_u wrote: > > > Hi cosmy, > > > Bernhard pointed out that we did something similar in ullright. > > > The actual project site ishttp://www.ullright.org. > > > We use such virtual tables especially for our workflow module > > "ullFlow". > > > Have a look at the database > > structure:http://trac.ullright.org/browser/trunk/plugins/ullFlowPlugin/doc/sche... > > > The main points of interest are the definition of "virtual tables" in > > "UllFlowApp" > > and the definition of the virtual tables's columns in > > "UllFlowColumnConfig". > > The equivalent to rows is then stored in "UllFlowDoc", and the > > column's values in "UllFlowValue". > > > You are also kindly invited to visit the backend of our demo > > installation:http://demo.ullright.org/ullAdmin(loginwith admin/test) > > In the section "Workflow" you'll find "Manage applications" and > > "Manage columns". > > > From a technical point of view much logic resides in the "UllFlowDoc" > > model:http://trac.ullright.org/browser/trunk/plugins/ullFlowPlugin/lib/mode... > > > We also have a powerful generator which dynamically builds a sfForm. > > Here's an frontend example of a form of such virtual > > table:http://demo.ullright.org/ullFlow/create/app/purchase_request > > > Klemens > > > On Aug 9, 10:35 am, Bernhard Schussek wrote: > > > > Hi, > > > > In my opinion you should really create a virtual schema as the previous > > > poster mentioned. Create one table "Table" that stores the custom tables, > > > one table "Field" for the field definitions (like display name, type, > > > default value etc.), one table "TableEntry" for the virtual objects and > > > one > > > table "FieldValue" for the values of the virtual fields. > > > > A colleague of mine did this in his open-source project "Ullright" which > > > is > > > a available athttp://ull.at. I suggest to look at its source if you want > > > to > > > know more. > > > > Bernhard > > > -- > > > Sent from my HTC Hero > > > > 7. Aug 2009 11:56 vorm. schrieb am "cosmy" : > > > > Ok, i think it could be a solution but.. how do i manage the > > > persistence of this data? > > > In other words, how do i save the data of these forms in the database? > > > Maybe as an unique string in a specific table ( in example: > > > [attribute: value | attribute2: value2] ) ? > > > but how do i manage the queries? i have to use LIKE or regexp and it > > > will be very slow to get out data of a specific type of entry, won't > > > it? > > > > Is there an api of symfony to manage this kind of things? > > > > On 7 Ago, 08:22, Alan Bem wrote: > You shouldn't > > > change > > > database schema on "li... > > > > > On Fri, Aug 7, 2009 at 5:50 AM, Alan Candido wrote: > > > > > > > > > > Hi, > > > I don't tried... > > > > > > 2009/8/3 cosmy > > > > > >> Hi all, > >> I need to realize an application that let the > > > > possibility to make > >> dynamic ... > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
