f394d92981
- Use URL.create
...
- Stop testing for undocumented (now unavailable) dict-style access to rows
2023-02-25 23:35:44 -05:00
9fbf83baff
Package upgrades and SQLAlchemy 2.0 compatibility
2023-02-01 16:23:25 -08:00
86117c4b87
Merge pull request #206 from thedataincubator/parse-newlines
...
Avoid replacing newlines with spaces early in the query
2022-06-11 22:23:04 -05:00
59de1b6810
Merge pull request #213 from kianmeng/fix-typos
...
Fix typos
2022-06-11 14:56:42 -05:00
b3c4035900
Merge pull request #193 from bapowell/master
...
Use connect_str, so loading from DSN file actually works
2022-06-11 11:18:00 -05:00
df8f60cb42
Added test and acknowledgement
2022-06-11 10:56:52 -05:00
d856d915a2
Merge branch 'master' of https://github.com/meihkv/ipython-sql into meihkv-master
2022-06-11 10:34:55 -05:00
57f05a49bd
Merge branch 'master' of https://github.com/jsalbr/ipython-sql into jsalbr-master
2022-06-10 11:52:29 -05:00
faa26ee838
Merge branch 'master' of https://github.com/catherinedevlin/ipython-sql
2022-06-10 08:16:38 -05:00
bb64862303
Use ipython's own shell_expand
...
Fixes #194
2022-06-10 08:16:29 -05:00
82db653a3d
Fix typos
2022-06-02 22:43:47 +08:00
55d415f352
Avoid replacing newlines with spaces early in the query
...
The parser split off the first three elements of the cell, to check
if they have a connection string or push the result to a variable.
But if these elements weren't found, the components were glued back
together with spaces. If one of these components was a line comment,
it ends up commenting out more than it should.
This solution tries splitting off bits to see if they match the
expected form. But if they don't, it goes back to using the pre-
split string, thus preserving the original whitespace. This should
allow the connection string and redirect to appear after any number
of newline characters, as long as they are still the first non-
whitespace elements in the cell.
2022-01-25 18:27:29 -08:00
53323bfa7d
remove pop descriptor
2021-10-14 14:53:05 -04:00
c461e00bb4
Merge branch 'catherinedevlin:master' into master
2021-10-14 14:47:16 -04:00
63ff5ecf25
Merge branch 'master' into master
2021-07-07 11:46:20 -07:00
a684573e60
Actian Avalanche, Actian X, Ingres, Vector, and support
...
Added ingres to the list of databases that are autocommit.
Sorted _COMMIT_BLACKLIST_DIALECTS tuple alphabetically.
2021-06-22 08:49:39 -07:00
873893a387
Exclude bigquery dialect from autocommit
2021-05-26 17:03:19 -07:00
805e428423
fix issue 194
2021-05-02 16:20:46 +02:00
76cf5fc2b3
Use connect_str, so loading from DSN file actually works
2021-04-26 08:15:32 -05:00
e608279083
Added DatabaseError for MySQL
2021-04-23 08:18:43 +02:00
df087a8314
minor changes
2021-04-23 08:17:49 +02:00
ee7e209744
Merge pull request #179 from lebedov/enable-pgspecial-for-redshift
...
Enable use of PGSpecial for Redshift databases
2021-03-14 09:53:23 -04:00
8f771d16f9
Merge pull request #180 from WisdomWolf/master
...
Minor Fixes for dsn.ini
2021-03-14 09:44:26 -04:00
8453277c0e
update descriptor
2021-02-02 17:00:01 -05:00
7a6cd0c126
fix descriptor
2021-02-02 16:50:15 -05:00
7e02748536
add descriptor parsing
2021-02-02 16:42:38 -05:00
a6bf3e4855
add classmethod to _close
2021-02-02 10:09:51 -05:00
a2319fd866
Fix upstream issue 148
...
Fixes upstream https://github.com/catherinedevlin/ipython-sql/issues/148 by adding "vertica" to dialects with broken commit
2020-10-27 07:02:08 -04:00
0a5f9491a1
Fixes parsing config using bracketed section name
2020-09-25 14:47:12 -04:00
ae2b6755ef
Enable pgspecial for redshift databases.
2020-09-23 09:36:08 -04:00
b24ac6e941
Parse SQL comments in first line
2020-05-10 16:58:03 -04:00
2af7e344fb
applied black
2020-05-02 10:58:20 -04:00
ba21a75616
added test for --file not found
2020-05-02 10:54:04 -04:00
8829e17c18
--file working
2020-05-02 10:49:20 -04:00
4f243a18c8
Merge pull request #140 from vkk800/filesupport
...
Add support for running queries from files
2020-05-02 10:26:21 -04:00
3094ce783b
tests for multi-line {} substitution
2020-05-02 09:16:39 -04:00
4eb6044a05
Merge branch 'master' of https://github.com/catherinedevlin/ipython-sql
2020-05-02 09:04:26 -04:00
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
0e194ca9ab
added test for Lucas' bugfix
2020-05-02 08:28:38 -04:00
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
49bbce6cf9
Tied in new --append code with args
2020-05-02 08:22:09 -04:00
c5930ccc0c
Merge branch 'master' of https://github.com/catherinedevlin/ipython-sql
2020-05-02 08:14:29 -04:00
e7b5f842f1
preparing --append command
2020-05-02 08:14:25 -04:00
44559ce077
Merge pull request #160 from gbrault/master
...
added if_exists='append' to PERSIST
2020-05-02 08:12:27 -04:00
d6f4501b2b
Merge branch 'master' into master
2020-02-26 16:43:45 -07:00
c0f923a04b
Support complex JSON in connection args wrapped by string delimiters
2020-02-26 16:33:54 -07:00
25007d9245
Merge branch 'master' into master
2020-02-26 09:23:16 -07:00
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
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
0a0a93ffe4
add new line between line & cell sections of magic
2020-01-21 10:37:34 -05:00
Catherine Devlin