[Cod-bugs] Filtering structures with/without disorder

[Andrius Merkys]

Hi,

On 11/4/24 16:52, Fx COUDERT wrote:
> Thanks. Is there a simple, complete example on how to query the COD server through SQL? The page you linked to says "The more sophisticated queries however may need direct access to the COD SQL server”. I can see how to create a local copy of your SQL database athttps://wiki.crystallography.net/creatingSQLdatabase/ but I do not see how to connect directly to your server?

The following Bash command should give all COD IDs of entries without 
explicitly marked disorder:

mysql -u cod_reader -h sql.crystallography.net cod -e 'select file from 
data where flags NOT LIKE "%has disorder%"' -N | wc -l

Please notice the 'wc -l' at the end, which I use in order not to 
overflow my terminal with the IDs. It is better to redirect the output 
to a file.

Hope this helps,
Andrius

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.