Jump to content

upgrading, configuration ps with oracle?


Recommended Posts

Hi,
This is my first post here,
So Welcome, My name is Jakub, I am posting from Poland.

I already installed prestashop. It is working, but I wouldlike to use Oracle Database.
I already found in conifguration file that database type is set to mysql.
Some other base are supported?
In which files I will find declaration of batabase methods?


I will share few informations for peaople who can look for same problems what i had.
I am now importing categories and products from other DB (mssql)
I am using my own scripts based on deps in shop base.
I am using only one lang ver so I am not multipli quest i *_lang.
In same way I will made manufacture id (like category)

Downloading categories:
2 sql questions with category_id dep.

$pytanie = "insert into `ps_category` ( `id_parent`, `level_depth`, `active`, `date_add`, `date_upd`)
select id_category,'2','1','$data','$data' from ps_category_lang where name= '$nazwa_nadkategorii[$a]' and id_lang=8 limit 1";

$pytanie = "insert into ps_category_lang (id_category, id_lang, name, link_rewrite)
select id_category, '8','$podkategorie[$a]','$podkategorie[$a]'from ps_category order by id_category desc limit 1";



Now products
I added ps_product_temp
where I am keeping dep from mssql db.

$pytanie = " insert into `ps_product` (`id_category_default`,`ean13`,`weight`,`id_tax`, `date_add`, `date_upd`) 
select id_category,'$wartosc[3]','$wartosc[0]','1','$data', '$data' from
ps_category_lang
inner join
ps_product_temp on
name=nazwa_kategorii and
kod_produktu='$wartosc[1]'
where id_lang=8
 ";

$pytanie = "insert into `ps_product_lang` (`id_product`, `link_rewrite`, `id_lang`, `description_short`, `name`)
 select id_product, '$wartosc[1]','8', '$wartosc[0]', '$wartosc[2]' from ps_product
   where weight='$wartosc[0]'";


$pytanie ="insert into `ps_category_product` (`id_category`, `id_product`)
select id_category,id_product from ps_category_lang 
inner join ps_product_temp on
name=nazwa_kategorii and
kod_produktu='$wartosc[1]'
inner join ps_product_lang on
ps_product_lang.link_rewrite='$wartosc[1]' 
and ps_product_lang.id_lang=8";



2 questions with dep (id_product)
and to make products visible 3rd question

My quesstion is:

I found out that in ps_product is default category column
it is not used?
Any else is making updates via sql questions? if some one has some *.sql
it is very welcome :)

Regards!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...