Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

1.x not working with sqlite #589

Open
rapito opened this issue Mar 29, 2018 · 3 comments
Open

1.x not working with sqlite #589

rapito opened this issue Mar 29, 2018 · 3 comments

Comments

@rapito
Copy link

rapito commented Mar 29, 2018

If you try to connect to a sqlite db, you get a "table not found {table_name}" error.

@jardelsantana
Copy link

show us the database structure.

@rapito
Copy link
Author

rapito commented Mar 29, 2018

@jardelsantana

create table transactions
(
	id INTEGER,
	account VARCHAR(4) not null,
	amount_change FLOAT not null,
	action VARCHAR(50) not null,
	balance FLOAT
)
;

create unique index transactions_id_uindex
	on transactions (id)
;

create table users
(
	id INTEGER not null,
	name VARCHAR(50) not null,
	account VARCHAR(4) not null,
	pin VARCHAR(4) not null,
	balance FLOAT
)
;

create unique index users_id_uindex
	on users (id)
;

create unique index users_account_uindex
	on users (account)
;


image

The same script/structure works fine If I switch to MySQL.

@rapito
Copy link
Author

rapito commented Apr 2, 2018

@jardelsantana Do you know if there's any workaround to fix this? If you have some insight I can jump in the code and submit a pull request

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants