]> git.phdru.name Git - sqlconvert.git/log
sqlconvert.git
8 years agoMake process_statement() a generator
Oleg Broytman [Wed, 28 Sep 2016 23:47:30 +0000 (02:47 +0300)]
Make process_statement() a generator

Prepare for process_statement() to yield a list of statements:
extended INSERT will be split into a list of plain INSERTs.

8 years agoClean up StatementGrouper on close
Oleg Broytman [Wed, 28 Sep 2016 23:38:55 +0000 (02:38 +0300)]
Clean up StatementGrouper on close

8 years agoUse `return` instead `raise StopIteration`
Oleg Broytman [Wed, 28 Sep 2016 23:38:03 +0000 (02:38 +0300)]
Use `return` instead `raise StopIteration`

8 years agoIgnore coverage data and reports
Oleg Broytman [Wed, 28 Sep 2016 16:58:29 +0000 (19:58 +0300)]
Ignore coverage data and reports

8 years agoExtend demo.sql: add extended INSERTs with and w/o columns list
Oleg Broytman [Wed, 28 Sep 2016 16:06:58 +0000 (19:06 +0300)]
Extend demo.sql: add extended INSERTs with and w/o columns list

8 years agoDone: convert string escapes
Oleg Broytman [Tue, 27 Sep 2016 19:50:27 +0000 (22:50 +0300)]
Done: convert string escapes

8 years agoVersion 0.0.7: Change quoting style to MySQL, PostgreSQL or SQLite 0.0.7
Oleg Broytman [Mon, 26 Sep 2016 22:00:43 +0000 (01:00 +0300)]
Version 0.0.7: Change quoting style to MySQL, PostgreSQL or SQLite

8 years agoUse test coverage in tox.ini
Oleg Broytman [Mon, 26 Sep 2016 21:57:33 +0000 (00:57 +0300)]
Use test coverage in tox.ini

8 years agoAdd a test for print_tokens()
Oleg Broytman [Mon, 26 Sep 2016 21:54:23 +0000 (00:54 +0300)]
Add a test for print_tokens()

8 years agoRename test_tokens.py -> test_process_tokens.py
Oleg Broytman [Mon, 26 Sep 2016 21:53:28 +0000 (00:53 +0300)]
Rename test_tokens.py -> test_process_tokens.py

Merge test_stgrouper.py into test_process_tokens.py.

8 years agoFix a bug: assign buffer even if encoding is None
Oleg Broytman [Mon, 26 Sep 2016 21:50:29 +0000 (00:50 +0300)]
Fix a bug: assign buffer even if encoding is None

8 years agoChange quoting style to MySQL, PostgreSQL or SQLite
Oleg Broytman [Mon, 26 Sep 2016 21:32:48 +0000 (00:32 +0300)]
Change quoting style to MySQL, PostgreSQL or SQLite

8 years agoVersion 0.0.6: string (un)escaping, tests with Pg/SQLite 0.0.6
Oleg Broytman [Sun, 25 Sep 2016 15:36:36 +0000 (18:36 +0300)]
Version 0.0.6: string (un)escaping, tests with Pg/SQLite

8 years agoUpdate docs
Oleg Broytman [Sun, 25 Sep 2016 15:28:52 +0000 (18:28 +0300)]
Update docs

8 years agoAdd tests for SQLite
Oleg Broytman [Sun, 25 Sep 2016 15:25:49 +0000 (18:25 +0300)]
Add tests for SQLite

8 years agoUse SQLObject for string quoting
Oleg Broytman [Sun, 25 Sep 2016 15:14:47 +0000 (18:14 +0300)]
Use SQLObject for string quoting

8 years agoUnescape all known escapes
Oleg Broytman [Sun, 25 Sep 2016 14:46:50 +0000 (17:46 +0300)]
Unescape all known escapes

8 years agoDo not test statements in StatementGrouper
Oleg Broytman [Sun, 25 Sep 2016 01:36:23 +0000 (04:36 +0300)]
Do not test statements in StatementGrouper

StatementGrouper simply raises StopIteration if there are no statements.

8 years agoDo not clean up: rm doesn't work
Oleg Broytman [Sun, 25 Sep 2016 01:18:12 +0000 (04:18 +0300)]
Do not clean up: rm doesn't work

Well, it works but only in the virtual environment
while we need to clean up the root directory.

8 years agoGlobally skip a module that requires Postgres connection
Oleg Broytman [Sun, 25 Sep 2016 01:13:18 +0000 (04:13 +0300)]
Globally skip a module that requires Postgres connection

8 years agoExclude tests/conftest.py from flake8 tests with directive
Oleg Broytman [Sun, 25 Sep 2016 01:02:12 +0000 (04:02 +0300)]
Exclude tests/conftest.py from flake8 tests with directive

8 years agoRun flake8 from root to test docs and scripts
Oleg Broytman [Sat, 24 Sep 2016 23:19:37 +0000 (02:19 +0300)]
Run flake8 from root to test docs and scripts

Exclude .tox virtual environments.

8 years agoAdd a test for unescaped strings for Postgres
Oleg Broytman [Sat, 24 Sep 2016 20:23:35 +0000 (23:23 +0300)]
Add a test for unescaped strings for Postgres

Use SQLObject for testing.

8 years agoRemove unused py.test
Oleg Broytman [Sat, 24 Sep 2016 05:01:20 +0000 (08:01 +0300)]
Remove unused py.test

8 years agoSimplify tox.ini: call pytest with the current python
Oleg Broytman [Sat, 24 Sep 2016 00:01:38 +0000 (03:01 +0300)]
Simplify tox.ini: call pytest with the current python

8 years agoFix copy/paste in .gitignore
Oleg Broytman [Fri, 23 Sep 2016 23:58:20 +0000 (02:58 +0300)]
Fix copy/paste in .gitignore

8 years agoExtend .gitignore
Oleg Broytman [Fri, 23 Sep 2016 22:46:48 +0000 (01:46 +0300)]
Extend .gitignore

8 years agoMinor refactoring of MANIFEST.in
Oleg Broytman [Fri, 23 Sep 2016 22:41:23 +0000 (01:41 +0300)]
Minor refactoring of MANIFEST.in

8 years agoIgnore .cache and .tox directories only at the top
Oleg Broytman [Wed, 21 Sep 2016 22:34:42 +0000 (01:34 +0300)]
Ignore .cache and .tox directories only at the top

8 years agoUse coverage and tox for testing
Oleg Broytman [Tue, 20 Sep 2016 23:45:58 +0000 (02:45 +0300)]
Use coverage and tox for testing

8 years agoFix scripts in setup.py
Oleg Broytman [Tue, 20 Sep 2016 23:44:06 +0000 (02:44 +0300)]
Fix scripts in setup.py

8 years agoAdd test for converting \' to ''
Oleg Broytman [Sat, 17 Sep 2016 16:00:52 +0000 (19:00 +0300)]
Add test for converting \' to ''

8 years agoRemove classes from tests
Oleg Broytman [Sat, 17 Sep 2016 15:56:35 +0000 (18:56 +0300)]
Remove classes from tests

Remove leftovers from unittest, completely switch to pytest.

8 years agoRemove mysql-specific requote_names from StatementGrouper's test
Oleg Broytman [Sat, 17 Sep 2016 15:53:41 +0000 (18:53 +0300)]
Remove mysql-specific requote_names from StatementGrouper's test

8 years agoUse pytest for testing
Oleg Broytman [Sun, 11 Sep 2016 18:37:36 +0000 (21:37 +0300)]
Use pytest for testing

8 years agoFix misspelling: mysq2sql -> mysql2sql
Oleg Broytman [Sun, 11 Sep 2016 17:16:18 +0000 (20:16 +0300)]
Fix misspelling: mysq2sql -> mysql2sql

8 years agoFix minor misspellings in docs
Oleg Broytman [Sun, 11 Sep 2016 17:16:18 +0000 (20:16 +0300)]
Fix minor misspellings in docs

8 years agoAdd README.html for gitweb
Oleg Broytman [Sun, 11 Sep 2016 17:05:51 +0000 (20:05 +0300)]
Add README.html for gitweb

8 years agoTODO: Add tests for Postgres and SQLite
Oleg Broytman [Sat, 10 Sep 2016 17:49:05 +0000 (20:49 +0300)]
TODO: Add tests for Postgres and SQLite

8 years agoUnescape strings
Oleg Broytman [Sat, 10 Sep 2016 17:35:02 +0000 (20:35 +0300)]
Unescape strings

8 years agoRename remove_directives -> remove_directive_tokens
Oleg Broytman [Sat, 10 Sep 2016 17:05:22 +0000 (20:05 +0300)]
Rename remove_directives -> remove_directive_tokens

8 years agoCondense a sequence of newlines after a /*! directive */;
Oleg Broytman [Thu, 8 Sep 2016 22:37:06 +0000 (01:37 +0300)]
Condense a sequence of newlines after a /*! directive */;

8 years agoDeclare development status Pre-Alpha
Oleg Broytman [Thu, 8 Sep 2016 14:59:49 +0000 (17:59 +0300)]
Declare development status Pre-Alpha

8 years agoVersion 0.0.5: Remove /*! directives */; and newlines after them 0.0.5
Oleg Broytman [Wed, 7 Sep 2016 19:57:00 +0000 (22:57 +0300)]
Version 0.0.5: Remove /*! directives */; and newlines after them

8 years agoFix flake8 warning: remove unused import
Oleg Broytman [Wed, 7 Sep 2016 19:52:11 +0000 (22:52 +0300)]
Fix flake8 warning: remove unused import

8 years agoSkip semicolons and newlines /*! directives */;
Oleg Broytman [Wed, 7 Sep 2016 19:26:13 +0000 (22:26 +0300)]
Skip semicolons and newlines /*! directives */;

8 years agoFix: flush buffer and outfile
Oleg Broytman [Wed, 7 Sep 2016 19:48:38 +0000 (22:48 +0300)]
Fix: flush buffer and outfile

8 years agoMake begin/end separators in demo scripts more evident
Oleg Broytman [Wed, 7 Sep 2016 19:24:32 +0000 (22:24 +0300)]
Make begin/end separators in demo scripts more evident

8 years agoAdd demo-process.py
Oleg Broytman [Mon, 5 Sep 2016 21:29:33 +0000 (00:29 +0300)]
Add demo-process.py

8 years agoJoin demo scripts; add argparse parameters parsing
Oleg Broytman [Mon, 5 Sep 2016 20:57:41 +0000 (23:57 +0300)]
Join demo scripts; add argparse parameters parsing

Join group-{file,sql}.py into demo-group.py
     parse-{file,sql}.py into demo-parse.py.

8 years agoRemove processing from demo scripts
Oleg Broytman [Mon, 5 Sep 2016 20:17:42 +0000 (23:17 +0300)]
Remove processing from demo scripts

8 years agoAdd a semicolon and a newline after directive
Oleg Broytman [Mon, 5 Sep 2016 19:18:29 +0000 (22:18 +0300)]
Add a semicolon and a newline after directive

8 years agoRename sample.sql -> demo.sql
Oleg Broytman [Mon, 5 Sep 2016 19:16:25 +0000 (22:16 +0300)]
Rename sample.sql -> demo.sql

8 years agoSet encoding to utf-8 for demo scripts
Oleg Broytman [Mon, 5 Sep 2016 19:15:38 +0000 (22:15 +0300)]
Set encoding to utf-8 for demo scripts

8 years agoTODO: Fix semicolons and newlines after /*! directives */
Oleg Broytman [Sun, 4 Sep 2016 19:13:46 +0000 (22:13 +0300)]
TODO: Fix semicolons and newlines after /*! directives */

8 years agoTODO: Remove /*! directives */ - done!
Oleg Broytman [Sun, 4 Sep 2016 14:54:43 +0000 (17:54 +0300)]
TODO: Remove /*! directives */ - done!

8 years agoUpdate docs: mention /*! directives */
Oleg Broytman [Sun, 4 Sep 2016 14:46:58 +0000 (17:46 +0300)]
Update docs: mention /*! directives */

8 years agoAdd MySQL-specific remove_directives() and process_statement() 0.0.4
Oleg Broytman [Sun, 4 Sep 2016 14:29:40 +0000 (17:29 +0300)]
Add MySQL-specific remove_directives() and process_statement()

8 years agoMove requote_names from process_tokens.py to process_mysql.py
Oleg Broytman [Sun, 4 Sep 2016 13:36:12 +0000 (16:36 +0300)]
Move requote_names from process_tokens.py to process_mysql.py

8 years agoInclude scripts/mysql2sql into sdist
Oleg Broytman [Sun, 4 Sep 2016 11:28:20 +0000 (14:28 +0300)]
Include scripts/mysql2sql into sdist

8 years agoVersion 0.0.3: Rename the project: mysql2py -> sqlconvert 0.0.3
Oleg Broytman [Sun, 4 Sep 2016 11:24:26 +0000 (14:24 +0300)]
Version 0.0.3: Rename the project: mysql2py -> sqlconvert

8 years agoFix docs after split index -> mysql2sql
Oleg Broytman [Sun, 4 Sep 2016 11:22:51 +0000 (14:22 +0300)]
Fix docs after split index -> mysql2sql

8 years agoRename target 'html' to 'docs'
Oleg Broytman [Sun, 4 Sep 2016 11:18:52 +0000 (14:18 +0300)]
Rename target 'html' to 'docs'

8 years agoRename mysql2sql -> sqlconvert
Oleg Broytman [Sun, 4 Sep 2016 11:16:36 +0000 (14:16 +0300)]
Rename mysql2sql -> sqlconvert

8 years agoVersion 0.0.2: Rename mysql-to-sql.py -> mysql2py 0.0.2
Oleg Broytman [Sat, 3 Sep 2016 20:41:52 +0000 (23:41 +0300)]
Version 0.0.2: Rename mysql-to-sql.py -> mysql2py

8 years agoDisplay progress bar
Oleg Broytman [Sat, 3 Sep 2016 20:40:29 +0000 (23:40 +0300)]
Display progress bar

8 years agoRename mysql-to-sql.py -> mysql2py
Oleg Broytman [Sat, 3 Sep 2016 20:22:58 +0000 (23:22 +0300)]
Rename mysql-to-sql.py -> mysql2py

8 years agoTODO: Progress bar
Oleg Broytman [Sat, 3 Sep 2016 20:17:17 +0000 (23:17 +0300)]
TODO: Progress bar

8 years agoUpdate TODO
Oleg Broytman [Sat, 3 Sep 2016 18:34:55 +0000 (21:34 +0300)]
Update TODO

8 years agoFix flake8 warning
Oleg Broytman [Sat, 3 Sep 2016 16:08:01 +0000 (19:08 +0300)]
Fix flake8 warning

8 years agoVersion 0.0.1: First release. Setup, tests and docs infrastructure 0.0.1
Oleg Broytman [Sat, 3 Sep 2016 16:00:35 +0000 (19:00 +0300)]
Version 0.0.1: First release. Setup, tests and docs infrastructure

8 years agoFix vim script
Oleg Broytman [Sat, 3 Sep 2016 16:00:19 +0000 (19:00 +0300)]
Fix vim script

8 years agoMinor fix in docs
Oleg Broytman [Sat, 3 Sep 2016 15:56:00 +0000 (18:56 +0300)]
Minor fix in docs

8 years agoFix unicode test for Py3
Oleg Broytman [Sat, 3 Sep 2016 15:55:37 +0000 (18:55 +0300)]
Fix unicode test for Py3

8 years agoUse sphinx.ext.viewcode to include module's code
Oleg Broytman [Sat, 3 Sep 2016 15:50:32 +0000 (18:50 +0300)]
Use sphinx.ext.viewcode to include module's code

8 years agoRequire m_lib
Oleg Broytman [Sat, 3 Sep 2016 15:48:44 +0000 (18:48 +0300)]
Require m_lib

Require sqlparse instead of install_requires.

8 years agogenapidocs: replace short options with long ones
Oleg Broytman [Sat, 3 Sep 2016 15:48:01 +0000 (18:48 +0300)]
genapidocs: replace short options with long ones

8 years agoUse encoding (default is utf-8) and unicode
Oleg Broytman [Fri, 2 Sep 2016 22:26:02 +0000 (01:26 +0300)]
Use encoding (default is utf-8) and unicode

8 years agoChange arguments handling
Oleg Broytman [Fri, 2 Sep 2016 21:16:02 +0000 (00:16 +0300)]
Change arguments handling

Allow `-` to name stdin or stdout.
Input file is always the first argument, no need to use option `-i`.
Output file can be named with `-o` or as the second argument
but not both. Option `-o` is useful when there is no input file (input
is redirected, for example: `mysql-to-sql.py -o out.sql < in.sql`).

8 years agoPrint error message
Oleg Broytman [Fri, 2 Sep 2016 20:59:08 +0000 (23:59 +0300)]
Print error message

8 years agoRadically simplify MANIFEST.in by using global-include
Oleg Broytman [Sun, 28 Aug 2016 15:05:01 +0000 (18:05 +0300)]
Radically simplify MANIFEST.in by using global-include

8 years agoInclude API docs
Oleg Broytman [Sun, 28 Aug 2016 10:16:35 +0000 (13:16 +0300)]
Include API docs

8 years agoStarted documentation
Oleg Broytman [Sun, 28 Aug 2016 10:08:18 +0000 (13:08 +0300)]
Started documentation

8 years agoFix a bug: do not add additional newlines
Oleg Broytman [Sat, 27 Aug 2016 19:19:05 +0000 (22:19 +0300)]
Fix a bug: do not add additional newlines

As the package doesn't strip newlines from the input string
(to preserve original newlines) there is no need to separate lines
with additional newlines.

8 years agoAdd requirements_docs.txt
Oleg Broytman [Sat, 27 Aug 2016 16:55:08 +0000 (19:55 +0300)]
Add requirements_docs.txt

8 years agoAdd script mysql-to-sql.py
Oleg Broytman [Sat, 27 Aug 2016 14:39:20 +0000 (17:39 +0300)]
Add script mysql-to-sql.py

Cannot be name mysql2sql.py to avoid collision with the package.

8 years agofixup! Rename scripts -> demo; move sample.sql into demo
Oleg Broytman [Sat, 27 Aug 2016 14:08:17 +0000 (17:08 +0300)]
fixup! Rename scripts -> demo; move sample.sql into demo

8 years agoInclude ez_setup.py into sdist
Oleg Broytman [Sat, 27 Aug 2016 13:49:00 +0000 (16:49 +0300)]
Include ez_setup.py into sdist

8 years agoRename scripts -> demo; move sample.sql into demo
Oleg Broytman [Sat, 27 Aug 2016 13:43:16 +0000 (16:43 +0300)]
Rename scripts -> demo; move sample.sql into demo

8 years agoFix Python3 compatibility
Oleg Broytman [Sat, 27 Aug 2016 13:41:32 +0000 (16:41 +0300)]
Fix Python3 compatibility

8 years agoCollect lines and reparse until the last statement is complete
Oleg Broytman [Fri, 26 Aug 2016 21:48:02 +0000 (00:48 +0300)]
Collect lines and reparse until the last statement is complete

8 years agoProcess input stream line by line
Oleg Broytman [Wed, 24 Aug 2016 14:44:41 +0000 (17:44 +0300)]
Process input stream line by line

8 years agoSimplify test: use 'for' loop to loop over generator
Oleg Broytman [Wed, 24 Aug 2016 14:42:37 +0000 (17:42 +0300)]
Simplify test: use 'for' loop to loop over generator

8 years agoAdd sample and scripts to sdist
Oleg Broytman [Tue, 23 Aug 2016 21:59:57 +0000 (00:59 +0300)]
Add sample and scripts to sdist

8 years agoA trailing space added by distutils
Oleg Broytman [Tue, 23 Aug 2016 20:19:47 +0000 (23:19 +0300)]
A trailing space added by distutils

8 years agoAllow whitespaces and comments after the last statement
Oleg Broytman [Tue, 23 Aug 2016 19:57:30 +0000 (22:57 +0300)]
Allow whitespaces and comments after the last statement

8 years agoGroup statements separated by semicolons
Oleg Broytman [Sun, 21 Aug 2016 08:09:55 +0000 (11:09 +0300)]
Group statements separated by semicolons

8 years agoExclude ez_setup.py from flake8 testing
Oleg Broytman [Sun, 21 Aug 2016 08:08:44 +0000 (11:08 +0300)]
Exclude ez_setup.py from flake8 testing

8 years agoRename scripts
Oleg Broytman [Sun, 21 Aug 2016 08:04:35 +0000 (11:04 +0300)]
Rename scripts

8 years agoRefactor identical code in the script
Oleg Broytman [Sun, 14 Aug 2016 12:04:58 +0000 (15:04 +0300)]
Refactor identical code in the script