A wrapper for simplified sqlite usage using sqlite3.
Project description
SQLiteDave - A wrapper for simplified sqlite usage using sqlite3.
usage - load_csv_to_table
''' mydb = sqlite_db() mydb.connect() print(mydb.queryone('SELECT CURRENT_DATE')) mydb.close()
'''
usage - load_csv_to_table
''' mydb = sqlite_db() mydb.connect() print(mydb.dbstr()) csvfilename = 'Station.tsv' tblname = 'Station' mydb.load_csv_to_table(csvfilename,tblname,True,'\t') mydb.close() '''
usage - export_table_to_csv
''' mydb = sqlite_db() mydb.connect() print(mydb.dbstr()) csvfilename = 'Station.tsv' tblname = 'Station' mydb.export_table_to_csv(csvfilename,tblname) mydb.close()
'''
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sqlitedave_package-1.1.1.tar.gz
(34.0 kB
view hashes)
Built Distribution
Close
Hashes for sqlitedave_package-1.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7aad74345bdd765375d337e58390374a6d74c032c5f8f30388fd4dbbf58f2d9b |
|
MD5 | 93a22fa504d93f70a65ac08dcf7b92e9 |
|
BLAKE2b-256 | 961a0164fb2985f539b3df4d6186b406308f1fc7f7ac787d7898c6cced97ec2e |