NfSuhDhM

1import csv
2import sqlite3
3
4# Create the database
5connection = sqlite3.connect('test.db')
6cursor = connection.cursor()
7
8# Create the table
9cursor.execute('DROP TABLE IF EXISTS line_info')
10cursor.execute("CREATE TABLE line_info (id INT PRIMARY KEY NOT NULL, acc_id TEXT, EUSOL_id TEXT, acc_name TEXT, reasons TEXT, genebank TEXT);")
11connection.commit()
12
13# Load the CSV file into CSV reader
14creader = csv.reader(open("line_info.csv", 'rt', encoding = 'utf-8'))
15
16# Iterate through the CSV reader, inserting values into the database
17for i in creader:
18    cursor.execute('INSERT INTO  line_info VALUES (?,?,?,?,?,?)', i )
19
20
21connection.commit()
22connection.close()
23	
24from app import db
25class Line_info(db.Model):
26    id = db.Column(db.Integer, primary_key=True)
27    acc_ID = db.Column(db.String)
28    EUSOL_id = db.Column(db.String)
29    acc_name = db.Column(db.String)
30    reasons = db.Column(db.String)
31    genebank = db.Column(db.String)
32
33    def __init__(self, acc_ID,EUSOL_id,acc_name,reasons,genbank):
34        self.acc_ID = acc_ID
35        etc....................
36	
37import os
38basedir = os.path.abspath(os.path.dirname(__file__))
39
40class Config(object):
41    SQLALCHEMY_DATABASE_URI = os.environ.get('DATABASE_URL') or 
42    'sqlite:///' + os.path.join(basedir, 'test.db')
43    SQLALCHEMY_TRACK_MODIFICATIONS = False
44	
45import os
46from flask import Flask
47from config import Config
48from flask_sqlalchemy import SQLAlchemy
49#from flask_migrate import Migrate
50
51app = Flask(__name__)
52app.config.from_object(Config)
53db = SQLAlchemy(app)    
54#migrate = Migrate(app, db)
55
56from app import routes, models