Quick Start¶
Note
Current supported engines are mysql
.
Common operations¶
Importing beesql:
import beesql
Creating a database connection:
from beesql import DB
db = DB(database_type='mysql', db_name="database_name", username="username" password='password',
host="database_host", port="database_port")
db = DB('mysql', 'db_name').auth('username', 'password')
The database_type should be one of supported engines.
** Creating a statement **:
statement = db.query('table_name').select()
statement = db.query('table_name').update(name="new name")
statement = db.query('table_name').delete()
- ** Select statement **::
- statement = db.query().on(‘table_name’).select() => `` SELECT * FROM table_name ``
- statement = db.query().on(‘table_name’).select(‘id’, ‘age’) => `` SELECT id, age FROM table_name ``
- statement = db.query(‘table_name’).select(‘id’, ‘age’).select(‘location’) => `` SELECT id, age, location FROM table_name ``
- ** Update statement **::
- statement = db.query(‘table_name’).update(age=23) => `` UPDATE table_name SET age=23 ``
- ** Delete statement **::
- statement = db.query(‘table_name’).delete() => `` DELETE FROM table_name ``
- ** Where condition **::
- db.query(‘table_name’).select().where(age=20, code=‘100’) => `` SELECT * FROM table_name WHERE age = 20 AND code = 100
- db.query(‘table_name’).select().where(age=20)._and(‘code’).eq(100) => `` SELECT * FROM table_name WHERE age = 20 AND code = 100
- db.query(‘table_name’).select().where(‘age’).lt(100)._or(‘code’).gte(10) => `` SELECT * FROM table_name WHERE age < 20 OR code >= 100