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

52 commits

This branch
This branch
All branches
Author SHA1 Message Date
Correl
82b2c1339c Update support for AllPrices 
Iterate over the current AllPrices data, capturing game format, price
provider, provider market, and currency.
 2021-05-26 17:46:17 -04:00
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