l2tscaffolder fails to create parser about l2tscaffolder HOT 4 CLOSED

ok, I was able to reproduce this, looking at what the bug is and then I'll submit a fix

from l2tscaffolder.

OK, debugging this shows:

SyntaxError('invalid syntax', ('<unknown>', 30, 10, '      self.* = None\n'))

So line 30 in the sqlite_plugin.jinja2....

{% for attr in query_columns[query_name]|sort(false) %}self.{{ attr }} = None

So looking at the query columns here... I get:

{'Messages': ['*']}

If you would do something different than select * then this will work.... since now the generator tries to add the attribute "self.*" which is not valid.

I will add a check to see whether a select * is selected, and advise against it....

You should be able to create the plugin if you change from "SELECT *" to "SELECT column_a, column_b, ...."

from l2tscaffolder.

Now when you try to run the generate this way you get:

Callback function name [#1]: Messages
SQL Statement [#1]: SELECT * FROM messages 
More entries? [Y/n]: n
Unable to configure, with error: UnableToConfigure('Unable to generate parser while using * to select columns. Please adjust your SELECT statements to include explicit column names.',)
Want to try again? [Y/n]:  

That is you'll need to redo the SQL statement.

And if you redo the statement:

Callback function name [#1]: Messages
SQL Statement [#1]: SELECT Message,Timestamp,Foobar FROM messages
More entries? [Y/n]: n

IT will be accepted and the parser will be generated...

from l2tscaffolder.

Thanks

from l2tscaffolder.