Dan Helfman
96456efd76
Fixed a bug in which some printed or exported notes appeared in alphabetical order instead of your chosen ordering.
2009-06-14 21:45:08 -07:00
a580e1759d
Fixed a bug in which placeholder next ids in the note_current table weren't getting reaped.
2009-04-11 23:52:09 -07:00
4d00c92e3a
Changed the order of exported HTML and CSV notebooks so that after all the "startup" notes are included, the remaining notes are included in alphabetical order (instead of reverse chronological order).
2009-02-24 12:52:44 -08:00
a8af8b3fb3
Fixed several edge cases with re-ranking notes during a reorder. Now updating several notes' ranks on every reorder instead of making successively more precise fractional ranks.
2009-02-10 17:05:03 -08:00
fc502c6c82
Clarified the names of some of the notebook note-loading methods so that they are less confusing.
2009-02-02 13:41:09 -08:00
58d0450ff5
Including email address with user object so that it shows up properly in the settings panel.
2009-01-26 15:06:09 -08:00
a55934f948
Fixed a Luminotes Desktop bug in which creating and then clicking on a new note link sometimes caused a red error message.
...
This was due to a floating point rounding error in Luminotes that occured when loading note revisions from a SQLite database.
2008-12-12 23:36:29 -08:00
c07d315ffe
Replaced title button with font face button. Needs more work in IE. Also added more rounded corners to several display elements.
2008-12-10 23:21:44 -08:00
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
ca8ae5cd82
Rolling back the part of revision 1285 that made quota calculation just use note_current instead of note table.
...
It was intended to make quota storage calculation faster, which it did
do. However, it wasn't enough of an improvement (27 seconds down to 8
seconds for the query), so a different solution will be necessary.
2008-11-21 16:17:54 -08:00
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
3c11526480
Fixed a bug that prevented the autosaver from working on non-forum notebooks.
2008-11-20 17:39:20 -08:00
d3e040d984
Blog post URLs are now user-friendly and SEO-friendly.
2008-11-18 15:11:58 -08:00
4855ac0c7e
New note_count member on model.Notebook.
2008-11-17 23:42:29 -08:00
7185a9f8a3
Fixed a bug in which search result note summaries were not showing the portion of the note that matched the search term.
2008-11-14 12:30:03 -08:00
a6ca368e4c
Fixing typos within new SQL.
2008-11-11 22:01:57 -08:00
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
8f4cdd662d
Adding a database index to the session table.
2008-11-10 12:32:02 -08:00
b8a7881b7a
Adding a much-needed index to the session table.
2008-11-07 13:12:03 -08:00
c9ca87c544
Adding drop for session table.
2008-11-07 12:29:25 -08:00
1889bf8a23
model.User.sql_update_access() now able to take either bool read_write value or Notebook.READ_* value.
2008-11-04 12:22:44 -08:00
6708675fec
Factored out page navigation (pagination) code and made use of it on forum thread list page.
2008-10-31 15:17:59 -07:00
b368fa23b6
Fixed SQL statement bugs related to new Note.username member.
2008-10-31 11:43:53 -07:00
dccab45de3
The username of the author of a forum post now shows up in the UI.
2008-10-30 16:53:42 -07:00
b4a40d2c25
More work on the discussion forums.
2008-10-30 15:26:27 -07:00
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
3e51057d2d
Order forum threads in reverse chronological order by creation date.
2008-10-28 14:38:01 -07:00
4048240419
Fixed typo in table name. Added schema_version to dropped tables.
2008-10-28 14:03:21 -07:00
36af0bbfed
Propagating notebook tags to the UI code.
2008-10-24 15:07:36 -07:00
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
f2b88441ee
Leading/trailing spaces in note titles are now ignored when making links to such notes.
2008-09-28 14:48:22 -07:00
9247683a72
Lots more work on the payment code necessary to support Luminotes Desktop.
2008-09-11 00:36:12 -07:00
30283b0e29
More unit tests passing on Windows.
2008-08-21 14:22:20 -07:00
1c834af8df
Okay, just doing the datetime precision hack unconditionally on Windows.
2008-08-21 00:43:15 -07:00
0e2e665cca
Making float into int to stifle deprecation warning.
2008-08-21 00:35:05 -07:00
3fa1e8f8e6
Hack to work around poor timer precision on Windows. This bug prevented Persistent.update_revision() from working consistently.
2008-08-21 00:33:19 -07:00
410f6f8cbf
Added basic note searching for SQLite. Should really be using SQLite's full-text search instead.
...
In sql_load_notes, no longer adding offset clause if start = 0 since SQLite doesn't like offset without limit.
Switched from using "ilike" to "like" with lower(), since "ilike" is a PostgreSQL-specific extension.
Moved BACKEND flags from Database to Persistent to prevent need from circular imports (model files importing controller.Database).
2008-08-19 17:48:33 -07:00
85443e3849
Fixed another limit/offset ordering problem to make SQLite happy.
2008-08-19 14:45:13 -07:00
d0d0946788
Added backend parameter to sql_calculate_storage() for SQLite support. Also fixed bug in which salt could contain "\" character.
2008-08-19 14:21:59 -07:00
f6fbf724f3
quote() function now correctly handles bools as input such that SQLite gets a 't' or 'f' value as appropriate.
2008-08-18 18:07:08 -07:00
98042c5c3f
Fixed ordering of SQL offset/limit clauses to make SQLite happy.
2008-08-18 18:05:51 -07:00
9d4a33218f
Updated Database.py, initdb.py, and updatedb.py to support local SQLite database. Still need other changes in model/*.py though.
2008-08-15 17:27:03 -07:00
4b795ef722
Removed locale setting from model/schema.sql and put it in the INSTALL instructions instead.
2008-08-05 16:40:19 -07:00
1c44759ca5
Updated with missing DROP of group-related tables/views.
2008-08-03 13:57:03 -07:00
3fd3f23fe0
No longer stripping out puncutation when searching titles.
2008-06-30 02:09:14 -07:00
fe139cc749
First pass for suggest-as-you-type for linking.
2008-06-27 16:11:09 -07:00
599971ba01
When linking to a note by title, the note resolution is now
...
case-insensitive instead of case-sensitive.
2008-06-25 20:04:06 -07:00
Dan Helfman
a8a6070da0
Implemented controller.users.signup_group_member().
...
Modified UI code to call this method correctly and display results.
Split generic user signup functionality out into a separate private method.
2008-06-06 14:46:29 -07:00
Dan Helfman
0faa06ea10
Called controller.Users.calculate_group_storage() from various places. Fixed model.User.sql_calculate_group_storage().
2008-06-05 15:59:01 -07:00
Dan Helfman
f8efc2f178
Added a new group_storage_bytes member to model.User and some SQL to calculate it.
2008-06-04 19:46:08 -07:00
Dan Helfman
Dan Helfman