[Lift] Re: Howto re-initialize database

2009-04-08 Thread Tobias Daub

Thanks, that helped!

If I want to create some initial items in a table when lift is started 
first, where is a good point to do that?

I had a look a Boot.scala but couldn't find an entry point.

Tobias
 Right, sorry about that.

 On Apr 6, 10:01 am, Derek Chen-Becker dchenbec...@gmail.com wrote:
   
 Actually, Derby doesn't have an in-memory mode 
 (http://db.apache.org/derby/faq.html#in_memory), and saves the data to disk
 by default. The JDBC connection URL determines the directory that Derby
 saves stuff in. In the ToDo app I believe it's lift_example, which should
 be in your project root directory. You can just delete that directory and it
 wipes the DB.

 Derek



 On Mon, Apr 6, 2009 at 5:53 AM, TylerWeir tyler.w...@gmail.com wrote:

 
 The default setup uses Apache Derby[1], which is an in-memory db.
   
 You are free to use other DBs, most commonly used would be MySQL and
 PostgreSQL, although there are others.
 Take a look here,
 http://wiki.liftweb.net/index.php?title=Cheat_Sheet#Connection_String...
   
 [1]http://db.apache.org/derby/
   
 On Apr 6, 3:25 am, Tobias Daub hannes.flo...@gmx.li wrote:
   
 Hi Derek,
 
 This was something that confused me a bit, too. Which kind of database
 is Lift using? Its not mentioned at all in the tutorial, or?
 
 I just know it from Turbogears, that they had a tool that could play
 with the underlying database and do stuff like delete all tables and
 create new empty ones. With Grok its really easy to create a new empty
 database, too.
 
 I think this is really helpful for testing, because you dont have waste
 so much time with doing it manually.
 
 I just asked, because I thought maybe there's something similar to do so.
 
 thanks
 Tobias
 
 If you're talking about one of the archetypes (using Derby), just
 delete the Derby directory in your project root. Otherwise, you could
 look at the destroyTables_!! method on Schemifier. Could you give some
 more details?
   
 Derek
   
 On Sun, Apr 5, 2009 at 1:06 PM, Tobias Daub hannes.flo...@gmx.li
 mailto:hannes.flo...@gmx.li wrote:
   
 Hi There,
   
 How can I initialize the database again, e.g. to have all tables
   
 emtpy
   
 again?
   
 Do I have to modify Boot.scala?
   
 thanks
 Tobias
   
 
   


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Lift group.
To post to this group, send email to liftweb@googlegroups.com
To unsubscribe from this group, send email to 
liftweb+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/liftweb?hl=en
-~--~~~~--~~--~--~---



[Lift] Re: Howto re-initialize database

2009-04-06 Thread Tobias Daub

Hi Derek,

This was something that confused me a bit, too. Which kind of database 
is Lift using? Its not mentioned at all in the tutorial, or?

I just know it from Turbogears, that they had a tool that could play 
with the underlying database and do stuff like delete all tables and 
create new empty ones. With Grok its really easy to create a new empty 
database, too.

I think this is really helpful for testing, because you dont have waste 
so much time with doing it manually.

I just asked, because I thought maybe there's something similar to do so.

thanks
Tobias
 If you're talking about one of the archetypes (using Derby), just 
 delete the Derby directory in your project root. Otherwise, you could 
 look at the destroyTables_!! method on Schemifier. Could you give some 
 more details?

 Derek

 On Sun, Apr 5, 2009 at 1:06 PM, Tobias Daub hannes.flo...@gmx.li 
 mailto:hannes.flo...@gmx.li wrote:


 Hi There,

 How can I initialize the database again, e.g. to have all tables emtpy
 again?

 Do I have to modify Boot.scala?

 thanks
 Tobias




 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Lift group.
To post to this group, send email to liftweb@googlegroups.com
To unsubscribe from this group, send email to 
liftweb+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/liftweb?hl=en
-~--~~~~--~~--~--~---



[Lift] Re: Howto re-initialize database

2009-04-06 Thread TylerWeir

The default setup uses Apache Derby[1], which is an in-memory db.

You are free to use other DBs, most commonly used would be MySQL and
PostgreSQL, although there are others.
Take a look here, 
http://wiki.liftweb.net/index.php?title=Cheat_Sheet#Connection_String_Quickies

[1] http://db.apache.org/derby/


On Apr 6, 3:25 am, Tobias Daub hannes.flo...@gmx.li wrote:
 Hi Derek,

 This was something that confused me a bit, too. Which kind of database
 is Lift using? Its not mentioned at all in the tutorial, or?

 I just know it from Turbogears, that they had a tool that could play
 with the underlying database and do stuff like delete all tables and
 create new empty ones. With Grok its really easy to create a new empty
 database, too.

 I think this is really helpful for testing, because you dont have waste
 so much time with doing it manually.

 I just asked, because I thought maybe there's something similar to do so.

 thanks
 Tobias



  If you're talking about one of the archetypes (using Derby), just
  delete the Derby directory in your project root. Otherwise, you could
  look at the destroyTables_!! method on Schemifier. Could you give some
  more details?

  Derek

  On Sun, Apr 5, 2009 at 1:06 PM, Tobias Daub hannes.flo...@gmx.li
  mailto:hannes.flo...@gmx.li wrote:

      Hi There,

      How can I initialize the database again, e.g. to have all tables emtpy
      again?

      Do I have to modify Boot.scala?

      thanks
      Tobias
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Lift group.
To post to this group, send email to liftweb@googlegroups.com
To unsubscribe from this group, send email to 
liftweb+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/liftweb?hl=en
-~--~~~~--~~--~--~---



[Lift] Re: Howto re-initialize database

2009-04-06 Thread Derek Chen-Becker
Actually, Derby doesn't have an in-memory mode (
http://db.apache.org/derby/faq.html#in_memory), and saves the data to disk
by default. The JDBC connection URL determines the directory that Derby
saves stuff in. In the ToDo app I believe it's lift_example, which should
be in your project root directory. You can just delete that directory and it
wipes the DB.

Derek

On Mon, Apr 6, 2009 at 5:53 AM, TylerWeir tyler.w...@gmail.com wrote:


 The default setup uses Apache Derby[1], which is an in-memory db.

 You are free to use other DBs, most commonly used would be MySQL and
 PostgreSQL, although there are others.
 Take a look here,
 http://wiki.liftweb.net/index.php?title=Cheat_Sheet#Connection_String_Quickies

 [1] http://db.apache.org/derby/


 On Apr 6, 3:25 am, Tobias Daub hannes.flo...@gmx.li wrote:
  Hi Derek,
 
  This was something that confused me a bit, too. Which kind of database
  is Lift using? Its not mentioned at all in the tutorial, or?
 
  I just know it from Turbogears, that they had a tool that could play
  with the underlying database and do stuff like delete all tables and
  create new empty ones. With Grok its really easy to create a new empty
  database, too.
 
  I think this is really helpful for testing, because you dont have waste
  so much time with doing it manually.
 
  I just asked, because I thought maybe there's something similar to do so.
 
  thanks
  Tobias
 
 
 
   If you're talking about one of the archetypes (using Derby), just
   delete the Derby directory in your project root. Otherwise, you could
   look at the destroyTables_!! method on Schemifier. Could you give some
   more details?
 
   Derek
 
   On Sun, Apr 5, 2009 at 1:06 PM, Tobias Daub hannes.flo...@gmx.li
   mailto:hannes.flo...@gmx.li wrote:
 
   Hi There,
 
   How can I initialize the database again, e.g. to have all tables
 emtpy
   again?
 
   Do I have to modify Boot.scala?
 
   thanks
   Tobias
 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Lift group.
To post to this group, send email to liftweb@googlegroups.com
To unsubscribe from this group, send email to 
liftweb+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/liftweb?hl=en
-~--~~~~--~~--~--~---