github/mtgsqlive
1
0
Fork 0
mirror of https://github.com/correl/mtgsqlive.git synced 2024-11-21 11:08:38 +00:00
Code Issues Projects Releases Packages Wiki Activity
51 commits 2 branches 1 tag 31 MiB
Commit graph

51 commits

This branch
This branch
All branches
Author SHA1 Message Date
Eric Lakatos
0fe54837ca
Merge pull request #69 from tooomm/patch-1 
Update MTGJSON version number
 2021-03-19 17:51:17 -04:00
tooomm
995f6c21a3
v5 2021-02-28 12:32:37 +01:00
ZeldaZach
debc6ce2cb Revert "Add Postgres support (#67)" 
This reverts commit 2c2e51ddd3.
 2021-01-20 13:16:25 -05:00
Antony Derham
2c2e51ddd3
Add Postgres support (#67) 
* Add Postgres support

- Add engine switch to command
- Add support for Postgres schema syntax
- Leverage Postgres enum types
- Leverage Postgres array types

* Formatting, types, cleanup
 2021-01-17 01:41:45 -05:00
Zach H
0c889412fd
Fix #63 2020-08-16 23:45:01 -04:00
Mark Cheese
afccbe88f7
Merge pull request #61 from mtgjson/meta-patch 
Add meta table
 2020-07-17 15:52:08 -04:00
Mark Cheese
8f946d3d24
Add meta table 2020-07-17 15:50:51 -04:00
Mark Cheese
391ce43d90
Booster typo fix 2020-07-07 15:40:33 -04:00
Mark Cheese
7a234a725f
Merge pull request #60 from mtgjson/booster-patch-1 
booster fix
 2020-07-07 14:55:30 -04:00
Mark Cheese
837d0b8829
booster fix fix 2020-07-07 14:54:57 -04:00
Mark Cheese
573cd282ab
booster fix 2020-07-07 14:52:43 -04:00
ajr-dev
636f8ca64b
Fix typo (#59) 2020-07-06 16:03:58 -04:00
Mark Cheese
53a6d6f370
Extras fix 2020-07-06 01:54:40 -04:00
Mark Cheese
62cb553173
Merge pull request #58 from mtgjson/v5-patch 
v5 Release Updates
 2020-07-06 01:50:58 -04:00
Mark Cheese
3c5607eb32
v5 Release Updates 2020-07-06 01:47:55 -04:00
ajr-dev
df465d8424
Refactor (#57) 2020-07-05 22:54:18 -04:00
Zach H
ad2475438d
Update setup.py 2020-04-22 17:32:36 -04:00
Mark Cheese
0b46d58d29
ENUM options fix (#53) 2020-04-03 22:44:05 -04:00
Mark Cheese
26650c1a05
v5 Structure Handling (#52) 2020-03-28 15:45:35 -04:00
Mark Cheese
13d2a09b7f
Commit bug fix (#51) 2020-03-19 14:41:24 -04:00
Mark Cheese
03cd07af3b
setup.py and some more table stuff (#50) 2020-02-24 23:06:06 -05:00
Mark Cheese
276943550a
Dynamic Table Generation (#48) 
* Dynamic Table Generation

* Added -x flag for additional inputs

* Clean Up Dynamic Tables

* More Table Generation Cleanup
 2020-02-02 18:05:57 -05:00
Mark Cheese
6988b47ca4 Fix for new prices structure (#47) 2020-01-21 15:39:48 -05:00
Mark Cheese
2deb975e89 MySQL Schema tweaking and isBuyABox added. (#46) 2020-01-20 22:41:44 -05:00
Mark Cheese
17461375b3 Added MySQL schema and isDateStamped column. (#44) 2020-01-08 10:39:21 -05:00
Mark Cheese
8eb31aa752 Missing Key bug fix (#37) 2019-12-10 19:12:57 -05:00
Mark Cheese
8678f6003a Additional Inputs (#36) 
* Additional Inputs

* Black formatted

* Fixed version variable

* Added otherFaceIds column
 2019-12-09 23:58:24 -05:00
Mark Cheese
559d07b55d Price value validation added. (#35) 2019-11-04 18:57:05 -05:00
Zach H
7139f36241
Add CSV support (#33) 
* Add CSV support

Signed-off-by: ZeldaZach <zahalpern+github@gmail.com>

* foreignData => foreign_data. `--all` will now build all components

Signed-off-by: ZeldaZach <zahalpern+github@gmail.com>
 2019-10-27 19:06:09 -04:00
ZeldaZach
cd7e36886a frameeffects 2019-10-23 20:46:36 -04:00
Jason Addington
6fa3063e7b Fix errors causing data population to fail (#31) 
* Modify card price reader to handle null price dictionaries (e.g. 10E Anaba Bodyguard)

* Add support for undocumented `subtypes`, `supertypes`, and `types` fields on `tokens`.
 2019-10-12 12:58:18 -04:00
Zach H
9b18d52a5d
Mark's Changes for SQL (#29) 
* Added new fields.

- Added `hasLeadershipSkills` and `hasNoDeckLimit`

* Update json2sql.py

* Changed for new build

* Export .sql file

* fixes
 2019-09-30 00:23:06 -04:00
Zach Halpern
0d08bb8b92 translations may be non-existent 
Signed-off-by: Zach Halpern <ZaHalpern+github@gmail.com>
 2019-09-18 21:35:17 -04:00
Mark Cheese
9f575175bd Added New Fields. (#27) 
* Added new fields.

- Added `hasLeadershipSkills` and `hasNoDeckLimit`

* Update json2sql.py

* Changed for new build
 2019-09-16 18:02:35 -04:00
Mark Cheese
6b74f2baad Foreign keys and datatype improvements (#24) 2019-08-18 15:43:46 -04:00
Mark Cheese
67e14b6d16 Re-Adding "duelDeck" to tokens table. (#23) 
* Updated fields for 4.5.0

* Update json2sql.py
 2019-08-15 13:26:53 -04:00
Mark Cheese
1f5e035b07 Updated fields for 4.5.0 (#22) 2019-08-12 10:44:30 -04:00
Zach Halpern
11225ab7c9 Add ID key to each table for indexing, alphabetize fields, mark booleans, "blackify" and use f-strings if needed 2019-07-20 20:47:47 -04:00
Chris Mohr
91c6ea6ff7 Update json2sql.py (#21) 
* Update json2sql.py

Add mtgArenaId, mtgoFoilId, mtgoId to cards table

* Add defaults for new columns
 2019-07-20 18:39:27 -04:00
Mark Cheese
a5a65d3fe9 Some Minor Fixes and Improvements (#20) 
* Quality of life change.

* Updated json2sql.py

- Added "prices" table.
- Tidy'd up: fixed some minor formatting, and made some small improvements to log output.
- Added option of using "AllSetFiles" for input, simply provide a path to the directory as the input.
- Added auto-increment "id" column as primary key to relational tables for easy referencing.

To-Do:
- allow .zip and other compressed input
- Standardize formatting (Escaping characters, quote types/positioning, line breaks, etc.)

* Update mtgsqlive/json2sql.py

Co-Authored-By: Zach H <zahalpern+github@gmail.com>

* Put json2sql.py back where it belongs!

* Delete json2sql.py

* Applied suggestions and cleaned up a little more.
 2019-07-12 22:49:12 -04:00
Zach H
f3c23eec7e
Update json2sql.py 2019-07-07 23:05:52 -04:00
Maciej Sumiński
fb2674ff37 'Cards' table structure update to 4.4.2 + one bug fix (#19) 
* Fix sqlite3.connect() parameter type

Function sqlite3.connect() expects a string, but output_file is a
PosixPath variable.

* Update 'cards' table structure to match version 4.4.2
 2019-06-27 07:53:11 -04:00
Zach H
08bf857c70
License change approved. MTGJSON moving from GPLv3->MIT. 2019-06-22 23:59:05 -04:00
Jason Addington
0bd4089efc Implement set_translation import (#17) 
* Replace colons with hyphens in log filenames to be compatible with Windows.

* Always open the json file as UTF8 encoding as the default on Windows is different.

* Add set_translation data import.
 2019-06-12 15:02:25 -04:00
ZeldaZach
1de6e57e41 add foreign only 2019-05-31 13:33:29 -04:00
Zach Halpern
3b0bac4ed7 4.4.0 compatibility 
Signed-off-by: Zach Halpern <ZaHalpern+github@gmail.com>
 2019-04-28 10:11:28 -04:00
Zach Halpern
2374181fd9 Add new missing fields from recent updates 
Signed-off-by: Zach Halpern <ZaHalpern+github@gmail.com>
 2019-04-21 23:59:37 -04:00
Zach Halpern
eba5743aa8 primary key needs length 
Signed-off-by: Zach Halpern <ZaHalpern+github@gmail.com>
 2019-01-18 03:39:33 -05:00
Fryyyyy
c3add103cd Make fast (#11) 2019-01-17 18:59:26 -05:00
Zach H
99d6c40d4c MTGJSONv4 Support (#10) 
* initial pass

* Improve speeds, fix rulings

Signed-off-by: Zach Halpern <ZaHalpern+github@gmail.com>

* tox

Signed-off-by: Zach Halpern <ZaHalpern+github@gmail.com>

* Readme, main, and updates

Signed-off-by: Zach Halpern <ZaHalpern+github@gmail.com>

* fixes to params

Signed-off-by: Zach Halpern <ZaHalpern+github@gmail.com>

* alpha

Signed-off-by: Zach Halpern <ZaHalpern+github@gmail.com>

* Add tokens

Signed-off-by: Zach Halpern <ZaHalpern+github@gmail.com>
 2019-01-17 17:04:42 -05:00