marx | The classless CSS reset | Theme library

So assume it is a straight start of string match STARTSWITH can be used to match the two tables, then the output can be trimmed with SUBSTRING and LENGTH and some handling of NULL for no matches. And then to rank the matches we can use QUALIFY and ROW_NUMBER with a crude longest street type wins

Your whole code is indented in the first if condition, which means it would work only if your entry string has a space in it.

On top of that, do you use quotes or double quotes when you add your argument ? Because using sys.argv[1] takes the 1st argument.

Looks like the else branch of if 'description' in dic: is never executed. If your code is indented correctly, then also the csvWriter.writerow part is never executed because of this.

That yields that no contents are written to your file.

A comment on code style:

• use with open(file) as file_variable: instead of manually using open and close. That can save you some trouble, e.g. the trouble you would get when the else branch would indeed be executed and the file would be closed multiple times :)

I believe the problem relies in the append_to_csv function because of a wrong indentation.

Look at your code:

Does this answer your question?

This sort of atomic constraint change is not currently supported by cockroach. The reasons why not are relatively involved. Cockroach attempts to perform all schema changes in an online manner, never locking the table for writes. To achieve this, the database decomposes schema changes into stages, most of which are executed asynchronously after the transaction commits. This poses problems for a variety of schema changes which rely on eachother. We are actively working on fixing this, though it is a long project. You can read more in this RFC.

For now, the best you can do is to drop the constraint and add a new one with a different name and in a subsequent transaction rename it to the old name.

(Edited with usage instructions below) The Gods of SQL Purity may scorn me for this answer but I propose creating a Javascript UDF that takes the output of GET_DDL, parses the results and returns to a SQL statement, which you can then copy/paste and run.

Here is one such UDF which worked against the table I tried it on by select prepare_seed_stmt('my_tbl', get_ddl('table', 'my_tbl'));

Pay close attention to the expressions object to make sure it does what you want and since many datatypes are missing (like VARIANT, etc)

Try and set the encoding to UTF-8

For example:

file = open(filename, encoding="utf8")

For reference check this post:

UnicodeDecodeError: 'charmap' codec can't decode byte X in position Y: character maps to

This could be achieved like so:

1. Put your code in a function which takes a filename as an argument
2. Use list.files to get a vector of all xml files in your directory
3. Use e.g. lapply to loop over the files, which will return a list of your texts.