MojoFacets.git
13 years agoalways use binmode => ':utf8' with File::Slurp
Dobrica Pavlinusic [Tue, 22 Jun 2010 19:11:37 +0000 (21:11 +0200)]
always use binmode => ':utf8' with File::Slurp

13 years agouse binmode to load data in cp1250 encoding
Dobrica Pavlinusic [Tue, 22 Jun 2010 19:04:36 +0000 (21:04 +0200)]
use binmode to load data in cp1250 encoding

13 years agoshow subscript n for numeric columns
Dobrica Pavlinusic [Tue, 22 Jun 2010 19:00:22 +0000 (21:00 +0200)]
show subscript n for numeric columns

13 years agoadded export checkbox and timefmt for x axis
Dobrica Pavlinusic [Tue, 22 Jun 2010 18:32:08 +0000 (20:32 +0200)]
added export checkbox and timefmt for x axis

13 years agodon't use style on img#gnuplot
Dobrica Pavlinusic [Tue, 22 Jun 2010 18:12:47 +0000 (20:12 +0200)]
don't use style on img#gnuplot

13 years agodraw multiple columns on gnuplot
Dobrica Pavlinusic [Tue, 22 Jun 2010 17:37:18 +0000 (19:37 +0200)]
draw multiple columns on gnuplot

13 years agoshow png exports
Dobrica Pavlinusic [Tue, 22 Jun 2010 16:34:00 +0000 (18:34 +0200)]
show png exports

13 years agodraw gnuplot graph server-side
Dobrica Pavlinusic [Tue, 22 Jun 2010 16:05:25 +0000 (18:05 +0200)]
draw gnuplot graph server-side

13 years agocreate export of all data in tab-separated format
Dobrica Pavlinusic [Tue, 22 Jun 2010 15:29:47 +0000 (17:29 +0200)]
create export of all data in tab-separated format

13 years agodon't generate zero for null values
Dobrica Pavlinusic [Tue, 22 Jun 2010 15:01:47 +0000 (17:01 +0200)]
don't generate zero for null values

13 years agoreformat float using sprintf
Dobrica Pavlinusic [Tue, 22 Jun 2010 14:26:29 +0000 (16:26 +0200)]
reformat float using sprintf

13 years agoinvalidate changed columns on commit
Dobrica Pavlinusic [Tue, 22 Jun 2010 14:26:06 +0000 (16:26 +0200)]
invalidate changed columns on commit

13 years agodon't add duplicate columns on commit
Dobrica Pavlinusic [Tue, 22 Jun 2010 14:20:14 +0000 (16:20 +0200)]
don't add duplicate columns on commit

13 years agoconvert dd.mm.yyyy to yyyy-mm-dd
Dobrica Pavlinusic [Tue, 22 Jun 2010 14:15:16 +0000 (16:15 +0200)]
convert dd.mm.yyyy to yyyy-mm-dd

13 years agomodify multiple columns
Dobrica Pavlinusic [Tue, 22 Jun 2010 14:14:52 +0000 (16:14 +0200)]
modify multiple columns

13 years agosupport various $out values
Dobrica Pavlinusic [Tue, 22 Jun 2010 13:23:50 +0000 (15:23 +0200)]
support various $out values

This allows us to create datasets from scalars, arrays and hashes

13 years agoedit column depends
Dobrica Pavlinusic [Tue, 22 Jun 2010 12:39:41 +0000 (14:39 +0200)]
edit column depends

13 years agoextract changed columns from $update
Dobrica Pavlinusic [Tue, 22 Jun 2010 12:37:47 +0000 (14:37 +0200)]
extract changed columns from $update

13 years agonew syntax for row $update in test
Dobrica Pavlinusic [Tue, 22 Jun 2010 11:56:35 +0000 (13:56 +0200)]
new syntax for row $update in test

we now use $update instead of $row so we can cleanly track changed
columns changed

13 years agofixed type <tt> code errors
Dobrica Pavlinusic [Tue, 22 Jun 2010 11:43:25 +0000 (13:43 +0200)]
fixed type <tt> code errors

13 years agosimple CSV file import
Dobrica Pavlinusic [Tue, 22 Jun 2010 11:29:27 +0000 (13:29 +0200)]
simple CSV file import

13 years agoshow dependent or all code snippets button
Dobrica Pavlinusic [Mon, 21 Jun 2010 12:40:36 +0000 (14:40 +0200)]
show dependent or all code snippets button

13 years agoredirect to /data/index if path doesn't exist
Dobrica Pavlinusic [Mon, 21 Jun 2010 12:28:57 +0000 (14:28 +0200)]
redirect to /data/index if path doesn't exist

13 years agostart google chrome with Speed Tracer and app support
Dobrica Pavlinusic [Mon, 21 Jun 2010 12:06:26 +0000 (14:06 +0200)]
start google chrome with Speed Tracer and app support

13 years agoMerge branch 'cols_changed-exact'
Dobrica Pavlinusic [Sun, 20 Jun 2010 17:47:28 +0000 (19:47 +0200)]
Merge branch 'cols_changed-exact'

13 years agorefresh items if $out is generated cols_changed-exact
Dobrica Pavlinusic [Sun, 20 Jun 2010 17:46:52 +0000 (19:46 +0200)]
refresh items if $out is generated

by reload /data/items after new dataset is created

13 years agoshow scrollbar for console bigger than 2/3
Dobrica Pavlinusic [Sun, 20 Jun 2010 17:03:14 +0000 (19:03 +0200)]
show scrollbar for console bigger than 2/3

13 years agohide code depends and description
Dobrica Pavlinusic [Sun, 20 Jun 2010 16:59:12 +0000 (18:59 +0200)]
hide code depends and description

make textarea full width

13 years agocomment out $cols_changed dump
Dobrica Pavlinusic [Sun, 20 Jun 2010 16:55:51 +0000 (18:55 +0200)]
comment out $cols_changed dump

13 years agoMerge branch 'cols_changed-exact'
Dobrica Pavlinusic [Sun, 20 Jun 2010 16:53:52 +0000 (18:53 +0200)]
Merge branch 'cols_changed-exact'

13 years agoremove between facet value and white ; delimiter
Dobrica Pavlinusic [Sun, 20 Jun 2010 16:53:08 +0000 (18:53 +0200)]
remove between facet value and white ; delimiter

13 years agocalculate new columns from stats on commit
Dobrica Pavlinusic [Sun, 20 Jun 2010 16:49:48 +0000 (18:49 +0200)]
calculate new columns from stats on commit

13 years agoMerge branch 'cols_changed-exact'
Dobrica Pavlinusic [Sun, 20 Jun 2010 12:05:53 +0000 (14:05 +0200)]
Merge branch 'cols_changed-exact'

13 years agoanother $col_changed cleanup
Dobrica Pavlinusic [Sun, 20 Jun 2010 12:04:31 +0000 (14:04 +0200)]
another $col_changed cleanup

0 denotes used column (extracted from source using regex),
while positive numbers denote added columns.
This allow allow us to color used and created columns differently

13 years agoread code from disk in utf-8 encoding
Dobrica Pavlinusic [Sun, 20 Jun 2010 11:35:38 +0000 (13:35 +0200)]
read code from disk in utf-8 encoding

13 years agodump code with utf8 encoding
Dobrica Pavlinusic [Sun, 20 Jun 2010 11:29:44 +0000 (13:29 +0200)]
dump code with utf8 encoding

13 years agotrack exact $cols_changed
Dobrica Pavlinusic [Sun, 20 Jun 2010 11:15:28 +0000 (13:15 +0200)]
track exact $cols_changed

First we parse query to find accessed columns (this is error prone), and
after each eval, we check to find all produced columns.

13 years agosort files my mtime
Dobrica Pavlinusic [Sat, 19 Jun 2010 20:18:06 +0000 (22:18 +0200)]
sort files my mtime

13 years agopreserve column order in depends and description
Dobrica Pavlinusic [Sat, 19 Jun 2010 19:29:22 +0000 (21:29 +0200)]
preserve column order in depends and description

13 years agoexample to produce new dataset from test.js
Dobrica Pavlinusic [Sat, 19 Jun 2010 18:58:47 +0000 (20:58 +0200)]
example to produce new dataset from test.js

13 years agofix sorting for undef values
Dobrica Pavlinusic [Sat, 19 Jun 2010 17:04:13 +0000 (19:04 +0200)]
fix sorting for undef values

13 years agoreport number of items returned from sort
Dobrica Pavlinusic [Sat, 19 Jun 2010 16:41:21 +0000 (18:41 +0200)]
report number of items returned from sort

13 years agocleanup all_filters name generation
Dobrica Pavlinusic [Sat, 19 Jun 2010 16:33:09 +0000 (18:33 +0200)]
cleanup all_filters name generation

13 years agoshow unique symbol in table view
Dobrica Pavlinusic [Sat, 19 Jun 2010 16:13:17 +0000 (18:13 +0200)]
show unique symbol in table view

13 years agofix markup for unique span
Dobrica Pavlinusic [Sat, 19 Jun 2010 16:12:16 +0000 (18:12 +0200)]
fix markup for unique span

13 years agocommit $out changes into new dataset
Dobrica Pavlinusic [Sat, 19 Jun 2010 16:00:00 +0000 (18:00 +0200)]
commit $out changes into new dataset

This is quite a big deal: it allows us to create new datasets from
results of code eval into $out variable. You can think of it as
group by on steroids, since you create reports with a bit of perl

13 years agocontroll overflow of $out and show scroll bar
Dobrica Pavlinusic [Sat, 19 Jun 2010 14:07:41 +0000 (16:07 +0200)]
controll overflow of $out and show scroll bar

13 years agoshow all applicable code snippets
Dobrica Pavlinusic [Sat, 19 Jun 2010 13:30:02 +0000 (15:30 +0200)]
show all applicable code snippets

This required us to check if current dataset (using columns) has all
applicable columns for given dataset

13 years agoinsert white semicolumn to improve copy/paste
Dobrica Pavlinusic [Sat, 19 Jun 2010 13:12:33 +0000 (15:12 +0200)]
insert white semicolumn to improve copy/paste

This allows us to copy/paste into gnumeric and split data on ; to get
two columns, one with value and another with numeric count

13 years agoreduce using $out in code
Dobrica Pavlinusic [Sat, 19 Jun 2010 12:21:43 +0000 (14:21 +0200)]
reduce using $out in code

This allows us to generate various summaries over all rows on screen.

13 years agoupgrade old values in changes to array
Dobrica Pavlinusic [Sat, 19 Jun 2010 11:42:33 +0000 (13:42 +0200)]
upgrade old values in changes to array

13 years agotoggle show/hide on console click
Dobrica Pavlinusic [Fri, 18 Jun 2010 22:09:37 +0000 (00:09 +0200)]
toggle show/hide on console click

13 years agotweak columns acquision order
Dobrica Pavlinusic [Fri, 18 Jun 2010 22:02:11 +0000 (00:02 +0200)]
tweak columns acquision order

This allows us again just to reload table data after we restart server,
since we don't require columns (which isn't saved until user selects
save for the first time) but headers which is there.
However, if we do have columns in session, we'll use that (which is
required for code eval to add new columns).

13 years agoextract meters from text data
Dobrica Pavlinusic [Fri, 18 Jun 2010 21:29:12 +0000 (23:29 +0200)]
extract meters from text data

13 years agoexample for in-place update
Dobrica Pavlinusic [Fri, 18 Jun 2010 20:24:07 +0000 (22:24 +0200)]
example for in-place update

13 years agoself-modifing code depends on modified columns
Dobrica Pavlinusic [Fri, 18 Jun 2010 20:23:03 +0000 (22:23 +0200)]
self-modifing code depends on modified columns

13 years agotwo code samples for pftf dataset
Dobrica Pavlinusic [Fri, 18 Jun 2010 20:15:41 +0000 (22:15 +0200)]
two code samples for pftf dataset

13 years agocleanup code depends and description generation
Dobrica Pavlinusic [Fri, 18 Jun 2010 19:56:37 +0000 (21:56 +0200)]
cleanup code depends and description generation

13 years agoadded console link
Dobrica Pavlinusic [Fri, 18 Jun 2010 19:48:14 +0000 (21:48 +0200)]
added console link

13 years agoquote column names in regexps
Dobrica Pavlinusic [Fri, 18 Jun 2010 18:27:57 +0000 (20:27 +0200)]
quote column names in regexps

13 years agoadded overwrite checkbox to code console
Dobrica Pavlinusic [Fri, 18 Jun 2010 18:19:44 +0000 (20:19 +0200)]
added overwrite checkbox to code console

Newly generated code will always be saved, but modifications won't
witout user explicitly clicking on checkbox or renaming description.

13 years agoload code depends and description
Dobrica Pavlinusic [Fri, 18 Jun 2010 17:58:44 +0000 (19:58 +0200)]
load code depends and description

13 years agosave commited code snippets
Dobrica Pavlinusic [Fri, 18 Jun 2010 17:30:22 +0000 (19:30 +0200)]
save commited code snippets

Dependent columns (part before the dot) is calculated automatically.
If there are newly created columns, they are suggested as description.

13 years agodump all log to /tmp/mojo_facets.log for debug
Dobrica Pavlinusic [Fri, 18 Jun 2010 17:29:44 +0000 (19:29 +0200)]
dump all log to /tmp/mojo_facets.log for debug

13 years agounload datasets from memory
Dobrica Pavlinusic [Fri, 18 Jun 2010 17:03:45 +0000 (19:03 +0200)]
unload datasets from memory

if checkbox m(emory) is unchecked on load screen

13 years agohide scrollbar in textarea
Dobrica Pavlinusic [Fri, 18 Jun 2010 16:30:00 +0000 (18:30 +0200)]
hide scrollbar in textarea

13 years agowe need filters for columns, not header
Dobrica Pavlinusic [Fri, 18 Jun 2010 16:16:29 +0000 (18:16 +0200)]
we need filters for columns, not header

header is filled just once from source file, while columns is updated
with columns added from code

13 years ago_data_items is unused
Dobrica Pavlinusic [Fri, 18 Jun 2010 16:14:17 +0000 (18:14 +0200)]
_data_items is unused

13 years agohide ignored files
Dobrica Pavlinusic [Fri, 18 Jun 2010 16:07:34 +0000 (18:07 +0200)]
hide ignored files

13 years agohide changes
Dobrica Pavlinusic [Fri, 18 Jun 2010 16:07:17 +0000 (18:07 +0200)]
hide changes

13 years agodump filters
Dobrica Pavlinusic [Fri, 18 Jun 2010 16:06:04 +0000 (18:06 +0200)]
dump filters

13 years agomark all columns used in code
Dobrica Pavlinusic [Fri, 18 Jun 2010 15:54:00 +0000 (17:54 +0200)]
mark all columns used in code

13 years agohighlight added columns with changed class
Dobrica Pavlinusic [Fri, 18 Jun 2010 15:33:28 +0000 (17:33 +0200)]
highlight added columns with changed class

13 years agowe need session columns to show applicable code
Dobrica Pavlinusic [Fri, 18 Jun 2010 12:38:04 +0000 (14:38 +0200)]
we need session columns to show applicable code

13 years agofix filter creation
Dobrica Pavlinusic [Fri, 18 Jun 2010 09:10:31 +0000 (11:10 +0200)]
fix filter creation

re-use of $i is just plain wrong, braking filters

13 years agohide code console after commit
Dobrica Pavlinusic [Fri, 18 Jun 2010 08:04:55 +0000 (10:04 +0200)]
hide code console after commit

13 years agoorder column must exist
Dobrica Pavlinusic [Fri, 18 Jun 2010 07:54:08 +0000 (09:54 +0200)]
order column must exist

If it doesn't we reset it to first columns because without it we
don't get any rows displayed

13 years agoMerge branch 'master' of git.rot13.org:/git/mojo_facets
Dobrica Pavlinusic [Thu, 17 Jun 2010 19:43:56 +0000 (21:43 +0200)]
Merge branch 'master' of git.rot13.org:/git/mojo_facets

13 years agoupgrade scalar values to arrays
Dobrica Pavlinusic [Thu, 17 Jun 2010 19:41:57 +0000 (21:41 +0200)]
upgrade scalar values to arrays

This usally happens when you write eval code wrong, like in

$row->{something} = 1;

istead of

$row->{something} = [ 1 ];

This is probably wrong place for this, but it makes simple mistake less
fatal.

13 years agodon't insert newlines in code textarea
Dobrica Pavlinusic [Thu, 17 Jun 2010 19:41:40 +0000 (21:41 +0200)]
don't insert newlines in code textarea

13 years agoadded reload original link, hide commit on errors
Dobrica Pavlinusic [Thu, 17 Jun 2010 19:09:10 +0000 (21:09 +0200)]
added reload original link, hide commit on errors

13 years agochange left-over $rec to $row
Dobrica Pavlinusic [Thu, 17 Jun 2010 18:56:47 +0000 (20:56 +0200)]
change left-over $rec to $row

13 years agobutton to close code console
Dobrica Pavlinusic [Thu, 17 Jun 2010 18:56:31 +0000 (20:56 +0200)]
button to close code console

13 years agodon't include code console if there is no code
Dobrica Pavlinusic [Thu, 17 Jun 2010 18:15:58 +0000 (20:15 +0200)]
don't include code console if there is no code

13 years agoload and test code snippets
Dobrica Pavlinusic [Thu, 17 Jun 2010 18:08:07 +0000 (20:08 +0200)]
load and test code snippets

13 years agobrowse code on disk at /code/
Dobrica Pavlinusic [Thu, 17 Jun 2010 17:42:08 +0000 (19:42 +0200)]
browse code on disk at /code/

13 years agoadded code examples
Dobrica Pavlinusic [Thu, 17 Jun 2010 17:15:33 +0000 (19:15 +0200)]
added code examples

13 years agobetter count example
Dobrica Pavlinusic [Thu, 17 Jun 2010 16:54:35 +0000 (18:54 +0200)]
better count example

13 years agoMerge branch 'eval-code'
Dobrica Pavlinusic [Thu, 17 Jun 2010 16:46:26 +0000 (18:46 +0200)]
Merge branch 'eval-code'

13 years agoelement in code eval is now called $row eval-code
Dobrica Pavlinusic [Thu, 17 Jun 2010 16:44:13 +0000 (18:44 +0200)]
element in code eval is now called $row

This is much better name than $rec, especially when you try to
read code example or explain it to someone :-)

13 years agoconvert action filename back to REST url
Dobrica Pavlinusic [Thu, 17 Jun 2010 16:43:51 +0000 (18:43 +0200)]
convert action filename back to REST url

13 years agomodify existing column example
Dobrica Pavlinusic [Thu, 17 Jun 2010 14:47:28 +0000 (16:47 +0200)]
modify existing column example

13 years agorebuild stats when new columns are added
Dobrica Pavlinusic [Thu, 17 Jun 2010 14:39:55 +0000 (16:39 +0200)]
rebuild stats when new columns are added

13 years agoMerge branch 'master' into eval-code
Dobrica Pavlinusic [Thu, 17 Jun 2010 14:27:51 +0000 (16:27 +0200)]
Merge branch 'master' into eval-code

13 years agodon't redirect to /data/index needlessly
Dobrica Pavlinusic [Thu, 17 Jun 2010 14:26:30 +0000 (16:26 +0200)]
don't redirect to /data/index needlessly

This allow us to restart server and just load needed data on demand with
reload as opposed to first selecting active dataset and rest of the
stuff which we allready have in session.

13 years agofix warning for datasets without modifications
Dobrica Pavlinusic [Thu, 17 Jun 2010 14:18:45 +0000 (16:18 +0200)]
fix warning for datasets without modifications

13 years agostore new columns in $loaded
Dobrica Pavlinusic [Thu, 17 Jun 2010 14:00:57 +0000 (16:00 +0200)]
store new columns in $loaded

This allows sorting to do the right thing (e.g. work)

13 years agofind columns used in code snippet and show them to user
Dobrica Pavlinusic [Thu, 17 Jun 2010 12:53:05 +0000 (14:53 +0200)]
find columns used in code snippet and show them to user

13 years agoadded two examples of perl code to eval on data
Dobrica Pavlinusic [Thu, 17 Jun 2010 12:48:44 +0000 (14:48 +0200)]
added two examples of perl code to eval on data

13 years agodefault code is nothing
Dobrica Pavlinusic [Wed, 16 Jun 2010 22:08:04 +0000 (00:08 +0200)]
default code is nothing