fastsqlite

FastSQLite Documentation

Example

from fastsqlite import FastSQLite

db = FastSQLite()
db.connect('file.db')
db.create_table('gato', 'id int, rum varchar(300)')

Using FastSQLite

db = FastSQLite()

db.connect( file):

db.connect('database.db')

Important:

ALTERtable [table] RENAME TO [rename];
[variable] = variable: str

db.rename_table(str, str)

example:
	db.rename_table('old_name', 'new_name')

Table Actions

db.create_table(table, columns):

CREATEtable [table]([columns]);

db.rename_table(table, rename):

ALTERtable [table] RENAME TO [rename];

db.drop_table(table):

DROPtable [table];

Column Actions

db.insert(table, column, params):

INSERT INTO [table]([column]) VALUES([params]);

db.update(table, params, where, condition):

UPDATE [table] SET [params] WHERE [where] = [condition];

db.delete(table, where, condition):

DELETE FROM [table] WHERE WHERE [where] = [condition];

db.add_column(table, new_column):

ALTERtable [table] ADD COLUMN [new_column];

db.add_fk_reference(table, fk_column, column_id):

FOREIGN KEY([fk_column]) REFERENCES [table]([column_id]);

Queries Section

db.custom_fetch( query):

query = 'SELECT nombre as n, precio as p FROM productos WHERE precio < 5.60;'
db.custom_fetch(query):

db.fetch_all(table):

SELECT * FROM [table];

db.fetch_one(table, column):

SELECT [column] FROM [table];

db.fetch_many(table, columns):

SELECT [columns] FROM [table];

db.distinct(table, columns):

SELECT DISTINCT [columns] FROM [table];

db.where(table, columns, where, param):

SELECT [columns] FROM [table] WHERE [where] = [param];

db.like(table, columns, param):

SELECT [columns] FROM [table] LIKE [param];

db.between(table, columns, where, param1, param2):

SELECT [columns] FROM [table] WHERE [where] BETWEEN [param1] AND [param2];

db.left_join(table1, table2, columns, column1, column2):

SELECT [columns] FROM [table1] LEFT JOIN [table2] ON [table1].[column1]=[table2].[column2];

db.right_join(table1, table2, columns, column1, column2):

SELECT [columns] FROM [table1] RIGHT JOIN [table2] ON [table1].[column1]=[table2].[column2];

db.inner_join(table1, table2, columns, column1, column2):

SELECT [columns] FROM [table1] INNER JOIN [table2] ON [table1].[column1]=[table2].[column2];

db.union_all(table1, table2, columns_table1, columns_table2):

SELECT [columns_table1] FROM [table1] UNION ALL SELECT [columns_table2] FROM [table2];

db.union(table1, table2, columns_table1, columns_table2):

SELECT [columns_table1] FROM [table1] UNION SELECT [columns_table2] FROM [table2];

db.avg(table, column, name, where, param):

SELECT AVG([column]) AS [name] FROM [table] WHERE [where] = [param];

db.count(table, column, name, where, param):

SELECT COUNT([column]) AS [name] FROM [table] WHERE [where] = [param];

db.sum(table, column, name, where, param):

SELECT SUM([column]) AS [name] FROM [table] WHERE [where] = [param];

db.max(table, column, name, where, param):

SELECT MAX([column]) AS [name] FROM [table] WHERE [where] = [param];

db.min(table, column, name, where, param):

SELECT MIN([column]) AS [name] FROM [table] WHERE [where] = [param];