sqljocky query - method not found

Question

Trying to query mysql database with sqljocky. This query works fine in phpmyadmin and return 5 rows with fine data. In Dart i got exception:

Class '_ResultsImpl' has no instance method 'forEach'.

I made breakpoint in query callback. Result object public filds are empty: enter image description here

Ping function works well, so connection to base is established. enter image description here

Even if i query simple "show tables" query, it returns to me empty Results instance with no data.

Query code below:

var pool = new ConnectionPool(
        host: '127.0.0.1', port: 8889, 
        user: 'root', password: 'root', 
        db: 'lulzvideo', max: 5);


pool.query('select id, title from users')
    .then((results) {   
      results.forEach((row) {
        print('Name: ${row[0]}, email: ${row[1]}');
      });
    });

Your code worked for me, but if I put that code (slightly modified for my table) in a main it will not complete. So if I add: *.then((_) => pool.close())* before the last semicolon it works fine. Are you sure about the parameters to the connection (i.e. are you pointing to the db with the data you expect)? I am using sqljocky-0.11.0 — user1338952, Oct 15 '14 at 15:32

score 0 · Answer 1 · edited May 23 '17 at 12:20

0

result.listen((row) {
  // Import into object
  object.Import(row);

sqljocky querying database synchronously

edited May 23 '17 at 12:20

Community

1
1

answered Oct 15 '14 at 15:11

Günter Zöchbauer

623,577
216
2,003
1,567

I wonder, why, but result.rows is empty List. Code do not get to print line, it fails in forEach. `The null object does not have a getter 'length'.` – kolombet Oct 15 '14 at 15:28
1

Result seems to be a stream - see linked answer for more code. – Günter Zöchbauer Oct 15 '14 at 15:32

sqljocky query - method not found

1 Answers1