python dbi
2024-02-15 17:10:21
```python
import sqlite
```
```python
conn = sqliteconnect('test.db')
```
```python
c = conn.cursor()
c.execute('CREATE TABLE stocks (date text, trans text, symbol text, qty real, price real)')
```
```python
c.execute("INSERT INTO stocks VALUES ('--', 'BUY', 'IBM', , )")
```
```python
conn.commit()
```
```python
conn.close()
```