Re: [web2py] Re: help please
El jueves, 20 de diciembre de 2012 10:44:42 UTC-3, Aurelijus Useckas escribió: yeah.. backup backup backup.. it's just that sometimes you forget to :( Would it be wise to add some backup module to web2py admin? It could default to 1 copy per day or smthing simillar. It would especially serve Noobs :) I think this can be accomplished with the db.export_to_csv method and cron, but adding the option to the admin interface would be useful. Perhaps with large databases and csv there could be performance issues. Maybe it's necessary to use native engine backup commands in such cases. --
Re: [web2py] Re: help please
yeah.. backup backup backup.. it's just that sometimes you forget to :( Would it be wise to add some backup module to web2py admin? It could default to 1 copy per day or smthing simillar. It would especially serve Noobs :) On Thu, Dec 20, 2012 at 12:27 AM, Derek sp1d...@gmail.com wrote: The data is gone. Let this be a reminder to all of you out there, back up your data and back it up often. Also, it's not backed up if you can't restore it, so test out restores as well. On Wednesday, December 19, 2012 9:08:47 AM UTC-7, LightDot wrote: First, make a couple of physical copies of the database and do not write into it anymore. Then, working on a copy, you could try restoring / extracting the data by using forensic tools, etc. I'm not aware of a straightforward sqlite restore tool, but there might be one or two out there... I'm sure you're not the first to have such an issue. I guess it comes down to the question of is it worth the time and effort. Regards, Ales On Wednesday, December 19, 2012 4:54:50 PM UTC+1, Aurelijus Useckas wrote: Yeah I know.. I have an old backup only :( me bad On Wed, Dec 19, 2012 at 5:51 PM, Mark czhan...@gmail.com wrote: Do you have any kind of backup files for the database? Or, do your server/computer backup daily or weekly? If there are any backup files, you can restore the deleted data easily. Mark On Wednesday, December 19, 2012 8:21:27 AM UTC-5, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( -- -- --
[web2py] Re: help please
i'm on SQLite On Wednesday, December 19, 2012 3:21:27 PM UTC+2, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( --
[web2py] Re: help please
definitely messed up. no way they will return back. That's why referenced tables are for. Il giorno mercoledì 19 dicembre 2012 14:25:01 UTC+1, Aurelijus Useckas ha scritto: i'm on SQLite On Wednesday, December 19, 2012 3:21:27 PM UTC+2, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( --
[web2py] Re: help please
is there any way to extract data from sqlite? The file is still full of data... I don't understand, if you delete somthing that is linked, everything messes up? On Wednesday, December 19, 2012 3:34:31 PM UTC+2, Niphlod wrote: definitely messed up. no way they will return back. That's why referenced tables are for. Il giorno mercoledì 19 dicembre 2012 14:25:01 UTC+1, Aurelijus Useckas ha scritto: i'm on SQLite On Wednesday, December 19, 2012 3:21:27 PM UTC+2, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( --
[web2py] Re: help please
I said *messed up* just to use part of your sentence. With referenced table, if you used the default ondelete attribute of the field, every child record gets deleted as soon as the parent is deleted. You can't fetch the data drom sqlite, it's definitely gone. For goods. The fact that the sqlite file is still large is because by default SQLite doesn't release the space: it keeps it for future records. On Wednesday, December 19, 2012 2:38:32 PM UTC+1, Aurelijus Useckas wrote: is there any way to extract data from sqlite? The file is still full of data... I don't understand, if you delete somthing that is linked, everything messes up? On Wednesday, December 19, 2012 3:34:31 PM UTC+2, Niphlod wrote: definitely messed up. no way they will return back. That's why referenced tables are for. Il giorno mercoledì 19 dicembre 2012 14:25:01 UTC+1, Aurelijus Useckas ha scritto: i'm on SQLite On Wednesday, December 19, 2012 3:21:27 PM UTC+2, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( --
[web2py] Re: help please
but I can see the records inside the storage.sqlite file, so they must be accessible somehow On Wednesday, December 19, 2012 3:51:37 PM UTC+2, Niphlod wrote: I said *messed up* just to use part of your sentence. With referenced table, if you used the default ondelete attribute of the field, every child record gets deleted as soon as the parent is deleted. You can't fetch the data drom sqlite, it's definitely gone. For goods. The fact that the sqlite file is still large is because by default SQLite doesn't release the space: it keeps it for future records. On Wednesday, December 19, 2012 2:38:32 PM UTC+1, Aurelijus Useckas wrote: is there any way to extract data from sqlite? The file is still full of data... I don't understand, if you delete somthing that is linked, everything messes up? On Wednesday, December 19, 2012 3:34:31 PM UTC+2, Niphlod wrote: definitely messed up. no way they will return back. That's why referenced tables are for. Il giorno mercoledì 19 dicembre 2012 14:25:01 UTC+1, Aurelijus Useckas ha scritto: i'm on SQLite On Wednesday, December 19, 2012 3:21:27 PM UTC+2, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( --
[web2py] Re: help please
do you see them in appadmin ? if yes, then it's a no-issue: the data is there but I'm not sure what are you pointing to saying *all my data (from other table views) disapears* . If it's not there in appadmin but you see the records on sqlite with some other tool, than you're app is using a different database than the one you're examining with the external tool. Appadmin lets you see all the records for all your defined tables, without filters. Il giorno mercoledì 19 dicembre 2012 14:55:14 UTC+1, Aurelijus Useckas ha scritto: but I can see the records inside the storage.sqlite file, so they must be accessible somehow On Wednesday, December 19, 2012 3:51:37 PM UTC+2, Niphlod wrote: I said *messed up* just to use part of your sentence. With referenced table, if you used the default ondelete attribute of the field, every child record gets deleted as soon as the parent is deleted. You can't fetch the data drom sqlite, it's definitely gone. For goods. The fact that the sqlite file is still large is because by default SQLite doesn't release the space: it keeps it for future records. On Wednesday, December 19, 2012 2:38:32 PM UTC+1, Aurelijus Useckas wrote: is there any way to extract data from sqlite? The file is still full of data... I don't understand, if you delete somthing that is linked, everything messes up? On Wednesday, December 19, 2012 3:34:31 PM UTC+2, Niphlod wrote: definitely messed up. no way they will return back. That's why referenced tables are for. Il giorno mercoledì 19 dicembre 2012 14:25:01 UTC+1, Aurelijus Useckas ha scritto: i'm on SQLite On Wednesday, December 19, 2012 3:21:27 PM UTC+2, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( --
Re: [web2py] Re: help please
Thanks Niphlod for supporting me on this one. The problem is that appadmin doesn't see any records but if I'm accessing the same storage.sqlite db with VIM or even word processor, I can still see all the data in there, it's just that something doesn't allow appadmin or sqlite viewer to see it.. I wonder why and what possibly could be done.. On Wed, Dec 19, 2012 at 5:09 PM, Niphlod niph...@gmail.com wrote: do you see them in appadmin ? if yes, then it's a no-issue: the data is there but I'm not sure what are you pointing to saying *all my data (from other table views) disapears* . If it's not there in appadmin but you see the records on sqlite with some other tool, than you're app is using a different database than the one you're examining with the external tool. Appadmin lets you see all the records for all your defined tables, without filters. Il giorno mercoledì 19 dicembre 2012 14:55:14 UTC+1, Aurelijus Useckas ha scritto: but I can see the records inside the storage.sqlite file, so they must be accessible somehow On Wednesday, December 19, 2012 3:51:37 PM UTC+2, Niphlod wrote: I said *messed up* just to use part of your sentence. With referenced table, if you used the default ondelete attribute of the field, every child record gets deleted as soon as the parent is deleted. You can't fetch the data drom sqlite, it's definitely gone. For goods. The fact that the sqlite file is still large is because by default SQLite doesn't release the space: it keeps it for future records. On Wednesday, December 19, 2012 2:38:32 PM UTC+1, Aurelijus Useckas wrote: is there any way to extract data from sqlite? The file is still full of data... I don't understand, if you delete somthing that is linked, everything messes up? On Wednesday, December 19, 2012 3:34:31 PM UTC+2, Niphlod wrote: definitely messed up. no way they will return back. That's why referenced tables are for. Il giorno mercoledì 19 dicembre 2012 14:25:01 UTC+1, Aurelijus Useckas ha scritto: i'm on SQLite On Wednesday, December 19, 2012 3:21:27 PM UTC+2, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( -- --
Re: [web2py] Re: help please
did you try with some app that has sqlite support such as sqliteman or the sqlite3 command line ? I hardly doubt that if sqlite3 commandline can't fetch your records, what you're seeing with VIM is your actual records Il giorno mercoledì 19 dicembre 2012 16:12:31 UTC+1, Aurelijus Useckas ha scritto: Thanks Niphlod for supporting me on this one. The problem is that appadmin doesn't see any records but if I'm accessing the same storage.sqlite db with VIM or even word processor, I can still see all the data in there, it's just that something doesn't allow appadmin or sqlite viewer to see it.. I wonder why and what possibly could be done.. On Wed, Dec 19, 2012 at 5:09 PM, Niphlod nip...@gmail.com javascript:wrote: do you see them in appadmin ? if yes, then it's a no-issue: the data is there but I'm not sure what are you pointing to saying *all my data (from other table views) disapears* . If it's not there in appadmin but you see the records on sqlite with some other tool, than you're app is using a different database than the one you're examining with the external tool. Appadmin lets you see all the records for all your defined tables, without filters. Il giorno mercoledì 19 dicembre 2012 14:55:14 UTC+1, Aurelijus Useckas ha scritto: but I can see the records inside the storage.sqlite file, so they must be accessible somehow On Wednesday, December 19, 2012 3:51:37 PM UTC+2, Niphlod wrote: I said *messed up* just to use part of your sentence. With referenced table, if you used the default ondelete attribute of the field, every child record gets deleted as soon as the parent is deleted. You can't fetch the data drom sqlite, it's definitely gone. For goods. The fact that the sqlite file is still large is because by default SQLite doesn't release the space: it keeps it for future records. On Wednesday, December 19, 2012 2:38:32 PM UTC+1, Aurelijus Useckas wrote: is there any way to extract data from sqlite? The file is still full of data... I don't understand, if you delete somthing that is linked, everything messes up? On Wednesday, December 19, 2012 3:34:31 PM UTC+2, Niphlod wrote: definitely messed up. no way they will return back. That's why referenced tables are for. Il giorno mercoledì 19 dicembre 2012 14:25:01 UTC+1, Aurelijus Useckas ha scritto: i'm on SQLite On Wednesday, December 19, 2012 3:21:27 PM UTC+2, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( -- --
Re: [web2py] Re: help please
I've tried Sqlite database browser. Same results.. but still it's strange, records are really there On Wed, Dec 19, 2012 at 5:22 PM, Niphlod niph...@gmail.com wrote: did you try with some app that has sqlite support such as sqliteman or the sqlite3 command line ? I hardly doubt that if sqlite3 commandline can't fetch your records, what you're seeing with VIM is your actual records Il giorno mercoledì 19 dicembre 2012 16:12:31 UTC+1, Aurelijus Useckas ha scritto: Thanks Niphlod for supporting me on this one. The problem is that appadmin doesn't see any records but if I'm accessing the same storage.sqlite db with VIM or even word processor, I can still see all the data in there, it's just that something doesn't allow appadmin or sqlite viewer to see it.. I wonder why and what possibly could be done.. On Wed, Dec 19, 2012 at 5:09 PM, Niphlod nip...@gmail.com wrote: do you see them in appadmin ? if yes, then it's a no-issue: the data is there but I'm not sure what are you pointing to saying *all my data (from other table views) disapears* . If it's not there in appadmin but you see the records on sqlite with some other tool, than you're app is using a different database than the one you're examining with the external tool. Appadmin lets you see all the records for all your defined tables, without filters. Il giorno mercoledì 19 dicembre 2012 14:55:14 UTC+1, Aurelijus Useckas ha scritto: but I can see the records inside the storage.sqlite file, so they must be accessible somehow On Wednesday, December 19, 2012 3:51:37 PM UTC+2, Niphlod wrote: I said *messed up* just to use part of your sentence. With referenced table, if you used the default ondelete attribute of the field, every child record gets deleted as soon as the parent is deleted. You can't fetch the data drom sqlite, it's definitely gone. For goods. The fact that the sqlite file is still large is because by default SQLite doesn't release the space: it keeps it for future records. On Wednesday, December 19, 2012 2:38:32 PM UTC+1, Aurelijus Useckas wrote: is there any way to extract data from sqlite? The file is still full of data... I don't understand, if you delete somthing that is linked, everything messes up? On Wednesday, December 19, 2012 3:34:31 PM UTC+2, Niphlod wrote: definitely messed up. no way they will return back. That's why referenced tables are for. Il giorno mercoledì 19 dicembre 2012 14:25:01 UTC+1, Aurelijus Useckas ha scritto: i'm on SQLite On Wednesday, December 19, 2012 3:21:27 PM UTC+2, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( -- -- --
[web2py] Re: help please
Do you have any kind of backup files for the database? Or, do your server/computer backup daily or weekly? If there are any backup files, you can restore the deleted data easily. Mark On Wednesday, December 19, 2012 8:21:27 AM UTC-5, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( --
Re: [web2py] Re: help please
Yeah I know.. I have an old backup only :( me bad On Wed, Dec 19, 2012 at 5:51 PM, Mark czhang2...@gmail.com wrote: Do you have any kind of backup files for the database? Or, do your server/computer backup daily or weekly? If there are any backup files, you can restore the deleted data easily. Mark On Wednesday, December 19, 2012 8:21:27 AM UTC-5, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( -- --
Re: [web2py] Re: help please
Mine is a very stupid question but sometime... Is there an active field in your db tables? Il giorno mercoledì 19 dicembre 2012 16:54:50 UTC+1, Aurelijus Useckas ha scritto: Yeah I know.. I have an old backup only :( me bad On Wed, Dec 19, 2012 at 5:51 PM, Mark czhan...@gmail.com javascript:wrote: Do you have any kind of backup files for the database? Or, do your server/computer backup daily or weekly? If there are any backup files, you can restore the deleted data easily. Mark On Wednesday, December 19, 2012 8:21:27 AM UTC-5, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( -- --
Re: [web2py] Re: help please
First, make a couple of physical copies of the database and do not write into it anymore. Then, working on a copy, you could try restoring / extracting the data by using forensic tools, etc. I'm not aware of a straightforward sqlite restore tool, but there might be one or two out there... I'm sure you're not the first to have such an issue. I guess it comes down to the question of is it worth the time and effort. Regards, Ales On Wednesday, December 19, 2012 4:54:50 PM UTC+1, Aurelijus Useckas wrote: Yeah I know.. I have an old backup only :( me bad On Wed, Dec 19, 2012 at 5:51 PM, Mark czhan...@gmail.com javascript:wrote: Do you have any kind of backup files for the database? Or, do your server/computer backup daily or weekly? If there are any backup files, you can restore the deleted data easily. Mark On Wednesday, December 19, 2012 8:21:27 AM UTC-5, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( -- --
Re: [web2py] Re: help please
The data is gone. Let this be a reminder to all of you out there, back up your data and back it up often. Also, it's not backed up if you can't restore it, so test out restores as well. On Wednesday, December 19, 2012 9:08:47 AM UTC-7, LightDot wrote: First, make a couple of physical copies of the database and do not write into it anymore. Then, working on a copy, you could try restoring / extracting the data by using forensic tools, etc. I'm not aware of a straightforward sqlite restore tool, but there might be one or two out there... I'm sure you're not the first to have such an issue. I guess it comes down to the question of is it worth the time and effort. Regards, Ales On Wednesday, December 19, 2012 4:54:50 PM UTC+1, Aurelijus Useckas wrote: Yeah I know.. I have an old backup only :( me bad On Wed, Dec 19, 2012 at 5:51 PM, Mark czhan...@gmail.com wrote: Do you have any kind of backup files for the database? Or, do your server/computer backup daily or weekly? If there are any backup files, you can restore the deleted data easily. Mark On Wednesday, December 19, 2012 8:21:27 AM UTC-5, Aurelijus Useckas wrote: I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event reset the autoincrement and make it appear totally identical.. still nothing :( did i mess up??? :( -- --
[web2py] Re: help please on adding jquery-ui theme to SQLFORM.grid
Thanks for the responses, After reading the notes, I dug around and discovered the following list of themes that can be used in layout.html. base black-tie blitzer cupertino dark-hive dot-luv eggplant excite-bike flick hot-sneaks humanity le-frog mint-choc overcast pepper-grinder redmond smoothness south-street start sunny swanky-purse trontastic ui-darkness ui-lightness vader Simply substitute any of these theme names in place of the '' below. (This is the line in layout.html referenced in the earlier note) !-- uncomment here to load jquery-ui -- link rel=stylesheet href=http://ajax.googleapis.com/ajax/libs/ jqueryui/1.8.16/themes//jquery-ui.css type=text/css media=all / (I imagine you already know this, but I thought I'd include the list I found for other interested users) - Tom On Nov 13, 9:15 pm, Anthony abasta...@gmail.com wrote: CSS files typically go in your app's /static/css folder, and you then have to make sure the CSS file gets linked in the page head (like any other CSS file). An easy way to include the CSS file is to do: response.files.append(URL('static', 'cs/your_theme_file.css')) in the controller action that needs the jquery-ui theme (or in your layout.html file if needed on most/all pages). Anthony On Sunday, November 13, 2011 9:45:45 PM UTC-5, tomt wrote: Hi, I'm looking for an example of how to install and use a jquery theme for SQLFORM.grid I see that I can implement jquery-ui by defining: form = SQLFORM.grid(query=db.table.field=='3',ui='jquery-ui') I see that I can download a theme fromhttp://jqueryui.com/download but I don't know where to install it, or how to enable it. I searched the web2py group for examples, but I failed to find any. I'd appreciate it if someone could post a working example of this feature. Thanks in advance, - Tom
[web2py] Re: help please on adding jquery-ui theme to SQLFORM.grid
Yes, those are the pre-built jQuery UI themes (see Gallery tab): http://jqueryui.com/themeroller/. You can also create your own using ThemeRoller. On Monday, November 14, 2011 10:52:40 PM UTC-5, tomt wrote: Thanks for the responses, After reading the notes, I dug around and discovered the following list of themes that can be used in layout.html. base black-tie blitzer cupertino dark-hive dot-luv eggplant excite-bike flick hot-sneaks humanity le-frog mint-choc overcast pepper-grinder redmond smoothness south-street start sunny swanky-purse trontastic ui-darkness ui-lightness vader Simply substitute any of these theme names in place of the '' below. (This is the line in layout.html referenced in the earlier note) !-- uncomment here to load jquery-ui -- link rel=stylesheet href=http://ajax.googleapis.com/ajax/libs/ jqueryui/1.8.16/themes//jquery-ui.csshttp://ajax.googleapis.com/ajax/libs/jqueryui/1.8.16/themes//jquery-ui.css type=text/css media=all / (I imagine you already know this, but I thought I'd include the list I found for other interested users) - Tom On Nov 13, 9:15 pm, Anthony abas...@gmail.com wrote: CSS files typically go in your app's /static/css folder, and you then have to make sure the CSS file gets linked in the page head (like any other CSS file). An easy way to include the CSS file is to do: response.files.append(URL('static', 'cs/your_theme_file.css')) in the controller action that needs the jquery-ui theme (or in your layout.html file if needed on most/all pages). Anthony On Sunday, November 13, 2011 9:45:45 PM UTC-5, tomt wrote: Hi, I'm looking for an example of how to install and use a jquery theme for SQLFORM.grid I see that I can implement jquery-ui by defining: form = SQLFORM.grid(query=db.table.field=='3',ui='jquery-ui') I see that I can download a theme fromhttp://jqueryui.com/download but I don't know where to install it, or how to enable it. I searched the web2py group for examples, but I failed to find any. I'd appreciate it if someone could post a working example of this feature. Thanks in advance, - Tom
[web2py] Re: help please on adding jquery-ui theme to SQLFORM.grid
CSS files typically go in your app's /static/css folder, and you then have to make sure the CSS file gets linked in the page head (like any other CSS file). An easy way to include the CSS file is to do: response.files.append(URL('static', 'cs/your_theme_file.css')) in the controller action that needs the jquery-ui theme (or in your layout.html file if needed on most/all pages). Anthony On Sunday, November 13, 2011 9:45:45 PM UTC-5, tomt wrote: Hi, I'm looking for an example of how to install and use a jquery theme for SQLFORM.grid I see that I can implement jquery-ui by defining: form = SQLFORM.grid(query=db.table.field=='3',ui='jquery-ui') I see that I can download a theme from http://jqueryui.com/download but I don't know where to install it, or how to enable it. I searched the web2py group for examples, but I failed to find any. I'd appreciate it if someone could post a working example of this feature. Thanks in advance, - Tom
[web2py] Re: Help please on plugin_wiki on http://www.vimeo.com/13485916
Thanks, I appreciate the help. On Sep 26, 9:15 pm, rochacbruno rochacbr...@gmail.com wrote: You are using # but you have to use @ for the decorador class PluginWikiWidgets(PluginWikiWidgets): @staticmethod def blabla(a,b): return blabla Enviado via iPhone Em 26/09/2010, às 22:59, tom_tren...@yahoo.com tom_tren...@yahoo.com escreveu: Hi, I have been following the video athttp://www.vimeo.com/13485916 I'm impressed by the possibilities of this plugin and I was able to successfully run the examples localy, but I ran into a problem when trying to duplicate the tutorial's example of creating a new widget. I believe I copied the code correctly, but I receive the following error: Traceback (most recent call last): File /home/xa21/web2py/applications/mypwiki/models/plugin_wiki.py, line 584, in render_widget html = getattr(PluginWikiWidgets,name)(**args) TypeError: unbound method sayhi() must be called with PluginWikiWidgets instance as first argument (got nothing instead) I'm running version 1.85.3 of web2py on fedora linux, and my python version is 2.5.2 The following is the code I entered mypwiki/models/plugin_wiki_custom.py # coding: utf8 class PluginWikiWidgets(PluginWikiWidgets): #staticmethod def sayhi(message='Welcome'): This plugin just says hi return SPAN(message,auth.user.first_name) . ... Home # Example of custom widget `` name: sayhi message: Welcome ``:widget . I'm hoping someone can point out the source of my error. Thanks in advance, - Tom