bobf is sharing code with you

Bitbucket is a code hosting site. Unlimited public and private repositories. Free for small teams.

Don't show this again

bobf / SASqlConsole

SQLAlchemy-based interactive SQL prompt

Clone this repository (size: 106.8 KB): HTTPS / SSH
hg clone https://bitbucket.org/bobf/sasqlconsole
hg clone ssh://hg@bitbucket.org/bobf/sasqlconsole

Searching for commits

Mercurial supports a functional language for selecting a set of revisions.

The language supports a number of predicates which are joined by infix operators. Parenthesis can be used for grouping.

Identifiers such as branch names must be quoted with single or double quotes if they contain characters outside of [._a-zA-Z0-9\x80-\xff] or if they match one of the predefined predicates.

Prefix operators

not x
Changesets not in x. Short form is ! x.

Infix operators

x::y

A DAG range, meaning all changesets that are descendants of x and ancestors of y, including x and y themselves. If the first endpoint is left out, this is equivalent to ancestors(y), if the second is left out it is equivalent to descendants(x).

An alternative syntax is x..y.

x:y
All changesets with revision numbers between x and y, both inclusive. Either endpoint can be left out, they default to 0 and tip.
x and y
The intersection of changesets in x and y. Short form is x & y.
x or y
The union of changesets in x and y. There are two alternative short forms: x | y and x + y.
x - y
Changesets in x but not in y.

Predicates

all()
All changesets, the same as 0:tip.
ancestor(single, single)
Greatest common ancestor of the two changesets.
ancestors(set)
Changesets that are ancestors of a changeset in set.
author(string)
Alias for user(string).
bookmark([name])
The named bookmark or all bookmarks.
branch(set)
All changesets belonging to the branches of changesets in set.
children(set)
Child changesets of changesets in set.
closed()
Changeset is closed.
date(interval)
Changesets within the interval, see hg help dates.
descendants(set)
Changesets which are descendants of changesets in set.
file(pattern)
Changesets affecting files matched by pattern.
follow()
An alias for ::. (ancestors of the working copy's first parent).
grep(regex)
Like keyword(string) but accepts a regex. Use grep(r'...') to ensure special escape characters are handled correctly.
head()
Changeset is a named branch head.
heads(set)
Members of set with no children in set.
id(string)
Revision non-ambiguously specified by the given hex string prefix.
keyword(string)
Search commit message, user name, and names of changed files for string.
limit(set, n)
First n members of set.
max(set)
Changeset with highest revision number in set.
merge()
Changeset is a merge changeset.
min(set)
Changeset with lowest revision number in set.
p1([set])
First parent of changesets in set, or the working directory.
p2([set])
Second parent of changesets in set, or the working directory.
parents([set])
The set of all parents for all changesets in set, or the working directory.
present(set)
An empty set, if any revision in set isn't found; otherwise, all revisions in set.
rev(number)
Revision with the given numeric identifier.
roots(set)
Changesets with no parent changeset in set.
tag(name)
The specified tag by name, or all tagged revisions if no name is given.
user(string)
User name is string.

Commits 1–30 of 67

Author Revision Comments Message Labels Date
Clovis Fabricio 6c1743ee5681 Improved column coloring code to use itertools.cycle instead of reimplementing it
Clovis Fabricio 8c606dc759d0 Fixed writing of unicode return values to csv files, by encoding everything to the default encoding
Clovis Fabricio 02b92d9ae5da Fixed wrong .csv rowcount message when the underlining db returns -1 as rowcount
Clovis Fabricio cfbfdf9022ad Remove --no-color option parsing True/False dance.
bobf 26f7acad5ab9 catch 'commit;' as a command and special case it and call session.commit() - TODO need to make this deal with e.g. 'commit ;' etc.
bobf 89dc850e9b9e whitespace removal
bobf 5eaca6cee547 change from gpl to MIT. no idea why i thought gpl was a good idea for this
bobf b3b4bad19b2e merge
bobf 4e85f463befe fix missing ".next()" call in csv output method
nosklo 27c7f4f87929 Changed everything to unicode, created encoding configuration on rc file
Branch
issue3-unicode
nosklo bb2589842f84 Added format_exception message to format the exception in a compatible way
nosklo 74145c087550 merge upstream work
nosklo d68a094af5a4 removed column lowercasing because it was causing "WTF where is my column"
nosklo 794fe00f2e43 Added a connection to the local variables on the ".i" interactive mode,
bobf 2e1fefb13141 fix bug with csv export raising an exception if no rows found
bobf b13112a9d811 fix the column formatting to account for the spaces between columns, but a
Clovis Fabricio 30c4e7b3ad7b Added default url configuration as key "default" in the `aliases` dict on config:
Clovis Fabricio af2f8b1e9f4e Added config option for the query time information, `show_time` defaulting to True
Clovis Fabricio 4b6dbf0f0396 Query time information updated
Clovis Fabricio aec4a3ffd1c3 Using formatting tuple for consistency with the project style
Clovis Fabricio bf486783e9fc Fixed small typo on displaying timing information when query has no result table.
Clovis Fabricio fd4e969ffbd2 Changed query duration information so it shows up if the query takes more
Clovis Fabricio 65b169009470 merge from upstream
Clovis Fabricio 60cbcfd92bed When query takes more than 1 second, the query time is now shown before
Clovis Fabricio ecb42c6b2e1f * `Console.show_result()` should display a rowcount of 0, which is a valid
b...@rabbi 1190d3c2b10a Fix import of DBAPIError for older versions of sqlalchemy
b...@rabbi 4eb129bf7804 Fix checking readline imported okay before trying to use it
b...@rabbi 7956393271ef fix colours in .sc output so .sc with no args looks better
b...@rabbi ee84aa0a347b fix typo in docstring for Console.schema
b...@rabbi ba6b2020010c las3r added support for changing schema in postgres with .schema <foo> which
  1. 1
  2. 2
  3. 3
  4. »