diff options
| -rw-r--r-- | LICENSE | 25 | ||||
| -rw-r--r-- | README.md | 77 |
2 files changed, 102 insertions, 0 deletions
@@ -0,0 +1,25 @@ +BSD 2-Clause License + +Copyright (c) 2016-2019, Michał Klichowicz +All rights reserved. + +Redistribution and use in source and binary forms, with or without +modification, are permitted provided that the following conditions are met: + +1. Redistributions of source code must retain the above copyright notice, this + list of conditions and the following disclaimer. + +2. Redistributions in binary form must reproduce the above copyright notice, + this list of conditions and the following disclaimer in the documentation + and/or other materials provided with the distribution. + +THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" +AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE +IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE +DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE +FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL +DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR +SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER +CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, +OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE +OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. diff --git a/README.md b/README.md new file mode 100644 index 0000000..9056106 --- /dev/null +++ b/README.md @@ -0,0 +1,77 @@ +JFR Teamy Mojżesz - README +===================================================================== + +import scores, lineups and bidding from PBN files + +Overview +======== + +This piece of software serves as a replacement for Kolektor in the JFR Teamy ecosystem, for when data is read not from BWS files, but from Portable Bridge Notation files. + +It was developed specifically for the purpose of importing data from PBN dumps from LoveBridge tablet system (get it? tablets, Moses, funny. why aren't you laughing?), but should be capable of handling PBN files in general. + +Prerequsites +============ + + * Python 2.7 (sorry) + * Python MySQL connector + * python-requests + * for EXE compilation: PyInstaller 3.6 + +Usage +===== + +``` +python src/main.py +``` + +Configuration +============= + +Two main data sources are required to run the script: + + * a PBN file accessible via HTTP(S) + * a `mojzesz.json` config file in the current (working) directory + +Sample config file is provided in the repo. `mysql` and `source` sections should be self-explanatory (`auth` section is not required if PBN is not behind HTTP Auth, and `headers` section is just explicitly forwarded to the HTTP(S) request headers). + +As for `settings` section: + + * `pbn_round` is the round in PBN file for which the boards should be read (filtered by `[Round "X"]` fields) + * `teamy_round` and `teamy_segment` point to the round and segment in JFR Teamy event database into which data is imported + * `fetch_lineups` enables reading lineups from PBN files, strict comparison of full name + surname is conducted, and players have to be in correct Teamy rosters + * `overwrite_scores` enables overwriting existing scores: otherwise, if a score in board points has changed in PBN from the one present in Teamy database, a warning is emitted + * `info_messages` controls logging verbosity: 0 = warnings and errors, 1 = info messages, warnings and errors, 2 = debug output + * `job_interval` is number of seconds between subsequent runs + +The script is meant to run continuously, both PBN and config files are read from scratch on every iteration. + +Quirks, assumptions and known issues +==================================== + + * one only section within the PBN is supported: table number (`[Table "XX"]`) is stripped of any section letters and converted to numerical value that must match the table number in Teamy database + * LoveBridge exports seem to indicated double in the `[Contract ""]` field by `*`, not `x` - both notations are supported + * there's no support for initial lead card, hopefully: yet; when it comes, it's most likely going to be in a non-standard PBN field + * bidding data is always overwriting values in the database + * lineups, if requested, are always overwriting values in the database + * if the records for specific boards are missing from the `scores` table in event database (as in, JFR Webmaster haven't created them yet), they are created + +Author +====== + +This software was made by [Michał Klichowicz](https://emkael.info). + +If you use it, you probably know how to reach me. + +If you don't (know how to reach me), you can find it on my website. + +License +======= + +PBN parsing makes significant use of [the Python port of BCDD](https://github.com/emkael/pybcdd), with BCalc binding removed, in a blatant act of self-plagiarism. + +So I guess it's suitable to share this under [BSD-2-Clause license](LICENSE), as well. + +--- + +`In a room with a window in the corner I found truth` |