Re: [web2py] Re: help please

2012-12-23 Thread Alan Etkin
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

2012-12-20 Thread Aurelijus
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

2012-12-19 Thread Aurelijus Useckas
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

2012-12-19 Thread Niphlod
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

2012-12-19 Thread Aurelijus Useckas
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

2012-12-19 Thread Niphlod
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

2012-12-19 Thread Aurelijus Useckas
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

2012-12-19 Thread Niphlod
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

2012-12-19 Thread Aurelijus
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

2012-12-19 Thread Niphlod
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

2012-12-19 Thread Aurelijus
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

2012-12-19 Thread Mark
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

2012-12-19 Thread Aurelijus
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

2012-12-19 Thread Paolo Caruccio
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

2012-12-19 Thread LightDot
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

2012-12-19 Thread Derek
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

2011-11-14 Thread tomt
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

2011-11-14 Thread Anthony
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

2011-11-13 Thread Anthony
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

2010-09-27 Thread tom_tren...@yahoo.com
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