Commit Graph

1568 Commits

Author SHA1 Message Date
Dimitri Fontaine
09a49f4771 MySQL also has a "timestamp" datatype, register default casts and handle the default value CURRENT_TIMESTAMP properly: without quoting. 2013-10-05 21:29:26 +02:00
Dimitri Fontaine
57725a72d1 Fix quoting of the table name in MySQL migration for a single table. 2013-10-05 21:05:20 +02:00
Dimitri Fontaine
0769e145b4 Inline functions used within per-row loops. 2013-10-05 18:22:47 +02:00
Dimitri Fontaine
ef6eb2bd3c Allow filtering the MySQL migration to a single table from the command language. 2013-10-05 18:02:42 +02:00
Dimitri Fontaine
c01b693f21 Force MySQL identifiers that are PostgreSQL reserved keywords to be quoted. 2013-10-05 17:02:57 +02:00
Dimitri Fontaine
c35468d437 Remove hard-coded value that somehow did find a way in, thanks to Hans Hübner. 2013-10-05 15:39:15 +02:00
Dimitri Fontaine
40e9c438fa Handle CL-POSTGRES::PROTOCOL-ERROR for batch retry. 2013-10-04 17:18:13 +02:00
Dimitri Fontaine
165f74b197 Add some test files. 2013-10-04 17:12:50 +02:00
Dimitri Fontaine
b12d71cfe0 Add a facility to better play with connection strings: with-database-uri. 2013-10-03 21:28:44 +02:00
Dimitri Fontaine
fc8c0556dd Don't make an index specific kernel when we don't have indexes to migrate at all 2013-10-03 21:09:45 +02:00
Dimitri Fontaine
005b33d99f Export more practical stuff in the main package, and make run-command smarter. 2013-10-03 21:00:16 +02:00
Dimitri Fontaine
b4c9ca0571 Fix a stupid loop initialisation variable (what should've been). 2013-10-03 19:01:48 +02:00
Dimitri Fontaine
79d9b3f0e3 Document how to build a self-contained binary image, and tweak main.lisp for that. 2013-10-03 18:21:48 +02:00
Dimitri Fontaine
001b33343d Add forgotten main.lisp file. 2013-10-03 18:12:30 +02:00
Dimitri Fontaine
2bf7c4df12 Assorted clean up to prepare a binary image. 2013-10-03 17:42:09 +02:00
Dimitri Fontaine
ab5613925b Implement a faster integer to ip code and inline it for real this time. 2013-10-01 23:52:19 +02:00
Dimitri Fontaine
2528d8ac21 Direct tests to use the ip4r database. 2013-10-01 23:51:49 +02:00
Dimitri Fontaine
e0cb525810 MySQL migration: Use table OIDs rather than table name for disambiguating index names. 2013-10-01 09:30:17 +02:00
Dimitri Fontaine
c7a28aa859 Add a default cast rule from "year" to "integer". 2013-10-01 09:29:42 +02:00
Dimitri Fontaine
94edae3662 Fix the previous commit... 2013-10-01 00:24:17 +02:00
Dimitri Fontaine
e175e7782a Fix mysql stream-table to be usable directly. 2013-10-01 00:15:29 +02:00
Dimitri Fontaine
ea5a373ad9 Fix loading examples to avoid loading with the index already there. 2013-10-01 00:11:54 +02:00
Dimitri Fontaine
6b3e5d6338 Some tries at optimisations. 2013-10-01 00:11:26 +02:00
Dimitri Fontaine
1fd0fb68f2 Get rid of the global null-as processing, which means nothing. 2013-10-01 00:11:13 +02:00
Dimitri Fontaine
2ddaba4284 Fix MySQL schema casting WRT identifers.
In MySQL schema cast, take care to downcase or quote the colum names
references in the index definitions, and replace non alphanumeric characters
with #\_ when downcasing.
2013-09-30 22:09:07 +02:00
Dimitri Fontaine
ccc153b9e1 Don't report a separation line when there's no finally section to separate... 2013-09-30 19:54:26 +02:00
Dimitri Fontaine
64589134c8 Temporary hack for debugging, error wasn't there anyway. 2013-09-30 19:48:42 +02:00
Dimitri Fontaine
d3991690cf Fix handling of CSV loading when not given fields nor columns lists. 2013-09-30 19:48:21 +02:00
Dimitri Fontaine
2ff0d11332 Fix a typo in the com.informatimago.clext ASD dependency declaration. 2013-09-30 17:31:28 +02:00
Dimitri Fontaine
32d183efa5 Rework the summary handling in LOAD FROM ARCHIVE commands. 2013-09-30 16:04:01 +02:00
Dimitri Fontaine
9c1592c4eb Switch to using the unzip command rather than the CL implementation... 2013-09-30 14:23:19 +02:00
Dimitri Fontaine
2a6c974f8e Handle input file encodings. 2013-09-30 00:26:41 +02:00
Dimitri Fontaine
47257a173c Add some logs in the archive code. 2013-09-30 00:26:07 +02:00
Dimitri Fontaine
5ca4348e7e Fix handling of per-field NULL IF properties. 2013-09-29 22:26:20 +02:00
Dimitri Fontaine
9bea12ed3e Fix the LOAD FROM ARCHIVE command code paths until it actually works. 2013-09-28 23:45:24 +02:00
Dimitri Fontaine
a951d55f4c Don't try to probe-file tmpdir when it's nil. 2013-09-27 10:28:49 +02:00
Dimitri Fontaine
6e3767bb37 Implement generic field to columns projection with support for user code.
And use that new facility in the Archive mode of operations, which is a
practical unit of testing and milestone to reach. We have enough code to
actually compile and try running the parser's output.
2013-09-25 00:01:46 +02:00
Dimitri Fontaine
b4e530981c WIP implementing full archive fetching and downloading. 2013-09-24 18:34:05 +02:00
Dimitri Fontaine
4172374b61 Use CREATE TABLE IF NOT EXISTS in the db3 import. 2013-09-24 11:05:57 +02:00
Dimitri Fontaine
2ab8c74c49 Update docs to point ot the main Postmodern tree. 2013-09-23 15:34:39 +02:00
Dimitri Fontaine
fd578e7c63 Document the temporary dependency towards the patched version of Postmodern. 2013-09-23 15:28:20 +02:00
Dimitri Fontaine
699fcb21f2 Refactor to new Postmodern patch. 2013-09-23 15:25:02 +02:00
Dimitri Fontaine
7151a2ea62 Refactor transaction handling, depend on a patch to postmodern. 2013-09-23 11:30:20 +02:00
Dimitri Fontaine
fd2809277f Code cleanup: use with-stats-collection. 2013-09-23 09:58:41 +02:00
Dimitri Fontaine
ac4f9ff654 Code review, client messages, logs, summary, index naming and building. 2013-09-23 00:09:11 +02:00
Dimitri Fontaine
031a8bd15a First pass at thinking parallel: create indexes while copying next tables... 2013-09-22 16:37:04 +02:00
Dimitri Fontaine
e75954c319 Remove the global kernel parameter, create as needed. 2013-09-22 15:12:43 +02:00
Dimitri Fontaine
1a28a03e1f Add option "schema only" for MySQL migrations, cleanup code, fix identifer case for indexes. 2013-09-21 17:35:03 +02:00
Dimitri Fontaine
c9dd959fbd Implement MySQL migration option "downcase|quote identifier". 2013-09-20 22:52:45 +02:00
Dimitri Fontaine
020cd7d3ed Fix the code to handle lack of target type in MySQL cast rules parsing. 2013-09-20 22:51:44 +02:00