Commit Graph

292 Commits (master)

Author SHA1 Message Date
Catherine 2af7e344fb applied black 2020-05-02 10:58:20 -04:00
Catherine ba21a75616 added test for --file not found 2020-05-02 10:54:04 -04:00
Catherine 8829e17c18 --file working 2020-05-02 10:49:20 -04:00
Catherine Devlin 4f243a18c8
Merge pull request #140 from vkk800/filesupport
Add support for running queries from files
2020-05-02 10:26:21 -04:00
Catherine 733e3de9ea cleanup rst docs 2020-05-02 10:07:14 -04:00
Catherine 3094ce783b tests for multi-line {} substitution 2020-05-02 09:16:39 -04:00
Catherine 4eb6044a05 Merge branch 'master' of https://github.com/catherinedevlin/ipython-sql 2020-05-02 09:04:26 -04:00
Catherine Devlin 0bc02a1fc3
Merge pull request #156 from Lucaszw/multiline-variable-support
support for variables in multi-line statements
2020-05-02 09:03:20 -04:00
Catherine 0e194ca9ab added test for Lucas' bugfix 2020-05-02 08:28:38 -04:00
Catherine Devlin bc7644ca27
Merge pull request #158 from Lucaszw/fix-missing-first-new-line
add new line between line & cell sections of magic
2020-05-02 08:24:52 -04:00
Catherine 49bbce6cf9 Tied in new --append code with args 2020-05-02 08:22:09 -04:00
Catherine c5930ccc0c Merge branch 'master' of https://github.com/catherinedevlin/ipython-sql 2020-05-02 08:14:29 -04:00
Catherine e7b5f842f1 preparing --append command 2020-05-02 08:14:25 -04:00
Catherine Devlin 44559ce077
Merge pull request #160 from gbrault/master
added if_exists='append' to PERSIST
2020-05-02 08:12:27 -04:00
Catherine acac2cd355 Merge branch 'Jmoore1127-master' 2020-03-16 23:22:03 -04:00
Catherine 55798cbdb5 credit JMoore1127 in README 2020-03-16 23:21:18 -04:00
Jared Moore 49d52f9085
Merge pull request #3 from kacecode/master
Support complex JSON in connection args wrapped by string delimiters
2020-02-26 16:44:03 -07:00
Jared Moore d6f4501b2b
Merge branch 'master' into master 2020-02-26 16:43:45 -07:00
Kacey Cole c0f923a04b Support complex JSON in connection args wrapped by string delimiters 2020-02-26 16:33:54 -07:00
Jared Moore 25007d9245
Merge branch 'master' into master 2020-02-26 09:23:16 -07:00
Jared Moore fd47e9e6a1
Merge pull request #2 from kacecode/master
Merge upstream (#1)
2020-02-26 09:18:27 -07:00
Kacey Cole 1838317085
Merge upstream (#1)
* Merge upstream and adjust connection args to ipython arg.

Upstream changed from custom body parsing to utilizing
ipython magic arguments. Removed extant connection args
parsing from sql.parse and added relevant flag and persistence
to sql.magic and sql.parse. Updated tests to reflect changes.

* Update README with connection arguments info

* Remove out of date tests

* Improve README on connection arguments
2020-02-26 01:32:03 -07:00
Gilbert Brault 856be231b8
added if_exists='append' to PERSIST
can use PERSIST now to add to an existing table
2020-01-30 12:51:25 +01:00
lucaszw 0a0a93ffe4 add new line between line & cell sections of magic 2020-01-21 10:37:34 -05:00
Lucas Zeer 37f19b46f2
Merge branch 'master' into multiline-variable-support 2020-01-20 11:26:26 -05:00
lucaszw b1a046bdf5 support for variables in multi-line statements 2020-01-20 11:16:52 -05:00
Catherine Devlin ad79dd7bbb
Merge pull request #150 from ponnou/add-athena-to-commit-blacklist-dialects
Added AWS Athena to the autocommit blacklist dialects
2020-01-20 10:11:38 -05:00
Catherine 9db062c205 Merge branch 'marketneutral-master' 2020-01-20 10:07:56 -05:00
Catherine 9b6d093741 credit for displaycon in NEWS 2020-01-20 10:06:38 -05:00
Catherine 0b8bf93b03 Merge branch 'master' of git://github.com/marketneutral/ipython-sql into marketneutral-master 2020-01-20 09:49:44 -05:00
Catherine d8027f2261 t push origin masterMerge branch 'pik-meta-commands' 2020-01-19 03:33:19 -05:00
Catherine 117764caf0 Merge branch 'meta-commands' of git://github.com/pik/ipython-sql into pik-meta-commands 2020-01-19 03:31:52 -05:00
Catherine c8d289ab7b Fixed failing test code (run_cell not runcode) 2020-01-09 20:53:26 -05:00
Jared Moore 581b22f8c4 cleanup testing import 2019-12-06 16:02:16 -07:00
Jared Moore 38e18db85e Merge pull request #1 from Jmoore1127/connect-args
Connect args
2019-12-06 14:59:53 -07:00
Jared Moore 5fa75c3e62 cleanup naming 2019-12-06 14:51:09 -07:00
Jared Moore 90baf45b97 update readme 2019-12-06 14:39:34 -07:00
Jared Moore 250922eb88 Enable passing connect_args to sqlalchemy
connect_args may be passed as a json object e.g.
%sql sqlite:// {"options": "-csearch_path=myschema"} SELECT * FROM work;

or as a local variable e.g.
my_args = {"options": "-csearch_path=myschema"}
%sql sqlite:// :my_args SELECT * FROM work;
2019-12-06 14:22:16 -07:00
Andre Ponnouradjane 62d226e478 add athena to the commit blacklist 2019-11-23 15:16:17 -08:00
Catherine Devlin ee4bc93598
Merge pull request #141 from zdog234/patch-1
Minor tweaks to README.rst sentence on HiveServer2
2019-10-24 22:23:13 -04:00
Catherine Devlin 07166c7681
Merge pull request #144 from casio/fix/pin-prettytable-dep
(actually :) Pin version of prettytable to allow poetry install
2019-10-24 22:22:43 -04:00
Catherine Devlin ee2010b26f
Merge pull request #147 from taisyun/version-specifier
Fixed wrong version specifier
2019-10-24 22:03:54 -04:00
Taishun Nakatani 416efe8c81 Fixed wrong version specifier
It failed when using 'pipenv install -r requirement.txt'

PEP-440
https://www.python.org/dev/peps/pep-0440/#version-specifiers
2019-07-25 19:31:07 +09:00
casio fb82110b2d (actually :) Pin version of prettytable to allow poetry install 2019-06-29 22:09:39 +02:00
Zane Dufour 458cfdc902
Minor tweaks to README.rst sentence on HiveServer2 2019-05-07 12:20:54 -04:00
Catherine Devlin f2bf804732
Merge pull request #136 from milesrichardson/patch-1
Pin version of prettytable to allow poetry install
2019-05-05 13:24:46 -04:00
Jonathan Larkin 5342d57bb5 FIX: Update README for list of SqlMagic options 2019-04-26 20:19:51 +00:00
Jonathan Larkin 7c66fdfa28 Update README for list of SqlMagic options 2019-04-26 20:17:00 +00:00
Jonathan Larkin cf948668c7 Add magic config SqlMagic.displaycon to supress printing of connection string 2019-04-26 20:11:50 +00:00
Ville Kauppila c9ccd9f24a Add support for runnin queries from files 2019-04-22 14:18:33 +03:00