witten
/
luminotes
Archived
1
0
Fork 0
Commit Graph

23 Commits

Author SHA1 Message Date
Dan Helfman b7789c6533 Fixed a bug in which certain new installations of Luminotes Desktop on Windows yielded an "uh oh" error on initial launch.
This was due to duplicate notebook timestamps within the sqlite
database, which meant that notebook_current included the placeholder
"next ids" along with the actual notebooks. The fix was to modify the
notebook_current view to filter out those placeholder ids.
2008-12-04 12:30:59 -08:00
Dan Helfman fc3849b8be HTML entities/characters like """ are now stripped from notebook names before turning them into friendly ids.
This means that blog posts now have better URLs if they the post titles contain HTML entities/characters.
2008-11-21 14:07:23 -08:00
Dan Helfman d3e040d984 Blog post URLs are now user-friendly and SEO-friendly. 2008-11-18 15:11:58 -08:00
Dan Helfman 6480b86574 Major SQL changes to support faster searching, plus changes to model.Note to support the new SQL. Unit tests all pass.
note_current is now a table containing the current versions of each note, rather than a view.
This makes the tsearch2 index much less bloated with duplicate information
2008-11-11 21:45:18 -08:00
Dan Helfman 8f4cdd662d Adding a database index to the session table. 2008-11-10 12:32:02 -08:00
Dan Helfman b8a7881b7a Adding a much-needed index to the session table. 2008-11-07 13:12:03 -08:00
Dan Helfman 58c8fdac00 Fixed an occasional bug that caused unexpected logouts by moving the session info into the database. No more write races. 2008-10-29 14:26:22 -07:00
Dan Helfman 388f2fcb02 Foundational work for both tags and discussion forums. Should have checked this in in smaller pieces. 2008-10-24 11:51:19 -07:00
Dan Helfman 9247683a72 Lots more work on the payment code necessary to support Luminotes Desktop. 2008-09-11 00:36:12 -07:00
Dan Helfman d38ca756a2 Added database schema changes to support user group-related tables, views, and indices. 2008-05-27 15:22:18 -07:00
Dan Helfman c6ab3b5da0 Fixed a database indexing bug that prevented notes with really long (~2700+
character) titles from saving correctly.

Changed the literal quotation character in the starting wiki note to the
""" character entity so it doesn't show up as a change in the diff.
2008-05-05 22:56:20 +00:00
Dan Helfman 16333c48ec Additional comments on upgrading. 2008-03-17 21:58:54 +00:00
Dan Helfman 94a51889f9 Added ability to reorder notebooks on the right side of the page.
Need to complete unit tests for controller.Notebooks.move_up() and move_down().
2008-03-15 03:04:59 +00:00
Dan Helfman bb89c42e60 * Wrote a database reaper script to delete unused notes, notebooks, etc.
* Added some database indices to improve select performance.
2008-03-04 20:01:59 +00:00
Dan Helfman 65ce915755 When saving a note, auto-delete any files that used to be linked from it but no longer are. Still need unit tests. 2008-02-22 19:47:28 +00:00
Dan Helfman b543121767 Now Content-Type header is saved upon upload and sent upon download. 2008-02-18 20:19:36 +00:00
Dan Helfman 731dc52623 More work on file uploading. Unit tests need to be fixed. 2008-02-18 20:08:07 +00:00
Dan Helfman 5520fe5892 * make a User_revision object containing a revision timestamp, user_id, username
* change controller.Notebooks.load_note_revisions() to select and return User_revision objects
 * change controller.Notebooks.save_note() to use User_revision objects for new_revision and previous_revision as well
 * update client to deal with new load_note_revisions() return values (make sure all uses of revisions_list are updated)
 * update client to deal with new new_revision/previous_revision
 * update changes pulldown to show username along with each timestamp
 * update model.Invite to load redeemed_username along with redeemed_user_id
 * display the redeemed username next to each email address in the "share this notebook" note
2008-01-04 04:45:43 +00:00
Dan Helfman a354eadcbb When saving a model.Notebook or model.Note to the database, set the user_id field based on the current user. 2008-01-01 01:44:54 +00:00
Dan Helfman 32fd09b3f7 * Implemented controller.Users.send_invites().
* Added some SQL indices to invite table.
2007-12-06 01:32:20 +00:00
Dan Helfman 274a87dee2 New model.Invite object for the invite table.
Renamed sent_user_id column to from_user_id, which makes a lot more sense.
2007-12-03 23:34:35 +00:00
Dan Helfman 82bf5bca29 Schema and model changes to support invitations and multiple user collaboration:
* added new database table of invited email addresses
 * altered user_notebook table to have a new owner boolean column, indicating whether the user has owner access to the notebook
 * altered notebook and note tables/views to have an additional user_id field to indicate the user that created that revision
 * updated model.Notebook and model.Note to support new user_id field
2007-12-01 01:08:16 +00:00
Dan Helfman cdd971780e Began work on notebook deletion and subsequent undo/undeletion.
Changed schema slightly to support this.
Added a schema delta file and wrote an UPGRADE doc with info on how to upgrade schemas.
2007-11-17 04:21:48 +00:00