Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for VARBINARY Fields for Unicode #8

Open
palisadoes opened this issue Dec 16, 2019 · 1 comment
Open

Support for VARBINARY Fields for Unicode #8

palisadoes opened this issue Dec 16, 2019 · 1 comment
Labels
question Further information is requested

Comments

@palisadoes
Copy link

How should I configure graphene-sqlalchemy-filter to account for VARBINARY fields in a SQLAlchemy model?

I have no issues using graphene-sqlalchemy-filter filtering on INTEGER columns. With VARBINARY defined columns, I can filter using numeric only strings with these caveats.

  1. Filtering with a "0" gives every value.
  2. Filtering with an "AlphaNumeric" value or a a numeric value with a leading zero gives this error. The character referenced is the location of the first non-numeric character in the string. In this case the filter string was "75556b"
{
  "errors": [
    {
      "message": "Extra data: line 1 column 6 (char 5)"
    }
  ]
}

You can view my code here where I'm attempting to filter the PairXlate table on key (VARBINARY) and idx_pair_xlate_group (BIGINT).
: https://github.com/palisadoes/pattoo/tree/753885eb4dfa72c525425a29c98e5fd6ef6fb8ff/pattoo/db

@art1415926535
Copy link
Owner

What type of data is stored in VARBINARY? Can you give some examples of sqlalchemy queries you are interested in?

@art1415926535 art1415926535 added the question Further information is requested label Dec 30, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants