the only problems is when I'll query with SQLAlchemy with a field like : "uri,uri,uri" is there a simple query to extract this uri ? like a contains ?
Le jeu. 21 mars 2019 à 09:35, Scheck David <da...@sphax.it> a écrit : > I found this which could make the work. because it seems that it index all > in one field and this will improve my performances. what do you think? > > https://stackoverflow.com/questions/40106609/indexing-nested-json-with-postgres > > I think this could do the trick > > Le mer. 20 mars 2019 à 17:03, Mike Bayer <mike...@zzzcomputing.com> a > écrit : > >> On Wed, Mar 20, 2019 at 11:04 AM david scheck <schecksda...@gmail.com> >> wrote: >> > >> > Hi everyone, >> > >> > I'm trying to implement a nested JSONB index on a nested field in the >> json file. I searched through internet and came at the conclusion that I >> had to create it manually. >> > >> > so that's where I am. >> > >> > op.create_index('ix_law_search_vector', 'law', ['search_vector'], >> unique=False, postgresql_using='gin') >> > >> > >> > first of all, I don't understand the 3rd argument. what does this >> represent? the name of the index? >> >> the first argument is the name of the index. All the remaining >> positional arguments are SQL expressions. So the ['search_vector'] is >> probably wrong. >> >> > >> > this is what should be. but my problem is that my desire index is very >> deep in the JSONB. >> >> > >> > >> > that's what I've to target : >> Image.image_metadata['afield']['anotherfield']['fieldindex'] >> > >> > >> > I want to create an index on fieldindex. >> > >> > >> > but if I do : >> > >> > op.create_index('uri', ['search_vector'], unique=False, >> postgresql_using='gin') >> > >> > >> > as there is a lot of field 'uri' in the json, will it index all this >> fields in 1 ? >> > >> > >> > (I'm new to sqlalchemy, I usually use the django orm, so sorry in >> advance). >> >> Right so in SQLAlchemy, you don't have to figure any of this out. >> Just get the Postgresql syntax you want exactly and run it, >> op.execute("CREATE INDEX whatever"). if you show me the syntax I >> can see how to make Index() do it too but to just emit a very specific >> CREATE INDEX, you can just type it out. >> >> >> >> > >> > >> > Thanks for answers >> > >> > >> > -- >> > SQLAlchemy - >> > The Python SQL Toolkit and Object Relational Mapper >> > >> > http://www.sqlalchemy.org/ >> > >> > To post example code, please provide an MCVE: Minimal, Complete, and >> Verifiable Example. See http://stackoverflow.com/help/mcve for a full >> description. >> > --- >> > You received this message because you are subscribed to the Google >> Groups "sqlalchemy" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> an email to sqlalchemy+unsubscr...@googlegroups.com. >> > To post to this group, send email to sqlalchemy@googlegroups.com. >> > Visit this group at https://groups.google.com/group/sqlalchemy. >> > For more options, visit https://groups.google.com/d/optout. >> >> -- >> SQLAlchemy - >> The Python SQL Toolkit and Object Relational Mapper >> >> http://www.sqlalchemy.org/ >> >> To post example code, please provide an MCVE: Minimal, Complete, and >> Verifiable Example. See http://stackoverflow.com/help/mcve for a full >> description. >> --- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to sqlalchemy+unsubscr...@googlegroups.com. >> To post to this group, send email to sqlalchemy@googlegroups.com. >> Visit this group at https://groups.google.com/group/sqlalchemy. >> For more options, visit https://groups.google.com/d/optout. >> > > > -- > > With kindest regards, > > > *David SCHECK* > > PRESIDENT/DEVELOPER > > [image: Signature Logo Sphax Bleu-01.png] > > Phone: +32 4 87 86 70 12 > Visit our website ! https://www.sphax.org > -- With kindest regards, *David SCHECK* PRESIDENT/DEVELOPER [image: Signature Logo Sphax Bleu-01.png] Phone: +32 4 87 86 70 12 Visit our website ! https://www.sphax.org -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.