Allow grid-based editing of the Users/ExpenseTypes

[GoogleCodeExporter]

Grid-based editing of Users/ExpenseTypes would be nice. During this process, we 
must search the database and modify all Expenses with that ExpenseType before 
making the database change. For example:

(1) create new User in database
(2) search database, replacing all instances of old user with new user
(3) remove old User from database

Original issue reported on code.google.com by Daniel.S...@gmail.com on 21 Sep 2010 at 11:12

[GoogleCodeExporter]

additionally, we should be able to completed delete a User/ExpenseType from the 
edit page... Again, this will require some work in the database to ensure that 
no Expense objects are referencing the removed value. The pattern would be:

(1) search database, replacing all instances of user/type with "null" or 
something safe.
(2) remove User/Type from database

Original comment by Daniel.S...@gmail.com on 26 Sep 2010 at 3:12

[GoogleCodeExporter]

Implemented - both User and ExpenseType tables can be edited from the 'edit 
page'. It turns out that you really only have to change the User or ExpenseType 
table, the corresponding Expense table handles itself.

One final update would be to add a 'short name' column to the User table - this 
is missing and currently there is no way to add after creation of a User object.

Original comment by Daniel.S...@gmail.com on 27 Sep 2010 at 12:05

[GoogleCodeExporter]

closed in version 1.1 

Original comment by Daniel.S...@gmail.com on 27 Sep 2010 at 2:26

• Changed state: Closed