57 lines
2.0 KiB
JavaScript
57 lines
2.0 KiB
JavaScript
import postgres from 'postgres';
|
||
|
||
const DATABASE_URL = "postgres://postgres:xGhPj4IuE5VocaxUoYAj1dSr2xf6M3hh3c2C6YbnB7ZOeVJLRvmL0mzCbhvf14dh@65.109.236.58:8392/postgres";
|
||
|
||
const sql = postgres(DATABASE_URL);
|
||
|
||
const partners = [
|
||
{ name: "The Purest Solutions", logo: "/partners/purest.png" },
|
||
{ name: "AKER", logo: "/partners/aker.png" },
|
||
{ name: "MINISO", logo: "/partners/miniso.png" },
|
||
{ name: "TRABZONSPOR", logo: "/partners/trabzon.png" },
|
||
{ name: "MANUKA", logo: "/partners/manuka.png" },
|
||
{ name: "COOK", logo: "/partners/cook.png" },
|
||
{ name: "beyyoglo", logo: "/partners/beyyoglo.png" },
|
||
{ name: "XENON SMART", logo: "/partners/xenon.png" },
|
||
{ name: "HE-QA", logo: "/partners/heqa.png" },
|
||
{ name: "Fresh Scarfs", logo: "/partners/fresh.png" },
|
||
{ name: "Sabancı Üniversitesi", logo: "/partners/sabanci.png" },
|
||
{ name: "VATKALI", logo: "/partners/vatkali.png" },
|
||
];
|
||
|
||
async function setupPartners() {
|
||
try {
|
||
console.log('Creating partners table if not exists...');
|
||
await sql`
|
||
CREATE TABLE IF NOT EXISTS partners (
|
||
id SERIAL PRIMARY KEY,
|
||
name VARCHAR(255) NOT NULL,
|
||
logo VARCHAR(255),
|
||
display_order INTEGER DEFAULT 0,
|
||
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
||
)
|
||
`;
|
||
|
||
console.log('Clearing existing partners...');
|
||
await sql`DELETE FROM partners`;
|
||
|
||
console.log('Seeding partners...');
|
||
for (let i = 0; i < partners.length; i++) {
|
||
const partner = partners[i];
|
||
await sql`
|
||
INSERT INTO partners (name, logo, display_order)
|
||
VALUES (${partner.name}, ${partner.logo}, ${i + 1})
|
||
`;
|
||
}
|
||
|
||
console.log('Success! Partners table setup and seeded.');
|
||
await sql.end();
|
||
process.exit(0);
|
||
} catch (error) {
|
||
console.error('Error setting up partners:', error);
|
||
process.exit(1);
|
||
}
|
||
}
|
||
|
||
setupPartners();
|