badsql 1.1

SQL but worse

# badsql This is a file-based version of SQL.

Pass the headers as the parameter to db()

`python mydb = db(['id', 'name', 'age']) `

Use .insert(pos, row) to add to the table

`python mydb.insert(1, [0, 'Bob', 11]) mydb.insert(2, [1, 'Sam', 9]) mydb.insert(3, [2, 'Will', 10]) `

Use .display() to show the table

`python print('Full table:\n') mydb.display() print('\n') `

Use .select(query) to select specific rows

`python print('Where age >= 10:\n') mydb.select('age >= 10').display() print('\n') `

Any Python-compilable code can be used

`python print('Where len(name) != 4:\n') mydb.select('len(name) != 4').display() print('\n') `

The .select() method returns a db object

To save the table use .save(filename)

`python mydb.save('table') `

To load in a table from a file use load(filename)

`python db2 = load('table') `

This returns a db object

`python print('Loaded from table.csv:\n') db2.display() `

Note:

for .save() and load(), ‘.csv’ is appended at the end of the filename in all cases.

[View on Github](https://github.com/nayakrujul/badsql)