Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3
- data = [
- (1, 'H', 1, '1'),
- (2, 'He', 1, '18'),
- (3, 'Li', 2, '1'),
- (4, 'Be', 2, '2'),
- (5, 'B', 2, '13'),
- (6, 'C', 2, '14'),
- (7, 'N', 2, '15'),
- (8, 'O', 2, '16'),
- (9, 'F', 2, '17'),
- (10, 'Ne', 2, '18'),
- (11, 'Na', 3, '1'),
- (12, 'Mg', 3, '2'),
- (13, 'Al', 3, '13'),
- (14, 'Si', 3, '14'),
- (15, 'P', 3, '15'),
- (16, 'S', 3, '16'),
- (17, 'Cl', 3, '17'),
- (18, 'Ar', 3, '18'),
- (19, 'K', 4, '1'),
- (20, 'Ca', 4, '2'),
- (21, 'Sc', 4, '3'),
- (22, 'Ti', 4, '4'),
- (23, 'V', 4, '5'),
- (24, 'Cr', 4, '6'),
- (25, 'Mn', 4, '7'),
- (26, 'Fe', 4, '8'),
- (27, 'Co', 4, '9'),
- (28, 'Ni', 4, '10'),
- (29, 'Cu', 4, '11'),
- (30, 'Zn', 4, '12'),
- (31, 'Ga', 4, '13'),
- (32, 'Ge', 4, '14'),
- (33, 'As', 4, '15'),
- (34, 'Se', 4, '16'),
- (35, 'Br', 4, '17'),
- (36, 'Kr', 4, '18'),
- (37, 'Rb', 5, '1'),
- (38, 'Sr', 5, '2'),
- (39, 'Y', 5, '3'),
- (40, 'Zr', 5, '4'),
- (41, 'Nb', 5, '5'),
- (42, 'Mo', 5, '6'),
- (43, 'Tc', 5, '7'),
- (44, 'Ru', 5, '8'),
- (45, 'Rh', 5, '9'),
- (46, 'Pd', 5, '10'),
- (47, 'Ag', 5, '11'),
- (48, 'Cd', 5, '12'),
- (49, 'In', 5, '13'),
- (50, 'Sn', 5, '14'),
- (51, 'Sb', 5, '15'),
- (52, 'Te', 5, '16'),
- (53, 'I', 5, '17'),
- (54, 'Xe', 5, '18'),
- (55, 'Cs', 6, '1'),
- (56, 'Ba', 6, '2'),
- (72, 'Hf', 6, '4'),
- (73, 'Ta', 6, '5'),
- (74, 'W', 6, '6'),
- (75, 'Re', 6, '7'),
- (76, 'Os', 6, '8'),
- (77, 'Ir', 6, '9'),
- (78, 'Pt', 6, '10'),
- (79, 'Au', 6, '11'),
- (80, 'Hg', 6, '12'),
- (81, 'Tl', 6, '13'),
- (82, 'Pb', 6, '14'),
- (83, 'Bi', 6, '15'),
- (84, 'Po', 6, '16'),
- (85, 'At', 6, '17'),
- (86, 'Rn', 6, '18'),
- (87, 'Fr', 7, '1'),
- (88, 'Ra', 7, '2'),
- (104, 'Rf', 7, '4'),
- (105, 'Db', 7, '5'),
- (106, 'Sg', 7, '6'),
- (107, 'Bh', 7, '7'),
- (108, 'Hs', 7, '8'),
- (109, 'Mt', 7, '9'),
- (110, 'Ds', 7, '10'),
- (111, 'Rg', 7, '11'),
- (112, 'Cn', 7, '12'),
- (113, 'Nh', 7, '13'),
- (114, 'Fl', 7, '14'),
- (115, 'Mc', 7, '15'),
- (116, 'Lv', 7, '16'),
- (117, 'Ts', 7, '17'),
- (118, 'Og', 7, '18'),
- (57, 'La', 9, '4'),
- (58, 'Ce', 9, '5'),
- (59, 'Pr', 9, '6'),
- (60, 'Nd', 9, '7'),
- (61, 'Pm', 9, '8'),
- (62, 'Sm', 9, '9'),
- (63, 'Eu', 9, '10'),
- (64, 'Gd', 9, '11'),
- (65, 'Tb', 9, '12'),
- (66, 'Dy', 9, '13'),
- (67, 'Ho', 9, '14'),
- (68, 'Er', 9, '15'),
- (69, 'Tm', 9, '16'),
- (70, 'Yb', 9, '17'),
- (71, 'Lu', 9, '18'),
- (89, 'Ac', 10, '4'),
- (90, 'Th', 10, '5'),
- (91, 'Pa', 10, '6'),
- (92, 'U', 10, '7'),
- (93, 'Np', 10, '8'),
- (94, 'Pu', 10, '9'),
- (95, 'Am', 10, '10'),
- (96, 'Cm', 10, '11'),
- (97, 'Bk', 10, '12'),
- (98, 'Cf', 10, '13'),
- (99, 'Es', 10, '14'),
- (100, 'Fm', 10, '15'),
- (101, 'Md', 10, '16'),
- (102, 'No', 10, '17'),
- (103, 'Lr', 10, '18'),
- ]
- conn = sqlite3.connect('RAMAN.db')
- c = conn.cursor()
- c.execute('CREATE TABLE IF NOT EXISTS element (id integer, name char(2), a integer, b char(2));')
- conn.commit()
- #for row in data:
- # c.execute("INSERT INTO element VALUES (?, ?, ?, ?)", row);
- c.executemany("INSERT INTO element VALUES (?, ?, ?, ?)", data);
- conn.commit()
- conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement