[SOLVED] Sqlite3 Rows

[denwo]

I'm making a plugin and need to store some data.

I'm using sqlite3 and everytime i run my cuberite server i see this error.

1 2

[10:45:24] Can't load plugin TestPlugin because of an initialization error in file Plugins/TestPlugin/test.lua: 2 (no such table: table) <span style="color: #333333;" class="mycode_color"><span style="font-size: small;" class="mycode_size"><span style="font-family: Monaco, Consolas, Courier, monospace;" class="mycode_font"></span></span></span>

Here's my code

1 2 3 4

<span style="color: #333333;" class="mycode_color"><span style="font-size: small;" class="mycode_size"><span style="font-family: Monaco, Consolas, Courier, monospace;" class="mycode_font">db = sqlite3.open('test.sqlite3')</span></span></span> <span style="color: #333333;" class="mycode_color"><span style="font-size: small;" class="mycode_size"><span style="font-family: Monaco, Consolas, Courier, monospace;" class="mycode_font">LOG(db.rows('SELECT * FROM table'))</span></span></span> <span style="color: #333333;" class="mycode_color"><span style="font-size: small;" class="mycode_size"><span style="font-family: Monaco, Consolas, Courier, monospace;" class="mycode_font">db:close()</span></span></span> <span style="color: #333333;" class="mycode_color"><span style="font-size: small;" class="mycode_size"><span style="font-family: Monaco, Consolas, Courier, monospace;" class="mycode_font"></span></span></span>

EDIT:
i just realised that i'm an idiot the db files were located in cuberite's folder not in the plugin's folder

[NiLSPACE]

Just like any SQL engine you have to create the tables first: https://github.com/cuberite/WorldEdit/bl...ipts/1.sql

[denwo]

Just like any SQL engine you have to create the tables first: https://github.com/cuberite/WorldEdit/bl...ipts/1.sql

i undestand how sql works i have already created the table and add a couple of rows.

[NiLSPACE]

You can take a look at the Gallery plugin. It has an ExecuteStatement method which you give the SQL statement, optional parameters and optional callback: https://github.com/cuberite/gallery/blob...a#L83-L108
Then you can use it like this: https://github.com/cuberite/gallery/blob...#L237-L249

[xoft]

First, you should be calling methods on the "db" object with a colon: db:rows(...)
Second, db:rows(...) creates an iterator, the LOG function cannot output the value of an iterator.

[xoft]

If you want to output the values in all rows, you can do this:

1 2 3 4 5

for a in db:rows('SELECT * FROM table') do   for k, v in pairs(a) do     LOG(k .. " = " .. v)   end end

[denwo]

1	[09:32:47] Can't load plugin TestPlugin because of an initialization error in file Plugins/TestPlugin/test.lua: 2 (no such table: test)

@xoft ft tried it didn't work

[xoft]

Then you'll have to post your entire code for the Initialize function and the database you're using.

[denwo]

i've sent you a pm

[denwo]

I've tried to change the name (in-order to make a new sqlite3 file) it failed.

Any ideas?